I am Lalit Soni,working on Microsoft Dynamics AX 2012(version 6.0 ,Middle East ,Dubai,Oman),Currently I have 3 Month Experience on AX ,My role is specially for SSRS Reporting Services,
I have Top 10 Report given by company,under that 8 Report is available in AX ,But the other 2 Report is not there,
One is Daily Sales Report,
Other is Profit /Margin Report,
Can you please tell me Which table/filled I pickup for showing the data in Report,Because My most of the time is spenindg on finding table//filled,
The Format of Daily Sales Report
Product Name: Cartoon: Sales Cost
200 140 2800
where as Profilt/Margin is become crucial becuase I have to show same figure here also but with Margin and total percentage of the Sales,
The Format of Daily Sales Report
Product Name: Cartoon: Sales Cost Cost Value Margin % of Total Sale
200 140 2800 2600 200 7
Now this Profit /Margin I have to show in Sales of the day and MTD and YTD format.
Dear Sir/Mem,
ReplyDeleteI am Lalit Soni,working on Microsoft Dynamics AX 2012(version 6.0 ,Middle East ,Dubai,Oman),Currently I have 3 Month Experience on AX ,My role is specially for SSRS Reporting Services,
I have Top 10 Report given by company,under that 8 Report is available in AX ,But the other 2 Report is not there,
One is Daily Sales Report,
Other is Profit /Margin Report,
Can you please tell me Which table/filled I pickup for showing the data in Report,Because My most of the time is spenindg on finding table//filled,
The Format of Daily Sales Report
Product Name: Cartoon: Sales Cost
200 140 2800
where as Profilt/Margin is become crucial becuase I have to show same figure here also but with Margin and total percentage of the Sales,
The Format of Daily Sales Report
Product Name: Cartoon: Sales Cost Cost Value Margin % of Total Sale
200 140 2800 2600 200 7
Now this Profit /Margin I have to show in Sales of the day and MTD and YTD format.
Please help me to build this reports
Regards,
Soni