Hello,
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.
Applied filters:
"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
11220033 -2
11220033 -10
11220033 -53
ZHPF8183 -68
ZHPF8183 -17
ZHPF8183 -500
VP500240 -0.5
VP500240 -5.5
What I need:
Item no. Quantity
11220033 -65
ZHPF8183 -585
VP500240 -6
Thank you.
*This post is locked for comments
I have the same question (0)
