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) / To show ShippedDateReq...
Microsoft Dynamics AX (Archived)

To show ShippedDateRequested column in SalesQuotationReport

(0) ShareShare
ReportReport
Posted on by SadiqQ 437

I have to show ShippedDateRequested column from SalesQuotationTable in SalesQuotationReport. SalesQuotationDP class which is data provider class for the report is using SalesQuotationHeaderTmp table as base table for the report. Values are being set in columns of SalesQuotationHeaderTmp table from CustQuotationJour table.

Above mention my required field ShippedDateRequested is in SalesQuotationTable. I am not able to do it.

Please advise how can I use values from columns in other table.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Your requested approach is incorrect I am afraid.

    Reports which involve postings must be using the posted journal for fetching data, so it must indeed come from CustQuotationJour table. The reason behind is that once you have done the posting, the produced report must be reproducible the exact same way as before. Now in AX you could run cleanup routines which can remove sales orders and quotations once they are posted. How would you refer to SalesQuotationTable from your customized report, if there is no such entry anymore?

    The answer is you do not.

    What you need to do instead is change the posting logic, bring over the ShippedDateRequested field to the CustQuotationJour table during posting, and use that new custom field to be filled in to your Tmp table for the quotation in the Data Provider class.

    Most likely you could do this initialization in \Data dictionary\Tables\CustQuotationJour\initFromSalesQuotationTable method, likely that is being used during the posting.

  • SadiqQ Profile Picture
    SadiqQ 437 on at

    Thank you very much Vilmos Kintera,

    Your are right, I did as per your advise and it worked. I modified CustQuotationJour Table by adding ShippedDateRequested column. Then I added line in Data dictionary\Tables\CustQuotationJour\initFromSalesQuotationTable method to update this new column in CustQuotationJour table with value in ShippedDateRequested  column in SalesQuotationTable table.

    Then I added line in SalesQuotationDP data provider class for SalesQuotationReport. This new line  sets value in tmp table from ShippedDateRequested.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
Basit Profile Picture

Basit 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans