Hello Jet Express Community,
I am using Jet Express. When I am using GL function Wizard, I am getting 2 different results in these two situations:
Situation1: I am selecting my view code (GL DIMENSI) and there are 4 different dimensions but I am not filtering these dimensions.
Situation2: In the view code, I am not selecting any code
This is clarified through the attachment.
My question is why both situations are showing different result.
I am new to Jet Express so may be this is very basic question.
thanks
Khushwant
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello -
Let's start with a some background about "dimensions". This is a little long-winded but it will help you make sense out of what I mention in a moment.
People often get confused about the terms used to describe dimensions - Dimension, Shortcut Dimension, Global Dimension, Advanced Dimensions, etc.
They are just additional pieces of information attached to your transactions that allow you to "slice and dice" your analyses in different ways. Navision provides two such dimensions by default (Global Dimension 1 and Global Dimension 2).
Your Jet Express GL reports can filter information based on these dimensions. When wanting to use one or both of the default dimensions to filter your results, you simply specify the correct information in either the "Global Dimension 1 Code" or "Global Dimension 2 Code" parameter:
Organizations are also able to define additional Dimensions. These are called Shortcut (or Advanced) Dimensions. Again, they are just additional… "categories" that can be used to compartmentalize your data. Analysis Views are created within NAV and shortcut dimensions are assigned to those Views.
To use an Analysis View In a Jet Express GL report, you enter the name of that View in the View parameter and then specify the filters you wish to use for the associated dimensions.
Apparently, your NAV database contains an Analysis View named "GL DIMENSI" which includes the shortcut dimensions of "Business Unit Code", "Job Code", "Plant Property and Equip. Code", and "Project/Department Code". By including the View in your GL function (but leaving the dimension codes blank), you are telling NAV to compute the GL balance based on transactions filtered by the specified NAV Analysis View in which those shortcut dimension are not applied (this is *not* the same as not applying the View at all).
I hope that helps.
-HP -
Jet Reports Historic Posts Thanks HP, I got my reply
Please sign in to leave a comment.