ACCT CR (Cash Receipts) Control Maintenance Records

The following control maintenance records belong to the CR (Cash Receipts) area within the ACCT (Accounting) category.

Activate Additional Lockbox Report Data

Set to Yes if you want to run the automatic reports from running after cash posting. ClosedMore:

New in Release 8.7.9

In conjunction with the Cash Receipt Application History control maintenance record, the system activates data gathering for the following reports:

Allow Zero & Negative $ Orders To Process When Job Limit Exceeded

New in Release 8.7.8

Allows orders with a negative or zero balance to process even if the job limit for the customer has been exceeded.

Anticipation Credit Percentage

Enter a percentage, in decimal format, to apply to each invoice when issuing an anticipation credit at the time of cash receipts. ClosedMore:

Options

Enter a percentage in decimal format.

Outcome of setting this control record

The system applies the percentage you enter to each invoice when issuing an anticipation credit at the time of cash receipts. The system issues anticipation credits to customers who pay before the discount and/or final due date of the invoice.

Default Value(s)

0.00%

Dependencies

The system uses this percentage only if the Create Anticipation Credit Invoice From C/Rcontrol maintenance record is set to Yes.

In addition, set the following control maintenance records:

Action if set to Null

Same as if set to zero percent.

Additional Information

When the system calculates anticipation credit, the credit can be applied against the customer's open accounts receivable balance to reduce their debt overall. For more information about anticipation credits, see Anticipation Credit Basics.

Auto C/R Default Customer If Not Found

Use this record if your company has customers who send payments to a lock box at a bank. The bank then uploads the payments into Cash Receipts. Enter the default customer to which the system should post a cash receipts payment if the system does not recognize a customer during the upload.

Auto Cash Receipts Multi Lockbox

If you use EDI 823 lockbox transactions to collect cash receipts from customers for your business, use this record to streamline the process when collecting multiple batches of cash receipts each day. ClosedMore:

Settings

Options include:

  • Lockbox ID - List the 823 Lockbox ID for each bank from which you receive receipts.

  • Cash G/L Account - Enter the corresponding cash G/L account for each bank from which you receive receipts.

  • Batch ID - Assign a Batch ID Prefix to differentiate between batches during the day’s collections.

  • Customer If Not Found - Set a default customer if not found at the bank level for EDI 823 lockbox transactions.  If there is not a customer set up at the bank level, then the global default customer not found will be used. This option new in Release 8.7.9.

Outcome of setting this control record

Use this control record to help identify the batches of cash receipts for easier reconciliation against the lock box file you receive from your bank.

Default Value(s)

Blank

Example(s)

For example, the system uploads cash receipts twice during the day from three banks: Wells Fargo, Chase, and 1st Bank. The system calls them A1, A2, and A3 on the first batch. When the second batch load runs, the system uses the same identifiers. Your system now has two A1s, A2s, and A3s. If you assign the banks prefixes, then you can better reconcile your cash receipts. You assign Wells Fargo a WFB prefix. So you know that both the WFB-A1 and WFB-A3 are from Wells Fargo Bank.

Action if set to Null

Batch IDs are auto-assigned.

Additional Information

None

Cash Receipt Application History

Turns tracking for cash receipts as a running log of changes to the cash receipt after the cash receipt has been created. ClosedMore:

New in Release 8.7.8.

Options

  • Yes - Turn on tracking for cash receipt history.

  • No - Keep standard tracking tools in place.

Outcome of setting this control record

The system tracks the following attributes in the A/R File:

Attribute

# / Name

Description

45 / HAPP_ID

The order ID related to the cash receipt.

46 / HAPP_DATE

The post date on which the cash receipt change was made.

47 / HAPP_TIME

The time of day at which the change to the cash receipt was made.

48 / HAPP_BRGL

The G/L branch for which the cash receipt was created.

49 / HAPP_GLAMT

The G/L amount for which the cash receipt change was made.

50 / HAPP_GLID

The G/L account ID connected to the cash receipt.

51 / HAPP.USER

The User ID for the user who made the change to the cash receipt.

Default Value(s)

No.

Dependencies

None.

Action if set to Null

None.

Additional Information

You can use Report Writer to create a custom report with these attributes.

 

C/R Anticipation Credit Invoice Product

Enter the miscellaneous charge product to use when the system creates an anticipation credit. ClosedMore:

Options

Select the miscellaneous charge product you have defined in Product Maintenance for anticipation credits.

Outcome of setting this control record

The system uses the product you select here when it creates an invoice for an anticipation credit. The system issues anticipation credits to customers who pay before the discount and/or final due date of the invoice.

Default Value(s)

None

Dependencies

Set this control maintenance record if you set the Create Anticipation Credit Invoice From C/Rcontrol record to Yes for any of your branches.

In addition, set the following control maintenance records:

Action if set to Null

The system is unable to create the invoice for the anticipation credit.

Additional Information

When the system calculates anticipation credit, the credit can be applied against the customer's open accounts receivable balance to reduce their debt overall. For more information about anticipation credits, see Anticipation Credit Basics.

Create Anticipation Credit Invoice From C/R

For each customer home branch, indicate whether the system prompts the user to do an anticipation credit check from Cash Receipts when the user enters a customer payment before the due date. ClosedMore:

Options

  • Yes - The system prompts the user.

  • No - The system does not prompt the user.

Outcome of setting this control record

Adds a prompt for anticipation credit checks in Cash Receipts.

Default Value(s)

No

Dependencies

To use anticipation credits, also set the following control maintenance records:

 

Action if set to Null

Same as if set to No.

Additional Information

You can override the setting in this record for a customer by entering Yes or No in the Anticipation Credit Invoice field on the Additional Credit Information window in Customer Maintenance. To access this field, select Pricing > Credit Controls in Customer Maintenance and select the Additional tab.

Note: The system determines the customer's home branch by first looking at the Accessible Branches window for the customer in Customer Maintenance. If a home branch is not specified there, the system looks at the branch entered on the cash receipt.

For more information about anticipation credits, see Anticipation Credit Basics.

Do Not Apply Discounts To Cash Receipts

Indicate whether to disable the automatic application of discounts in Cash Receipts. ClosedMore:

Options

  • Yes - The No Discount option in the Cash Receipts window is enabled.

  • No - The No Discount option in the Cash Receipts window is not enabled.

Outcome of setting this control record

If set to Yes, the system does not automatically apply any available discount for a customer upon entry of a cash receipt for that customer. The discount displays with a question mark.

If set to No, the system applies any available discount for a customer upon entry of a cash receipt for that customer.

Default Value(s)

No

Action if set to Null

Same as if set to No.

Additional Information

You can override the default setting in Cash Receipts.

Use Terms Grace Period In Cash Receipts

Indicate whether the Cash Receipts program uses the terms code grace period for late payments to still receive a discount. ClosedMore:

Options

  • Yes - The Cash Receipts program respects the cash discount grace period assigned to a terms code in Terms Maintenance for payments received after the discount date.

  • No - A grace period for payments received after the discount date to still receive a discount is not in effect, even if a grace period is assigned to a terms code.                   

Outcome of setting this control record

If set to Yes, discounts are available in cash receipts for the number of grace days indicated for the terms code past the discount date.

Default Value(s)

No

Examples

For example, if set to Yes, a discount available through the 10th of the month with a grace period of five days displays on the window until the 15th.

Action if set to Null

Same as if set to No.

Additional Information

For more information about defining terms codes, see Creating and Editing Terms Codes.