Dear Guys,

I have a AR customer = "Cash" which has been building transactions over a long time populated from the "Counter Sales POS".

Now it has been brought to my attention a balance exist (should not be).

I am unable to eliminate all the matching invoice and receipts only leaving, unpaid or outstanding invoices.

Would like to extract these records for a closer reconciliation.

What functionality in AR could serve my needs ?

Thanks in advance.

Hi Edward

If it were me, I would use the Maintenance | Create Write Off Batch function. Enter that customer only, and put in a range of dollar amounts from -999999 to 999999. It will create an adjustment batch which you can review.

If you are OK with the batch, when you post it, everything is matched up.

AR adjustments hit the GL account defined under the customer's control account set - the writeoff field.

Steve