Hi there,

The issue might be in the database. Here are some steps that might help resolve it.

First Customer aged (subledger) and Accounts receivable account (general ledger) should match either $301.36 or $301.38.

The program displays on Cheick Data integrity window balances as of the latest transaction date (which can be seen on Setup > Settings > Company > Information).

Normally Customer aged total outstanding should be the same as Accounts receivable account balance as of the latest transaction date.

So when you display Customer aged and Accounts receivable account make sure both reports are as of the latest transaction date.

If after that they do not match the balances on Data integrity make sure to reset both reports example Reports >  Customers and Sales or Receivables > Customer aged > select Default report options under template line > Then choose the latest transaction date and customers then display the report. Make sure to select Default report option on template line before displaying Account receivable account too.

Second you can run a database utility on the file to rebuild the database and have the data table display the correct information on screen. Usually dbutil will get rid of the data inconsistency of few cents or will move the inconsistency to where it should be.

Here is the link on how to run dbutil : http://bit.ly/165bYZb

If the data inconsistency is moved to another area(s) on Data integrity screen you can resolve it by following the below article if foreign currency is not used and the discrepency is not between Total debit and Total credit.

http://bit.ly/14QyuWk

If the inconsistency is between Total debit and Total credit the database needs to be put back into history mode. You will have to call support (1-888-522-27222) to do that.

Hope this helps

Thanks

Hi there,

The issue might be in the database. Here are some steps that might help resolve it.

First Customer aged (subledger) and Accounts receivable account (general ledger) should match either $301.36 or $301.38.

The program displays on Cheick Data integrity window balances as of the latest transaction date (which can be seen on Setup > Settings > Company > Information).

Normally Customer aged total outstanding should be the same as Accounts receivable account balance as of the latest transaction date.

So when you display Customer aged and Accounts receivable account make sure both reports are as of the latest transaction date.

If after that they do not match the balances on Data integrity make sure to reset both reports example Reports >  Customers and Sales or Receivables > Customer aged > select Default report options under template line > Then choose the latest transaction date and customers then display the report. Make sure to select Default report option on template line before displaying Account receivable account too.

Second you can run a database utility on the file to rebuild the database and have the data table display the correct information on screen. Usually dbutil will get rid of the data inconsistency of few cents or will move the inconsistency to where it should be.

Here is the link on how to run dbutil : http://bit.ly/165bYZb

If the data inconsistency is moved to another area(s) on Data integrity screen you can resolve it by following the below article if foreign currency is not used and the discrepency is not between Total debit and Total credit.

http://bit.ly/14QyuWk

If the inconsistency is between Total debit and Total credit the database needs to be put back into history mode. You will have to call support (1-888-522-27222) to do that.

Hope this helps

Thanks

Keith:

The reports are already at the last day of my fiscal year (June 30 2013)

I have run the dbutil and it did not change anything!  Here is the integrity summary

My customer aged report shows 257.84, which is made up of $50.43 in customer credits & deposits and $308.27 in receivables

You will note that the Deposit Acct Balance is $43.54, this appears to be due to one of the customers having a credit note of 6.89 (50.43 - 6.89 = 43.54)

I understand how I could fix the 2 cent discrepancy by un-linking the AR account,  It also further appears that the credit note is the exact amount of the difference between the Unpaid invoices total and the amount in the customer aged report.

I am going to clear the Credit Note from my system by doing a cash refund to the customer, which should make it easier to understand the adjustment that I need to make to the AR ledger account.

Then I am going to un-link the AR ledger account and make a Journal entry to correct the $0.02 discrepancy, this should fix the data inconsistency!

It seems strange that SA is treating the credit note as a receivable, also that when a customer has a deposit it shows up in the customer aged report by default; I am not an accountant so perhaps this sort of thing is actually to be expected!!!!

Any further comment or suggestions would be most welcome.

I see that my graphic did not show up, how do I get an image to appear in the post?

Issue Solved, thanks to those that helped.

Happy to know that the issue has been resolved :)

As for the image upload my recommendation will be to use a JPG format.

Also click on Use rich formatting on the lower right side of the answer box then upload the image by clicking on Insert/Edit media icon.