Solved

Report to print Inventory Item & Description only on label


Userlevel 1

Looking to make a report that will print on a Zebra label.

The only report parameter I need is Item # (InventoryItem.InventoryCD) and the the user should be able to select a single Item # for printing.

This is the end goal - a 4”x6.75” label with the Item ID and Item Description.
Need to be able to select and print a label for either Stock or Non-Stock Items.

 

The report I’ve created gives me a look-up option for the item but when run the report, I get a label for every item in the system (and this is not my intent).

 

I’m learning Report Designer through trial and error and this request seems so simple, yet I’m stumped. Any help would be appreciated.

icon

Best answer by Gabriel Michaud 25 May 2021, 17:47

Hi @sarah,

From the report designer, can you open the Schema Builder and look at the Filters tab? I can see from your screenshot that the parameter has been added (from the Parameters tab), but I suspect the filter criteria is missing.

Assuming your parameter is named @Inventory_ID, and that you’re selecting from the InventoryItem table, here’s how it should look:

 

View original

2 replies

Userlevel 6
Badge +7

Hi @sarah,

From the report designer, can you open the Schema Builder and look at the Filters tab? I can see from your screenshot that the parameter has been added (from the Parameters tab), but I suspect the filter criteria is missing.

Assuming your parameter is named @Inventory_ID, and that you’re selecting from the InventoryItem table, here’s how it should look:

 

Userlevel 1

Thank you @Gabriel Michaud your suggestion worked, thank you so much!

So grateful for the Acumatica Community!

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 — 2020  Acumatica, Inc. All rights reserved