Skip to main content
Solved

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


Forum|alt.badge.img

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...

 

Best answer by dngu

Hi Chris!  Apparently, there is already a Pick List with barcode display in the system ie. “Pick List - Confirm Picked with Barcode”.  We just have to edit the report a bit to work with our need.

 

View original

Robert Sternberg
Captain II
Forum|alt.badge.img+8

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? 


Forum|alt.badge.img
  • Jr Varsity II
  • March 17, 2023

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.

 


Forum|alt.badge.img
  • Jr Varsity II
  • March 17, 2023

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
Captain II
Forum|alt.badge.img+8

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


Forum|alt.badge.img
  • Jr Varsity II
  • March 18, 2023

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

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • April 20, 2023

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


Forum|alt.badge.img
  • Jr Varsity II
  • April 20, 2023

Hi Chris!  Yes, we found a solution to display the barcodes on the Pick List.  Thanks...


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • April 20, 2023

Hi @dngu would you be able to share the solution you found? Thank you!


Forum|alt.badge.img
  • Jr Varsity II
  • April 20, 2023

Hi Chris!  Apparently, there is already a Pick List with barcode display in the system ie. “Pick List - Confirm Picked with Barcode”.  We just have to edit the report a bit to work with our need.

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings