1. Home
  2. Point-Of-Sale Software
  3. Statement Error

Statement Error

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

Reply to
Brian_McCarthy
Loading thread data ...

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.

Reply to
jocelynp

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.