Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have created this report in SSRS 2008 to pull item cost from AX2009 from Project module , report works fine
only issue I have the cost posted in AX 2009 its not pulling exact the same amount, its pulling the cost when the report is run,
item transaction posted on 10/14/2014 for this item 10009413 $ 6916.69
and when I run the report now thru SSRS cost pulling for same item $ 7459.21
that's causing issue, because its not matching with AX 2009 numbers
I am using the tables for this Projitemtranscost >
Field > Amountmst
can some one please advise, am I missing some thing in my query , why the cost is not pulling what's posted in AX 2009 on that day,
thanks in advance
can some on help with question, or this question posted on wrong form ?
just want to know which table to use if cost needs to be pulled from Project for item what's posted in Ax 2009, thru SSRS 2008
any advise will be helpful
Report will show what data is pulled. I see no reason why report would show you wrong data if tables are right (backend).
Where do you see the value in AX ? If a form show you this value, check the table behind this form and use that. if form uses base table and there are additional logic, you will also have to do the same in the report.
Are you using native SSRS or AX SSRS ?
thanks Girija for replying
when I go to Project > Project Detail and select the Project and bottom of the page under tab Item transaction I see the cost for item 10009413 $ 6916.69
when I pull the report thru SSRS for same item same period its shows cost $ 7459.21
I am using SSRS
SQL Server Business Intelligence development studio 2008
and I am using the same table what's used in AX to post this cost
don't know what I am missing ?
there must me some thing , I am not aware of
if you can guide me in that direction, I will appreciate
Business Applications communities