Closing billing cycle

Posted by DW on February 4, 2006, 12:07 pm

Please log in for more thread options

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?

Posted by Rob on February 4, 2006, 1:19 pm

Please log in for more thread options

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:

> 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?