We have a set of items separated by bin location in HQ that we are setting to inactive, and we've recently started doing so at the store levels.
Is there a way to either update the items in HQ as inactive once they are at all stores, or perhaps pull the local status with HQ?
It's more convenient to work on these locally, but I need them set to inactive in HQ as well in the most efficient manner.
Thanks!
Your friendly neighborhood Pawlybeans
*This post is locked for comments
I've not gotten the chance to, since I have to go through the owner first, and even then, he's very nervous about allowing anyone but our RMS parter or his personal tech guy to work with SQL.
I've decided for the time being that I'm going to go back to making items inactive at the HQ level, since I can also put sales block in place from there.
Hi! Have you checked to see if there is a worksheet and/or SQL script that could be run? You might want to check with your Microsoft Dynamics RMS/HQ Partner/VAR.
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,902 Super User 2024 Season 2
Martin Dráb 229,316 Most Valuable Professional
nmaenpaa 101,156