Skip to main content
Question

How to use GS1 barcode in Acumatica?


Forum|alt.badge.img

Hi,

What are the steps to configure or use the GS1 barcode in Acumatica? Any example?

 

Thanks,

EV

25 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • October 13, 2022

Hello,

Did you notice this previous post, related to printing the same barcodes you’re asking about?

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 21 replies
  • October 13, 2022
laura01 wrote:

Hello,

Did you notice this previous post, related to printing the same barcodes you’re asking about?

 

Hello,

I saw that article but is not what I need right now.

What I need is:

  1. The steps to configure the item or acumatica to scan a GS1 barcode. When I scan a GS1 barcode the system is not reading it. The only location where I see a GS1 configuration is in the Item Preferences. 
  2. How I can extend the scan functionality 

Thank,

EV


Forum|alt.badge.img+1
  • Semi-Pro I
  • 177 replies
  • October 17, 2022
edsonvelez64 wrote:
laura01 wrote:

Hello,

Did you notice this previous post, related to printing the same barcodes you’re asking about?

 

Hello,

I saw that article but is not what I need right now.

What I need is:

  1. The steps to configure the item or acumatica to scan a GS1 barcode. When I scan a GS1 barcode the system is not reading it. The only location where I see a GS1 configuration is in the Item Preferences. 
  2. How I can extend the scan functionality 

Thank,

EV

Following as I am looking into the same thing. 2022R2 apparently added this functionality for the report designer but I wasn’t able to get it working as expected yet.


Michaelh
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 185 replies
  • November 14, 2022

Having a similar issue myself. When I scan in the barcode on Pick, Pack, Ship. It does not parse the string, it just says that the item cannot be found. It also claims the item is:


(01)10822045000183(10)2026-3-CG321041(17)220131

 

This is the full value of the GS1 Code created using the Acumatica Report Writer under the QR code settings. Did I miss a step here? The GTIN is set under the item xref, but scanning 2D codes just isn’t functioning for me.


bryanb39
Pro II
Forum|alt.badge.img+5
  • Pro II
  • 177 replies
  • February 3, 2023

Maybe check on this setting?

 


Forum|alt.badge.img
  • Varsity I
  • 25 replies
  • September 11, 2023

What functionality does this give users? Can I do scan and transfers of a serialized unit using a single scan? I found the article on GS1 on the help site but no actual explanation of how to setup the barcode, what data can be held by it and how to utilize within Acumatica. 

 

https://help.acumatica.com/(W(3))/Help?ScreenId=ShowWiki&pageid=947c9182-7423-41db-8e2d-2472e5c38c79

 

Does anyone have any videos / articles explaining?

 

If I have a serialized stock item:

Stock item ID = TAPE

Serial # = SN12345

 

How would this barcode need to read when scanned?


Michaelh
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 185 replies
  • September 11, 2023

As far as I know, READING 2D BARCODES is not supported yet, thus everyone asking questions. Printing is supported, thus the article linked above.

Quick Run Down:

A normal barcode has a single data element. The barcode.

A 2D barcode holds multiple elements at once. This means that if you had a configurable mapping, you COULD say that scanning a 2D barcode would import the FIRST attribute as the Item ID, the 2nd Attribute as a Serial Number, and so on and so forth. This would require a lot of mapping and most 2D codes aren’t standardized yet, so we have questions like: Is your first element an Item ID, it could be a Serial number, it could be a website, we just don’t know.

So whatever system utilizes 2D barcodes will probably need flexibility, like:

For Screen: Pick Pack and Ship

Warehouse = Barcode (which could also be user-entered)
Location = Barcode
Item ID = 2D Barcode Attribute 1
Qty = Barcode
Serial/Lot = 2D Barcode Attribute 2

 

This mapping would tell a user they can either scan a barcode or enter by hand the Warehouse.

This mapping tells us that if we are asked for the Item ID, we know that we are expecting a 2D barcode (or hand-entered) and that it would need to check the first attribute of the 2D barcode if one was scanned. Similarly, if we are asked to enter the Serial/Lot we can either scan the 2D barcode grabbing the 2nd attribute or we can enter the value by hand. 

Because of this massive mapping likely needing to be done for most every screen, I think Acumatica has been holding off on implementing this. 2D barcodes are the future, but this implementation would be quite the undertaking from what I understand/assume. I’m hoping they push to integrate quickly. 

AS FOR PRINTING:

