Report Title

Optional parameter that allows the user to specify a report title that will print as part of the report header.

N

Run Mode

·       CUSTOMER – prints all customers.

·       DETAIL – provides a detailed listing of all customers with their orders.

·       ORDER – provides a listing of all orders.

·       SUMMARY – provides a summary listing.

This parameter defaults to DETAIL.

Y

Organization

Defaults to the ORG_ID of the logged in user and cannot be changed.

Read-only

Organization Unit

Defaults to the ORG_UNIT_ID of the logged in user and cannot be changed.

Read-only

FAR610_Mode

·       Aged Receivables Report (FAR610) – only the report will be generated

·       Aging Report with Customer Statements (FAR610T) – the report AND a statement(s) will be generated.

·       Statement of Previous Run – Parent Job Id is required in order to run it successfully in this mode.

Y

Begin Date

All transactions having txn_date >= this date will be selected. Typically, this will be set to something like 1/1/1900.

Y

End Date

All transactions having txn_date <= this date will be selected.

Y

Generate Data

This parameter decides whether or not to save records in FAR610_Master and FAR610_Detail tables.

Y

Purge Data

This parameter decides whether or not to purge data from FAR610_Master and FAR610_Detail tables after generating the report.

N

Subsystems

Select one or more subsystems for which to run the report. If left blank, the process will run for all subsystems. Report can be run for multiple subsystems at a time.  

N

Aging Interval #1

Indicates the first aging interval, starting with "current". Typically set to '30'.

Y

Aging Interval #2

Typically set to '60'. This parameter should be greater than the Aging Interval #1.

Y

Aging Interval #3

Typically set to '90'. This parameter should be greater than the Aging Interval #2.

Y

Aging Interval #4

Typically set to '120'. This parameter should be greater than the Aging Interval #3.

Y

Display All Buckets

This parameter determines whether or not to display values for all intervals in the report.

Y

Youngest Interval

Enter zero (0) to select all intervals. Enter 1 – 4 to select transactions equal to and older than the value entered on the corresponding Interval number.

Y

Include Receipts Refunds

This parameter determines whether or not to include receipts and refunds before invoicing.

Y

Unapplied Credits

This parameter determines whether or not to include unapplied credits in the report.

Y

Customer Minimum Debit

All customers with balances greater than the amount entered in this parameter will appear on the all customers with balances report.

N

Customer Minimum Credit

All customers with credit balances less than the amount entered in this parameter will appear on the Aged Receivables report. Enter a large amount here to get only debit balance customers in the report (e.g., 999999999).

N

Print Customer with 0 Balance

Setting this to Y will include orders for customers where the customer's total balance due is zero , but there are orders with offsetting debit and credit balances. When generating statements, this should be set to N; otherwise, it's recommended that this be set to Y.

Y

Order Minimum Debit

All orders with balances greater than the amount entered in this parameter will appear on the report. Enter a large amount here to get only credit balance orders in the report (e.g., 999999999).

N

Order Minimum Credit

All orders with credit balances less than the amount entered in this parameter will appear on the report. Enter a large amount here to get only credit balance orders in the report (e.g., 999999999).

N

Print Order with Zero Balance

Setting this to Y will include orders where the order's total balance due is zero, but there are order lines with offsetting debit and credit balances. When generating statements, this should be set to N; otherwise, it's recommended that this be set to Y.

Y

Minimum Debit for Order Line

All order lines with balances greater than the amount entered in this parameter will appear on the report. Enter a large amount here to get only credit balance order lines in the report (e.g., 999999999).

Y

Minimum Credit for Order Line

All order lines with credit balances less than the amount entered in this parameter will appear on the report. Enter a large amount here to get only credit balance order lines in the report (e.g., 999999999).

Y

SubTitle

Optional parameter that allows the user to specify the title that will print as part of the report header of the statement.

N

Company Number

Enter company number for which you want to run this report. Leaving it blank would run aging for all the companies.

N

Aging Method

·       INVOICE_DATE – calculates the aging bucket based on Invoice Date. This will ignore payment schedules.

·       DUE_DATE – calculates based on due date. This will considered payment schedules.

This parameter refers to the aging, NOT on the selection criteria.

Y

Specific Message for Bucket 1, Specific Message for Bucket 2, Specific Message for Bucket 3, Specific Message for Bucket 4, Specific Message for Bucket 5

Any specific message for the bucket can be specified to display on the statements. The message for the most overdue will display (i.e., all messages will NOT display if the 120 aging interval is applied).

Bucket 1 correlates to "current", bucket 2 correlates to aging interval 1, bucket 3 correlates to aging interval 2, etc.

N

General Message

Any general message for customers.

This message will display before the bucket-specific message.

N

Customer Statement Mode

Indicates how to group the customer statement:

·       INVOICE – there will be one line per invoice number containing the total balance for the invoice number.

·       ORDER – there will be one line per order line number.

N

Generate Exception Report

This parameter determines whether or not to generate the exception report.

Y

Association Name

By default, the name of the org unit defined on the Mailing Address screen in Organizational Unit Maintenance will display on the statements. If necessary, you can override the default here.

N

Association Address Line 1, Association Address Line 2, Association Address Line 3, Association Address Line 4, Association City, Association State, Association Postal Code, Association, Country Code, Association Phone Number, Association Fax Number, Association Email Address

By default, the mailing address of the org unit defined on the Mailing Address screen in Organizational Unit Maintenance will display on the statements. If necessary, you can override the default here.

N

Pay Label Name, Payment Address 1, Payment Address 2, Payment Address 3, Payment Address 4, Pay City Name, Payment State, Payment Pay Postal Code, Payment Pay Country Code

By default, the payment address of the org unit defined on the Payment Address screen in Organizational Unit Maintenance will display on the statements. If necessary, you can override the default here.

N

Use Address Change Service

·       Y =  the labels are printed with ACS Format having Intelligent Mail Barcode, and the process makes sure the appropriate values are set for the Barcode Identifier, Service Type Identifier, and Mailer ID parameters. The width of the label also increases by one row.

·       N = the ACS format is ignored and the label is printed without the barcode.

For more information on ACS, please see Address Change Service.

N

Barcode Identifier

A two-digit value that indicates the degree of pre-sorting this mail piece received before being presented for mail delivery.

N

Service Type Identifier

A three-digit value representing both the class of the mail (such as first-class, standard mail, or periodical), and any services requested by the sender.

N

Mailer ID

A six or nine-digit number assigned by the USPS that identifies the specific business sending the mailing. Higher volume mailers are eligible to receive six-digit Mailer IDs, which have a larger range of sequence numbers associated with them; lower volume mailers will receive nine-digit Mailer IDs. To make it possible to distinguish six-digit IDs from nine-digit IDs, all six-digit IDs begin with a digit between 0 and 8, inclusive, while all nine-digit IDs begin with the digit 9.

N

Advanced Job Parameters

Sort Order for Aging Report

This will sort the data on the aging report.

Y

Filter for Aging Report

Enter any additional filter criteria for selecting records from the table.

N

Filter

Enter additional filter criteria for selecting records from the FAR610_Master table.

N