How to create a Auto Number for Item master

[Former Member]

Hi Experts

I have a requirement where the Item Code has to be picked from the EAN list (Bar code list), Is it possible to write a Formatted Search query and pick the next number from the EAN Table(User defined table?)

Please help out

[Johan_H]

Hi,

How do you determine in the EAN table what "the next number" is ?

Regards,

Johan

[Former Member]

Hi Johan

The EAN table contains numbers generated from a barcode generator, that will be added in the table, and it has to select the numbers in the table, not duplicate the numbers

[Johan_H]

Hi Sachin,

Ok, how do you register in the EAN table that an EAN code has been used ?

In other words, how do you know that there is a new EAN code available in the EAN table, and that it has not already been used ?

Regards,

Johan

[Former Member]

Hi Johan

Think we need to flag the used EAN Numbers when the item number fetches the particular EAN number.

We can have logic to pick the continuous numbers entered in the EAN table

[Johan_H]

Hi Sachin,

It sounds like you would do better to change this method around, and first create the new ItemCode (a simple running number for example), and then create a formatted search (query) to generate the new EAN code based on the ItemCode in the system CodeBars field.

That way you do not need a user table, or a separate EAN code generator, and you have no problem with a user forgetting to run the generator first, when they try to set up a new item.

Regards,

Johan

[Former Member]

Hi Johan

thanks but how will the EAN be selected? as its a random number generated by the Bar code software which has to be used as Item Code

[Johan_H]

Hi Sachin,

Do I understand correctly that you create the EAN code and print it on a product (or package) directly from this Bar code software ?

In other words:

1. Create the physical new product
2. Run the Bar code software that is connected to the printing process that prints the bar code on the product or package.
3. Copy this new barcode into the user table in B1
4. Setup the new product in B1

or ?:

1. Create the physical new product
2. Run the Bar code software.
3. Copy the new bar code to the printing process that prints the bar code on the product or package.
4. Copy the new bar code into the user table in B1
5. Setup the new product in B1

Regards,

Johan

[Former Member]

hi Johan

The EAN is generated by the Bar code printer vendor and it is shared, and there is no integration with barcode reader, the only requirement is to pull the EAN number into Item Master data. It would be great if you can help on that

[Johan_H]

Hi Sachin,

Ok, so generally speaking an EAN code with 13 numbers is made up of 4 parts:

[Country code][Company code][Some number][Check sum]

As an example: 6417367837585

64 = Finland

17367 = our company ID

83758 = the running number

5 = the check sum

When you check your Bar code software, you will probably find some settings somewhere that contain the country and/or company codes. Then the bar code software generates a random number and calculates the check sum number.

See this article for more information on how EAN codes work.

This principle can be duplicated in a query, and thus it can be used directly in B1.

So the whole process would become:

1. Set up the new item in B1
2. Generate the ItemCode as a running number with a formatted search in the ItemCode field
3. Generate the new bar code with a formatted search (query using the new ItemCode ) in the CodeBars field
4. Copy the new bar code to your printing process.

Would that work for your scenario ?

Regards,

Johan