On day 1, customer X buys some products. I send an invoice A with total amount Y and a payment term of 60 days.
On day 30, customer X comes back and buys the same products again, so I send an invoice B with total amount Y and a payment term of 60 days.
On day 40, customer X pays invoice A
I export the bank statement and import it into Tryton
I start the reconcile wizard to reconcile the invoice
The (nasty) problem is that the wizard takes invoice B to be reconciled. This means that the customer 70 days later is asked to pay invoice A, which he already did. And because the amounts of the invoices are the same it is overlooked easily.
Is this something which can be enhanced in the code with a date sorting?
Completely agree, but that’s not the case and this issue pops up after years of everything working perfectly. So the users are not used to add the invoice.
There is room for improvement here also, for example when using rules if we only have the party information the invoice is not filed and the user needs to select it manually and most of the time forgets it.