Statement reference 00000000

[AKPolarBear]

On our AR Statements, we have several customers that have entries that are of 0 value, apply to 0, balance due 0, etc and reference numbers of 00000000. These are all at the top or first to be listed.
On the tear off strip of the Statement, the reference numbers are invoice numbers with 0 amount due. In looking at the form I see that these are the Apply to Numbers and Document Numbers respectfully.

How do I clear these up and how do I prevent future occurrences?

 

[MacolaHelp]

Sounds like data corruption of some kind. Do you have a lot of them? You should be able to take these trxs out via AR open item load. As a precaution, I would rebuild arcusfil, aropnfil, aropnhst, reset balances and age accounts. Are these transactions that need to be reapplied so they will purge off properly and/or not display on aging and statements? Do these transactions also show on the aging report? Once you clean it up, you'll need to monitor going forward. I'm not sure I've seen this particular problem before, so I'm not sure how to tell you to prevent it. I have seen some very strange results when an AR service invoice is used to write off outstanding credit balances on account & then the two transactions are both applied to the credit balance document. Using a debit memo doesn't create the same result.

 

[crystalreporting]

Given that they are zero dollar transactions, I wouldn't have a problem deleting them outside Macola i.e. through Enterprise Manager, MSQuery, Query Analyzer etc. Files you'd need to clear these records from should be AROPNFIL and AROPNHST. As Macolahelp says, you probably should do some rebuilds etc. and then look for these transactions daily to see if you can establish a pattern or reason they are being created.

Peter Shirley

http://www.linkcorp.com