Payables by Supplier Report

Go To User Guide - Accounts Payable

Accounting>File>Accounts Payable>Check Writing>Payables by Supplier

Accounting>File>Accounts Payable>A/P Reports>Payables by Supplier

This will provide a printout of payables due to a specified date. It prints on 8.5 x11 sized paper. The report sorts by Supplier and then Invoice number.

It is recommended that you print this report and view it prior to paying bills to determine which of them you want to pay at this time.

Report Type	Explanation
Payables Due	This selection allows you to choose what payables are due based upon Due Date, Transaction Date, or Invoice Date. Invoices in a Hold status may be included.
All Payables	This selection allows choosing payables due based upon a cut-off or ending date and/or the supplier name
Report Options
Include Holds	Check this to include payables placed on hold
Use Payee	Check this box to use the payee's name instead of the supplier's name.
Date to Use	This selection determines what date parameters you should enter to determine which payables are due for payment. Select the Due Date, Transaction Date or the Invoice Date. When this selection changes the Begin and End date will change too.
Begin/End Due Date	Enter the beginning and ending date parameters for this report. Click the F8 button to display the calendar.
Supplier	Selecting a supplier name may be done one of two ways: From the Supplier File: Click on the F8 button to access the supplier file, where you may search by either the supplier name or the payee name. Exact Match or Fuzzy Search: Click on the button to the right of the F8 button for supplier name to determine whether you want to search for an exact match of the characters typed in, or if you want a "close" fuzzy match. A fuzzy match is useful if you have suppliers that are similar in name or closely related, i.e., Carpet Industries, Carpet Pad Company, Carpet Supplies, etc.
Output CSV	Choose to create a CSV file in addition to a printed report.
Stores	Be sure to tag at least one store code. Your choices are either one store code or all store codes. If you do not select at least one store code, the report will not print.

Report Example

List of CSV Fields

Inv Num

Inv Date

Trans Date

Due Date

Invoice Amount

Discount %

Non Disc Amount

Amount Due

Status

Supplier