25
Hi,
Just a quick question. Just wondering if it's safe to place/remove a customer on HOLD on the RM00101 SQL table? So essentially run a "UPDATE RM00101 SET HOLD = 1" (or 0) script based on some conditions.
To that point, when you place a customer on HOLD via Sales -> Cards -> Customer, is this the only SQL column that gets affected? Or are there other value changes in this table and/or in other tables?
Thanks!
Thanks Andrea, very helpful. I'll begin testing things out then.
Thank you for using Microsoft Communities. This is Andrea, and I will assist with your question today.
We always recommend you make changes via the front end of GP to ensure you get desired results. If you have a lot of customers that need to be put on hold, you could look at creating a simple integration with Integration Manager as that still uses GP (like running a macro in GP), so if any errors were to occur, you’d be able to see them and address them vs. updating data in SQL.
In core GP, when you put a vendor on hold the following occurs in the tables:
Now, I can’t speak to any 3rd party tables/customizations. If you have any of those in place, there could be other tables that should be updated when you place a customer on hold.
Hope this helps!
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
