Creating receivables companies

The company must already exist in Global Ledger.

Customer Group

Select a customer group. A customer group can be associated with multiple companies to enable intercompany cash application and reporting.

Multiple Currency Processing

Select this check box if multiple currency transactions are used by the company.

Currency Rate Override

Select whether currency exchange rates can be overridden when non-base currency transactions are created.

Default Aging Method

Select an aging method for the company. If this field is blank, then the aging method for the customer group is used.

Age Credits

Select a credit memo aging method for the company. If this field is blank, then the age credits option for the customer group is used.

Age Payments

Select a payment aging method for the company. If this field is blank, then the age payments option for the customer group is used.

Age Disputes

Select whether disputes are aged using the Default Aging Method. If this field is blank, then the age disputes option for the customer group is used.

Aging Periods

Specify the aging periods that are used when aging across companies. Specify the periods in consecutive and ascending order. If these fields are blank, then 30, 60, 90, and 120 are used.

If the Additional Aging Periods check box is selected, then three additional aging periods are available.

Current Days

Specify the number of days that separate the current and future aging periods. Current and future aging periods contain transactions that are not past due for due date aging or past transaction date for transaction date aging.

Additional Aging Periods

Select this check box to show three additional Aging Periods fields and one additional Future Days field.

Future Days

If the Additional Aging Periods check box is selected, then specify the number of future days. A secondary Future Aging field is available.

Transaction Sequence

Select the transaction sequence that is used on aging reports. If this field is blank, then the transaction sequence on the customer group is used.

Display Date

Select the date to use to specify the open obligation data that is displayed on aging reports. This option is used for obligations and is not related to the aging method. If this field is blank, then the display date option for the customer group is used.

The IDM template is used to generate notices, for example, basic dunning letters, advanced dunning letters, receivable statements, and payment request notices.

If this check box is cleared, then the documents are created using a built-in report.

To view sample IDM templates, fact sheets, and XML files, see Setting up Receivables IDM templates.

Type

Select whether the address is a post office box, a street address, a military address, or an unidentified type.

Automatic Batch Numbering

Select this check box if automatic batch numbering is used for payment batch entry.

Last Batch

If Automatic Batch Numbering is selected, then specify the last payment batch number assigned. When a new payment batch is added, the batch number is incremented by one. If this field is blank, then the batch number begins with one.

Balance Batch Control Totals

Select this check box if the transaction batch total must equal the control total before a transaction batch can be released.

Operator ID Required

Select this check box if an operator code is required during payment batch entry.

Edit Remittance

Select this check box if remittance records are edited against open transactions.

Allow Remittance Changes

Select this check box if payment remittance data can be changed after a payment is released.

Allow Zero Payments

Select this check box if a zero amount payment is allowed. Zero amount payments can be applied to invoices, debit memos, and credit memos that net to a zero amount.

Edit Deposit Date

Select this check box if the deposit date is edited against the date range that is specified in Global Ledger. Use System Control to establish the date range.

Allow Unreleased Payment Applications

Select this check box to allow unreleased payments to create cash applications.

Allow Prepayment Tax

Select this check box to enable prepayments for tax accrual processing with cash application offset.

Prepayment Tax Code

Enter a prepayment tax code if the Allow Prepayment Tax check box is marked. This is the default tax code used for taxable prepayment processing.

Prepayment Tax Control GL Account

Enter a prepayment tax control Global Ledger account if the Allow Prepayment Tax check box is marked. This will be the default Global Ledger account used for taxable prepayment processing.

Automatic Batch Numbering

Select this check box to use automatic batch numbering for manual invoice entry.

Last Batch

If Automatic Batch Numbering is selected, then specify the last assigned invoice batch number. When a new invoice batch is added, the batch number is incremented by 1. If this field is blank, then the batch number begins with 1.

Balance Batch Control Totals

Select this check box if the transaction batch total must equal the control total before a transaction batch can be released.

Operator ID Required

Select this check box if an operator code is required during memo entry or invoice entry.

Currency Override

Select this check box if the code for customer currency can be overridden when a transaction is created.

Create Historical Distributions For Interface

