I'm getting an error message when I close the billing cycle that 4 customers are out of balance and it won't let me close any accounts. I've looked at the customers and I can't see anything wrong with them.
Any suggestions?
Closing billing cycle
Feb 04, 2006
1 Replies
Basically what it is telling is that your the Accounts Receivable and the Last Closing Balance for those 4 customers do not match. You need to make them equal, in order to do that you need to make note of the Accounts Receivable Balance and the Customer Account Number from the error message. Then run this SQL statement in SO Admin UPDATE Customer SET LastClosingBalance = x WHERE AccountNumber = 'y' x = AccountsReceivableBalance y = AccountNumber
******************************************************** MAKE A BACKUP OF YOUR DATABASE BEFORE DOIN ANY UPDATE QUERIES ********************************************************Rob
"DW" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required