Finance | Project Operations, Human Resources, ...

EFT File Generation to include invoice number

(0) Share

Report

Posted on by Mairead

Hi,

Is it possible to include the invoice number for invoices paid in the EFT file so as the supplier can reconcile what invoice is paid?

I have setup the payment reference on the supplier account however more and more supplier are asking for the invoice number?

Thanks

Mairead

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Mairead,

The EFT that you use for payments is used in which country/region?

In my home country we use SEPA payments that are based on the Electronic Reporting framework, which gives use the possibility to include additional information into a payment file.

However, this is also limited to the available space in the file.

If you have multiple invoices to pay then you might want to send your vendor a remittance advice, which is an out of the box report that you can generate with the payment file.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Maired,

Are you using any 3rd party ISV or Export format to generate EFT file and in which region? Generally to make an EFT payment and to include invoice number in it would require you a customization. I am using 3rd party treasury automation suits in US and we modified EFT format to include invoice and echeck number also in EFT file.

Was this reply helpful? Yes No
Mairead 92 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I am from Australia. We have been using the remittance report but still suppliers are asking for the invoice reference on the bank statements. Does this need a customization?

Thanks

Mairead

Was this reply helpful? Yes No
Suggested answer

Anke Hampel Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Mairead,

Although the format for EFT file is not quite clear, you might want to consider to use payment id instead of payment references.

For example:

AP > Invoices > Invoice journal - Tab: Invoices

Enter Payment ID

Please also adjust the method of payment in payment attributes:

I hope this will help. In case you are still facing problems, please setup a support request for investigations in depth.

Kind Regards,

Was this reply helpful? Yes No