Skip to main content
Solved

All transactions with reason codes

  • October 9, 2024
  • 2 replies
  • 115 views
maheshc73
Freshman II

can we generate a GI that includes all transactions with reason codes? We need to see all inventory adjustments and their associated reason codes, as well as write-offs and the reason codes used for them. Thank you!

Best answer by nhatnghetinh

Hi @maheshc73 

You need to create a new DAC to aggregate the ReasonCode into 1 table by creating a SQL view and combining it with Customization.

A simple way that can be used immediately is to create 2 GIs by using INTran and ARTran on each different GI.

 

 

 

Best Regards,

NNT

    2 replies

    nhatnghetinh
    Captain II
    Forum|alt.badge.img+13
    • nhatnghetinh
    • Captain II
    • Answer
    • October 9, 2024

    Hi @maheshc73 

    You need to create a new DAC to aggregate the ReasonCode into 1 table by creating a SQL view and combining it with Customization.

    A simple way that can be used immediately is to create 2 GIs by using INTran and ARTran on each different GI.

     

     

     

    Best Regards,

    NNT

    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      maheshc73
      Freshman II
      • maheshc73
      • Author
      • Freshman II
      • October 9, 2024

      Hi @nhatnghetinh 

      Thanks this was helpful.

      Best Regards,

      Mahesh C

       

        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