This link goes to GS1 compliant encodings. It requires a good bit of string knowledge to interpret, but it’s not insurmountable: https://www.gs1.org/standards/gs1-datamatrix-guideline/25#2-Encoding-data+2-2-GS1-element-strings

Section 2.3 has the full encoded string, but I would read all of section 2 to understand why it KNOWS how to parse that string.


Forum|alt.badge.img
  • Varsity I
  • 25 replies
  • September 11, 2023

@Michael Hansen Appreciate the breakdown. I was under the impression Acumatica could read these on certain screens. 


Michaelh
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 185 replies
  • September 11, 2023

@Lhouldsworth - I know some companies/VARs have their own customization scripts for it, but I haven’t found an out of the box solution. Right now, the system just takes the full encoding. Thus my post about it outputting the entire barcode instead of a single element.

My guess is the customizations just override the field and start parsing the string for things like (01) or (17) to find the data they need. It’s really just String Cutting at that point.


asmith50
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 67 replies
  • November 10, 2023

Is there anyone out there who is scanning 2D barcodes inside of Acumatica that would be willing to explain how they did this? Or sell their customization to others?


asmith50
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 67 replies
  • February 15, 2024

I have found two 3rd party ISVs who help handle this needs. Acumatica can scan barcodes (but CANNOT parse out the different data fields) containing multiple lines of data (Inventory ID, qty, Lot #, etc.) inside of one barcode. 


dsimmerly
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 114 replies
  • February 15, 2024

jgadbois18
Freshman II
  • Freshman II
  • 9 replies
  • February 23, 2024
asmith50 wrote:

I have found two 3rd party ISVs who help handle this needs. Acumatica can scan barcodes (but CANNOT parse out the different data fields) containing multiple lines of data (Inventory ID, qty, Lot #, etc.) inside of one barcode. 

@asmith50 who are the ISVs?

 


asmith50
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 67 replies
  • February 23, 2024

@jgadbois18 Linfa Systems (https://linfasystems.com/wms-for-acumatica/) and MomentTrack are the two companies I have met with who can handle this need. I am in the process of implementing Linfa Systems right now. 


jgadbois18
Freshman II
  • Freshman II
  • 9 replies
  • February 26, 2024

@asmith50 are these ISVs certified by Acumatica? I don’t see them on the marketplace. Curious what your experience has been like so far. 

 


asmith50
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 67 replies
  • February 26, 2024

@jgadbois18 Linfa Systems (https://linfasystems.com/wms-for-acumatica/) was on previous versions but is not currently (that I could tell) and MomentTrack is new to the game but very excited to work with Acumatica. As far as I know MomentTrack is not certified. 

 

Linfa Systems seems to have a strong platform which should work well for my client. MomentTrack is newer and I have not used them in an implementation. They do have a great VR picking functionality which is lightyears ahead of anyone else. 


aclair
Freshman I
  • Freshman I
  • 5 replies
  • February 29, 2024
Michael Hansen wrote:

Having a similar issue myself. When I scan in the barcode on Pick, Pack, Ship. It does not parse the string, it just says that the item cannot be found. It also claims the item is:


(01)10822045000183(10)2026-3-CG321041(17)220131

 

This is the full value of the GS1 Code created using the Acumatica Report Writer under the QR code settings. Did I miss a step here? The GTIN is set under the item xref, but scanning 2D codes just isn’t functioning for me.

When printing the barcode in report designer are you using the UCC128 type? 

The barcode should read: “0110822045000183102026-3-CG321041(220131” in the Report Designer,

the ‘(‘ is the designated FNC1 character in this instance

I used the following formula for printing based on item, but can be easily modified to by receipt etc:

='01'+[INItemXRef.AlternateID]+'10'+[INLotSerialStatus.LotSerialNbr]+'('+'17'+Substring(Year([INLotSerialStatus.ExpireDate]),2,2)+Month([INLotSerialStatus.ExpireDate])+IIf(Day([INLotSerialStatus.ExpireDate])<10,'0'+Day([INLotSerialStatus.ExpireDate]),Day([INLotSerialStatus.ExpireDate]))+30+[@qty]


asmith50
Jr Varsity III
Forum|alt.badge.img+1
  • Jr Varsity III
  • 67 replies
  • March 5, 2024

@aclair My issue isn’t the creating a data matrix code (yet) my issue is not being able to scan a complex code and have ACU parse out the data in its respective fields.

 


aclair
Freshman I
  • Freshman I
  • 5 replies
  • April 11, 2024
aclair wrote:
Michael Hansen wrote:

Having a similar issue myself. When I scan in the barcode on Pick, Pack, Ship. It does not parse the string, it just says that the item cannot be found. It also claims the item is:


(01)10822045000183(10)2026-3-CG321041(17)220131

 

This is the full value of the GS1 Code created using the Acumatica Report Writer under the QR code settings. Did I miss a step here? The GTIN is set under the item xref, but scanning 2D codes just isn’t functioning for me.

When printing the barcode in report designer are you using the UCC128 type? 

The barcode should read: “0110822045000183102026-3-CG321041(220131” in the Report Designer,

the ‘(‘ is the designated FNC1 character in this instance

I used the following formula for printing based on item, but can be easily modified to by receipt etc:

='01'+[INItemXRef.AlternateID]+'10'+[INLotSerialStatus.LotSerialNbr]+'('+'17'+Substring(Year([INLotSerialStatus.ExpireDate]),2,2)+Month([INLotSerialStatus.ExpireDate])+IIf(Day([INLotSerialStatus.ExpireDate])<10,'0'+Day([INLotSerialStatus.ExpireDate]),Day([INLotSerialStatus.ExpireDate]))+30+[@qty]

 

@Michaelh Sorry forgot to tag you, this doesn't answer the OPs question but it should fix your issue


Dana Moffat
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 552 replies
  • April 12, 2024

@jgadbois18 @asmith50 Linfa is the North American distributor for RIC Group, the certified WMS ISV on Acumatica Marketplace: https://www.acumatica.com/acumatica-marketplace/the-ric-group-warehouse-management-solution/


Dana Moffat
Acumatica Moderator
Forum|alt.badge.img+2
  • Acumatica Moderator
  • 552 replies
  • April 12, 2024

 


Stéphane Bélanger
Freshman II
Forum|alt.badge.img+1

To produce 2D barcodes easily with any type of data or barcode format, you should use Asgard Labels. To read them, Acumatica has a minimal support for GS1 but it could be extended by way of a customization. 


jeremyd45
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 212 replies
  • August 2, 2024

@Dana Moffat is there any trick to getting these to scan during pick pack ship or receipt? I have been testing and cannot get these to accurately scan into the system. I was going to open a ticket, but came across this as I was looking for other solutions. 


Michaelh
Semi-Pro II
Forum|alt.badge.img+1
  • Semi-Pro II
  • 185 replies
  • August 5, 2024

@jeremyd45 - When you scan using the barcode, what result is it outputting? If we can see the string, we can help identify any issues. The value should only be what the system is expecting, like 

12715678321

It should NOT look like

(07)123434(08)132234

Acumatica is not smart enough to parse those values out YET.  If you 100% need those values to be parsed, I strongly suggest you find a 3rd party who implements this. See the above posts for 2 potentatial sellers.


  • Freshman I
  • 9 replies
  • September 5, 2024
aclair wrote:
aclair wrote:
Michael Hansen wrote:

Having a similar issue myself. When I scan in the barcode on Pick, Pack, Ship. It does not parse the string, it just says that the item cannot be found. It also claims the item is:


(01)10822045000183(10)2026-3-CG321041(17)220131

 

This is the full value of the GS1 Code created using the Acumatica Report Writer under the QR code settings. Did I miss a step here? The GTIN is set under the item xref, but scanning 2D codes just isn’t functioning for me.

When printing the barcode in report designer are you using the UCC128 type? 

The barcode should read: “0110822045000183102026-3-CG321041(220131” in the Report Designer,

the ‘(‘ is the designated FNC1 character in this instance

I used the following formula for printing based on item, but can be easily modified to by receipt etc:

='01'+[INItemXRef.AlternateID]+'10'+[INLotSerialStatus.LotSerialNbr]+'('+'17'+Substring(Year([INLotSerialStatus.ExpireDate]),2,2)+Month([INLotSerialStatus.ExpireDate])+IIf(Day([INLotSerialStatus.ExpireDate])<10,'0'+Day([INLotSerialStatus.ExpireDate]),Day([INLotSerialStatus.ExpireDate]))+30+[@qty]

 

@Michaelh Sorry forgot to tag you, this doesn't answer the OPs question but it should fix your issue

I’ve used the same for barcoding (with UCC-128 code)

='(01)'+[INVENTORYID]+'(10)'+[LOTSERIALNBR]+'(17)'+Right(Year([EXPIRATIONDATE]),2)+Right('00' + Cstr(Month([EXPIRATIONDATE])),2)+Right('00' + Cstr(Day([EXPIRATIONDATE])),2)+'(30)'+[QUANTITY]


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