Question

How to display product barcode and bin location barcode in Pick List?

  • 16 March 2023
  • 5 replies
  • 41 views
D
Rank
Userlevel 1

We are trying go paperless with Pick List for our warehouse; Does anyone know how to make the Item’s barcode and the bin location’s number to display on the Pick List as a barcode?  Like the pic below, thanks...

 

5 replies

Robert Sternberg
Rank
Userlevel 5
Badge +1

Hi @dngu to do this we will need to modify the Pick List Report.  Using report designer we can add an image element of the type Barcode and set the value to the InventoryCD of the item and the Bin location.  Can you please attach a RPX file of your Pick List report so we can take a look together? 

Robert Sternberg - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
D
Rank
Userlevel 1

Hi Robert, we insert the picturebox as a barcode, however the Value field doesn’t seem to allow us to point to the table INitemXref.

 

D
Rank
Userlevel 1

we manually added =[INItemXRef.AlternateID] to the “value” field.  And also added another barcode for the LocationID ie. =[INLocation.LocationCD] same as the way we added AlternateID.  The report displays duplicate lines, not sure it’s the right way to add the values.  Please advise, thanks…

 

 

Robert Sternberg
Rank
Userlevel 5
Badge +1

That’s expected due to the 1:M relationship of Stock Item to Cross Reference ID.  You will need to create a join based on the data you would like to see in the report.  Are you attempting to pull Barcode Type, Global Type, Customer/Vendor Type cross-reference information?  Could you possibly provide a screenshot showing your cross references for a stock item and point out an example for us?

 

Thanks

Robert Sternberg - If I helped you, please *Like* my post/reply. If I provided an answer to your question, please mark it as *Best Answer*.
D
Rank
Userlevel 1

We are just attempting to pull the barcode type.  There is only a single entry for the barcode.

 

Reply


Terms & ConditionsCookie settings
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 — 2022  Acumatica, Inc. All rights reserved