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 are displayed.

 

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.
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.
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.
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.
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).
Aging Date Type	Select from following list of types: Document, Journal, Posting, Due, Invoice.
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 combination of the Group by parameter and Detail Level parameter allows for the order to be displayed on the report.  For example, the Group by parameter is set to Order, or the Detail Level parameter is set to one of Order, Invoice, or Document. See the Collection Notes section for more information.
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.
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 Detail Report Information section below for what details display for these settings.

 

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.

 

Header Information

 

No header information is displayed.

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 Detail Level value to Order.  Any notes defined of type “Collections” will be listed on the report.

 

NOTE: These notes are tied directly to order record and must of Note Type “Collections” to display on report.  Refer to the administrative setup area within the MMS > General > NoteType setup of the Administration Tool.

 

 

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.