Skip to main content
Solved

Generic Inquiry: Invoices and Memos showing Inventory ID

  • Jul 3, 2024 2:49 AM UTC
  • 4 replies
  • 150 views
  • Translate All
Freshman I
Forum|alt.badge.img

Please help how to show in the generic inquiry of Invoices and Memos the Inventory ID.

Best answer by nhatnghetinh

Hi @retros 

Please see the attached file.

 

Best Regards,

NNT

View original

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Naveen Boga
  • Captain II
  • Jul 3, 2024 4:03 AM UTC

@retros You can join with the ARInvoice (DocType, RefNbr) and ARTran (TranType and RefNbr) to fetch the InventoryID details

Note: You will get duplicate records as lines may have multiple line items for the each Invoice and Memo document.

 

 

Translate
Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    nhatnghetinh
    Captain II
    Forum|alt.badge.img+15

    Hi @retros 

    Please refer to the GI "Invoiced Items" available on Acumatica.

     

     

    Best Regards,

    NNT

    Translate
    I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
      Freshman I
      Forum|alt.badge.img
      • retros
      • Author
      • Freshman I
      • Jul 3, 2024 8:24 AM UTC

      @nhatnghetinh may i asked for the copy of this GI? thank you

      Translate
      nhatnghetinh
      Captain II
      Forum|alt.badge.img+15
      • nhatnghetinh
      • Captain II
      • Answer
      • Jul 3, 2024 8:33 AM UTC

      Hi @retros 

      Please see the attached file.

       

      Best Regards,

      NNT

      Translate
      I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
        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