Revenue Controls

The fields on this section govern just the Accounts Receivable functional area.  As this area can often be one that is very decentralized, many controls have override flags present on this section of SOPT.  Those same controls can then be set at the Revenue Source table, which is a slightly decentralized area because not all parties in an application collect the same types of revenues.  The same controls can also be found on the Billing Profile table, which can be a very decentralized area because profiles can be defined at a department level or even at a unit level within a department.

The following table displays Revenue options and controls found on SOPT:

Option/Control

Description

General Information

AR Department Inference

Critical to accounts receivable processing is the extent to which controls are decentralized.  This option has four values to facilitate the population of the AR Department and AR Unit fields on accounting documents: Set to ALL, Infer From User ID, Infer From Document ID, and No Inference.

Set To ALL: This setting is common for an application that is driven by system-wide controls or has only a few exceptions.  Users in those exceptions will manually enter values themselves.

Infer From User ID: Each user ID in the application is associated with at least a department code and possibly a unit code.  The value or values associated with a user ID in security setup will default.  If there is no unit to default, then it will be set to ALL.

Infer From Document ID: Each document ID in the application is associated with at least a department code and possibly a unit code.  The value or values associated with a document ID at the time of document creation will default.  If there is no unit to default, then it will be set to ALL.

No Inference:  This setting is used when an application is driven by decentralized controls or has only a few exceptions.  All users will have to enter an AR Department and Unit, whether those are actual values or system-wide values of ALL.

Receivables

Receivable Due Date Lag

This option establishes the number of days past the receivable date or number of days past the statement date that the Receivable is due when A/R processes are calculating late fees and interest.  Default is zero. 

Allow Override of Receivable Due Date Lag

Override capability to control use of the same option set at the Billing Profile level.

Minimum Billing Amount

 

Currency option that specifies a minimum amount that a customer account must total, in order to be selected for the automatic billing process.  No bill (dunning message or a statement) is printed if the outstanding document amount is less than this amount.  The default value for this field is $ 0.00.

Allow Override of Minimum Billing Amount

Override capability to control use of the same option set on the Billing Profile level.

Minimum Negative Billing Amount

 

Currency option that specifies a minimum negative amount that a customer account must total, in order to be selected for the automatic billing process.  This edit only applies to customers with a Billing Type of Statement, and will not affect the printing of invoices.  The default value for this field is $ 0.00.

Allow Override of Minimum Negative Billing Amount

Override capability to control the use of the same option set on the Billing Profile level.

Minimum Past Due Amount for Finance Charge

This option indicates the minimum amount a past due amount can be before applying finance charges.

Allow Override of Minimum Past Due Amount

This option indicates whether the Minimum Past Due Amount for Finance Charge is overrideable at the Billing Profile level. 

Finance Charge Fee 1-5

Five separate and optional pick lists of Finance Charge Codes from the Finance Charge table.  The same code cannot be selected for more than one fee.  The default is blank. 

Allow Override of Finance Charge Fees

Override capability to control the use of the same options set on the Billing Profile or Revenue Source levels.  Only one override field is needed to apply to all five fees at once. 

Past Due Days for Intercept

 

This required numeric field represents a selection parameter for an offline process that automatically selects the past due receivables to be sent for intercept.  The default value is blank.

Allow Override for Past Due Days for Intercept

Override capability to control the use of the same option set on the Billing Profile level.

Intercept Request Table Load Status

 

This field indicates the status with which selected records are loaded to the Intercept Request Table (IRT).  Valid values are Active and Inactive.  The default value is Inactive. 

Allow Override of Intercept Request Table Load Status

An override capability to control the use of the same option set on the Billing Profile level.

Cash Receipts

Print Deposit Ticket

This is a Yes/No option that indicates whether you use the print deposit process to deposit money into the bank.  If checked, accepted cash receipts will be updated to a Cash Receipt Pending table waiting to be selected and printed on a deposit ticket.  A cash receipt will not be updated to the Deposit Reconciliation table until it is printed on the Deposit Ticket.  If this box is not checked, an accepted cash receipt will be updated to the Deposit Reconciliation table directly (dependent on the option selected for the Use Deposit Reconciliation option).  The default value is Yes.

Use Deposit Reconciliation

This is a Yes/No option that indicates whether the deposit reconciliation process will be used.  The default value is Yes.

Require Deposit Date Only

When selected, this flag indicates that the Deposit Date is required on revenue transactions.  This flag requires the deposit date to be entered on the CR documents even when users do not want to use the Deposit Reconciliation process.

If this flag is selected, the Use Deposit Reconciliation option may not be selected.  Therefore, cash receipt transactions will not update the Deposit Reconciliation tables.

The Print Deposit Ticket flag cannot be selected if the Require Deposit Date Only flag is selected.

Automatic Net Credit Balance

 

This is a Yes/No option that allows you to decide whether the system should automatically net a credit balance (that is, from an overpayment) against a positive receivable within the same customer account.  The default value is Yes.

Unreserved Credit Balance Event Type

The primary event type assigned to an overpayment accounting line when an auto apply is performed on a Cash Receipt to a customer account or Receivable document level.  Use of this event type is made when the flag for Reserved Credit Balance is not selected on the Cash Receipt vendor line.  Unreserved credit balances can be automatically netted against future open receivables or automatically returned to customers.

Allow Override of Unreserved Credit Balance Event Type

Override capability to control the same option set on the Billing Profile level.

Reserved Credit Balance Event Type

