Inactivating a Customer with Open Transactions – Work Around Solution (SQL Tool)

It’s a common case in Dynamics GP that you want to inactivate a customer, although, you always receive the warning message that “You cannot inactivate a customer record with un-posted or posted transactions.
Here is the scenario:
A customer with open transactions has a zero balance, all invoices are paid. Although, the system doesn’t allow inactivating a customer. 

Customer Maintenance Window

Continue Reading Mahmood M. Alsaadi’s Article on their blog

Inactivating a Customer with Open Transactions – Work Around Solution (SQL Tool)

Blog Syndicated with Mahmood M. Alsaadi’s Permission

Leave a reply

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
May 2025
MTWTFSS
    1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  
« Apr   Jun »
Follow
Sign In/Sign Up Sidebar Search
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...