Accounts Receivable Control Maintenance

If you edit this topic, review Accounts Receivable Control Maintenance Database Information.

Menu Path: Accounts Receivable Images\bluerarw.gif Module Setup Images\bluerarw.gif Accounts Receivable Control Maintenance

Purpose

Set up and maintain Accounts Receivable module options and controls.

Overview

Use Accounts Receivable Control Maintenance to select default settings for Accounts Receivable module options.

Edit the defaults as necessary for your company. After making changes, be sure to click the OK button in the ribbon, otherwise your changes will not be saved.

For database information for this window, see Accounts Receivable Control Maintenance Database Information.

Setting Up Default Accounts Receivable Settings

To set up default settings for the Accounts Receivable module:

  1. Click the Update button in the ribbon.

  2. Select default settings.

  3. Click the OK button in the ribbon. The module settings are updated.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Accounts Receivable Control Maintenance window.

Update

Click this button to update accounts receivable options.

OK

Click this button to accept changes to the accounts receivable options. This button is only available after you click the Update button in the ribbon.

Cancel

Click this button to cancel changes to the accounts receivable options. This button is only available after you click the Update button in the ribbon.

Main Tab Fields

Field

Field Name

Current Period

Enter the current period, or click the Lookup button to select the period. You can also change the default period in Accounts Receivable Period Update.

Current Year

Enter the current year. You can also change the default year in Accounts Receivable Year Update.

Invoice Sanity Amount

Enter the maximum invoice amount allowed. Entering this amount helps prevent typographical errors in Invoice Entry.

Example If the invoice sanity amount is set to 100,000 and the user enters an amount greater than 100,000, a message alerts the user. This will help eliminate some of the errors that occur during heads down entry.

Allow Batch Discrepancies

Select one of the following options for controlling batch discrepancies:

  • Yes - Allow a general ledger posting to occur even if a batch count and/or batch total is different than the actual count and/or actual total.

  • No - Does not allow a general ledger posting to occur if the batch count or batch total is different than the actual count or actual total.

  • Warn - Warn the user before general ledger posting that the batch count and/or batch total is different than the actual count and/or actual total.

Check Sanity Amount

Enter the maximum amount of a payment. Entering this amount helps prevent typographical errors in Deposit Entry.

Example If the check sanity amount is set to 100,000 and the user enters a payment amount greater than 100,000 during Deposit Entry processing, a message alerts the user. This will help eliminate some of the errors that occur during heads down entry.

Posting Period/Date Control

Select one of the following options for controlling posting periods and dates:

  • Yes - When invoices are created from the Customer Service module in Invoice Create and Print, the invoice date must be within the selected posting period. When deposits are entered for customers or as miscellaneous receipts the payment date must be within the selected posting period.

  • No - Invoice dates or payment dates do not need to be within the selected posting period.

  • Warn - Warn the user before general ledger posting that the invoice date or payment date is not within the selected posting period.

AR Prepayment Account

Enter a general ledger account to use when creating open accounts receivable prepayment transactions, or click the Lookup button to select an account. For information on processing accounts receivable prepayments, see Accounts Receivable Prepayment Process Flow.

Automatically reverse unrealized forex entries

Select this check box to automatically create reversing entries for unrealized foreign exchange gain and loss journal entries. If you select this check box, you must enter an account in the AP Unrealized Forex Income Statement Account field.

AR Unrealized Forex Balance Sheet Account

For each company code, enter an account (in the grid) to use when creating accounts receivable unrealized foreign exchange gain and loss transactions for the balance sheet.

AR Unrealized Forex Income Statement Account

For each company code, enter an account (in the grid) to use when creating accounts receivable unrealized foreign exchange gain and loss transactions for the income statement.

Past Due Aging Bucket #

These fields display the sequential numbers of the past due buckets.

Example if the first past due bucket is 1-15 days past due, then this is bucket 1, the next bucket is bucket 2, etc.

Past Due Days

Enter the number of days to include in each past due bucket. These past due buckets are used in Accounts Receivable Aged Trial Balance, Chargeback Management Aging Analysis, and Collection Management Aging Analysis.

Example if the first past due bucket is 1-15 days past due, enter 15 in the first field. If the second past due bucket is 31-40 days, enter 10 in the second field.

This defaults to 30 for each field.

Bucket Range Start

These fields display the first day for each past due aging bucket. The days depend on the number of days for each bucket entered in the Past Due Days fields.

Bucket Range End

These fields display the last day for each past due aging bucket. The days depend on the number of days for each bucket entered in the Past Due Days fields.

Past Due Aging Labels

