Search Tips
Pgm: ARCTRLFM – Maintain AR Control Settings; standard Treeview path: Accounts Receivable > Setup > Local Tables > Control File Options – Statement tab
Age Reports
The system allows for the following aging methods:
-
Invoice Date
-
Due Date
-
Post Date
The method selected is used when aging invoices for both the aged reports and customer statements.
Calculate Interest
Interest can be calculated by “Invoice Date” or by “Due Date”. Select the method that will be used by your company.
Aging Periods
The number of aging periods is user-defined up to a maximum of six periods, including current and maximum. The number of days in these periods may be changed at any time. The program will default the number of periods to four. If running with six periods, the AR Executive query and the collections report will utilize all six periods but the aged report will combine the last two periods into the fourth one.
Discount Always Applicable for Aged Report – Checkbox
If discounts are to be considered on the AR aged report regardless or not if they are beyond the discount date, check this box; otherwise, leave it unchecked.
Statement Name
CMiC Enterprise comes with a standard statement format represented by the name “AR Statements for Laser Printer”. This name will default to this field.
Statement Date Last Run
This field is used to define the date range for current activity when statements are printed. The current activity date range is from the last statement date to the current statement date.
Minimum Owing Amount
This is the default value for the same field on the Statement Printing Program. Enter the minimum dollar amount for which a statement will print. Statements will not print for a customer whose total amount owing is less than the amount entered in this field.
Print Only Invoices Owing
Use this option to select the default value for statement printing. This field determines which invoices that will appear on the statements.
Select “All Invoices” to print all current invoices.
Select “Greater Than 0” to only print invoices where the outstanding amount is greater than $0.00.
Select the “Not Equal to 0” option to only print invoices where the outstanding amount is not equal to $0.00.
Sort By option
Select the default way in which invoices will print on the statements. The system allows you to sort invoice by invoice number, job number, invoice date, or due date.
Default Corporate Address Code
If the corporate address on customer statements is not the standard company address, then enter the required address code in this field. If this field is left blank, the standard company address will be used.
Sender's Email Address
Enter the sender's email address for the notification being sent. The sender’s email address could be an AR department’s email address, or an individual’s email address.
Email Body Text Code
Enter/select the email body text code to be used in the body of the email notification.
NOTE: Text codes must be initially set up in the System Data module using the text type "AR-STMT". Refer to Define Text Type and Text Codes for an example of how this type of code is defined.
Email Subject Text Code
Enter/select the email subject text code to be used in the email notification.
NOTE: Text codes must be initially set up in the System Data module using the text type "AR-STMT". Refer to Define Text Type and Text Codes for an example of how this type of code is defined.
Deduct Deposit – Checkbox
Check this box if customer deposits (pre-payments) should be deducted from the total amount owing.
Print Deposits – Checkbox
Check this field if customer deposits (pre-payments) which have not yet been invoiced are to appear on the printed statements.
Add Interest Charges – Checkbox
Check this box if interest charges should be included in the statement when determining the total amount owing. If this box is checked, interest charges will automatically be printed on the statement.
Summarize Interest Rates
Currently this field is not being used.
Print Invoice Net on Statements
Check this box if the net amount due for an invoice is to be printed on the statements when payments have been made against that invoice.