Skip to main content
Solved

Error when I try to use InventorySummaryEnquiryResult in a report

  • August 19, 2022
  • 4 replies
  • 207 views
L
Freshman I

I need to include the unit cost that is on the inventory Summary but when I include InventorySummaryEnquiryResult the report gives an error.

Best answer by Manikanta Dhulipudi

Hi @leov78 The Inventory Summary inquiry uses a table that is not exist on the DB in order to pull this data, hence the GI cannot be lined to this either in Report.

Thanks

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Naveen Boga
  • Captain II
  • August 19, 2022

Hi @leov78  Can you please elaborate your question with issue details/screenshots?

 

Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    L
    Freshman I
    • leov78
    • Author
    • Freshman I
    • August 19, 2022

    Hi, on the sales order report I need to include the estimated unit cost that the lot item shows on the Inventory Summary. it is a lot item and multiple warehouse so it has to be the right estimated cost.

    so I included the InventorySummaryEnquiryResult to the report and I get the following error, I also tried with a new report and only included  InventorySummaryEnquiryResult and get the same error. Could I use  InventorySummaryEnquiryResult in reports?

     

     

    Manikanta Dhulipudi
    Captain II
    Forum|alt.badge.img+16

    Hi @leov78 The Inventory Summary inquiry uses a table that is not exist on the DB in order to pull this data, hence the GI cannot be lined to this either in Report.

    Thanks

    Acumatica Functional Consultant & Customer Experience Supervisor
      Chris Hackett
      Community Manager
      Forum|alt.badge.img
      • Chris Hackett
      • Acumatica Community Manager
      • November 1, 2022

      Hi @leov78 - were you able to find a solution? Thank you!

      Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. 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