ER format reference help

(0) Share

Report

Posted on by Mikaharx

I have been learning about the electronic reporting recently and I created a vendor payment bank file using the Microsoft guide: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/tasks/er-design-domain-specific-data-model-2016-11?toc=/dynamics365/commerce/toc.json

The guide works fine and I could generate the file from vendor payment journal after finishing the setup.

However, when I tried to create a new format (including a new data model) for testing purposes, no matter what I do, the format does not show up in the drop down-menu in the methods of payment.

I figured that the data model needs to be named as "PaymentModel" and the data source definition should be "CustomerCreditTransferInitiation". (Correct me if I am wrong)

I even imported another out-of-the-box format from Microsoft repository but it does not show up either. The format status for all of the cases is obviously set as completed.

Is there something that I am missing? What kind of setup do I need to do to enable the format in the method of payments drop-down menu?

My demo environment version is: Update28 (7.0)

See screenshots below for reference:

I have the same question (0)

All responses (8)

Answers (1)

Mikaharx 35 on at

Like (0)

Report
Copy link

Link copied!

As an update, if I use the simplified data model that I used in the tutorial, the formats WILL SHOW UP. Is it possible that there is a bug that only the data model that was defined first as "PaymentModel" works (the format that was created initially before creating new models/importing Microsoft data models)?

Was this reply helpful? Yes No
Thomas Tian on at

Like (0)

Report
Copy link

Link copied!

Hi Mika Hartio,

Would you please give me a repro steps for this issue. Then I can help you confirm whether it is a bug.

Was this reply helpful? Yes No
Mikaharx 35 on at

Like (0)

Report
Copy link

Link copied!

Here are the steps using combined screenshots:

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

It uses integration point value for that lookup, check standard model mapping, it should be populated like on the screenshot below and then set same value for your custom mapping

Was this reply helpful? Yes No
Mikaharx 35 on at

Like (0)

Report
Copy link

Link copied!

Dear Ievgen,

Thank you for your reply.

However, the field "Integration point" does not exist in the D365 version I am running.

Refer to the screenshot below:

Additionally, if some one could tell the required model name/root definition for AR payment file generation, that would be really helpful.

Best regards,

Mika

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

Actually I was wrong, that field is used for import not export. That lookup wants your model to be called Payment model and have CustomerCreditTransferInitiation there. Instead of creating new model, try to create one derived from payment model and base your format on it.

Was this reply helpful? Yes No
Mikaharx 35 on at

Like (0)

Report
Copy link

Link copied!

Deriving the model works! Thank you.

Do you have any idea if it is intended that non-derived payment models do not show up? Seems kinda odd.

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

I think so, because it pass journal id to it, knows how to get data from payment journal and so on. You can always add your own data sources, so I do not see a big issue with using standard.

Was this reply helpful? Yes No