It becomes quite common for certain businesses to have website with a shop. Often, payments through these shops are handled by a 3rd party payment provider (Adyen, Paypal, Worldpay etc.).

When receiving statements of these providers, the statement normally contains a unique payment reference. This payment reference is normally stored in the data of the webshop. It's quite common to download these orders into Business Central for further processing in warehouse, inventory & finance.

To match payments, a statement is downloaded from the provider containing the unique payment reference.
Unfortunately, it is not really possible to use the Payment Reconciliation in this situation because it is limited to Bank Account, Name & Address, Document No., External Document Number and Amount.

Please see below reason why it's not possible:
- Bank Account: The bank account is always the same for all transactions (e.g. Adyen, Worldpay)
- Name & Address: This is normally not available in the statements of such payment providers
- Document No.: When the order is placed online, the Document No. is not yet created in Business Central
- External Doc. No.: It's unelegant to use this field, because it is printed on Sales Documents (the Customer would not be able to relate to this number, when it is the unique payment reference of the payment provider)
- Amount: It could be that several open invoices with the Amount exists

It would be great if you could add a new Publisher-Event, that is executed in the "DocumentMatching"-function (as the last command). The parameter should be:
- SearchText : Text
- TempLedgerEntryMatchingBuffer : TEMPORARY Record "Ledger Entry Matching Buffer"
- VAR BankPmtApplRule : Record "Bank Pmt. Appl. Rule"

You have a similar solution in the function "DocumentMatchingForBankLedgerEntry" already.
Using such Publisher-Event it would be possible to match for additional fields which could contain a unique payment reference.

Hannes Holst
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.

Best regards,
Business Central Team



"DocumentMatching"-function of Codeunit 1255 "Match Bank Payments"

Category: Financial Management