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?
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:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.