Running the Open Payables Report

Run an Open Payables Report to create a list of the current status of all the unpaid payables as of a given date. Although you generally run the report for all branches, you can run it for a single branch or territory.

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

To run the Open Payables Report:

From the A/P > Reports menu, select Open Payables to display the Open Payables Report window.
In the Branch/Territory field, enter the branch, branches, or territories that you want to include in the report.
In the As of Date field, enter the date to determine which payables to include in the report.

Only payables with post dates that are open prior to or equal to this date are included. The default is the current date.

In the Vendor field, enter a vendor to include only invoices for that vendor in the report. To include invoices from all vendors, leave this field blank.

Select the Break on Branch check box to display the subtotal of payables for each vendor on a branch-by-branch bases, followed by the total payables for the vendor for all branches, followed by a grand total for all vendors.

Deselect this check box to display the combined total payables for each vendor for all branches, followed by a grand total for all vendors.

In the Mode area, select one of the following to determine the level of detail to include in the report.

Summary - Sorts the payables by pay-to or ship-from vendor and displays a total line for each vendor.

Detail - Sorts the payables by pay-to or ship-from vendor, displays a total line for each vendor, and also lists information such as invoice number, date, and amount, approved amounts, and unapproved differences.

In the Unapproved Invoices area, indicate whether to include unapproved payables.

In the Credits area, indicate which payable types to include in the report. The default is Include.

In the Sort By area, select whether to sort the payables in the report alphabetically by pay-to vendor or by ship-from vendor.

To add columns to the report, such as the Payable ID, from the File menu, select Report Column Selection to display the Column Selection window.
Set options, if needed, and generate report.

What the Report Shows

The Open Payables Report shows the following information:

Column	Description
Branches	The branch number associated with this payable.
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.
Invoice #	The invoice number connected with the payable.
A/P Br	The accounts payable branch for that line item. The information in this column displays only when you run the report in Detail mode.
Invoice Date	The date the invoice was processed.
Pay On	The day the payable is due.
Inv Amt	The total due on the invoice.
Deduct Amt	The amount, if any, of deductions applied to the invoice.
Gross Amt	The amount of the invoice after any deductions have been applied.
Disc Amt	The amount of the discount, if any, applied to the invoice.
Approv Amt	The amount of the invoice that has been approved for payment.
Unapproved	The amount, if any, that has not been approved for payment.
Difference	The difference between the invoice reconciled amount and the purchase order reconciled amount.
Payable ID	The ID for the payable. This must be set on the driver screen before running the report. When setting up the report, use the File > Report Column Selection option to add the Payable ID to the report.