AR Collections Report

The AR Collections report is a useful tool for managing customer collections and cash flow, reconciliation, and for reviewing a customer’s account.  The layout of this report changes dynamically based upon the parameters specified at run time.  Only non-voided documents in open status display.

 

Parameters

 

Parameter

Description

Customer Class

Choose (Select All) to include all defined classes, or select individually from the drop-down list.

A selection here controls what values are available within the Customer parameter.

Customer

Choose (Select All) to include all available customers, or select individually from the drop-down list. 

This field is dependent on what was selected within the Customer Class.  Only records belonging to the selected Customer Class(es) will be available in this field.

Company Wide Branch

Set this option to True to allow the report to group by a value other than Branch, otherwise the report will group by Branch.

Company Wide Authority

Set this option to True to allow the report to group by a value other than Authority, otherwise the report will group by Authority.

Note:

When grouping by Branch and by Authority are in effect, then the report will first group by Branch and then by Authority (as a subgroup).

Show Notes

Enter True to include all Collections notes attached to an order record or enter False to not display this information.

This option will only work if the Group by parameter is set to Order.

See the Notes (AR Credit & Collections) section for more information.

Detail Level

Choose which level of detail is to be included on the report.  The following detail level options are available:

Customer

Order

Invoice

Document

 

All values here work in conjunction with what was selected for Group by.  If the Group by option is set to “Customer”, for example, then a user may want to select a Detail Level of Order, to create a more thorough report.

See the following Report Details section for more information on this setting.

View Customer By

Choose Name to display the customers by name first followed by number or choose Number to display the customer number first and then name. 

 

Note: Name and number values are separated by a hyphen (“-“) on the report and will be sorted according to what is displayed (either name first or number).

 

Branch

Choose (Select All) to include all branches, or select individually from the drop-down list. 

The option of <none> will include only those records that do not have a branch assigned to them.

Set the *(company wide) option to allow the report to group by a value other than Branch.  To group by the Branch value, then do not select this option.

Authority

Choose (Select All) to include all authorities or select individually from the drop-down list. 

The option of <none> will include only those records that do not have an authority type assigned to them.

Aging Date Type

Select from following list of types:

Document

Journal

Posting

Due

Invoice

 

Group by

Select either Customer to group the data by the Customer Number, or choose Order to group the data by the Order Number.

Details of the item select here will automatically be included in the report.

 

Report Details

 

This section covers what specific items are listed in detail on the report.

 

Report Grouping

 

Grouping of data within the report is based on three-levels.  The highest level is based on Branch, the second level is Authority, and the lowest level is that of the value specified within the Group by field.

    Branch grouping is in effect when *(company wide) option is not set

    Authority grouping is in effect when the *(company wide) option is not set

    Order grouping is in effect when the Group by is set to Order and the Detail Level is specified as Document

    Customer grouping is in effect when the Group by is set to Customer and the Detail Level is either Order or Document.  Note: The View Customer By option will affect customer depending on whether Name or Number is selected

 

Header Information

 

No header information displays.

AR Collections Detailed Report Information

This section lists what displays on a report for the various settings of the Detail Level option.

 

Customer Details:  When the Detail Level is set to Customer the following line items will be displayed:

    Customer Number

    Customer Name

    Phone

    Contact

    Account Aging (<30, 31-60, 61-90, 91-120, >120)

    Aging Totals

    Total Invoice Amount

 

Order Details: When the Detail Level is set to Order the following line items will be displayed:

    Order Number

    Shipper

    Account Aging (<30, 31-60, 61-90, 91-120, >120)

    Aging Totals

    Total Invoice Amount

 

Invoice Details: When the Detail Level is set to Invoice the following line items will be displayed:

    Invoice Number

    Invoice Date

    Account Aging (<30, 31-60, 61-90, 91-120, >120)

    Aging Totals

    Total Invoice Amount

                                                                                           

Document Details: When the Detail Level is set to Document the following line items will be displayed:

    Document Number

    Document Type

    Journal Date

    Document Date

    Due Date

    Post Date

    Account Aging (<30, 31-60, 61-90, 91-120, >120)

    Aging Totals

    Total Invoice Amount

 

AR Collections Collection Notes

 

A user can choose to display collection notes associated to an order by setting the Show Notes option to True and setting the Group Level value to Order.  Any notes defined of type “Collections” will be listed on the report.

 

Note:

These notes tie directly to order record and must of Note Type “Collections” to display on report.  Refer to the administrative setup area within the Note Type Setup.

 

 

Figure 1: Collection Note display

 

Report Totals

 

The following section and grand totals will appear depending on the report options selected:

    Customer Total

    Order Total

    Authority Total

    Branch Total