Sage100 - Cash Receipts Entry - Deposit Remaining - Out of Balance

AR Clerk entered a deposit and distributed all the checks to proper accounts and invoices.

On the Deposit Header tab the "Cash Amount Remaining" and "Deposit Remaining" fields each have the amount of the last check distributed.

When I click on the close "X" I receive a messagebox telling me the deposit is out of balance "Do you want to delete the deposit?"

I have reviewed all the postings and retotaled the amounts by hand, the sum of the distributions are the correct total of the overall deposit.

However, I am unable to proceed, as the system is showing the total deposit out of balance?

(I did attempt deleting the invoices for the last customer and re-entering the payment to the invoices...resulting in the same issues)

Any ideas?

Parents
  • 0

    I got an idea that you have a number field that has a value past two (2) digits and you can't see it but the system can. I would export to Excel  the Cash Receipts Header and Detail files and the Cash Receipt Deposit file and look at the values. 

  • 0 in reply to BigLouie

    Thanks BigLouie.

    Exported the data and all records look fine.

    Summed the distribution column of each check and the total does not show extra characters and totals the total deposit

    I have one invoice where there was a .02 discount. The total of that and the applied amount is correct and totals the check.

    All of the other fields look fine...one check # is longer than the others... But no decimals in this either...

    I am still unable to post this cash receipts as it continues to show the Cash Amount Remaining, Deposit Amount Remaining and the Out of Balance...

Reply
  • 0 in reply to BigLouie

    Thanks BigLouie.

    Exported the data and all records look fine.

    Summed the distribution column of each check and the total does not show extra characters and totals the total deposit

    I have one invoice where there was a .02 discount. The total of that and the applied amount is correct and totals the check.

    All of the other fields look fine...one check # is longer than the others... But no decimals in this either...

    I am still unable to post this cash receipts as it continues to show the Cash Amount Remaining, Deposit Amount Remaining and the Out of Balance...

Children
No Data