Payables lists and reports
Payables has two kinds of output. Lists open in the grid view and can be sorted, grouped and exported. Reports print. Each takes criteria; those marked required must be filled. How lists and reports work in general is on Lists, boards and reports.
Lists
| List | Where | What it shows | Criteria |
|---|---|---|---|
| Vendor Invoice | Vendor Invoice | One row per invoice | Invoice, Vendor, Posting Status, Posting Date, Show Due, Required Reverse |
| Vendor Invoice Lines | Vendor Invoice | One row per invoice line | Invoice, Purchase Order, receipt, Vendor, Vendor Group, Posting Status, Posting Date, Purchase, Purchase No, Show Due, Required Reverse |
| Vendor Invoice Tax Lines | Vendor Invoice | The tax of each invoice line | Vendor, Posting Date |
| Vendor Aging Invoice Wise | Vendor Invoice | Each open invoice in age buckets | Aging Period and Till Date required; Vendor, Vendor Group, Auto Knock, Required Average Days, View on Currency, View on Dimension |
| Vendor Aging | Vendor Invoice | Each vendor's open balance in age buckets | As above |
| Payment Request | Vendor Invoice | Payment requests | Posting Date, Request, Journal, Payee |
| Vendor Payment | Payment | One row per payment | Payment, Journal, Payee, Posting Status, Posting Date, Instrument No, Required Reverse |
| Vendor Payment Lines | Payment | The invoices each payment cleared | Payment, Payee Entity, Payee, Posting Status, Posting Date, Required Reverse |
| Vendor Payment Through | Payment | The bank and cheque lines | Payee Entity, Payee, Posting Date, Payment Request |
| Payment Released | Payment | Released cheques | Transaction, Transaction Date |
| Vendor | Vendor | The vendor master | Vendor Category, Vendor Group |
| Vendor Legal Entity | Vendor | Vendors of this company with their terms | Vendor Category, Vendor Group, Tax Group, Payment Term, Payment Method, Purchase Organization, Purchase Team |
| Vendor Registration | Vendor Registration | Vendors' registrations | Vendor |
| Vendor Trial | Vendor Ledger | Opening, movement and closing per vendor | Date From and Date To required; Vendor, Vendor Group, Account, Reporting Structure, Posting Status, Posting Layer, View on Currency |
| Vendor Trial Detail | Vendor Invoice | Every entry of one vendor | Vendor and Date required; Reporting Structure, Posting Layer, Posting Status, Required Only Released, View on Currency, Currency, Required Reversal, Required Inventory Detail, Required Zero Values |
| Vendor Trial Detail (Legacy) | Vendor Ledger | The older detail list | Vendor, Date From and Date To required |
Several further vendor trial lists are client-specific variants of the ones above.
Reports
| Report | Where | What it prints | Criteria |
|---|---|---|---|
| Vendor Invoice | Vendor | The invoice | Invoice, Vendor, Posting Date, Show Voucher, Show Reference |
| Vendor Memo | Vendor | The debit note | Invoice, Vendor, Show Voucher |
| Payment | Payment | The payment advice | Payment required; Posting Date, Journal, Show Voucher, Tax Breakup, Hide Zero |
| On Account Payment | An on-account payment | As Payment | |
| Payment Request | Payment | The request | As Payment |
| Payment Release Advice | Payment | Payments released to payees | Date From and Date To required; Payment, Journal, Payee |
| Payment cheque prints | The cheque, laid out for a specific bank | Payment required; Payee Only, and on one layout Instrument No | |
| Vendor Trial Balance | Vendor | Balances per vendor | Date From and Date To required; Account, Vendor, Posting Status, Posting Layer, Required Zero Values, Required On Account, Required Reversal |
| Vendor Trial Balance Detail | Vendor | The entries behind each balance | Date From and Date To required; Account, Vendor, Posting Status, Required Reversal |
| Vendor Trial Balance - Ledger | Vendor | In ledger layout | As above |
| Vendor Statement | Vendor | One vendor's statement | Vendor, Date From and Date To required |
| Vendor Base Data | Vendor | Vendor master data | Vendor |
| Vendor ledger | Vendor Ledger | One vendor's ledger | Date From and Date To required; Vendor |
| Purchase by Item, Purchase Date Wise, Purchase By Vendor and Item, Purchase by Date | Vendor | Purchases in four layouts | Date From and Date To required; Vendor, Purchase, Purchase No, Item Variant, Item Category, Item Group, Item Sub Group, Item Posting, Purchase Organization, Purchase Group, View On, Required Purchase Structure |
| Purchase Report Party Wise | Vendor Invoice | Purchases per vendor | Date From and Date To required; Vendor, Vendor Group, Item Group, Purchase, Item Category, Purchase Type, Special Indicator, Purchase Organization |
| Tax Challan Payment Report | Vendor | Withholding tax paid over | Date From and Date To required; Payment, Vendor |
Reports configured but not in any menu: Payment Voucher, Note Sheet, Vendor Information, Purchase Report Item Group Wise, Purchase Return Report Party Wise, Purchase Return Item Group Wise.