Skip to main content
Solved

Get Next Record in GI


Forum|alt.badge.img

Hello,

Is it possible to access the next record in an inquiry? For example, I am build a generic inquiry to show where items are production orders and I want to get the next work center from the AMBomOper DAC. Is this possible?

 

Thanks,

Best answer by lauraj46

Hi @DoShawhan ,

There are next and previous functions in the Report Designer, however I’m not aware of any such functionality on a GI.   

Laura

View original
Did this topic help you find an answer to your question?

4 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • Answer
  • August 22, 2023

Hi @DoShawhan ,

There are next and previous functions in the Report Designer, however I’m not aware of any such functionality on a GI.   

Laura


Forum|alt.badge.img
  • Varsity I
  • 25 replies
  • October 11, 2024

Lauraj46, where can I find information about the next and previous functions in the Report Designer?


Forum|alt.badge.img+1
  • Semi-Pro I
  • 177 replies
  • December 27, 2024
lauraj46 wrote:

Hi @DoShawhan ,

There are next and previous functions in the Report Designer, however I’m not aware of any such functionality on a GI.   

Laura

Do you know where detailed Documentation is existing on this?
I only found the below:
 

This is not working at all on a Report for a MFG Label. It just brings back blank values for the next Work center or for the next Operation ID/CD


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • December 31, 2024

Hi ​@krausef77 ,

I don’t know of any additional documentation.  Also, I’m not sure why the documentation lists two input parameters. 

An example of the typical usage can be found in the standard report IN619200.rpx, which prints labels in two columns across.  These functions return the next or previous value from the record set. If it’s not working, you could troubleshoot by displaying all of the details and verifying your joins and sort.

Hope this helps!

Laura


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings