The Jet GL() function can be used to report directly from your Jet Budgets data - without having to first import your Jet Budgets data into Dynamics NAV, GP, or Business Central.
This video will be a step-by-step overview of including Jet Budgets data in your Jet reports.
Here we have the start of a basic Income Statement report:
Let's add functions to the Budget column to show the data from our Jet Budget.
Because there is an existing budget defined within Jet Budgets, once we click the Jfx button on the Jet ribbon to start the Jet Function Wizard, we can then change the function type to GL (Jet Budgets)...
... and now we see the parameters for the GL(JetBudget) function:
We can now specify the Jet Budget Name from where we want to retrieve our budget values...
... and also specify the Account, Start Period, and End Period information:
Once we press OK, our function is placed in our report and the appropriate value retrieved from the specified Jet Budget:
We can now simply copy that function down the column through the rest of the accounts:
If we want to show additional details about a particular value, we can select that value and click the Drilldown button on the Jet ribbon:
The Drilldown window then displays all the work items entries that were entered to create that specific value: