- It's extremely important to know
how much money you owe to your vendors
and when those payments are due.
It's also important to be able to provide
a list of invoices to your auditors
so that you can tie out the accounts payable balance
on the balance sheet in your financial statements
to your accounts payable sub ledger.
The report to do this is the Payables Trial Balance Report,
commonly known as an AP Aging.
Let's go to the reports menu and select Purchasing,
and select Trial Balance.
There are four options for reports related
to Payable Trial Balance.
I recommend you use the Historical Aged Trial Balance.
That report
has the option to select transactions
for reporting using the general ledger posting date.
By using the general ledger posting date,
you can set a cut-off date that coincides
with the date of the financial statements
for which you're trying to tie out the AP Balance.
Another good report here
is the Aged Trial Balance with Options.
As you see, selecting by GL Posting Date
is grayed out, however, if you're just looking
for what you want to pay, trying to make a decision,
you can do that from this report as well.
Just type in an option name, I chose AP,
and you can print in detail.
The In Detail checkbox is important
if you want to see the individual invoices
that are falling due, rather than just
a balance due to a vendor.
So normally, that check box is check.
Typically this report is not filtered because you're trying
to get a view of all the things you need to pay,
however, you can filter this by
a field called Payment Priority if you've entered that
on your invoices, the Payment Priority.
Or you can filter it by certain vendor classes
so you could see only certain types of vendors,
for instance, you might not want to see employees.
Please set your destination to the screen first
before you print this out to make sure it's really
what you want to print before you send it to the printer.
That's how you set up an AP Trial Balance in Dynamics GP.