web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / ER - Modified Purchase...
Finance | Project Operations, Human Resources, ...
Answered

ER - Modified Purchase Order Excel Format - Repeating first row value across

(0) ShareShare
ReportReport
Posted on by Aparisi82 2,180

Hello  dear experts

I have created a derived version of the Purchase Order Confirmation ( EXCEL) and created a derived order model as well as mapping.

the following order contains multiple lines with 2 products

10270   ( Product Life Status = Phased-out)

00029  ( Product Life Status = Released)

5466.pastedimage1609158414097v1.png

I modified the report to add the column Product Life Status  , but the report repeats the value "Phased-out" of product 10270   for each line .

7723.pastedimage1609158594963v2.png

This is the mapping  I created 

4718.pastedimage1609158801571v3.png

Any clue of why this is not working?

I have the same question (0)
  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: ER - Modified Purchase Order Excel Format - Repeating first row value across

    Hi,

    Can you please double check your binding.

    Right below the order line node on the right-hand side of your screenshot it shows a relationship to the purchpurchordertmp datasource.

    All nodes right below start with an @symbol indicating that they are taken from this datasource.

    Yours does not show this symbol, which indicates that you might have selected a different datasource and as a result get the first record included in each line.

    Best regards,

    Ludwig

  • Aparisi82 Profile Picture
    Aparisi82 2,180 on at
    RE: ER - Modified Purchase Order Excel Format - Repeating first row value across

    You are right

    here is what I did wrong

    I had selected the field from the yellow node instead of selecting from the previous one.

    pastedimage1609232077735v1.png

    Having said that , I am literally copying from existing logic without understanding what I am doing which is a good recipe for disaster.

    I have been really struggling to understand concepts such as  Calculated fields , record lists , formulas in the ER. 

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: ER - Modified Purchase Order Excel Format - Repeating first row value across

    Hi Alessandro,

    The standard Electronic Reports that MS ships are quite complex.

    Many refer to invoices, packings slips and other rather complex documents.

    Understanding them can take a while.

    To get started, why don't you try to extract some simpler data e.g. your vendors with some vendor specific fields just to get more familiar with how electronic reporting works.

    There are also a number of tectalks available that illustrate things in more detail.

    Please check them out by selecting the resource button in this community forum.

    Best regards,

    Ludwig

  • Aparisi82 Profile Picture
    Aparisi82 2,180 on at
    RE: ER - Modified Purchase Order Excel Format - Repeating first row value across

    It is a good idea.

    The reason I have been studyng the complex ones is that our AX partner suggested we use the standard Microsoft document to replace our current X++ reports and we will need to modify them by adding new fields or adding extra logic.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 867 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans