AR Aged Invoice Report showing doubled balance for some lines.

Hello, 

Our accounting department brought to my attention that for certain lines on the AR aged invoice report, the "Balance" field is showing exactly double what the "Current" field is. I went and looked in the database thinking there have been double invoice entries, but for each line we have one invoice and one payment. The strange thing is, our trial balance appears correct and this doubled amount only seems to be present within the aged invoice report. Also, all of these lines are for the same customer if that helps. 

Any ideas as to what may be causing this? 

Thanks!

Parents Reply Children
  • 0 in reply to Surya IT

    With duplication in the work table, the problem has nothing to do with the report and is either: bad data (as BigLouie is suggesting) or a problem with how Sage is preparing the work table data.

    Data that matters for the aging report:

    AR_OpenInvoice (balance? / invoice date...).

    AR_TransactionPaymentHistory (payments, credits... and transaction dates).  Normal transactions should not have negative dollar amounts in this table.  A payment, even though it deducts from the invoice total, is listed as a positive number.

    If these look good, I'd say the next step may be to contact a Sage expert (Sage support, or your Sage partner) for hands-on troubleshooting.