We are trying to clean up our customer accounts by offsetting unapplied payments to outstanding invoices. We have been doing this through Bank Rec but the net effect is zero as we are simply applying items within a customer's account. Now when we look at the bank data in GL (as we are sending detailed data from BR to GL due to reconciliation problems between GL and subledger - ugh), there are a bunch of items posted but for zero amounts. Is there a way to apply these amounts within A/R only rather than through BR as they really have no impact on the bank but are simply being done to clean up the customer accounts and show as current only those items that are truly outstanding?

Thanks!
Tanja

Tanja:

As these transactions don't impact BankRec you can just do them in an AR Cash batch.

The other option is to use the Write Off function in AR to write off all accounts with a balance from $0.00 to $0.00 (be very careful that you ste the from and to amounts correctly as by default you could write off everything outstanding). The net effect of this will be to match up all of the outstanding transactions.