You’re offline. This is a read only version of the page.
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
Sounds like you have missing records in the RM Apply Table. If you do not care about these transactions you can run Remove Transactions. If you do wnat to keep them you can try turning off posting to GL, void them, re-enter them with correct dates, apply payments to them and push them to history. Do you have test database where you can try this out first? Can you get help from your reseller or open a support case with Microsoft? This can get a bit tricky.
Narrowed it down some.....
I restored our year end database (created in December) and had a look at the receivables. The documents were open still and had a receivable transaction against them. On drilling into this receivable we got the no document exists error. These documents didn't show as overdue on the summary.
I ran a checklinks and it gave me a variety of no RM records exists for the above receipt and deleted them.
Then the documents appear on overdue.
I can see the cash receipt for this payment on 31st May 2010 in the bank POSTED DIRECTLY TO TRADE CREDITORS but not associate with a subledger account (drives me mad that people do that.)
Reconcile doesn't seem to solve the problem, checklinks doesnt solve the problem - is this now a database level issue?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (