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
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.
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,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156