Import File for Customer Payment using Electronic Reporting

(4) Share

Report

Posted on by Nikhil More

385

Our Customer is using LOCKBOX functionality in GP to create the Customer payments for Checks. Well, in D365 we don't have anything standard functionality for lockbox.

Well, on Customer Method Of Payment - we have option to map Customer Payment journal and also to map Import file format.

In Electronic reporting how we have create file which can be used to maped here in this option.

Please find attached screenshot below-

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (8)

Answers (2)

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

HI Nikhil,

Do you have a question or did you want to share your experience only? If you have a question, please explain what Lockbox is and how you need help.

Was this reply helpful? Yes No
Nikhil More 385 on at

Like (1)

Report
Copy link

Link copied!

Thank you @André Arnaud de Calavon for reply.

Yes my question is-

In existing system GP - we have something call "LOCKBOX".

The Bank Sends file for Customer Check Payments - which is Comma Deliminited File. This file then can be then imported in GP and Customer payments lines get generated.

Well in D365 we don't have the same functionality. Documents say- Need to use ISV or can be done through electronic reporting.

So to try it with electronic reporting, I see "Import" option on Vendor Payment Journal - which is linked with AR Method of payments.

On AR Method of payment we have option to link Electronic reporting mapping at Import file Configuration option.

.

I am not able to see the electronic Reporting file for import. I have attached image above.

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Nikhil More

Microsoft provides many out of the box payment formats and other configurations for import/export scenarios with ER configurations.

You need to import the configuration first, before you can select it on the Payment Methods.

You can do so using the two workspaces in the Dynamics 365 F&O (Electronic Reporting ; Globalization Studio)

Here is Microsoft documentation: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/electronic-reporting-import-ger-configurations

Please note that if no out of the box configuration suits your needs, you can create a custom configuration.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

CA Neeraj Kumar 5,099 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @Nikhil More

I tried to understand how the Lockbox functionality works in Dynamics GP. From my research, the closest equivalent in D365 Finance and Operations would be using MT940 bank statement reconciliation. With this approach, you can create a customer payment journal by setting up matching rules, which allow automatic settlement against invoices based on predefined criteria to identify the customer account.

To work effectively with Lockbox functionality, you need data that includes invoice numbers, as these are essential for matching payments to specific invoices. Typically, in the MT940 bank statement, most payment details are available, but the invoice or document number is not always included by default. In a real-world scenario, how do you usually collect the document or invoice numbers needed for matching?

Additionally, MT940 supports all types of customer payments, including checks, wire transfers, and more.

Could you please share a sample Lockbox file that you currently use? This will help us provide a more accurate solution tailored to handling Lockbox functionality in D365 Finance and Operations.

Sample Lockbox file format:

Currently, we are also recommending clients use Advanced Bank Reconciliation (now called Modern Bank Reconciliation) to automate as much of the vendor and customer payment reconciliation process as possible.

Please refer the below link:

https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/reconcile-bank-statements-advanced-bank-reconciliation

In this article, it is explained how to generate customer payments from Bank statement (MT940 or similar ones)

https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/apply-cash-adv-bank-rec#generate-customer-payments

Regards,

Neeraj Kumar

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

1 people found this reply helpful.

Was this reply helpful? Yes No
Nikhil More 385 on at

Like (1)

Report
Copy link

Link copied!

Thank You @CA Neeraj Kumar Sir,

Earlier Even I thought, it could be possible with MT940 - Advance bank reconciliation way.

But the format Client shared is something different-

Here is the current Lockbox file format -

550, 1,0003226410,0001620490, BIG Y FOODS INC, 725305, 3226410, 0080236485,011201539

It is in Text format, and it is for Customer Payment with Checks.

Do I create customized Report Design for above Text Format, under Advanced Bank Reconciliation Model??

I still don't understand how with Advance bank reconciliation we can generate Customer Payments.

I will follow the links you have provided.

.

Thank You so much for your inputs.

Was this reply helpful? Yes No
Nikhil More 385 on at

Like (1)

Report
Copy link

Link copied!

Hi @Sohaib Cheema Sir,
Thank You So much for your inputs. I will definitley try this way and will update you.

Thing is currently bank is sending us Lockbox file in text format - below is example

550, 1,0003226410,0001620490, BIG Y FOODS INC, 725305, 3226410, 0080236485,011201539

This is for Customer Check Payments which Bank Receives.

.

Well to import same file in D365 I need to Design custom Format in D365 Electronic Reporting. But I am not able to understand under which model I can create one also, How I can make it as "Import" format.

Thank You,

Nikhil

Was this reply helpful? Yes No
Verified answer

CA Neeraj Kumar 5,099 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Nikhil More,

When i say to use the MT940, it will have the details of check number, date, customer name (either in some description or separate column) ,using those details, you need to configure the matching rules. that will help to do the creation of payment journal.

Other than MT940 reconciliation process, i can suggest two options - one simple, other one complex

1) Simple approach: Use the below data entities and prepare some excel template which will take your text data and convert to the format of below entities.. then using DMF, customer payment journal will be created with settlement with invoices.

CustomerPaymentJournalEntity

CustomerPaymentJournalLineSettledInvoiceEntity

2) Complex approach: Follow this article https://learn.microsoft.com/en-us/dynamics365/finance/localizations/japan/import-customer-payment-jba-file-format and Extend the standard ER configuration (You can use the base as JBA Payment model ), presently this is for Japan but after extension you can remove the country code and make necessary changes to achieve the proper import mapping.

It is also using the above mentioned entities while updating the records after reading..

or you can create a Import model mapping from scratch also in order to avoid this much complexity [still requires in-depth expertise of ER].

I am not trying to discourage you by saying complex approach, genuinely i don't feel good to invest this much time for achieving this functionality through ER unless it is last resort.

Feel free to discuss more even on this ER configuration changes. I can surely give high level guidance on creating the same and provide some important resources to follow. 😊

Regards,

Neeraj Kumar

If this helped, please mark it as "Verified" for others facing the same issue Keep in mind that it is possible to mark more than one answer as verified

1 people found this reply helpful.

Was this reply helpful? Yes No
Nikhil More 385 on at

Like (1)

Report
Copy link

Link copied!

@CA Neeraj Kumar Thank You So much for your valuable imputs.

I will have hands on the suggested solutions. Will update your or ask for your help if needed.

Thank YOu.

Was this reply helpful? Yes No