I want to change item number from 001199 to 001199CS. But I can't do that make new item and download. Because this item number(001199) has very important movement history. So. I want to Change this item number.
Anyway, I do Worksheet 51. Sql : Upate itemlookcupcode ='001199cs' Where ItemLookupCode='001199'
Is it right or wrong? Could you check this statement?
Thank u
I don't understand why you can't change the lookupcode. The History is tied to Item.ID, which is an internal number that you never see and can't change. You just want to change Item.ItemLookupCode, which is a Varchar value that you CAN change. As long as the item has already been syncronized between HQ and Store, it is going to be linked by HQ.Item.ID = Store.Item.HQID. You can change the Lookup Code at HQ then use a
250 worksheet to send the change to the store.Glenn Adams Tiber Creek C> I want to change item number from 001199 to 001199CS.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required