AX 2012 reports

Finance and Operations/AX Developer Forum
1

Hi. I am a newbie to AX 2012 reports and I was wondering how I can add expiry dates to the sales confirmation report in AX 2012. I was able to use old school display methods for 2009 but not sure how to do that in 2012. Please tell me the steps. Thanks

2

Hello,

Assuming these fields are not available in temporary tables, you may have to make following changes -

  1. Inside AX - Modify temporary table to add these fields and modify data provider class to populate these fields
  2. Outside AX - modify the SSRS report to incorporate these fields and deploy the report.

Please note - you may have to debug AX to figure out temporary table and the class.

3

Hi Harish. Thank you for your reply. Do I need to create a new method in the SalesConfirmDp class? Can you provide a code snippet example so I understand the logic? Thanks

4

Hi,

You don’t need to create new method in this class. Try the following -

  • Required field(s) in temporary table;
  • Modify either ‘setSalesConfirmDetailsTmp’ and setSalesConfirmHeaderTmp’ method suitable for your requirement.
  • Modify SSRS report to display these fields
  • Don’t forget to generate full CIL (if you never did this before) or Incremental CIL (only if you regularly update your CIL)