A client has the following situation (simplified) to which I don't have a ready answer:

A vendor sent an invoice dated 9/1 for $1,000, terms 2%10, net 30. The vendor also issued a credit note unrelated to this invoice for $1,100 dated 9/2.

On the check run dated 9/5, the vendor is not selected, since the balance due is negative.

The vendor now sends another invoice for $1,000 dated 9/8, same terms.

On the check run dated 9/12, the vendor is now selected, since the balance due is $900. However, the 2% discount is taken only on the second invoice, so the net pay is $880. Really, the discount should be applied on both invoices, for a net pay of $860, even though technically the first invoice is more than 10 days old.

Here is the client's question to me:

"Is there a way systematically for those invoices that should have gone last week to reduce the outstanding credit by the discounted amount instead of the original invoice amount other than manually applying them?"

Thanks

Steve