Hello,
IN Navision we have that Functionality Item BY location .
So it is possible only on screen.
But what about the report Item By location.
I searched alll reports regarding Inventory , But i could not find so please let me what is that report No.
If it is not there then just throw some help on how to develop.
Just explain how to get the values.
Thanks and regards
Hi Hansika,
Not as standard. You can set a location filter on the inventory valuation report to get a single location. If you need to develop a report then the inventory valuation is the best template as you can run this “as at” a date. Just put a dataitem of location and indent the item and value entry, setting the location filter on the item each time.
Hi
I’m actually trying to recreat this report.
I’ve done as suggested… added Location as my first dataitem, indented Item and Value Entry
on the Location property select Code as a group filter.
Are you then saying I can remove the iventory posting group grouping on the item and replace with Location filter? or just add Location filter to my reqfilter fields?
Hi Hansika,
For Item by location report no need intendation.By using matrix type you can do.Download this item by location report[50024] file and import in your application .
Kindly follow this link
have a look at this blog
Hi Pandu,
This link was great thanks…
I’ve edited it a little to filter on ILE Posting Date…
and added a Excel Output option too…
Regards
Paddy
Hi Mohana,
Great Link…
Just up my street…step-by-step as i’m learning to develop in Nav.
Yoc can dowload the objects from end of the link… [;)]