Select this check box if historical AR code-based distribution records are created by interface transactions. Consider selecting this check box if you do not import invoice distributions to post to the Global Ledger. These distribution records are primarily used for the self-balancing report.

Create Summarized Historical Distributions For Interface

If Create Historical Distributions For Interface is selected, then select this check box to create distribution records in summary format. If this field is cleared, then distribution records are created in detail.

Automatic Manual Invoice Numbering

Select this check box to automatically number manually created invoices in ascending order.

Invoice Entry Template

Specify the print template type if you manually create invoices for printing.

Manual Invoice Prefix

Specify a Manual Invoice Prefix if the Automatic Manual Invoice Numbering check box is marked. This prefix forms the first part of the invoice number.

Last Manual Invoice Number

Change the Last Manual Invoice Number if the Automatic Manual Invoice Numbering check box is marked. This is the starting numeric value part of the invoice number following the Manual Invoice Prefix.

Manual Memo Prefix

Specify a Manual Memo Prefix if the Automatic Manual Invoice Numbering check box is marked. This prefix forms the first part of the memo number.

Last Manual Memo Number

Change the Last Manual Memo Number if the Automatic Manual Invoice Numbering check box is marked. This is the staring numeric value part of the memo number following the Manual Memo Prefix.

Front End Split AR Distributions

If the related Finance Enterprise Group has Front End Splits turned on, then this field is to check. If a distribution contains a project that is enabled for front end split and does not contain funding source, the distribution line is split according to the setup in Project Ledger. See the information in Project Ledger User Guide. Front end splits logic pertains to distribution creation for unreleased invoices, debit memos, and non-AR cash transactions.

Customer Delete Months

Specify the number of months that must elapse after the last customer activity date before a customer is automatically deleted when Customer Purge is run.

Verify Post Date

Select this check box if the general ledger dates that are assigned to transactions are validated against the date range in Global Ledger.

Hold Code

Specify a hold code for the company that is used in Analyst Review Detail. Order processing systems can use this hold code to decide whether to process orders for a particular customer.

Risk Code

Specify the default value for the risk code for customers of this company. This field is user-defined and can be used for customer reporting.

Due Date Change Allowed

Select this check box if the due date in the receivable invoice details can be changed.

History Update Periods

Specify the number of period closings until the status of a fully applied payment or transaction is updated to historical.

This field is used in the Transaction Status Update. For example, if a history period is 1, a payment or transaction in a fully applied status for one period close is moved to a closed status. Similarly, a payment or transaction with a closed status for one period close is moved to a historical status when the transaction status update is run.

Currency Display

Select whether transaction amounts are displayed in the base currency or in the transaction currency for select reports.

Summarize Transaction Lines

Select this check box if invoice transaction lines are summarized. If this check box is cleared, then invoice translation lines are displayed in detail.

Allow Entry Of Rebates From Contracts

Select this check box to specify contract rebate information for non-AR payments.

National Account Trans Option

Select whether national account transaction records can be created and deleted on the National Account page or with the National Account Trans Update mass update program.

If your company has national accounts with several open relationship transactions, we recommend that you select Transactions Updated With Mass Update Logic.

Periods Per Year

Select whether the periods per year are Twelve or Thirteen when customer transactions are stored and reported by period.

Period Offset

If Periods Per Year is Twelve, then you can specify a period offset value. The offset value is a signed or unsigned number. It is added to or subtracted from a transaction date to determine a period number in transactional reporting.

Credit Chargeback Prefix

Specify a prefix to use when creating a chargeback includes reversing applications records.

Locale

This is an optional language code field. Specify the company value to show the default locale parameter value on these report parameter screens:

• AR Statement Print
• Finance Charge Late Payment
• Chargeback Creation

Deposit Payment Code

Select the default value to use for deposits to Cash.

RTM Payment Code

Select the value to use for Return To Maker (RTM) payments to Cash.

Adjustment Payment Code

Select the value to use for adjustments to Cash.

RTM and Chargeback Batch

Specify the last batch number. If this field is blank, then the batch number begins with 1.

RTM

Specify the last Return To Maker (RTM) batch number. If this field is blank, then the batch number begins with 1.

Chargeback

Specify the last batch number for chargebacks. If this field is blank, then the batch number begins with 1.

Obligation Group

Specify the last reassignment number of the last reassigned open obligation. If this field is blank, then the transaction number begins with 1.

Credit Chargeback

Specify the last number for credit chargebacks. If this field is blank, then the credit chargeback number begins with 1.

Last Dunning Cycle ID

This field value is incremented by 1 when the Dunning Letter Selection is run.

Last Credit EFT Balancing Debit Memo Number

Specify the credit debit number for the last fund transfer that was used for cash application when credit balance is processed.

Use E Way Bill Number

Select this check box to use the electronic way bill number on receivables invoices and billing invoices.

Parallel Reference Format

Specify the format for alternate invoice identification.

Check Digit Type

Select this check box to enable the check digit format for parallel reference.

Assign Voucher Reference

Select this check box to use the voucher reference numbering. When this check box is selected, more fields are available to define alternative invoice identification.

Voucher Reference Reporting Basis

Select the reporting basis that is identified for statutory reporting.

Voucher Reference Format

Specify the variable or variables to use as the voucher reference format.

Foreign Trade And Payment Report

Select this check box to process and create foreign trade and payment records. When this check box is selected, another field is available to specify a threshold dollar amount for transaction reporting.

Report Threshold Amount

Specify the threshold amount for the foreign trade and payment report.

Claims And Liabilities Report

Select this check box to include a claims and liabilities report. This report contains the sum of all open payables and receivables invoices for the selected company.

When this check box is selected, two more fields are available.

Report Threshold Amount

Specify the threshold amount for the claims and liabilities report.

Output XML

Select No XML. For German companies, select Germany.

Locale

Specify the default language locale for statement, finance charge, and chargeback print processing.

Application Review Required

Select this check box if the applications audit program is required before applications are processed by the application close program.

Past Due Discount Display

Select this check box to show discount amounts that are past due during cash application.

Discount Grace Days

Specify the number of grace days that are added to the discount date so that automatic discounts are applied during cash application.

Over Application of Payment

Select this check box if you can over-apply a short payment to pay off an invoice and create a chargeback for the unpaid portion of the invoice.

Automatic Credit Apply

Select this check box if the automatic credit application occurs when an invoice or debit memo is cross-referenced to a credit memo.

Third Party Payer

Select this check box if third party payments are allowed. Third party payments are applied to open items regardless of customer relationship.

Application Post Date

Select whether the system date or the post date on the payment or credit memo is used as the general ledger date on application records.

Open Balance Include Drafts

Select this check box if bill of exchange item balances are included. If this check box is cleared, then bill of exchange items balances are excluded.

Interface to Payables

Select this check box to enable the interface between Receivables and Payables.

Default Vendor Class

If the Interface to Payables field is selected, then select a code that represents the subset of vendors. This field is valid if a vendor relationship is created for a customer.

Detail Payables Interface

If this check box is selected, then a payables open transaction is created with each opened receivables transaction. If this check box is cleared, then one open payables transaction is created.

Prorate Gain Loss Amount To Distributions

Select this check box to prorate the gain loss amount to the original distributions of a transaction.

Tax Recovery on Discount

Select this check box if a prorated amount of tax is recognized from cash application discounts on transactions that have tax-based distribution records.

Apply Cash Across Receivable Companies

Select this check box if transactions for all companies for the selected customer are available for online and automatic cash application.

Allow Zero Payment Adjustments

Select this check box if zero payment adjustments can be applied to an identical amount of debit and credit transactions.

Prevent Write Off Before Transaction GL Date

Select this check box if the write-off GL Date can only be greater than or equal to the invoice/payment GL Date.

Allow Historical Application Reversal

Select this check box to enable cash applications to be reversed where a payment or an invoice for the application is historical.

Specify Distribution Mix

Specify Distribution Mix allows a user-specified set of distributions to replace the standard Fund Accounting proration logic during cash application.

Mark As Paid Receivable Reason

Specify a Mark As Paid reason code. This enables an invoice to be cleared without having to complete a cash application process.

Mark As Paid Offset Account

Specify the Mark As Paid offset account to be associated with the Mark As Paid Receivable Reason code.

