Skip to main content

Notifications

Microsoft Dynamics RMS (Archived)

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?

Posted on by 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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans