Finance | Project Operations, Human Resources, ...

Vendor Payment file generation through Electronic reporting

(0) Share

Report

Posted on by VermaMC

463

Hi people,

We are doing a fresh implementation of D365FO. We have a requirement to build a vendor payment file to match the bank file format. I have couple of questions.

1. Do you recommend using the Electronic reporting for Vendor payment for a new country(for Eg: NZ) which Microsoft is not providing by default? or Do you recommend a traditional customization for ACH Classes for the new payment file?

2. I tried to duplicate the existing BACS (UK) and do the changes for my requirement. However, I am finding it hard to know which table and which fields are on the list as the labels of them are completely different as in the table in AOT in the binding screen. Please help me with it.

Regards,

Verma MC.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,612 Super User 2025 Season 2 on at

Like (0)

Report

RE: Vendor Payment file generation through Electronic reporting

Hi Verma,

1-It depends on your Bank. Some banks works just with ISO20022 standard and they just provide or receive file based on these formats. For more info please check dynfotech.com/.../

2- You can create a customization based on standard GER config that Microsoft have come up with. In this case, BACS (UK) with version 43.12 use payment model 43 as base.

When you click on Designer and then Mapping, you can check the provided mapping for each fields:

On your duplicate format of BACS (UK), you have the possibility to Modify mapping or crate a new fields.

BACS (UK) use "Payment model mapping 1611" > "CustomerCreditTransferInitiation" as mapping model:

If you need to change mapping on your model mapping you create a duplicate format config for "Payment model mapping 1611" and perform the required changes.

In order to get better understanding how GER works and how you can create a customization, please check the following posts on Microsoft docs:

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/electronic-reporting-configuration

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-quick-start3-customize-report

Was this reply helpful? Yes No
VermaMC 463 on at

Like (0)

Report

RE: Vendor Payment file generation through Electronic reporting

Well, I am not sure if this is purely functional consultant related. But, if there is any suggestion or guidance over the requirement that I mentioned it would be of great help irrespective of who responds to it.

Regards,

Verma MC

Was this reply helpful? Yes No
Suggested answer

WillWU 22,361 on at

Like (0)

Report

RE: Vendor Payment file generation through Electronic reporting

Reply,

Please wait for the help from functional consultants.

Was this reply helpful? Yes No
VermaMC 463 on at

Like (0)

Report

RE: Vendor Payment file generation through Electronic reporting

Hey people,

Any help on this would be greatly appreciated. Thanks.

Was this reply helpful? Yes No