Skip to main content

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​

ListWhereWhat it showsCriteria
Vendor InvoiceVendor InvoiceOne row per invoiceInvoice, Vendor, Posting Status, Posting Date, Show Due, Required Reverse
Vendor Invoice LinesVendor InvoiceOne row per invoice lineInvoice, Purchase Order, receipt, Vendor, Vendor Group, Posting Status, Posting Date, Purchase, Purchase No, Show Due, Required Reverse
Vendor Invoice Tax LinesVendor InvoiceThe tax of each invoice lineVendor, Posting Date
Vendor Aging Invoice WiseVendor InvoiceEach open invoice in age bucketsAging Period and Till Date required; Vendor, Vendor Group, Auto Knock, Required Average Days, View on Currency, View on Dimension
Vendor AgingVendor InvoiceEach vendor's open balance in age bucketsAs above
Payment RequestVendor InvoicePayment requestsPosting Date, Request, Journal, Payee
Vendor PaymentPaymentOne row per paymentPayment, Journal, Payee, Posting Status, Posting Date, Instrument No, Required Reverse
Vendor Payment LinesPaymentThe invoices each payment clearedPayment, Payee Entity, Payee, Posting Status, Posting Date, Required Reverse
Vendor Payment ThroughPaymentThe bank and cheque linesPayee Entity, Payee, Posting Date, Payment Request
Payment ReleasedPaymentReleased chequesTransaction, Transaction Date
VendorVendorThe vendor masterVendor Category, Vendor Group
Vendor Legal EntityVendorVendors of this company with their termsVendor Category, Vendor Group, Tax Group, Payment Term, Payment Method, Purchase Organization, Purchase Team
Vendor RegistrationVendor RegistrationVendors' registrationsVendor
Vendor TrialVendor LedgerOpening, movement and closing per vendorDate From and Date To required; Vendor, Vendor Group, Account, Reporting Structure, Posting Status, Posting Layer, View on Currency
Vendor Trial DetailVendor InvoiceEvery entry of one vendorVendor 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 LedgerThe older detail listVendor, Date From and Date To required

Several further vendor trial lists are client-specific variants of the ones above.

Reports​

ReportWhereWhat it printsCriteria
Vendor InvoiceVendorThe invoiceInvoice, Vendor, Posting Date, Show Voucher, Show Reference
Vendor MemoVendorThe debit noteInvoice, Vendor, Show Voucher
PaymentPaymentThe payment advicePayment required; Posting Date, Journal, Show Voucher, Tax Breakup, Hide Zero
On Account PaymentPrintAn on-account paymentAs Payment
Payment RequestPaymentThe requestAs Payment
Payment Release AdvicePaymentPayments released to payeesDate From and Date To required; Payment, Journal, Payee
Payment cheque printsPrintThe cheque, laid out for a specific bankPayment required; Payee Only, and on one layout Instrument No
Vendor Trial BalanceVendorBalances per vendorDate From and Date To required; Account, Vendor, Posting Status, Posting Layer, Required Zero Values, Required On Account, Required Reversal
Vendor Trial Balance DetailVendorThe entries behind each balanceDate From and Date To required; Account, Vendor, Posting Status, Required Reversal
Vendor Trial Balance - LedgerVendorIn ledger layoutAs above
Vendor StatementVendorOne vendor's statementVendor, Date From and Date To required
Vendor Base DataVendorVendor master dataVendor
Vendor ledgerVendor LedgerOne vendor's ledgerDate From and Date To required; Vendor
Purchase by Item, Purchase Date Wise, Purchase By Vendor and Item, Purchase by DateVendorPurchases in four layoutsDate 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 WiseVendor InvoicePurchases per vendorDate From and Date To required; Vendor, Vendor Group, Item Group, Purchase, Item Category, Purchase Type, Special Indicator, Purchase Organization
Tax Challan Payment ReportVendorWithholding tax paid overDate 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.