Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ER Configuration issue...
Finance | Project Operations, Human Resources, ...
Answered

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

(1) ShareShare
ReportReport
Posted on by Charan140 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
  • Suggested answer
    CA Neeraj Kumar Profile Picture
    CA Neeraj Kumar 22 on at
    ER Configuration issue in Data model mapping for Payment statistic report (UK)
    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
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,262 Super User 2024 Season 2 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 :)
     
  • Charan140 Profile Picture
    Charan140 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 13,262 Super User 2024 Season 2 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?
     
  • Charan140 Profile Picture
    Charan140 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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,861 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans