Skip to main content
Answer

Need help printing labels before release barcode scan only provides Inventory ID

  • October 31, 2025
  • 1 reply
  • 40 views

Hi everyone,

I was able to get the correct number of label prints by following this example:
🔗 Acumatica Inventory Label Report Per Qty – GitHub

I implemented a similar setup using INTran, InventoryItem, UsrNumbers, and POReceipt tables, where the user enters the Receipt Nbr and Inventory ID as parameters.

However, I’ve run into two problems:

  1. When using the barcode scanner, it only provides the Inventory ID not the PO Receipt number.

  2. The INTran table is only populated after release, but that doesn’t fit our workflow. We need labels to print before release, as soon as an item is scanned and the quantity is set (for example, if the set quantity is 5 and the base quantity is 10, we should get 50 labels).

Has anyone handled this scenario printing labels by Inventory ID before release and can share the best approach or table structure to use?

Thanks in advance!

Best answer by lauraj46

Hi ​@rmore49 ,

You can find the LotSerialNbr on an unreleased PO Receipt in the POReceiptLineSplit table.  

Also, an option to print multiple labels without requiring a customization project is to use a cross join with the DateInfo table.  I wrote about this approach here:

https://www.linkedin.com/pulse/acumatica-tips-tricks-how-print-multiple-product-labels-laura-jaffe/

Hope this helps!

Laura

 

1 reply

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • Answer
  • November 3, 2025

Hi ​@rmore49 ,

You can find the LotSerialNbr on an unreleased PO Receipt in the POReceiptLineSplit table.  

Also, an option to print multiple labels without requiring a customization project is to use a cross join with the DateInfo table.  I wrote about this approach here:

https://www.linkedin.com/pulse/acumatica-tips-tricks-how-print-multiple-product-labels-laura-jaffe/

Hope this helps!

Laura

Â