How-To Video
This video provides a quick overview of how to create your own financial report using the Jet Reports Financials extension to Dynamics 365 Business Central.
Goal
Here we have an Operating Expense Variance Report showing - for a specific period of time - the actual balance of each of our G/L Operating Expense accounts, the budget associated with each account, and the variance between the two:
Let's build this...
Step-by-Step
-
To start, let's select the Fast Financials tool.
-
This displays our entire chart of accounts along with the balance for each account.
-
We'll want Budget and Variance information, as well as balance, so let's adjust the Columns to include those, as well...
-
We're also going to want to Include column headers to make our report more readable.
-
Now, let's go select our Operating Expense accounts. We'll scroll down to where that category starts, select the beginning account...
-
... and then scroll down and - while pressing the SHIFT button on the keyboard - select the totaling account.
-
Next, we'll drag the selected accounts over to the worksheet...
and Jet Reports Financials performs the formatting of the data.
-
We can close the Fast Financials window... and we see that we have all the selected accounts along with the amounts, budget, and variance:
-
Going to the Options sheet, we see that Jet Reports Financials has automatically created the report options that we will need to run our report.
When we do run the report, we'll be prompted to enter the information we want:
-
The Options have been named for us so that it will make it easier to design our report.
-
Let's add some extra information to our report so that it's just the way we need it.
We'll give the worksheet a more descriptive name...
-
... add a title - which we'll format to the size and style we want...
-
Now it's just a matter of clicking the Run button to run the report...
-
... adjusting the Report Options...
-
... and now we have a completed variance report based on our data:
Comments