Statement Error

Sep 24, 2007 1 Replies
B

I have been using the EMS Data Import program for SQL to import the data from my existing database to our new RMS HQ database. I have successfully imported the customer data, including their account balances.



I'm getting an error message when I try to generate statements which is:



A10: has a balance discrepancy. Accounts Receivable indicates a balance of ?0.00. The last closing balance indicates a balance of ?1,457.45 as of



15/09/2007

Can somebody please advise me as to how I can fix this?



Regards,



Brian McCarthy


Vote
Twitter Facebook LinkedIn
J

Brian,

This error occurs when you close the customer billing cycle and then have new activity against the account in the same day. You need to always close the customer billing cycle at the end of the day (to assure there will be no more customer movement) so as to prevent the error going forward.

The scripts to correct this would be as follows:

Database> Backup

UPDATE Customer SET LastClosingBalance = ($ that last closing balance should be) WHERE AccountNumber = '(Customer Account Number)'

Also note, do not include the parenthesis when executing query.

Vote
Twitter Facebook LinkedIn

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required