top of page
Laptop and Paperwork

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. 


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

bottom of page