5,080
Hi there,
I need to mass update some of our manufacturing pick lists to pull from a temporary location without editing the BOMs
I did an update script in the TEST database and it appears to have worked.
Just want to know how safe it is...doesnt seem to have broken anything??
update PK010033 set LOCNCODE ='SC14' where MANUFACTUREORDER_I ='xxxxxxxx'
Any thoughts on doing this??
Tami
Hi Becky...good to hear from you too.
I did try it in the test and it appeared to work ok.
Just didn't want to break anything!
Hope all is well in these crazy covid times we are in.
Take care and stay safe!!
And thank you!
Tami
Hello Tami,
Thank you for using Community Forums. My name is Becky and I will assist you. Good to hear from you.
I would think you could do this. I would set an addition condition in you SQL Script to make sure the Manufactureorderst_1 is 3. I would not change it for MOs that already have issued components or have an MO receipt completed. I would not change it if there is any activity on the MO. Also, make sure you are not changing it to a site you just created. When an MO is created, all item/site possibilities for each component gets added to the MOP1400. A new site would be missing from that table.
There are two site columns in the PK010033 table, the LOCNCODE is the issue from site, and the WCID_i is the issue to site.
Hope this helps.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (