I want total description about a item depending on a Location
any one can give me some idea about how to do this in navision 2009 classic.
output should be like this
In NAV2013, in the when you design layout, in grouping, try column grouping.
You can get this type of data in Item By location form, and there you can select all the data and paste it in excel from NAV 2009.
Hi
Where you want total description based on Item ?
i want to show it on a report based on location how many items are there in the inventory as a matrix format.
Hii Did you people find any solutiom for this given query .
please give an update for that 
Hi,
Use this:
1)Use “item” as a Dataitem
-
Take Location and ItemledgerEntry as Record Variable
-
Take two array one for LocatonArr and Second For QuantityArr.
4)OnPreReport write code for store all location in LocationArr
5)In OnafterGetRecord event for item dataitem write code to store location wise quantity in quantityArr.
6)in report use this two array element as colum
and That’s it.[:D]
“if done than tik this subject as solve.”
Regards
Suraj
Its Working !!!
Thank you Suraj !!
Don’t ask such kind of question as here every member take out some spare time from their busy schedule and provide the solution.
Be careful…
Hi,
suraj gave the solution for this query and its working fine .
here is the solution given below .
Use this:
1)Use “item” as a Dataitem
-
Take Location and ItemledgerEntry as Record Variable
-
Take two array one for LocatonArr and Second For QuantityArr.
4)OnPreReport write code for store all location in LocationArr
5)In OnafterGetRecord event for item dataitem write code to store location wise quantity in quantityArr.
6)in report use this two array element as colum
and That’s it.
“if done than tik this subject as solve.”
Regards
Subidit
[Y]
[Y]Agree
[Y]Agree
[Y]Agree
i agree