Solved

Can I set a specific Inventory ID in the report and query data?

  • 24 October 2023
  • 2 replies
  • 38 views

Userlevel 2

Hi, I was wondering if it’s possible to set a specific inventory ID and obtain the data.

For example, if my Inventory ID is 9BRO01, how do I replace [InventoryItem.InventoryCD] and use 9BRO01 instead to run the report? Is it possible to do so?

icon

Best answer by Laura02 24 October 2023, 12:04

View original

2 replies

Badge +18

Hello @lightman ,

Yes, it is possible to go to File, Build Schema in Acumatica Report Designer, and enter a Filter:

Hard-code report for one item only

However, a better idea is to add Additional Sort and Filtering on the Report Parameters screen, then save the settings as a Report Template:

Save Template with Inventory ID Selection
Enter Template Name
Share and Save Template so others may use it

Laura

Userlevel 2

Thank you so much @Laura02 
That helped :)

Reply


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