Mass change item code in sales order

hant

Dear all,

My client is a manufacturing company. They receive orders from their customers prior 3-4 months before the goods delivered. During this time, the code of item can be changed due to some reasons (material change, design change...) with acceptance from customers. Does anyone know how to update the item code change to all related orders (not shipped) without recreating new orders?

Thanks in advance for your recommendation.

Regards,

hant

kriki

In general : if you rename a primary key of a record, all places where this is used is changed automatically (if the tablerelation of the field has been set).
For Items, the rename-function is blocked. I don't know if there is a reason for it (maybe for performance-issues).
You might try to disable that blocking code and try it (BUT DO THAT ON A TEST DB!) and then check if everywhere where the item is used it has been renamed.

pindev

This is a common issue. If you create production orders from the sales ones (and I thing you have to this, since you customize the products)you have just to update the item in the SO and then refresh the related PO. However, if you have more complex relations between several SOs and POs (this is not standard for Nav) or you use MPS for manufacturing planning, then you are in trouble and most probably have to change Navision a lot or the way you operate.