So this is a little weird.
We have debtor in our system who has suddenly increased his balance by $210,000, the strange part is that all these invoices relate to April/May 2010.
We run our own statements system that takes a snapshot of open items at the end of every month (going to change this to in house at some point) and I can see these invoices were added second week of April 2010 and by May EOM 2010 the balance outstanding was showing as 0.00. Stranger still is that these items have never left the statement, they still appeared on EOM December as Open but with no balance owing.
Over Christmas we rolled our ledger for 2011/12 and did the various integrity checks etc but with no issues. We have also been going back through 10 years of historical data and removing them from the live file:
Remove Receivables Transaction History - > Transactions and Distributions but we only got as far as end 2006 before realising it wasn't removing much due to out of period data.
We did run the remove Distributions up until July 2011 but the Transaction object is still there.
What could cause the invoice to start appearing as open?
*This post is locked for comments
I have the same question (0)
