In Dynamics RMS 2.0. HQ and SO, how can i safely remove 150+ item categories that aren't being used?
via sql script to remove the categories at HQ then sync it back to the database? or? is there a proper method?
thank-you
Raymond
*This post is locked for comments
Hi, Ray. What you want to do is a little tedious, as you have to (well you should) compare anything you want to delete to your transactions and purchases first so as not to screw up your reporting or hq syncs.
also compare items with categories. this usually has to be done first in hq, then in the stores. you can say 'DELETE FROM Category WHERE [Name] = 'Whatever'. But make sure you have a plan first, and backup your database first!!!
If you need help you can email me.
-Jerry
jerry@jrdata.us
Hello Raymond,
There is not a way to do this safely as it will cause orphaned values and may potentially damage the database.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (