Skip to Content
avatar image
Former Member

How to create a Auto Number for Item master

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 31, 2014 at 10:52 AM

    Hi,

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

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

    • 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