4 Replies Latest reply on Dec 22, 2011 8:51 PM by ben deng

    EPDM Serial Numbering Question

    Kevin Stickels

      I am looking for some insight regarding the Serial Number format in EPDM. While the majority of our numbering systems are simply a leading identifier (for example "G"), followed by the date, followed by the counter (001, 002, 003,...etc.) we have a situation where the numbering system has some intelligence (i.e. "hybrid"). In this example, the number is the MRP/ERP "Product Code" (2 char alpha-num) followed by the "Group Code" (3 char numeric) followed by a counter (4 digits numeric) that resets to "0" for each Prod/Group combination. Here is an example;

       

      Product Code = L1, (or L2, L3...)

      Group Code = 010, (or 025, 050...)

       

      Serial # would be: L10100001....L10100002...etc. then if Prod Code/ Group Code are different (for ex. L9 and 999, resp.) the numbering would be L99990001....0002....etc.

       

      Is there any way to map this type of serialization in EPDM? At worst case (so far) I would like to Serial Number the Variable "Prod Code" + "Group Code" + counter. Anyone out there ever run into a similar situation? Need some input relatively quickly. At the moment, I have an Item Master with 4200 entries and I would really like to automate the numbering before it gets too big.

       

      Thanks

        • Re: EPDM Serial Numbering Question
          Ravi Teja

          Hi Kevin,

                     Combining Different Fields into 1.such as "Prod Code" + "Group Code" + counter  is possible but resetting the counter or a creating a new counter for every new combination of "Prod Code" + "Group Code" is not possible (at least as an out of the box solution).

           

           

          Regards

          Ravi T

          • Re: EPDM Serial Numbering Question
            ben deng

            I just work out the problem. The question point is different serial number by the product code. The serial number field in data card can design to a text field where in the option card, and the Option Card display by the Product Code's vairable.

             

            1.jpg

            2.jpg

              • Re: EPDM Serial Numbering Question
                Ravi Teja

                ben deng wrote:

                 

                I just work out the problem. The question point is different serial number by the product code. The serial number field in data card can design to a text field where in the option card, and the Option Card display by the Product Code's vairable.

                 

                1.jpg

                2.jpg

                 

                Hi ben,

                              can you elaborate on what you did?

                 

                 

                 

                regards

                Ravi T

                  • Re: EPDM Serial Numbering Question
                    ben deng

                    Hi Ravi,

                              pls forgive my poor english.

                     

                              ("Prod Code" + "Group Code") +  Counter by Prod or Group .

                               in data card design window, new different counter text field in different option panel, counter text field has same variable name, option panel name same as  value of prod code(or group code) and controled by variable of prod code(or group code).

                              then new a text field to Combination prod code + group code + different counter

                     

                              so when change prod code or group code, we can see different counter text field in its's parent option panel.

                     

                              Hope it's clear enough to understanded.