on 12-31-2014 10:48 AM
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
Hi,
How do you determine in the EAN table what "the next number" is ?
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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:
or ?:
Regards,
Johan
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:
Would that work for your scenario ?
Regards,
Johan
User | Count |
---|---|
98 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.