web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / How to set store inven...
Microsoft Dynamics RMS (Archived)

How to set store inventory to zero from HQ

(0) ShareShare
ReportReport
Posted on by js2000 60

We closed one of the store last month, so I need to set item quantities to zero for closed location.  I could have set the quantities to zero at store before we unplugging the store POS, but its too late now as that location POS is gone.  

Is there a way to set closed store quantity to zero directly at HQ?  I see total quantities stored in  Item table and individual store quantity stored in Itemdynamic table but have no idea what I need to update and what I shouldn't.  Any help would be greatly appreciated.

Thanks in advance,

Js

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: How to set store inventory to zero from HQ

    Dear JS

    Please use the following SQL statement to adjust the Quantities.

    First Select and check the Store Qty, the sql Statement is as below

    select * from ItemDynamic where snapshotquantity<>0 and storeid=6199 (Instead of 6199 enter your storeID)

    After confirming the Qty the Run the following command.

    update ItemDynamic set snapshotquantity=0 where snapshotquantity<>0 and storeid=6199 (Instead of 6199 enter your storeID)

    Please this is to inform that when you adjust this qty in item dynamic in the item table it will automatically adjust because in the item table the qty is addition of all the stores.

    Thanks

    Umar Khitab

  • js2000 Profile Picture
    js2000 60 on at
    RE: How to set store inventory to zero from HQ

    Hi Umar,

    We transferred the inventory to other store, but we just recounted everything at new location so we can get accurate physical counts.  I think option 3 is my best bet here, but I was not sure about SQL statement and all different places I need to update the quantity. I was looking at one of the product and I found qty is stored in various fields in Item table and various fields in item dynamic table.  I am assuming I need to update on all places.  Can you please help me with SQL which I need to run?

    Regards,

    Js

  • Umar Khitab Profile Picture
    Umar Khitab 750 on at
    RE: How to set store inventory to zero from HQ

    Dear JS.

    First of all if you closed the Store then what about the Physical Inventory. You transfer it to where?

    1. First opiton is to make the transfer Out from the store and then connect your HQ to Headoffice. It will be zero.

    2. If there is no more system on location. If you have backup of Store you can restore it on any machine which have Store operation and HQ client from there you can make it zero.

    3. Check the storeID in you HQ. through SQL server update the Item dynamic table and make the qty zero against the storeid.

    Thanks

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans