Skip to main content

Dear experts

 

What is your approach for the automatic supplier payment matching with a CAMT.053 file? On a customer environment (Apps 10, update 15), we have set up CAMT.053 and it works fine for customer payments. What we are missing so far is the automatic matching of the supplier payments with the corresponding payment order. When the CAMT file is loaded into IFS no automatic matching takes place and the order ID has to be added manually (e.g. in the mixed payment window):

 

 

Is there a way in IFS standard to automate this process. E.g. when creating a supplier payment order to add the order ID into the payment order XML file (reference tag), so that this information can later be used in the CAMT file for automatic matching with the referred payment order? 

 

 

Many thanks in advance.

 

Best Regards,

Lukas

You can defined that message code is a Supplier Payment. In the file you can look after ICDT for supplier Payment message Code. 
 

Here after the external payment parameters must includ this message code. 

But before this basic data for the payment format must be setup. Find the payment format you are using and add Message Code ICDT. 
 

 Sorry for a fast description but i hope you can use it.  


Dear Rasmus, I have setup all of your recommended settings, but it is not working at all. :(

The thing is, that I do not have a real bank statement with real figures. I have done a supplier payment proposal with the order ID 144 and entered manually in the InstrID field.



Message code ICDT is connected to Supplier payment in the external payment parameters and in payment format message codes.

And there are not identifier connected with ICDT.
 


Could it be that there is a setup missing or is the xml file not correct, due to my fake entries. 

Thx in advance,
Benjamin

 


Hello everybody,

as far as I know, IFS cannot match imported supplier invoices via MT940 or CAMT - only for customers.


Thank you for your reply Link!

 

Okay I understood. That means the supplier invoices musst handled manually in the external Payment Details
 

or in Mixed Payments?

But is there a way, that IFS can recognize the supplier ID at least?

 


Hi All,

Let’s discuss this from an AP Settlement perspective.  You can pay for your supplier invoices directly via IFS or settle outside IFS. 

  1. Directly via IFS (Create payment via Supplier Payment Proposal flow) - AP Settlement: You will match the invoice and settle the invoice upon uploading the bank file or you will wait till the bank statement is loaded
  2. Pay via your internet banking or 3rd party link - AP Settlement: You will settle the invoice manually through a payment window, e.g. Mixed Payment or you will wait till the bank statement is loaded

If you are going to do your AR/AP reconciliation via a bank statement such as CAMT.053, the supplier invoice matching requirement will be decided based on your AP settlement practice. 

In the 1st point, your invoice are included in the payment order, so you don’t have a way to select it again in another payment window such as External Payment. So, you are supposed to match the Payment Order via CAMT.053. The idea is you will Acknowledge your supplier payment order and create the payment via CAMT.053 file (Load to external payment and then execute via mixed payment).

In the 2nd point, you have an option to match your supplier invoices via CAMT.053. If you have a clear supplier invoice reference (e.g. exact payment reference or supplier invoice) in your statement, you can match the individual invoices via external payment flow. If you don’t have an invoice reference, you can identify the supplier based on the bank account you used ( the bank should be able to send the supplier’s bank account number in the CAMT.053 file). In this case, you can create the payment as payment on account.

There is no limitation in IFS core logic. You have to play a bit on the external payment parameters or get consulting help. 


Hello Eranda,

thank you so much for your very good details. I see that the process is mainly used for the incoming payments to the bank. With regards to supplier payment, it should be handled in the external payments or at Mixed Payments - depending on the personal taste of the user. 
Supplier ID can be found via bank account and a SUPOA can be posted on the supplier ledger account.

Supplier payment order can be acknowledged in the mixed payment (if that has not be done before).
 

I am enlighted and know what IFS is capable of.

Have a nice day,

Benjamin


Reply