The Vendor Accounting Inquiry Report is accessed from the Reports Window, Accounts Payable folder and displays all Vendor Deposits, Invoices, and Check, Wire Transfer, or Credit Card payments for a particular Vendor. To achieve this goal the report is divided into two sections: Vendor Deposits / Deposit Checks and Vendor Invoices and Payments.
The Vendor Accounting Inquiry Report requires a single Vendor Code to be entered for which accounting activity will be displayed.
Vendor Deposit payables and their associated Checks and Credit Card Payments are listed in the Vendor Deposit / Deposit Checks section with columns for Transaction Date, Number, and Description, Fiscal Month, Type (either Vendor Deposit or Check), Purchase Order Number, Cash Account affected, and Check Number. For Vendor Deposits, the Deposit Amount is listed and, if the Deposit was paid via Credit Card, the total Payment Amount. Checks will also list the Payment Amount.
In the Vendor Invoice and Payments section, Vendor Invoices and Checks are listed with columns for Type (either Vendor Invoice or Check), Purchase Order Number, Date, Transaction Number and Description, Cash Account affected, and Check Number. For Vendor Invoices, the Gross Invoice Amount, Deposit Applied, and Net Invoice are also listed while the Payment Amount is displayed for Check and Credit Card transactions. Following the Vendor Invoices and Payments, the total Gross Invoice Amount, Deposit Applied, Net Invoice, Payments, along with the current available Vendor Deposit and Accounts Payable Amounts, are displayed.
Throughout both sections, the Balance columns represents the total balance currently owed to the Vendor.
An Invoice Date range is available to narrow the scope of the report. The Show Account Detail option will display a listing of each General Ledger Account affected by a Vendor Invoice transaction.