Announcements
I used report from NAV 2017 - R1001 - Inventory Valuation, to create a new report that could group by location. Because in the original report i can take the results of all Locations or filter by a specific.
My goal is to show all locations .
I added Location as Data Item, and indented Item , and dataitemlink by Code - Location Filter
Then in Code replaced :
//ValueEntry.SETFILTER("Location Code",GETFILTER("Location Filter"));
ValueEntry.SETFILTER("Location Code",Location.Code);
//ItemLedgEntry.SETFILTER("Location Code",Item.GETFILTER("Location Filter"));
ItemLedgEntry.SETFILTER("Location Code",Location.Code);
The original map takes about 2 minutes for all data, tis new map cant generate at all no data(20 minutes nd nothing). Except if i put some filters before generate the report, for example one location or one item.
What i am missing here?
Thanks for help
Hi Rikarddo ,
What if you try to change your data item instead?
Try using item ledger entry directly then create a parent group for Location and Items (it can be done easily thru RDLC / RDL)
By this way, you can filter a location to show only the inventory group by that location or inventory per each location group.
If you find this useful please give it a like or verify the answer. By this way you can help other members know that the topic has been answered. Have a nice day. Thank you.
Cheers,
Well the versions are really different, and i need to create a table. I preffer not.
Any other sugestions?
Hi, sorry I don't have a screenshot of NAV, you can download a US version of NAV that includes this feature in the Inventory Valuation feature.
US:
W1:
Hope this helps.
Thanks.
ZHU
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156