Accounts Receivable Options Set on the System Options Table

The following fields on the System Options (SOPT) table are important to defining Account Receivable processing.  To enable decentralized control, indicate whether certain of these fields can be overridden, specify the settings for the same fields on the Billing Profile (BPRO) table, and specify the inference setting on the AR Department Inference field.

For more detailed information about the valid values and fields in this table, and for using the System Options table in general, refer to the "System Options" section in the CGI Advantage Financial - General Accounting User Guide.

Fields related to the Receivable process include:

Option/Control

Description

Receivable Due Date Lag

Used to set the Due Date if not entered.  Set to the specified number of days past the receivable date / statement date for invoice / statement customers respectively.

 

Fields related to Cash Receipt processing include:

Option/Control

Description

Priority 1-5 Posting Type

Specifies the sequence in which payments should be applied using Auto Apply.

Automatic Net Credit Balance

Indicates whether the system should automatically net an unreserved credit balance from overpayment against outstanding receivables or referral to collection within the same customer account.

Use Deposit Reconciliation

Indicates whether the deposit reconciliation process is in use for your implementation of Advantage Financial.

Print Deposit Ticket

Indicates whether your entity uses the print deposit process to deposit money into the bank.  If checked, accepted cash receipts will not be recorded as deposited until the deposit ticket is printed.  If not checked, an accepted cash receipt will be available for deposit directly after being processed.

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.

Collection Cycle Code

Sets the default value of the system-wide collection cycle.

Unreserved Credit Balance Event Type

The event type assigned to an overpayment accounting line when Auto Apply is in use and the Reserve Cr Balance option is unchecked.   

Reserved Credit Balance Event Type

The event type assigned to an overpayment accounting line when Auto Apply is in use and the Reserve Cr Balance option is checked.

 

Fields related to Payment Plans include:

Option/Control

Description

Payment Plan Agreement Notification

Indicates if a Payment Plan Agreement Notification will be sent to customers.

Payment Plan Completion Notification

Indicates whether Payment Plan Completion Notification should be sent to customers.

Payment Plan Reminder Notification

Indicates whether Payment Plan Reminder Notifications will be sent to customers.

Payment Plan Cancellation Notification

Indicates whether Payment Plan Cancellation Notifications will be sent to customers.

Automatic NSF Check Cancellation

Indicates whether Payment Plans will be canceled when NSF checks are received.

Automatic Cancellation After Number of Missed Payments

Indicates the number of times payments can be missed before the Payment Plan is automatically canceled.

Minimum Days Between Payment Plan Start Date & First Due Date

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

Payment Plan Print Date Lag

Indicates when Payment Plan Reminder Notifications should be sent to customers.

Final Payment Plan Lag

Specifies the number of days after the specified End Date (on the Payment Plan table) after which a payment plan record may be closed.

 

Fields related to the Collections process include:

Option/Control

Description

Past Due Days for Collection Referral

Indicates the number of days past the Receivable Due Date that automatically makes past due receivables eligible to be sent to a collection agency.

Collection Referral Load Status

Indicates the status with which selected records are loaded to the Pending Collection Agency Referral (COLLR) table.

Generate Collection Document in this Status

Indicates the status in which automatically generated Collection documents are created.  

Number of Days Past Due for Intercept

Receivables will only be selected by the offline intercept selection program if the number of days past receivable due dates equal to or greater than this value.

IRT table Load Status

The offline intercept selection program can load the receivables to the IRT table as Active or Inactive records.  If records are loaded to the table as Inactive, you need to ”approve” them by changing the status to Active.  Active receivable records on the IRT table will be automatically used by the Automated Disbursement program to intercept payments.

 

Fields related to the Write-off process include:

Option/Control

Description

Write-off Method

Indicates the event type to be used for Write-offs system-wide.  Valid options are Direct and Allowance.

Past Due Days for Write-off

Indicates the number of days past due a receivable record must be before it is automatically selected for write-off.

Pending Uncollectible Receivable Table Load Status

Indicates with which status the records selected for write-off will be loaded into the Pending Write Off (PUNR) table.

Generate Write-off Documents in this Status

Indicates the status in which Write-off documents are automatically created by the system.

Line Limit for Generated Write-offs

Indicates the maximum number of vendor/customer lines a Write-off (WO) document can have when generated automatically by the system.

 

Fields related to the Billing process include:

Option/Control

Description

Minimum Billing Amount

Indicates the minimum currency amount that a customer account must total to be selected for the automatic billing process. No statement will be printed if the outstanding amount is less than this amount and there is no new activity in the billing period (must be both).

Minimum Negative Billing Amount

The negative minimum 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 effect the printing of Invoices.

Default is $0.00.  You cannot enter a positive amount.  

 

 Fields related to applying and defining finance charges include:

Option/Control

Description

Minimum Past Due Amount for Finance Charge

Indicates the minimum amount a past-due amount must be before applying finance charges.

Finance Charge Fee 1-5

Five separate fields that allow you to choose up to five finance charge codes from the Finance Charge Setup (FNCHG) table.

 

Fields related to the generation of customer refunds include:

Option/Control

Description

Automatic Refund to Customer of Credit Balance

Specifies whether the system should automatically generate a payment for a customer’s credit balance.

Number of Days for a Credit Balance

Specifies the number of days for a credit balance to stay in a customer’s account before a payment for a refund is automatically generated.

Automatically Process Customer Refund Documents

Indicates whether the system should automatically process an error-free payment request document generated by the system’s customer refund process for refunding a customer’s credit balance

 

Fields related to the handling of Non-Sufficient Funds include:

Option/Control

Description

NSF Check Charge Amount

Amount charged to a customer for a check returned for non-sufficient funds (NSF).