You’re offline. This is a read only version of the page.
66
Need to run a SQL query to change over 100 inventory items' Default site ids in the Inventory module.
1. Would like to know if "Inventory.DfltSite" is the only one place that needs to be changed? Also,
2. Can I run query anytime ?
Thanks for your help!
*This post is locked for comments
I have the same question (0)
Hi Ginny,
You have to update the INDfltSites for the siteid and ItemSite if the location changes too.
update indfltsites set dfltpickbin= @DfltPickBin,dfltputawaybin= @DfltPickBin,dfltsiteid= @NewSiteId,lupd_datetime= GETDATE(),lupd_user= 'SYSADMIN' where invtid= @InvtID AND cpnyid= @CpnyID
UPDATE ItemSite SET DfltPickBin = @DfltPickBin, DfltPutAwayBin = @DfltPickBin WHERE InvtID = @InvtID AND SiteID = @DfltSiteID
Run your query with a Begin Transaction and Commit Transaction and can run it anytime.
Share
Report
All responses (
Answers (
