Hi all,
Today we add a new Dimension to Navision which we should use in future. Also we should create new reports by using this dimension. But if I check my GLentris I just see Global Dimensino 1 & 2. How can I select one of the other Dimensions?
Thanks
Viki
3 comments
-
Jet Reports Historic Posts Official comment Hey Viki,
Jet Reports has the ability to report on the "shortcut" dimensions in Navision, but it isn't well documented. You can do this by just referencing the "caption" of the dimension. For example, if you have dimension 4 defined as "Region", then when you write your formula you can just reference the field Region even though "Region" is not in your list of possible fields.=NL("Sum","G/L Entry","Amount","Posting Date",$D$5,"Region",$D$6) -
Jet Reports Historic Posts Hello Shermang, I know this works on the GL Entry table, do you know what other tables it works on ??
-
Jet Reports Historic Posts I've used this in the "Cust. Ledger Entry" table. It seems to work fine.