To run an 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 an Open Payables Report:
From the A/P > Reports menu, select Open Payables to display the Open Payables Report screen.
In the Br/Tr/All 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, do one of the following to determine which invoices to include in the report:
Enter a vendor's name – Includes only those invoices from a particular vendor.
Leave the field blank – Includes all invoices, regardless of which vendor they are from.
In the Detail/Summary field, press F10 and select one of the following to determine the level of detail to include on 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 the following information:
|
|
|
|
|
|
|
|
|
|
|
|
In the Unapproved Invoices (Inc/Exc/Only) field, press F10 and select one of the following to determine whether to include unapproved payables:
Include – Includes all unapproved payables.
Exclude – Excludes all unapproved payables.
Only – Includes only unapproved payables.
In the Credits (Inc/Exc/Only) field, press F10 and select one of the following to determine which payable types to include in the report:
Include – Includes both debits and credits. This is the default.
Exclude – Includes only debits.
Only – Includes only credits.
In the Sort by Pay-To/Ship-From field, press F10 and select one of the following to determine how to sort the payables:
Pay-To – Sorts the payables alphabetically by pay-to vendor.
Ship-From – Sorts the payables alphabetically by ship-from vendor.
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.
In the Break on Branch (Y/N) field, enter one of the following to determine whether to separate information by branch:
N – Displays the combined total payables for each vendor for all branches, followed by a grand total for all vendors.
Y – Displays the subtotal of payables for each vendor on a branch-by-branch basis, followed by the total payables for the vendor for all branches, followed by a grand total for all vendors.
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 the report is run 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 to be paid. |
|
Unapproved |
The amount, if any, that has not been approved to be paid. |
|
Difference |
The difference between the invoice reconciled amount and the P/O reconciled amount. |
See Also: