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?

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (2)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: 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?

Please do not forget to perform this same process for store_2 to remove their unwanted inventory items.
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: 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?

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.