Accounts Receivable Model
The Accounts Receivable area model allows the user to select from the Customer and Customer Ledger fields. All text, integer, decimal, option / enum and boolean fields from the Customer table are available to select on reports. Reports in this area support drill down, flow fields and can be filtered. To learn more about creating reports using the designer click here
Explanation of Fields
Accounts Receivable reporting is centered around the customer ledger table. In order to make reporting easier the amount field has been expanded into fields for Invoice, Credit Memo, Finance Charge and Reminder.
Filters
When creating reports it is important to set filters in order to get the expected results. The following filters are available
Customer No, Blocked, Customer Posting Group, Posting Date, Dimension 1 .. 8, Salesperson and General Business Posting Group, Open, Document Type
Text and Date Fields
The following fields are available. from the customer Ledger
Customer No, Sell-to Customer No,
Document No, External Document No.
Salesperson Code, Payment Method Code,
Document Date, Posting Date
Customer Posting Group, Source Code, Reason Code
Dimensions 1 through 8
Amount Fields
The following fields are available.
Amount $ - This is the amount field from the customer ledger. It is the field to use when summing all different types of document amounts.
Remaining Amount $ - Shows value of invoice unpaid
Invoice Amount $ - Shows amount for document type Invoice
Credit Memo Amount $- Shows amount from any credit memos posted
Payment Amount $ - Shows payments made by customer
Sales $ - This is Amount $ less any taxes (i.e. net sale amount). This is the Sales $ field from customer ledger.
Finance Charge Memo $, Reminder$, Refund $ - These amounts are from documents posted from the finance, reminder or refund activity
Tip If creating an aged receivable type report, filter on Open documents only