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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to include all lin...
Microsoft Dynamics AX (Archived)

How to include all line items on the Sales Order Confirmation report

(0) ShareShare
ReportReport
Posted on by Community Member

Out of the box, the Sales Order Confirmation does not display line items after they have been delivered or invoiced. We need the report to display all line items regardless of the line status. Does anyone know if there is a setting that can be changed or what code needs to be modified to make this happen.

Thanks in advance for any help you can provide?

*This post is locked for comments

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Take a look in AX AOT at \Classes\SalesConfirmDP (data provider for confirmations), SalesConfirmContract (data contract) and SalesConfirmController.

    Those are being involved in populating the temporary record buffer, which is then handed over for the SSRS instance to render it with the report's design.

    If you want to make changes, that is where you should start looking at, to populate information which is currently being filtered out.

  • Community Member Profile Picture
    Community Member on at

    Thanks Vilmos.... Yes, that is where I have been looking. However, nothing stands out to me. I thought it would filtering out for the line status but I don't see any type of filtering happening.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Did you debug SalesConfirmDP.createData? I can see that it creates the query to populate the confirmation transaction temporary table there, see how does your querybuilddatasource SQL select statement look like before it starts looping.

  • Community Member Profile Picture
    Community Member on at

    Thanks for the reply.... I have been looking at the method for a couple of hours thinking the filter had to be in there but I don't see it. Which line is the filter?

  • Community Member Profile Picture
    Community Member on at

    Yes, walking through the code. I Viewed the SQL select statement for tradelooptrans (within createData), however I never see a filter as part of the SQL statement. Just a straight forward select statement

  • Community Member Profile Picture
    Community Member on at

    Thanks guys!! .... working on it right now.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans