Setting Up Accounts Receivable Values

Purpose: The Accounts Receivable section of the System Control table defines parameters that control:

• Column headings for Accounts Receivable screens and reports

• Aging categories

• Invoice processing

• Statement processing

For more information: For instructions and screen samples on how to create, change, delete, and copy a system control value, see System Control Table Components.

Section note: This section requires you to enter the column headings that appear on A/R screens and reports, the number of days duration for each A/R aging bucket, and whether the credit check process evaluates an aging category. Although you are not required to complete values for all six aging categories, you must complete the values for each aging category you use, and for each corresponding value.

For example, if you complete A/R Aging 1 Column Heading (A93) through A/R Aging 4 Column Heading (A96), you must complete A/R Aging 1 Days (A99) through A/R Aging 4 Days (B03), and A/R Aging 1 Credit Check (B06) through A/R Aging 4 Credit Check (B09).

Quick Reference of Accounts Receivable System Control Values

This table describes briefly each system control value for the Accounts Receivable application area and lists the control value, a short definition, other control values to which you should refer in this section, if necessary, and a column where you can indicate the value that you assigned for your company.

If you are working with multiple companies, make a copy of this table for each company on your system.

Company: ______________________________

System Control Value

Description

Your Value

A/R Aging 1 Column Heading (A93)

Defines the column heading for the first aging bucket.

Code:

A/R Aging 2 Column Heading (A94)

Defines the column heading for the second aging bucket.

Code:

A/R Aging 3 Column Heading (A95)

Defines the column heading for the third aging bucket.

Code:

A/R Aging 4 Column Heading (A96)

Defines the column heading for the fourth aging bucket.

Code:

A/R Aging 5 Column Heading (A97)

Defines the column heading for the fifth aging bucket.

Code:

A/R Aging 6 Column Heading (A98)

Defines the column heading for the sixth aging bucket.

Code:

A/R Aging 1 Days (A99)

Defines the number of days duration of the first aging bucket.

Number:

A/R Aging 2 Days (B01)

Defines the number of days duration of the second aging bucket.

Number:

A/R Aging 3 Days (B02)

Defines the number of days duration of the third aging bucket.

Number:

A/R Aging 4 Days (B03)

Defines the number of days duration of the fourth aging bucket.

Number:

A/R Aging 5 Days (B04)

Defines the number of days duration of the fifth aging bucket.

Number:

A/R Aging 6 Days (B05)

Defines the number of days duration of the sixth aging bucket.

Number:

A/R Aging 1 Credit Check (B06)

Defines if the credit check process evaluates the first aging bucket.

Selected/Unselected:

A/R Aging 2 Credit Check (B07)

Defines if the credit check process evaluates the second aging bucket.

Selected/Unselected:

A/R Aging 3 Credit Check (B08)

Defines if the credit check process evaluates the third aging bucket.

Selected/Unselected:

A/R Aging 4 Credit Check (B09)

Defines if the credit check process evaluates the fourth aging bucket.

Selected/Unselected:

A/R Aging 5 Credit Check (B10)

Defines if the credit check process evaluates the fifth aging bucket.

Selected/Unselected:

A/R Aging 6 Credit Check (B11)

Defines if the credit check process evaluates the sixth aging bucket.

Selected/Unselected:

Accounting Values (B71, B72, B73)

Defines the accounting year for last year.

Number:

Accounting Values (B71, B72, B73)

Defines the accounting year for the present year.

Number:

Accounting Values (B71, B72, B73):

Invoice Print Program (B83)

Defines the program that prints A/R invoices.

Code:

Statement Print Program (B85)

Defines the name of the program that prints A/R statements.

Code:

Invoice Age to Start Generating A/R Statement (B86)

Defines the number of days from the invoice date or due date that an A/R statement is generated.

Number:

Invoice Age to Stop Generating A/R Statement (B87)

Defines the number of days from the invoice date or due date that statements are no longer generated.

Number:

Statement Interval (B88)

Defines the number of days from a statement's date before the next statement is generated.

Number:

Default Debit Open Item Type (B91)

Defines the open item type that defaults when creating a debit invoice.

Code:

Age by Date Type (C02)

Defines whether you age open items by due date or invoice date.

Code:

Open Item Purge Days (C10)

Defines the number of days after the open item is closed that it is purged from the system.

Number:

Default Credit Open Item Type (C12)

Defines the open item type that defaults when creating a credit invoice.

Code:

Default Deferred Liability Open Item Type (C13)

Defines the open item type that defaults when creating a deferred liability invoice.

Code:

Deferred Liability Cash Post Method (C48)

Defines whether the system posts cash directly to Cash Receipts or on a per-order basis.

Code:

Default Cash Customer (C49)

Defines the Bill To Customer number to which all cash receipts post if you are posting directly to Cash Receipts.

Number:

Default Deferred Liability General Ledger Account # (C63)

Defines the default General Ledger Account Number for posting deferred liability

Number:

Include All Payment Types on Printed Invoice (D28)

Defines whether to print invoices for all forms of payment or just for orders paid on-account (Accounts Receivable)

Selected/Unselected:

Default Credit Limit for A/R Customers (D82)

Defines the credit limit to assign to new bill-to customers you create through Order Entry, Order Maintenance or Work with Bill-to Customers.

Value:

Default A/R Payment Terms (D83)

Defines the terms code to assign to new bill-to customers you create through Order Entry, Order Maintenance or Work with Bill-to Customers

Code:

Net A/R Credits in Each Age ’Bucket’ When Aging A/R Items (E14)

Defines whether to "age" A/R credits by including them in the appropriate age bucket based on creation date.

Selected/Unselected:

Process A/R Credits Immediately (E80)

Defines whether accounts receivable refunds are processing automatically by the system.

Selected/Unselected:

Allow A/R Credits as Payments (E81)

Defines whether you can allocate A/R credits as payment against new orders.

Selected/Unselected:

Default Check Credit Open Item Type (E82)

Defines the open item type for the system to use when flagging a credit open item to produce a refund check.

Code:

Default Credit Card Credit Open Item Type (E83)

Defines the open item type for the system to use when flagging a credit open item to produce a credit card credit.

Code:

Display A/R Balance in OEOM (H98)

Defines whether to display the customer’s total A/R balance, less any unavailable credit open items, in order entry.

Selected/Unselected:

Retain A/R Batch Errors After Processing (I33)

Specifies whether to retain A/R batch payment records that are in error after processing, or to delete them automatically.

Selected/Unselected:

Display Additional Fields in A/R Batch Processing (I42)

Specifies whether to display the Sold to # and Pick ctr # when working with A/R batch payment.

Selected/Unselected:

Allow Underpayment in A/R Batch Processing (I44)

Specifies whether to apply A/R batch payments that are less than the invoice amount.

Selected/Unselected:

Process A/R Batch Automatically after Creation through IJCT (I95)

Specifies whether to automatically process A/R batches received through the ARBATCH_IN job upon, or retain them for review.

Selected/Unselected:

IN03_06 Serenade 5.0 March 2015