Hello

If the debit and credit amount is matching perfectly then you can use highlighted option. You don’t enter allowed difference. It will populate matching amounts and you can see in proposal details.

See example below

If you want to match debit and credit transactions in different amounts, then you have to enter a difference. The difference amount will be posted as a new ledger item called difference item. If your remaining amount is arising from an invoice, then your original invoice is set to PaidPosted and you have a new difference item. If it is from payment, then your SUPOA transactions are paid and you have a new difference item.

As far as I know, there is no function that will fetch all debit transactions and match with unpaid invoices based on due date. And matching will stop where the debit transactions are 0.

Hope this helps

Thanks for the Info. I tested the Same, it seems like it works Only in Case the Payments of “SUPOA”. Supplier On Account Payment and Supplier invoice. Does not do the Setoff if it is “SUPIA”. Supplier Advance Payment. 

It really would be helpful if one could run a proposal offset for all open items.  I have over 300 items to offset against one credit and going the route of a manual offset is just painful.

Hello, 

I face the same issue, 

I get the error as mentionned in the screenshot below.

Could you fix the problem ?

Best regards

@gumabs 

Hello 

Is the screenshot visible to you ?

Hello @Abdessamad 

Please show the records from supplier 0002992. Then I  hope I can comment why it is not matching.

Thanks

Hello, 

Yes here’s attached the payment setup of the supplier

And the elements of offset when I chose the manual option

Hello @Abdessamad 

I think in your case only SUPOA 1618 and SUPOA 1619 should be selected with matching option 1 and 2. The others will not match because subtotal for all other items is not going to 0.

System is not very clever. Say that you have 5000 invoice and 4500 payment. This will not match because the balance is not going to zero after matching. You need to match them with manual offset option.

Hope it is clear