Hello! Could you help me solve one problem? I have a lot of Locations and a lot of Items. I need to show quantity and amout of items in the matrix form. Items and Locations - data from Tables. Quantities of Locations and Items are not defined. The Report/Form should looks like this: Location1 Location2 …
ItemName1 10 129 … 100$ 10$ … ItemName2 … …
Total 2000 200 … 12000$ 5000$ … Thank You. Den
Hi! Take a look at the “Item Card”, MenuButton “Item”, MenuItem “Items by Location” … this should be what you want, maybe you can copy and/or modify it. If you need this on a Report, you have to do a lot of programming with arrays, etc… Maybe it’s easier just to copy/paste it to Excel. Regards, Jörg
Thank you Jörg for suggestion. But I need put two parameters - Quantity and Amout to each Item in Location. Here is the problem. Den
Hi Dainius, If you want to go for the matrix, you should look at the Development Training Manual. In the forms chapter, there is an exercice telling you step by step how to create a Matrix form.
quote:
Originally posted by dainiusnew
Thank you Jörg for suggestion. But I need put two parameters - Quantity and Amout to each Item in Location. Here is the problem. Den
The easy way to achieve that (used in many Navision standard matrix forms), is to add a switch control (i. e.: an option filed with two values, “Quantity,Values”) and fill the matrix box accordingly, showing only a kind of data per time. Anna