Is there a sql query to update all customers' account balances to $0? I know that it is more than just UPDATE Customer SET AccountBalance = 0.00. In playing around with a test database I can see that the customer is still showing a receivable balance. Do I have to perform an adjustment on every customer to get the balance back to $0?
Much Thanks
*This post is locked for comments
Yes. It is more advisable for record tracing. You will be able to track back your adjustments easily.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,432
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
