Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Electronic Reporting i...
Finance forum
Answered

Electronic Reporting is showing only one Record when I export to Excel

(0) ShareShare
ReportReport
Posted on by Hayan Said 244

Dear All,

I have setup an Electronic Report to generate Excel sheet and save it on SharePoint, I Have Followed up a Blog that was shared by Ludwig Reinhard link is below, however I am facing an issue that the Excel sheet is only Having one record.

https://dynamicsax-fico.com/2018/11/01/reserves-for-bad-debt/comment-page-1/#comment-22412 

Please see below Screen Shots for the Process that i have done.

I have Created an ER Node

pastedimage1615378169558v1.png

I have designed the module

pastedimage1615378209081v2.png

Mapped to Datasource

pastedimage1615378225990v3.png

Designed and Bind the Record List with the Required Table

pastedimage1615378283808v4.png

Created the Excel sheet designed it and Mapped it with the module

pastedimage1615378376901v5.png

however i am only getting one record which is the first record in the list. Any ideas what i might have done wrong.

Best

HAYAN

Categories:
Financial Management
Other
  • Hayan Said Profile Picture
    Hayan Said 244 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Dear Ludwig,

    I was trying the Above Scenarios with On premise D365 F&O. I am getting the error that

    Unable to communicate with SharePoint Server in the Document management parameter.  can we work your Solution using OnPremise Env?

    Best

    HAYAN

  • Hayan Said Profile Picture
    Hayan Said 244 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Hello Ludwig,

    Thx for your help, I tried Arcadi Tip and it worked with me.

    Appreciate your help again.

    Best

    HAYAN

  • Hayan Said Profile Picture
    Hayan Said 244 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Thx Arcadi, i tried it and it worked. Appreciate ur help.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Hello Hayan,

    In your second screenprint, I can see a Record List element and right below a record element.

    In screenprint No 4 the record element is not bound to anything.

    Can you please try the following:

    1. Get rid of the record element in your model (screenprint 2). The easiest way might be setting up things from scratch.

    2. Do the same setup for the other elements exactly as you have it and then in the model mapping bind the record list element to your custtransopen table.

    Best regards,

    Ludwig

  • Suggested answer
    Arcadi Profile Picture
    Arcadi 780 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Try linking the BadDebt recordlist to tabelle1, you should see the fields in the format (left) with a "@" this means they are inside the loop

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans