Question Re: Item master data code logic in Enterprise Resource Planning Q&A

Item master data code logic

Former Member — Wed, 13 May 2015 06:06:25 GMT

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

Re: Item master data code logic

agustin_marcoscividanes — Wed, 13 May 2015 08:15:44 GMT

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

Re: Item master data code logic

Johan_Hakkesteegt — Wed, 13 May 2015 09:02:54 GMT

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

Re: Item master data code logic

Former Member — Wed, 13 May 2015 09:37:42 GMT

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.

Re: Item master data code logic

Johan_Hakkesteegt — Wed, 13 May 2015 09:53:02 GMT

Hi Agustin,

Why step 5 please ?

Regards,

Johan

Re: Item master data code logic

Johan_Hakkesteegt — Wed, 13 May 2015 09:58:49 GMT

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

Re: Item master data code logic

Former Member — Wed, 13 May 2015 10:25:36 GMT

Hai,

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

Re: Item master data code logic

Former Member — Wed, 13 May 2015 10:27:06 GMT

Hai,

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

any better suggestion & solution.

Re: Item master data code logic

Johan_Hakkesteegt — Wed, 13 May 2015 10:49:57 GMT

Hi,

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

Regards,

Johan

Re: Item master data code logic

Former Member — Wed, 13 May 2015 12:40:00 GMT

Hai,

Thanks Johan.

Re: Item master data code logic

agustin_marcoscividanes — Wed, 13 May 2015 12:45:05 GMT

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

Kind regards

Agustín Marcos Cividanes