How to back out 250 Worksheet dated 10262015 9:35 AM that ran 2 different stores? which cause inventory items to display in both stores? Do we run a 401 Worksheet? Is there a best practice or proper procedure to do this? Please, could you help?
*This post is locked for comments
Please do not forget to perform this same process for store_2 to remove their unwanted inventory items.
Worksheet Style 250: Update Inventory – Items. User had ran 2 stores in the Worksheet Style 250 Wizard. User had both stores checked/selected and approved the worksheet. This caused the inventory items of store_1 pos to appear in store_2 pos and vice versa.
Solution:
1.log into store_1 pos (had all users completely out and no transactions can occur),
2.sql -searched for unique items which is in store_2 but should not be store_1: select * from yourdatabase where description like 'corn%' -check the store id in the results.
3.sql : select * from yourdatabasename.dbo.Department-look for "ID" and find the #number for store_2 (leave HQID alone).
4. sql : select * from yourdatabasename.dbo.Item where Department ID = # (store_2 ID) and Description like 'corn%'. (Run several selects. Check with users about results to verify the items does not belong to store_1).
5. *becareful, then delete the unwanted items based on DepartmentID and another qualifier. becareful.-this is permanent.
6. verify-by running another sql select then log into store mgr for store_1 database, select> edit item and find 'corn' -it should not be there.
7. verify with superuser then reboot store_1 pos.
8.Please do not forget to perform this same process for store_2 to remove their unwanted inventory items.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,900 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156