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

[Johan_Hakkesteegt]

Hi,

When users create items they are going to make mistakes (wrong series, wrong category, etc.). The only question is, when and how often this will happen.

The item master data code (ItemCode) is locked once it gets used in a transaction.

That means that you cannot change the ItemCode anymore.

These items will be used in transactions before anyone notices these mistakes. The only question is, when and how often this will happen.

Because of this, this method that you are suggesting is unwise.

Users should look at the settings you described, to determine an item's properties, and all business logic should be based on these settings, not on the ItemCode. Queries and reports should use these settings, and not the ItemCode to filter or group results.

If you want to use this method after all, just create a formatted search that gets these settings. As there are so many, it will be difficult to use automatic refresh.

Regards,

Johan

[Former Member]

Hi,

1st of all thanks for your reply.

Actually what their requirement They asking to Automation code based on combination of logic followed running number.

[Johan_Hakkesteegt]

Hi,

My guess is that they want this, because they used this method before they started using SAP Business One.

They do not know that this method is not wise to use with B1. So I strongly recommend that you explain to your customer the risks of the method they suggested, and that all business logic goals can be achieved in better ways (like I explained above).

Regards,

Johan

[Former Member]

Hai,

Client not convinced already try to convince the same as above. but they accept..

any better suggestion & solution.

[Johan_Hakkesteegt]

Hi,

In that case, you should go with the solution Agustin described.

Regards,

Johan

[Former Member]

Hai,

Thanks Johan.