Dear Community,
I am now facing a problem most of us must have faced at one point : after having migrated many invoices & payments from the legacy system (3 years worth of accounting history) I now have to settle these transactions.
As of today, they are not settled which the makes invoices appear in the aging report and in the open customer/vendor invoices.
The transactions were migrated with a special code written in the description, so I know which are supposed to be settled together. I have now 2 main issues :
1) Is there a way to settle them in bulk ?
2) how can I have a common settlement reference in case of an N to M relationship ? (for example 2 payments for 3 invoices).
I have already given it some thought and here are my comments/ideas :
1) What I want to do is to settle posted transactions as if I was doing it manually from the customer/vendor transactions form, but in bulk.
I am trying to find a way with Flow, using the 2 entities (Vendor)PaymentJournalLineSettledInvoices. It seems that all settlements do not use these entities.
When settling transactions directly from the customer/vendor transactions form, no record is created in these entities. It means that the settlement is stored somewhere else, using another entity. Could someone point me to the correct data entity ?
2) I believe the standard works something like this (see image below). P1 settles F1 fully and F2 partially. P2 settles F2 partially and F3 fully. So P1 and F3 have no link at all, even though the customer said "these 2 payments are for these 3 invoices in no particular order". In other words, I should be able to see a common reference for all the transactions (P1 P2 F1 F2 F3). Is there a way to find that common reference ?
thank you very much for your help,
Alexis
