Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
Good day All,
I want to know whether i can get the Average Cost per Product for a particular day through x++.
This is a customer request and am not sure i can have access to this value as displayed in Inventory Aging report
Why do you need to use X++ here?
Just run the inventory value report as of a specific date and you get that value.
Trying to make a value calculation outside of D365FO is very hard as many factors influence how the value is calculated.
A customer wanted to have this on a form instead of having to run the report every time they need to use the value for a transaction.
I just want to be sure we can get this done with minimal effort else we just make do with the system default reports
Hello Matthew Ireti,
To get this calculation on a form should be quite easy as you have the data provider and everything that is needed building the report. Instead of a printable report you have a form as the output format. I think this is not a problem for you.
Where I see a problem is using this value for a transaction.
The value that you see is a kind of simple average price (value/quantity).
The price that is calculated this way and that is shown in the report is only an indication of the average price that was valid at the data for which the report was run.
It is certainly not a weighted average price and might differ from what D365FO calculates when you recalculate / close your inventory.
Just be aware of that when you build your solution.
Business Applications communities