ER Configuration issue in Data model mapping for Payment statistic report (UK)

(1) Share

Report

Posted on by Charan140

Hi,

Requirement is needed to add the Invoice Amount and PO Number field for Payment statistic report (UK). Here I was created the Model added these new fields under calculation in VendInvoices and configured Model mapping with Open, paid invoices config. after running the report, I get the Invoice amount for first invoice repeated for all other in report. I am not sure where I miss config. If anyone knows ping me, it helps me deliver on time.

Model:

Model Mapping:

Report Excel:

Thanks in advance,

N. Charan

I have the same question (0)

All responses (6)

Answers (1)

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
Check the configuration of the model and ensure that the fields are correctly mapped to the corresponding data sources. You can refer to the following link for the configuration of model mapping:
Configure country/region context dependent ER model mappings - Finance & Operations | Dynamics 365 | Microsoft Learn
Best Regards,
Hana

Was this reply helpful? Yes No
Charan140 24 on at

Like (0)

Report

Hi Hana,

Thanks for your reply,

The link you shared not helped me to resolve configuration issue. Please let me know if you find something else to resolve.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi Charan,
Can you provide more information on what is the formular behind $OpenVendnvoice?

To test you can try to bind AmountMST to check it it helps?

Was this reply helpful? Yes No
Charan140 24 on at

Like (0)

Report

Hi Alireza,

Please find the formula in below image.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report

Hi,
It seems that you have created several calculated fields e.g. ($VendInvoice). I recommend to activate debugging for data model mapping and try to check if you get any value or correct value for invoice amount based on mapping that you have created with these calculated fields.

If you see that you do not get any or correct values on $OpenVendnvoice you need to check $VendInvoice and steps back to better debugge this issue.

As another suggestion, please try to use Filter function than Where when you want to start filtering at first point :)

Was this reply helpful? Yes No
Suggested answer

CA Neeraj Kumar 4,994 on at

Like (1)

Report

Hi Charan,

Please check the format designer to ensure it is bound correctly. The binding should begin with an '@' sign; kindly validate this.

Regards,

Neeraj

Was this reply helpful? Yes No