Running the Payables Journal Report

Run a Payables Journal Report to create a list of all the payables for one or more branches for a specific time period. You can tailor the report to list just those payables entered by a specific user or in a specific branch. The report includes a branch exchange account summary.

For a description of the report, see What the Report Shows at the end of the topic.

To run a Payables Journal Report:

From the A/P > Reports menu, select Payables Journal to display the Payables Journal screen.
In the Br/Tr/All field, enter the branch, territory, or All to include in the report.
In the Start Date field, enter the date you want the report to start from in the MM/DD/YYYY format. The default is the current date.
In the End Date field, do one of the following:

To list the payables for a single date, press Enter to copy the start date information to this field.
To list the payables for a range of dates, enter the date that you want the report to finish, in the MM/DD/YYYY format.

In the User ID field, to list only the payables entered by a particular user, enter the user ID. This is an optional field.
In the Batch ID field, to list only the payables entered in a particular batch, enter the batch ID. This is an optional field.
In the Sort By field, enter one of the following to determine how to sort the payables in your report:

Payable – Sorts the payables by transaction number.
Vendor – Sorts the payables alphabetically by vendor name.

Use the Slct key to display the Additional Selection Input screen, where you can enter additional criteria, for example, to select orders associated with a particular batch number.
Use the Columns hot key to display the Columns Setup for Payables Journal Report screen, where you can set up the report columns to include specific types of information on the report. For example, you can include information about freight and handling charges. For more information, see Customer Sales Rebate Report.
Set options, if needed, and generate the report.

What the Report Shows

The Payables Journal Report shows the following information:

Column	Description
Branches	The branches for which the report was run.
Batch	The batch for which the report was run.
User ID	The ID of the person who ran the report.
Invoice #	The invoice number connected with the payable.
Inv Date	The date the payable was invoiced.
Pay Date	The date the payable is due.
Vendor Name	The name of the vendor to which the payable is due. If the payable is for a customer refund, or a one-time payment that uses a generic vendor, the vendor name and OVERRIDE displays in this field.
Inv Amt	The amount of the invoice.
Br #	The branch number associated with this payable.