Skip to main content
Solved

Get Next Record in GI

  • Aug 22, 2023 2:20 PM UTC
  • 4 replies
  • 228 views
  • Translate All
Freshman I
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

4 replies

lauraj46
Captain II
Forum|alt.badge.img+9
  • lauraj46
  • Captain II
  • Answer
  • Aug 22, 2023 2:49 PM UTC

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

Translate
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Varsity I
    Forum|alt.badge.img
    • johnw51
    • Varsity I
    • Oct 11, 2024 6:20 PM UTC

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

    Translate
      Semi-Pro III
      Forum|alt.badge.img+1
      • krausef77
      • Semi-Pro III
      • Dec 27, 2024 2:24 PM UTC

      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

      Translate
      lauraj46
      Captain II
      Forum|alt.badge.img+9
      • lauraj46
      • Captain II
      • Dec 31, 2024 1:59 PM UTC

      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

      Translate
      Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
        Terms & ConditionsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved