Skip to main content

Notifications

Microsoft Dynamics RMS forum

remove store from headquarters

Posted on by 90

I have a client that has headquarters installed, but the second store is no longer in business.  What steps are needed to detach from headquarters? If it wasn't that Headquarters has caused problems with inventory amounts they would leave it alone.

*This post is locked for comments

  • Shawn Meade Profile Picture
    Shawn Meade on at
    Re: remove store from headquarters

    Hello Aaron,

    To remove a store from Headquarters, you just need to locate all tables with the store ID column (you can use the KB Article below to help with finding those:)

    How to obtain the database schemas for Microsoft Dynamics Retail Management System

    mbs2.microsoft.com/.../kbdisplay.aspx

    Once you have them, you can then run a script such as:

    "declare @SID as int

    set @SID = X

    delete from Accounting where storeid = @SID

    delete from AccountingBatchExport where storeid = @SID"

    Then just add each table that has the store ID to the list.

    Remember to change the X to being the store ID.

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

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

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,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans