Personalized Community is here!
Quickly customize your community to find the content you seek.
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
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 need help with filtering data in NAV.
What I need:
To find what items we have consumed the most over some period of time at one of our manufacturing locations.
What I have done so far:
Went to History -> Item ledger entries.
"Location code" = one of our production facilities,
"Posting date" = 01/05/18..07/08/19,
"Entry type" = consumption.
Then I sorted all the rows by "Item number".
So this gives me all components that we have consumed in that facility over that period of time. But of course this list is enormous and it would take me ages to calculate sums of all different components.
Now I need to know how to let NAV sum up all different component consumption quantities.
Example of what I have:
Item no. Quantity
You can use Query functionality of NAV. (Object Designer > Query > New > Data Item (Item Ledger Entry) > Enter required filters and select required fields) and run the Query and export the data in Excel. Hope this shall resolve your issue.
(Quantity field > Method Type = Totals)
Thanks a lot. Don`t know why I did not think about exporting data to Excel.
Actually did not have to use Object Designer - Just selected all the rows and pressed Ctrl + E. Then created pivot table in excel and got the information I needed.
Business Applications communities