Enter a label associated with each past due bucket. These labels default to 1-30, 31-60, 61-90, 91-120, 121-150, and 150+, but can be manually overridden.

Option Tab Fields

Field

Field Name

Default Future Bucket Days

Enter the number of days to determine what invoices are displayed in the future bucket for aging purposes in Customer Aging and Credit Inquiry and Accounts Receivable Aged Trial Balance. For more information, see Future Bucket Days.

Default Prior Months 1

Enter the number of prior months for the first column of customer statistics (net invoices, write-off’s, cash discounts, etc.) in Customer Aging and Credit Inquiry.

Default Prior Months 2

Enter the number of prior months for the second column of customer statistics (net invoices, write-off’s, cash discounts, etc.) in Customer Aging and Credit Inquiry.

Auto Customer Assignment

Select this check box if you want the system to assign the next sequential number automatically for each new customer created. If you select this check box and do not select the Cust Assignment by Location check box, enter the next sequential number in the Next Customer Code field.

Cust Assignment by Location

Select this check box if you want the system to assign the next sequential number automatically for each new customer created, prefixed by the sales location prefix. If you select this check box, enter the next sequential number in the Next Customer Code field in Location Maintenance for each sales location. This check box is only enabled if you select the Auto Customer Assignment check box.

Increment by

Enter the increment for automatically generated customer codes. This field is only enabled if you select the Auto Customer Assignment check box.

Example If 100000 is entered in the Next Customer Code field and 10 is entered in the Increment by field, the next customer codes will be 100010, 100020, etc.

Next Customer Code

Enter the next customer code for automatically generated customer codes. This field is only enabled if you select the Auto Customer Assignment check box and clear the Cust Assignment by Location check box.

Note Use a number with at least six digits (to allow new customers to be added without worrying about a customer code conflict).

Allow Override of Customer Code

Select this check box if you want the Auto-increment check box to display below the Customer Name field in Customer Maintenance so users can select to allow the system to automatically assign the next sequential customer code, or can select to manually enter the customer code. This check box is only enabled if you select the Auto Customer Assignment check box.

Commission Rate Withheld (based on Aging Days)

Enter the commission rate reduction based on unpaid past due invoices for Commission Inquiry.

Use Customer Location for

Select one of the following options for defaulting the customer's sales and/or shipping location to the sales and/or shipping location in Order Entry or Order Edit:

  • Sales - Default the order’s sales location prefix from the default sales location prefix for the customer ship-to address. If it is blank, default the sales location prefix from the customer's default sales location prefix. If no default sales location prefix is entered for the customer ship-to address or the customer, default the sales location prefix from the default sales location prefix entered for the user in User Extended Options.

  • Shipping - Default the order’s shipping location prefix from the default shipping location prefix for the customer ship-to address. If it is blank, default the shipping location prefix from the customer's default shipping location prefix. If no default shipping location prefix is entered for the customer ship-to address or the customer, default the shipping location prefix from the default shipping location prefix entered for the user in User Extended Options.

  • Both - Default the order’s shipping and sales location prefixes from the default shipping and sales location prefixes for the customer ship-to address. If either location prefix is blank, default the location prefix from the appropriate default location prefix for the customer. If no default shipping and/or sales location prefix is entered for the customer ship-to address or the customer, default the location prefix from the appropriate default location prefix entered for the user in User Extended Options.

  • Neither - Ignore the default shipping and sales location prefixes for the customer ship-to address and the customer. Default both location prefixes from the user default sales and shipping location prefixes set up in User Extended Options.

Use Payment Algorithms

Select this check box to allow the use of payment algorithms in Deposit Entry. Select the list of eligible algorithms from the Available Algorithms grid.

Available Algorithms

This grid displays payment algorithms that can be used. To select an algorithm for use, double-click it, or select it, and then click the right arrow button. For more information, see Payment Algorithms FAQ. This grid is only enabled if you select the Use Payment Algorithms check box.

Click this button to add the selected payment algorithm in the Available Algorithms grid to the Eligible Algorithms grid. This button is only enabled if you select the Use Payment Algorithms check box.

Click this button to remove the selected payment algorithm in the Eligible Algorithms grid. This button is only enabled if you select the Use Payment Algorithms check box.

Eligible Algorithms

The grid displays payment algorithms authorized for use. To remove an algorithm, double-click it, or select it, and then click the left arrow button. This grid is only enabled if you select the Use Payment Algorithms check box.

Fintech Division ID

Enter the Fintech division ID if your company exports sales and tax information to Fintech for third-party accounts receivable payment collection. This division ID is used as the default for the Fintech Division ID field in Fintech Invoice Extract.