PDA

View Full Version : AR Aging Rerport and AR Leager Not Match


wdto925
06-28-2005, 03:30 AM
Dear All,

I have experience a problem regarding to AR Aging report is not match with AR ledger on closing balance.

The scenario is as following:
We received USD$25000.00 from a customer, and later discovered that there is USD$10,000.00 pay for the outstanding, and the remainding USD$15000.00 as a prepayment or overpaid by customer.
From this USD$15,000.00, we did a recieving by ticking "prepayment" in Recipts window. And, this USD$15,000 we use to deduct the other on going Invoices customer owes us.

The problem we experience as following:

(1) We discovered in Journal, that, Credit in Acccount Recievable and Debit in Bank. This transaction is no problem.
(2) But when we try to do recieveing in Recipts window, we found out that there is a negative -30,000.00 in the window using for settle the outstanding invoice.
(3) And, the closing balance on AR Ledger is zero balance and AR Aging is negative in USD$15,000.00

Please help to see which step did wrong? Thanks in advance.

Lisa_p
06-28-2005, 07:32 AM
It sounds like you entered the extra $15,000 twice, but then how could your bank be right?

You really only needed to make one entry for the $25,000. When you selected the invoice(s) to pay originally you could change the amount to total the $25,000 and the customer would then show the $15,000 credit balance on their account.