New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
Tiffanie

Crystal Reports, Data Matrix, GS1 - 128 - Is there a way around the character limitation of 14 characters for the "01" identfier?

We created a bunch of different sized labels through Crystal Reports after we purchased the new fonts to get a lot of information packed into a datamatrix cube so that it will fit on a very small area. We later learned, after already labeling most of our products, that the identifier "01" has a character limit of only 14 characters and now our project is put on hold! We have used all of our resources and they all say that there is no way to work around the limit as it is a government standard.
Is there another way!? Is there a different kind of label we can use that will fit long product IDs and serial numbers in a small cube in a small space!?
Desperate for help!

Operating System: Windows

Application: Crystal Reports (printing through ACCtivate)

08-09-18     8 day(s) ago     Views: 52

  Report Abuse

 

Tiffanie

Best Answer

Thanks for the idea, but that doesn't work. It is still cutting off at the 14 character limit and our scanner says product 'AP-064-C-U-HC-' does not exist in the database. The product ID that I'm scanning is AP-064-C-U-HC-W-36.

I think the UPC solution is the best work around.

Posted 1 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (5)

Ben
To encode the FNC1 for Data Matrix Application Identifiers, you may use the characters ~1.

The data should appear as:
DataToEncode = ("~101" & {LotSerialInventory.ProductID} & ("21" & {LotSerialInventory.LotNumber}))



Posted 2 day(s) ago

()
()
   Report Abuse

Tiffanie
Sorry, I'm not sure I understand.

Here is a product ID that will not scan with the code DataToEncode = ("(01)" & {LotSerialInventory.ProductID} & ("(21)" & {LotSerialInventory.LotNumber}))
Product ID: AU-032-C-U-HP-W-60-X2

Then we gave it a product ID specific UPC number (2877) to use with the new formula and it will scan the product ID into our system. This works and corrected the character limit issue.
New code: DataToEncode = ("(01)" & {@UPC} & ("(21)" & {LotSerialInventory.LotNumber}))

But, you are saying that we can apply the product ID database field and the lot serial number field into the barcode without parentheses and our mobile inventory gun will scan it into our system?

Posted 4 day(s) ago

()
()
   Report Abuse

Ben
The 01 Application Identifier has a 14 character limit but only for its element string. It is not a limit for the entire barcode.There can be multiple element strings in a barcode.

Here is an example:
(01)3456789012345717991231

It uses the two element strings and has two AIs (01) and 17. The 17 does not require parentheses around it because the previous element string uses fixed data.

Posted 7 day(s) ago

()
()
   Report Abuse

Tiffanie
Thanks, Ben. I'm not sure how to respond to your question through this forum so I'm commenting on my own question.

That is correct, we are using that specification. It's for scanning inventory and we are using Product ID and Lot/Serial data fields. It looks like the scanning system/our database system (ACCTivate) can only read the GTIN-14 GS1-128 and that identifier "01" unfortunately does have the 14 character limit in it. However, we did find a potential work around by utilizing the UPC field for product IDs that are larger than 14 characters and this seems to be the best "work around" solution to this problem.

Here is the old code that does not work for >14 characters:
DataToEncode = ("(01)" & {LotSerialInventory.ProductID} & ("(21)" & {LotSerialInventory.LotNumber}))

Here is the new UPC formula:
if isnull({Product.UPC}) or {Product.UPC}= '' then {LotSerialInventory.ProductID} else {Product.UPC}

Here is the new code for the barcode (datamatrix):
DataToEncode = ("(01)" & {@UPC} & ("(21)" & {LotSerialInventory.LotNumber}))

Unless you have something else that you think would work better as a "work around" solution to the limitation, without changing our product IDs, then I think that is the best thing to do. Thanks!

Posted 7 day(s) ago

()
()
   Report Abuse

Ben
What specification are you trying to follow for GS1-Code 128 and GS1-DataMatrix?

GTIN-14 specification that uses 01 allows up to 14 characters. I recommend reviewing your spec guide and then take a look at your options using the IDAutomation Application Identifier Guide.

If you have additional questions, the appropriate contact is GS1.org

Posted 7 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2017 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook