- [Narrator] The general ledger trial balance
is the most fundamental report in any ERP system.
Let's take a look at how to run a trial balance
in Microsoft Dynamics GP.
Click on the reports menu,
financial,
and trial balance.
Keep in mind, you can also create a trial balance report
using management reporter,
which is the financial reporting tool
that is most often used with GP.
First we select our detail level.
I'm going to select a detailed trial balance.
I create a new report option.
I'm going to call this audit
because I'm preparing this report for the auditors.
Make sure to include posting accounts.
Choose how you want to segment and sort the report.
I'm going to sort this by the account number.
That's the main account number
and I don't need subtotals.
If you have closed the year,
you will have to select history.
Normally, we're running trial balances for an open year.
Now, what do you do with this filtering here?
That's where you can really specify your date ranges.
I like to do beginning of the fiscal year
to the end of the fiscal year.
I insert the restriction.
I check my destination.
I'd like to print this to the screen first
before I send it to a file or to the printer.
If I'm going to provide this to auditors
and they're asking for it as a file,
I can send them a comma-delimited or tab-delimited file
so that they could load it into Excel.
I'm just going to print this to the screen for now.
Once I have my report options set up,
I'm able to go ahead and print the report
to see what that looks like to the screen.
Any changes to this report,
you'd have to make using the report writer tool
for Dynamics GP.
If you have sufficient rights, you can click modify here
but usually, that's something that would be done
by your authorized partner
or an IT person at your firm.
If you're happy with this,
you can change the destination to printer,
if you wanted it printed out,
and simply print it again
and then you'll have your report just how you want it.
You may change it to have subtotals for each period,
for each month.
You can also add in other restrictions.
For instance, only having certain departments
included in the report, etc.,
by adding more restrictions.
Simply save your report option
by hitting the save button,
so that if you have to run this next year or next month,
your option will be already there for you to use.