I have a few customers that will send in two or three cheques at the same time paying invoices (but not necessarily in any order). When I go into the cash batch and appliy payments for the first cheque everything is fine and the amount applied is shown and assigned equals yes. When I go to enter the next cheque, all the previous invoices I've applied all show unapplied and assigned equals no.

Is there a field that doesn't revert so I can quickly see what invoices have been matched? There have been times when I've been interrupted and have applied a payment to the same invoice a second time.

Thanks

Hi Mike,

Don't your clients tell you which invoices they are paying on the remittance advice?

Andrew:

Mike means that you have two cheques from customer A. You record the first cheque as batch 1 transaction 1. Then you record the second cheque in the same batch transaction 2. While recording the second cheque the list of o/s invoices gives no indication of which invoices the first cheque was applied to.

A suggestion for a future release?

Andrew:

I've had the same request made in both AR and AP frequently. In AP it happens if they keep a payment batch open for a few days (they could and should post the batch sooner but that doesn't always happen).

As Doug suggests, a future enhancement?

It's already on the list for both modules, but it's not very easy to implement.

Thanks Doug and Bruce,

Andrew, it doesn't have to be much - highlighting the line, or making the font bold would be enough - any kind of visual differentiation would be nice. This can be even more tedious than bank rec, especially when there are a hundred or more invoices involved spread over three or more cheques.

p.s. What's the assigned field meant for?

Mike:

The challenge is identifying transaction already on an open batch. Once that is accomplish highlighting,or any other thing, will be simple.

Hello Bruce,

Payables 92B (2016.11.07) keeps track of the total amount of payments in open manual check batches for the posted invoice transactions they are applied to. This amount is used to calculate the actual Remaining Amount for the invoice. The Remaining Amount is shown on manual check details. This helps prevent duplicate payment or over payment of invoices.