The secondary event type assigned to an overpayment accounting line when an auto apply is performed on a Cash Receipt to a customer account or Receivable document level and the flag for Reserved Credit Balance is not selected on the Cash Receipt vendor line.  Reserved credit balances are never automatically netted against future open receivables or automatically returned to customers.

Allow Override of Reserved Credit Balance Event Type

An override capability to control the same option set on the Billing Profile level.

Automatic Refund to Customer of Credit Balance

This is a Yes/No option where you define whether the system should automatically generate a payment request for a customer's unreserved credit balance.  The default value is No. 

Allow Override of Automatic Refund

An override capability to control the use of the same option set on the Billing Profile level.

Number of Days for Credit Balance

 

This option defines the number of days allowed for an unreserved credit balance to stay in a customer account before a payment is automatically generated.  This field is only used when the Automatic Refund to Customer of Credit Balance option is Yes.  The default value is zero. 

Allow Override of Number of Days for Credit Balance

An override capability to control the use of the same option set on the Billing Profile level.

Priority 1 5 Posting Type

 

Options where you can specify the sequence in which a payment should be applied to an outstanding receivable.  To specify the sequence you select from the posting pairs common to all event types in the event category of Revenue.  Although the names for these posting pairs are user-definable on the Event Category table, the codes used for each pair are the standard A-E letters that define the first five posting pairs of any event category.  The same code cannot be assigned to more than one priority.  The default for posting priority #1 is posting pair A, #2 is B, and so on.  Blanks are not allowed. 

Allow Override of Posting Priorities

This option indicates that only one override field is needed to apply to all five posting priorities at once.  It controls the use of the same options set at the Billing Profile level.

NSF Check Charge

This option indicates the amount of the fee charged for returned checks with insufficient funds.

Allow Override of NSF Check Charge

This option indicates whether the NSF Check Charge option is overrideable at the Billing Profile level.

Collections & Write Offs

Collection Cycle Code

An option where one selection is made from the Collections Controls table to indicate the default value of the system-wide collection cycle.  No is the default value and blank is allowed. 

Allow Override of Collection Cycle Code

An override capability to control the use of the same option set on the Billing Profile level.

Past Due Days for Collection Referral

This required numeric field represents a selection parameter for an offline process that automatically selects the past due receivables to be sent to a collection agency.  The default value is zero. 

Allow Override of Past Due Days

An override capability is needed to control the use of the same option set on the Billing Profile level.

Collection Referral Table Load Status

This option indicates the status with which selected records are loaded to the Pending Collection Agency Referral table.  Valid values are NA-Blank and Approved for Collection.  The default value is NA-Blank.

Allow Override of Load Status

An override capability to control the use of the same option set on the Billing Profile level.

Past Due Days for Write-Off

This option indicates the number of days for the offline process to automatically select the past due receivables to be written off.  The default is zero.

Allow Override of Past Due Days

This option indicates that the Past Due Days for Write-Off option can be overridden on the Billing Profile level.

Pending Write Off Table Load Status

 

This option indicates the status with which selected records are loaded to the Potentially Uncollectible Transactions Input table.  Valid values are NA-Blank and Approved for Write Off.   The default value is NA-Blank.  An override capability to control the use of the same option set on the Billing Profile level.

Allow Override of Load Status

An override capability to control the use of the same option set on the Billing Profile level.

Line Limit for Generated Write-Offs

 

This is a required numeric field that specifies the maximum number of vendor/customer lines a write-off document can have when generated by the WO Generation process.  It is a numeric field with valid values from 01 to 99.  The default value is 01.

Allow Override of Line Limit

An override capability to control the use of the same option set on the Billing Profile level.

Payment Plans

Payment Plan Agreement Notification

This is a billing instruction code that will be printed on a payment plan agreement notification.

Allow Override of Agreement Notification

An override capability to control the use of the same option set on the Billing Profile level.

Payment Plan Completion Notification

This is a billing instruction code that will be printed on a payment plan completion notification.

Allow Override of Completion Notification

An override capability to control the use of the same option set on the Billing Profile level.

Payment Plan Reminder Notification

This is a billing instruction code that will be printed on a payment plan reminder notification.

Allow Override of Reminder Notification

An override capability to control the use of the same option set on the Billing Profile level.

Payment Plan Cancellation Notification

This is a billing instruction code that will be printed on a payment plan cancellation notification.

Allow Override of Cancellation Notification

An override capability to control the use of the same option set on the Billing Profile level.

Automatic NSF Check Cancellation

This field indicates whether payment plans will be cancelled when NSF checks are received.

Allow Override of Automatic NSF Check Cancellation

An override capability to control the use of the same option set on the Billing Profile level.

Automatic Cancellation After Number of Missed Payments

This field indicates the number of times payments can be missed before the payment plan is automatically cancelled.

Allow Override of Number of Missed Payments

An override capability to control the use of the same option set on the Billing Profile level.

Minimum Days Between Payment Plan Start Date & First Due Date

This field indicates the minimum number of days that are required between the Start Date and First Due Date on the Payment Plan table.

Allow Override of Start Date & First Due Date

An override capability to control the use of the same option set on the Billing Profile level.

Payment Plan Print Date Lag

This field indicates when Payment Plan Reminder Notifications should be sent to customers.

Allow Override of Payment Plan Print Date Lag

An override capability to control the use of the same option set on the Billing Profile level.

Final Payment Plan Lag

This field defines the number of days that the Payment Plan Maintenance Batch Process will allow a payment plan to remain open before closing it.

 

Please refer to the CGI Advantage Financial - Accounts Receivable User Guide for more details about the available revenue options and controls.