Item master data code logic

[Former Member]

Dear Experts,

Want to automatic creation for Item master data code based on logic :

Totally 6 category of Item master data classification:

1. item series

2. Item category

3.item drawing category

4.parts identification id

5.Product group

6.Item Classification.

If any one category changing by manually, changes basis running item code creation based on combination

Example :

1. Item Series                  2. Item Category            3. Item Drawing Category       4.Parts Id list        5. Item Group         6. Item Classification

   97-consumable goods       0-standard                        c-component                       x                             adr                         project

[agustin_marcoscividanes · Accepted solution]

Hi

you can use a FMS to calculate the code for each item when you are adding a new.

Remember you cannot change the itemcode for an ítem when it has transactions.

Also, you can:

1. use the automatic series for itemcode.

2. create an UDF for OITM to save your "itemcode".

3. create a FMS to calculate your code with your restrictions.

4. put the FMS in the UDF.

5. add this field in document lines.

Kind regards

Agustín Marcos Cividanes

[Johan_Hakkesteegt · Accepted solution]

Hi Agustin,

Why step 5 please ?

Regards,

Johan

[Former Member · Accepted solution]

Hai,

In Existing ERP they followed Same Item Code Logic. They y using 5 kind of steps.

[agustin_marcoscividanes · Accepted solution]

Hi

If the "itemcode" changes, we can do a query to filter when it was sold, bought o made.

Kind regards

Agustín Marcos Cividanes