You’re offline. This is a read only version of the page.
Hello,
Our company ALWAYS has the Priority 1 bin and the 8 default bins set to the same bin. Is there a script that I can use after I set all the PRI1 bins to make the 8 Default bins use the same value, per part number, per site?
Here's the SQL I use to insert the bin records:
INSERT
IV00112 VALUES ('08060115','403','59C',1,0,0)
Here's the SQL I use to update the bins created with the script above as PRI1
UPDATE IV00117 SET BIN = 'AE5A' WHERE LOCNCODE = '429' AND ITEMNMBR = '11040003'
Sheldon Thomas
Thoughts? I assume I couuld modify my existing scripts to do this, but I wanted a second opinion from folks that have more expreience using this system... Any Help will be appreciated
*This post is locked for comments
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (