Reconciled refunds still outstanding

[ramam1]

Hey there,
On accpac 5.6 current...
We have a few entries from 2010 that are refunds which were posted and cleared but when I go to AR Customer Inquiry I see that they are listed as outstanding. Any ideas?

thanks

 

[DjangMan]

Check AROBL - do they show any outstanding amounts?

 

[ramam1]

The RF documents have AROBL.AMTDUEHC = 0.00

 

[DjangMan]

You could try running rvSpy when you refresh the Customer Inquiry screen to see where that screen is pulling the data from. That should get you close to the answer if not the answer itself.

 

[ramam1]

It's pulled from ARPYM.SWSTATUS - but the entries don't show up in Banking as unreconciled. What am I missing?

 

[DjangMan]

Does integrity check reveal any problems? Perhaps run a query to see how many refunds are still showing open. If you give me that query I can run it against a few other databases to compare.