Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 virtual launch event
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 | Upcoming TechTalks
From our buyer I got the following question;
I want to see quantity sold per item/per year.
My question; Can I build a query for this? or a report? Mayby its already availble?
Article Productgroupcode Quantity sold 2017 Quantity sold 2018 Quantity sold 2019
Article A Red 1000 1500 752
Article B Red 5000 6000 3691
Article C Red 3000 2500 1100
Thank you so much for the help!
There is existing report id 712 "Inventory - Sales Statistic" but it is not grouping based on year ( you need to filter for each year) , if you need to group by year you need to customize.
Or you can create the view in sql and call this view from excel.
If you are using BI such as Jet report , you should be able to create that report easily as they already provided dimension and measures for that.
Tnx! Any suggestion how to analyse sales history within NAV? I hope there is a simpler way to do it instead of an export to Excel and work with the data. A report would make the job for our buyer much simpler.
There is a sales history report where you can filter for specific data and specify the length of period it has the filter option to filter for an item. You also have sales analysis reports to run for items.
Thanks, do you have the report number?
Here you go:
Business Applications communities