Over Apply Invoice

Mark this check box to allow the over application of an invoice with a negative adjustment amount to clear the invoice and create a credit memo for the adjustment amount.

Reason Code

Specify the receivable reason code used for the Over Apply Invoice process.

Reason Code Description

Specify the receivable reason code description used for the Over Apply Invoice process.

Credit Memo Prefix

Specify the credit memo prefix for the generated credit memo number used for the Over Apply Invoice process.

Debit Memo Prefix

Specify the debit memo prefix for the generated credit memo number used for the Over Apply Invoice process.

Variance

For a one-to-one match to occur, the difference between the payment amount and the invoice amount must be within the variance amount you specify here.

Reason Code

Specify the Receivable Reason code used for over or short adjustment processing.

Maximum Invoices

The rolling number of invoice amounts for combined comparison to payment amount. It cannot be greater than 5.

Combination

The maximum combination of invoices for combined comparison to payment amount. It must be less than or equal to the Maximum Invoices value.

Use Company Customer Receivable Global Ledger For Chargeback

Mark this check box to have chargebacks use the company customer receivable global ledger code.

Allow Manual Chargeback Invoice Numbering

Mark this check box to have chargebacks be manually numbered by the cash application operator rather than system-assigned.

When these fields are selected and the record is saved, a corresponding Receivable Global Ledger Code is created:

• Accounts Receivable Code
• Received Not Applied Code
  Note: A received-not-applied account is a contra-asset account that is updated when payments are applied.
• Finance Charge Code
• Prepayment Code
• Proforma Prepayment Code
• Proforma Tax Invoice Code
• Finance Charge Admin Fee Code

Detail Payments

Select whether the interface to global ledger contains detail or summary information.

Detail Finance Charges

Select whether the interface to global ledger contains detail or summary information.

Allow Detailed Invoice Accrual Distributions

Select this check box to enable posting open receivables by segment. This option can be enabled independently of the others in this section.

Note: 

• Fund accounting cannot be used.
• The user-specified GL account for receivable accrual distributions is used for the receivable invoices that originated from a project contract. It is also used when receivable invoices are manually entered.

.

Allow Detailed Cash Distributions

Select this check box to enable posting cash distributions by segment. This option can be enabled independently of the others in this section.

Note: 

• Fund Accounting cannot be used.
• One or more cash accounts can be specified on a receivables payment. These cash accounts are used to create the cash GL postings.

Verify in the Accrual Global Ledger Interface Options section, that Yes, Detail Accrual Interfacing is selected in the Detail Payments field.

Allow Detailed RNA Distributions and Match Finance Structure For Applications

This option can be enabled if both of the other options in this section are selected. Select this check box to create received not applied (RNA) distributions that inherit user-specified GL account segments from the cash distributions.

If this check box is selected, select one or more structures.

Finance Structure Segments For Application Matching

The selected segments are used to derive the RNA account from the cash account. For example, if the Project check box is selected, the GL account on the RNA code and the project on the cash account is included in the RNA distribution.

When this feature is enabled, accounts receivable payments can only be applied to invoices that have the same value for each of the selected segments. For example, if a project value for a receivable payment is 100, then the amount can only be applied to invoices that also have a project value of 100.

Charge Type

Select the type of finance charges.

Rate Code

Select the finance rate code that contains a monthly percentage rate to calculate finance charges.

Grace Days

Select the number of grace days to add to a transaction due date before finance charges are assessed.

Disputes Financed

Select this check box to access finance charges on invoice amounts that are disputed.

Print Notice

Select this check box to indicate whether to print finance charge documents.

Charge Customer Minimum

Select this check box if a minimum finance charge is assessed. If this field is selected, then a customer minimum amount is required.

Cycle Code

Specify a finance charge-type cycle code. This code is used as a customer selection parameter when finance charges are assessed.

Interest Charge by Date

Select whether finance charges are assessed for past due or paid late transactions by multiple finance charge rates over a period of time.

Late Charge Rounding

Select this check box if the resulting interest charge invoices are rounded to the nearest currency unit.

Administrative Fee

Select this check box to assess an additional fixed administrative fee. When a finance charge is assessed for the late payments, an additional fixed administrative fee can be charged.

Calculation Method

Select a calculation method.

Customer Minimum

If the Charge Customer Minimum check box is selected, then specify the minimum finance charge amount to assess. If the calculated finance charge for the customer is less than this value, then the minimum charge is assessed.

Last Number

Specify the number of the last finance charge notice created. If this field is blank, then the number begins with one.

Prefix

Optionally, provide a prefix number for the finance charge debit memo. If this field is blank, then FC is used.

Enable Electronic Funds Transfer

Select this check box if electronic funds transfers are used.

System Calendar

Select a calendar for ETF processing.

Due Days

Optionally, specify the number of days that are used to calculate the ending due date when electronic fund transfers are processed.

Type

If you specify Due Days, then also select whether the number of days are actual days or bank days.

Global Ledger Days

Optionally, specify the number of global ledger days that are used to calculate the posting date for the cash deposit.

Type

If you specify Global Ledger Days, then also select whether the type of days is actual days or bank days.

Deposit Days

Optionally, specify the number of deposit days that are used to calculate the deposit date for the cash deposit.

Type

If you specify Deposit Days, then select whether they are actual days or bank days.

Deposit Cash Code

Select the code to use in ETF scenarios to withdraw funds from a customer's bank account.

This cash code is used to deposit funds into the receivable company account and to withdraw the funds from their customers' account. The cash code is mapped to a cash account and contains the financial institution and bank branch information. The financial institution and bank branch is displayed on the ACH File Header Record.

Credit Cash Code

Select the code to use to in ETF scenarios to deposit funds into a customer's bank account. This cash code is used to withdraw funds from the Receivable company account and deposit the funds into their customers' bank account.

Deposit Payment Code

Select the code to use for a payment batch that represents a net drawing of funds. This bank transaction code is used to deposit funds into the receivable company account and withdraw funds from their customer’s bank account.

Credit Payment Code

Select the code for a payment batch that represents a net deposit of funds. This bank transaction code is used to withdraw funds from the receivable company account and to deposit funds into their customer’s bank account.

EFT Company ID

Specify the company to use to identify the entity that receives and sends funds for ACH processing. This EFT company ID is displayed on the ACH Header and Control Total records.

Organization Identifier

Specify an optional organization identifier value to be used as part of the EFT bank file produced.

Require Payment Cash Codes

Select this check box if deposit and credit cash codes are required when EFT payments are created.

EFT Notification Print Email Template

Specify an EFT notification print email template.

EFT Notification Print Email Subject

Specify an EFT notification print email subject.

Acceptance Accounting Option

Select whether a global ledger update is required when BOE receivables is accepted.

Remittance Number

Specify the last bill of exchange remittance number that is assigned. If this field is blank, then the number begins with 1.

BOE Number

Select whether automatic numbering or manual numbering is used for internally created bills of exchange.

Last BOE Number

If the BOE Number field is Automatic Numbering, then specify the last bill of exchange number that is assigned.

Check Bank Risk

Select this check box if bank risk processing is performed by the company when a discounted remittance is discounted.

Discounted Remit Payment Code

Specify the payment code that is used in the Cash solution when a discounted remittance is cashed.

Remittance Control

Select this check box if remittance control is used and bills of exchange are processed with a single maturity date.

Acceptance Code

If the Acceptance Accounting Option is required at acceptance, then specify a bill of exchange acceptance code and description.

Financial Revenue Code

Specify the code and description of a general ledger account that is used for bill of exchange financial revenue accounting.

Financial Expense Code

Specify a code and description of a general ledger account that is used for bill of exchange financial expense accounting.

Dishonored Code

Specify a dishonored code and description for a general ledger account that is used for dishonored bill of exchange accounting.

The Project tab is available if you select the Project Invoicing check box in the Enterprise Group.

Credit Memo Prefix

Specify the prefix that is attached to the credit memo number. The prefix is exclusive to projects.

Invoice Prefix

Specify the prefix that is attached to the invoice number. The prefix is exclusive to projects.

Credit Reason Code

Select the reason code that is used when creating a project credit memo.