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
  • 0

    I have seen this before, you need to exam the AR Invoice History Header table and see if there are two Header records but only one detail record. Look at the balance in the AR Open Invoice table and look at the records in the AR Transaction Payment History table.

Reply
  • 0

    I have seen this before, you need to exam the AR Invoice History Header table and see if there are two Header records but only one detail record. Look at the balance in the AR Open Invoice table and look at the records in the AR Transaction Payment History table.

Children