Skip to main content

Notifications

Announcements

Dynamics 365 Community / Forums / Finance forum / ER Configuration issue...
Finance forum
Suggested answer

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

editSubscribe (0) ShareShare
ReportReport
Posted on by Community member 19
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
Categories:
Data Integration
Integrations
Development / Customization / SDK
Administration and Setup
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    CA Neeraj Kumar 2 on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    Hi Charan,
     
    Need to check format designer once, whether it is binded properly or not. The binding should start with @ sign, can you please validate it once. 
     
    Regards,
    Neeraj
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 10,802 Super User on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    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 :)
     
  • Community member Profile Picture
    Community member 19 on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    Hi Alireza,
              Please find the formula in below image.
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 10,802 Super User on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    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?
     
  • Community member Profile Picture
    Community member 19 on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    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.
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    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
     

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,324 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,096 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans