Receivables lists and reports

The lists (analytics) and printed reports of receivables, by menu, with the criteria each asks for. A criteria marked "required" must be filled before the list runs. Lists open, keep views and export the same way everywhere; see Lists, boards and reports.

Customer

Name	Kind	What it shows	Criteria
Customer	List	Customers with their category and group	Customer Category, Customer Group, Customer
Customer Legal Entity	List	The company records of customers	Customer Category, Customer Group, Tax Zone, Country Region, Country, State, City, Sales Organization, Customer
Customer Addresses	List	Every address of every customer	Customer, Customer Category, Customer Group, Tax Zone, Country Region, Country, State, City, Sales Organization
Customer Registration	List	Customers' registrations	Registration For Number
Customer Balance Summary	List	Each customer's opening, movement and closing for a period	Customer, Posting Status, Date From and Date To (required)
Collection Knocked	List	What each customer's collections cleared	Customer, Posting Status, Date From and Date To (required)
Customer Invoice, List of Sales Vouchers	List	Invoice headers	Invoice, Customer, Posting Status, Posting Date, Show Due, Required Reverse, and Transaction Journal, Sales Group, Sales Taker or Item No
Customer Invoice Lines, Customer Invoice Lines Local	List	Invoice lines, in invoice or company currency	Invoice, Customer, Posting Status, Posting Date, Show Due, Required Reverse, Special Indicator, Item No, Customer Group, Site, Item Posting, Transaction Journal and more
Sales Analysis - Item Wise	List	Sales by item	Invoice, Item No, Posting Status, Posting Date, Show Due, Required Reverse, Item Posting
Customer Collection, Customer Collection Lines	List	Collections and their lines	Transaction, Transaction Journal, Journal Indicator, Payer, Posting Status, Posting Date, Required Reverse, and more
Customer Trial Detail	List	A customer's ledger to a date	Customer and Date (required), Reporting Structure, Posting Layer, Posting Status, Required Zero Values, View On Customer Currency, Currency, Required Reversal, Required Inventory Details
Customer Base Data	Report	A customer's master data	Customer
Customer Trial Balance	Report	Opening, debits, credits and closing per customer	Date From and Date To (required), Account, Customer, Posting Status, Posting Layer, Required Zero Values, Required On Account, Required Reversal
Customer Trial Balance Detail	Report	The same, line by line	Date From and Date To (required), Account, Customer, Posting Status, Required Reversal
Customer Statement	Report	The statement of account sent to a customer	Customer, Date From, Date To (all required)
Customer Balance Confirmation	Report	A balance confirmation letter	Customer and Till Date (required)
Sales Report Annexure A	Report	Sales tax annexure of sales	Customer, Date From and Date To (required)
Sales Report Packing Wise	Report	Sales by packing	Customer, Date From and Date To (required), Item Category, Sales Organization, Packaging Group, Customer Group, Required Local Price/Amount
Sales By Customer, Sales by Responsible, Sales by Sales Taker, Sales by Item	Report	Sales analysed four ways	Date From and Date To (required), Customer, Sales, Sales No, Item Variant, Item Category, Item Group, Item Sub Group, Item Posting, Sales Organization, Sales Group, Sales Region, Sales Area, Sales Territory, View On, Required Sales Structure
Undertaking	Report	An undertaking letter printed for an invoice	Invoice

Some reports on this menu are print layouts made for one client; they carry that client's name.

Customer Invoice

Name	Kind	What it shows	Criteria
Sales Analysis - Region Wise	List	Sales by region	Invoice, Country Region, Posting Status, Posting Date, Show Due, Required Reverse, City, Customer
Customer Invoices Tax Lines	List	The tax lines of invoices	Customer, Posting Date
Customer Invoice, Invoice, Commercial Invoice, Customer Service Invoice, Fleet Invoice	Report	Invoice print layouts	Invoice and Customer (and Show Voucher on most)
Customer Memo	Report	Credit memo print	Show Voucher, Invoice, Customer
Client Receipt	Report	A receipt printed from the invoice	Transaction
Form - 5 Warranty under Medical Devices Rules	Report	A regulatory warranty form for an invoice	Invoice, Posting Date (required)
Biometric Report	Report	Customer biometric record	Customer (required)

Collection

Name	Kind	What it shows	Criteria
Customer Collection Through	List	How collections came in, line by line	Payer, Posting Date, Include Reversal, Transaction Journal, Customer Group
Receipt Voucher, Receipt Voucher Without Label, Token Receipt, Buy Back Receipt	Report	Receipt prints	Transaction, Posting Date
Collection	Report	The collection voucher	Show Voucher, Transaction, Posting Date, Transaction Journal, Tax Breakup, Hide zero Amount from Summary

Aging

Name	Kind	What it shows	Criteria
Customer Aging	List	Each customer's open balance in the buckets of an aging period	Aging Period and Till Date (required), Customer, Auto Knock, Required Weighted Average Days, View On Customer Currency, View Dimension, Customer Group
Customer Aging on Invoice	List	The same, invoice by invoice	Aging Period and Till Date (required), Customer, Customer Group, Sales Taker, Sales Responsible, Auto Knock, Required Weighted Average Days, View On Customer Currency, View Dimension

Customer Ledger

Name	Kind	What it shows	Criteria
Customer Trial	List	Customer balances for a period	Date From and Date To (required), Customer, Reporting Structure, Posting Status, Posting Layer, View On Customer Currency, Account, Currency, Customer Group
Customer Trial Detail (Legacy)	List	The older ledger list	Customer, Date From and Date To (required) and more
Customer Ledger	Report	A customer's ledger	Date From and Date To (required), Customer

Sales Tax, Tracking Number

Name	Kind	What it shows	Criteria
Annexure C	List	Sales to registered and unregistered buyers for the sales tax return. The province columns are fixed in the delivered query	None
Tracking Number Setup	List	Every tracking number: used on which collection, or void	Number Group (required), Tracking Number Setup, Posting Date

Elsewhere

• Sales Analysis - Customer Wise sits on the Sales and Distribution menu. See Sales.
• Customer Outstanding Days is configured but not part of Businessflo as delivered.