Finance | Project Operations, Human Resources, ...

DMF Import reference to JournalBatchNumber for Customer Payments

(0) Share

Report

Posted on by Dwight00

I have bee trying to get the DMF import for "Customer payment journal line settled invoice" to work as outlined in the link below.

A sample import file is attached.

I keep getting a staging error - The value 'NPC-000053385' in field 'Journal batch number' is not found in the related table 'Customer payment journal header'.

I export via DMF the header table and the JournalBatchNumber does seem to exist.

Am I missing a configuration setting or a formatting issue?

Thanks

Customer payment journal and settlement of invoices - Dynamics 365 Finance Community

/cfs-file/__key/communityserver-discussions-components-files/765/Sample-Inv-Settle-Load.xlsx

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Do you have journal created with number NPC-000053385 and with lines in it? If not try creating journal insert lines and then try to import payments for settlement as described in the post.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Dwight00,

When you want to import data for "Customer payment journal line settled invoice", you need to import data with in regards to journal batch number and journal line number

Was this reply helpful? Yes No
Dwight00 10 on at

Like (0)

Report

I have created the payment journal and am using the journal batch number it is displaying.

As mentioned, I have exported the the customer payment journal header table and it shows the journal batch number I am trying toi import. It just does not seem to recognize it.

Dwight

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Do you import data in correct company? since the error message that you mentioned is reflecting that the journal does not exists.

Can you try to perform settlement manually (mark transaction to journal line) in the journal and then export data from "Customer payment journal line settled invoice", then compare the file against the file that have used for import. If it does not have any difference, try to remove the settlement in the journal (unmark the transaction and import the Excel file that you have just exported, to check if you can import data.

If you can import data, the root cause can be related to data or format in the Excel file.

Was this reply helpful? Yes No
Dwight00 10 on at

Like (0)

Report

Thanks I have gone back and performed a test of entering invoices , a customer payment, one line and two through the user interface. Upon exporting via DMF< I get the appropriate customer payment journal header and line data in excel, but nothing is being exported via the customer payment journal line settled invoice, even though the invoices are being shown as settled against a payment.

Thoughts as to what might be causing the missing link?

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Dwight00,

Please check if the entity in the export data job have mapping for export:

If not, please try to re-generate mapping for the entity and then create a new export job and add the entity, then control if there is mapping for export.

PS. It is possible to add the mapping manually.

Was this reply helpful? Yes No
Dwight00 10 on at

Like (0)

Report

I have focused on getting the export of the settled invoice entity to work.

For some reason, it is only exporting unposted journals? Any ideas? I do not see any filter being applied in my DMF project.

I have also noticed that when I look at the generated mapping, I get a warning:

"Fields that are enabled for country/region CA are available for mapping". When I add the column for "Is Field Enabled", all indicate "Y".

Thanks

Dwight

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Dwight,

Regarding the export, I suggest that you create a new export job since the existing data job may have filter for export specific records.

If you want to export "Customer payment journal line settled invoice" for journal that is posted, it will not export any record. Once a journal posted the settlement lines will be removed from the journal.

Was this reply helpful? Yes No
Dwight00 10 on at

Like (1)

Report

What was unclear from the initial article for settlement of invoices via DMF entity was that the payment journal must not be posted in order for the Settlement invoice import to find the referenced payment journal batch number.

All now works as long as the payment journal is not posted.

Was this reply helpful? Yes No