Go to main content
1/143
Contents
List of Figures
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Overview to Accounts Receivable
1.1
System Integration
1.2
Accounts Receivable Features
1.2.1
Customer Management
1.2.2
Workflow Management
1.2.2.1
Multiple Invoice Entry Methods
1.2.2.2
Credit and Collections Management
1.2.2.3
Receipt Application
1.2.2.4
Reporting
1.2.3
Multi-National Functionality
1.3
Account Numbering Concepts
1.3.1
Business Unit - The "Where"
1.3.2
Object.Subsidiary - The "What"
1.4
Accounts Receivable System Flow
1.5
Tables Used by Accounts Receivable
1.5.1
Tables and Information Flow
1.5.2
Tables and Descriptions
1.6
Menu Overview
Part I Customer Information
2
Overview to Customer Information
2.1
Objectives
2.2
About Customer Information
2.3
What Is the Customer Record?
3
Enter Customers
3.1
Entering Customers
3.1.1
Before You Begin
3.1.2
What You Should Know About
3.1.3
What You Should Know About
3.1.3.1
Multiple Bank Accounts
3.1.4
What You Should Know About
3.1.5
Processing Options
3.2
Customer Master - Company/Business Unit Defaults
3.2.1
Before You Begin
3.2.2
What You Should Know About
4
Locate Customers
4.1
Locating Customers
4.1.1
What You Should Know About
4.1.2
Processing Options
Part II Invoice Processing
5
Overview to Invoice Processing
5.1
Objectives
5.2
About Invoice Processing
5.2.1
What Are the Types of Invoices?
5.2.1.1
Which Type of Invoice Should You Enter?
5.2.2
When Do You Review and Approve Invoices?
5.2.3
What Happens When You Post Invoices?
5.2.4
When Do You Set Up a Recurring Invoice?
5.2.5
What Is Customer Ledger Information?
6
Work with Invoice Entry Controls
6.1
Working with Invoice Entry Controls
6.2
About Batch Control
6.2.1
Why Would You Set Up Batch Control?
6.2.2
When Do You Use Batch Control?
6.2.3
What You Should Know About
6.3
About Two-Cycle Entry
6.3.1
Where Do You Set Up Two-Cycle Entry?
7
Understand Fiscal Date Patterns
7.1
About Fiscal Date Patterns
7.1.1
What You Should Know About
8
Work with Standard Invoices
8.1
Working with Standard Invoices
8.1.1
Before You Begin
8.2
Entering Standard Invoices
8.2.1
What You Should Know About
8.2.2
Processing Options
8.2.3
Processing Options
8.3
Locating Invoices
8.3.1
What You Should Know About
8.4
Revising Unposted Invoices
8.4.1
What You Should Know About
9
Work with Other Types of Standard Invoices
9.1
Working with Other Types of Standard Invoices
9.2
Entering an Invoice with Discounts
9.2.1
Before You Begin
9.2.2
What You Should Know About
9.3
Entering a Split Payment Invoice
9.3.1
What You Should Know About
9.4
Entering a Credit Memo
9.4.1
What You Should Know About
9.5
Entering an Invoice with Taxes
9.5.1
Before You Begin
9.5.2
What You Should Know About
9.6
Working with a Multi-Currency Invoice
9.6.1
Before You Begin
9.6.2
What You Should Know About
9.7
Setting Up a Recurring Invoice
9.7.1
Processing Options
10
Enter Speed Invoices
10.1
Entering Speed Invoices
10.1.1
What You Should Know About
10.1.2
Processing Options
11
Review and Approve Invoices
11.1
Reviewing and Approving Invoices
11.2
Reviewing Invoices
11.2.1
Reviewing a List of Invoice Batches
11.2.2
What You Should Know About
11.2.3
Reviewing and Revising Detailed Invoice Information
11.2.4
What You Should Know About
11.3
Approving a Batch of Invoices
11.3.1
Before You Begin
11.3.2
What You Should Know About
12
Understand the Post Process
12.1
About the Post Process for A/R
12.1.1
What Happens During the Pre-Post Process?
12.1.2
What Happens During the Post Process?
12.1.3
How Are Offsets Handled?
13
Post Invoices
13.1
Posting a Batch of Invoices
13.1.1
Before You Begin
13.1.2
What You Should Know About
13.2
Verifying the A/R Post Process
13.2.1
Reviewing the Posting Edit Report
13.2.2
Reviewing the Posting Journal
13.2.3
Reviewing Other Posting Reports
13.2.4
Processing Options
14
Revise Posted Invoices
14.1
Changing a Posted Invoice
14.1.1
What You Should Know About
14.2
Voiding a Posted Invoice
14.2.1
What You Should Know About
15
Print Invoice Journal Information
15.1
Printing Invoice Journal Information
15.1.1
Processing Options
15.1.2
Data Selection and Sequence
16
Locate Customer Ledger Information
16.1
Defining Invoice Search Criteria
16.1.1
Using the SQL Processing Option
16.1.2
Processing Options
16.2
Viewing Invoice Information
16.2.1
Viewing an Individual Invoice
16.2.2
What You Should Know About
16.2.3
Viewing an Associated Journal Entry
16.2.4
What You Should Know About
16.2.5
Viewing Invoice Detail
16.2.6
Viewing Multi-Currency Invoice Information
16.2.7
What You Should Know About
16.3
Viewing Account Information
16.3.1
Viewing Account Activity
16.3.2
Viewing Account Status Information
16.3.3
Processing Options
16.3.4
Viewing Collection Management Information
17
Work with Recurring Invoices
17.1
Working with Recurring Invoices
17.1.1
Example: Processing a Recurring Invoice
17.2
Entering Recurring Invoices
17.3
Reviewing Recurring Invoices
17.4
Revising Recurring Invoices
17.4.1
What You Should Know About
17.5
Recycling Recurring Invoices
17.5.1
What Happens When You Recycle Recurring Invoices?
17.5.2
Before You Begin
17.5.3
Processing Options
Part III Manual Receipts Processing
18
Overview to Manual Receipts Processing
18.1
Objectives
18.2
About Manual Receipts Processing
18.2.1
Which Form Do You Use to Enter Manual Receipts?
18.2.2
What Are the Steps for Processing Manual Receipts?
18.2.3
What Does the System Require to Process Manual Receipts?
18.2.3.1
Dates
18.2.3.2
Original Document Types
18.2.3.3
Matching Document Types
18.2.3.4
Type of Input Codes
18.2.3.5
Automatic Update of TI Code
18.2.3.6
Function Keys
18.2.3.7
Reason Code
18.2.3.8
Remark
18.2.3.9
Special Considerations
19
Update Invoices for Payment
19.1
Reviewing Open Items
19.2
Updating Invoice Information
19.2.1
What You Should Know About
19.2.2
Processing Options
20
Work with Invoice Match Receipts
20.1
Displaying Open Items
20.1.1
What You Should Know About
20.1.2
What You Should Know About
20.1.3
Processing Options
20.2
Entering Basic Receipts
20.2.1
What You Should Know About
20.3
Reviewing the Results of Receipts Entry
20.4
Processing Receipts Using the Current Domestic Value Method
20.4.1
Example: Current Domestic Value Method
20.4.2
Before You Begin
20.4.3
What You Should Know About
20.5
Reviewing Gain and Loss Information
20.5.1
Example: Currency Gain/Loss
20.5.1.1
Invoice and Receipt
20.5.1.2
Journal Entries
20.6
Entering Receipts with Discounts
20.6.1
Example: Invoice Match with Discount
20.6.2
What You Should Know About
20.7
Entering Receipts without Discounts
20.7.1
Example: Invoice Match without Discount
20.8
Creating Chargebacks for Discount Amounts
20.8.1
Example: Invoice Match - Create Chargeback for Discount Amount
21
Work with Other Types of Receipts
21.1
Entering Balance Forward Receipts
21.1.1
Example: Balance Forward Receipt
21.2
Entering Unapplied Receipts
21.2.1
Example: Unapplied Receipt
21.2.2
What You Should Know About
21.3
Creating Chargeback Invoices
21.3.1
Example: Chargeback Invoice
21.3.2
What You Should Know About
21.4
Entering Receipts with Write-Offs
21.4.1
Example: Invoice Match Receipt with Write-Off
21.5
Entering Receipt Adjustments
21.5.1
Example: Receipt Adjustment
21.6
Entering "G" Type Receipts
21.6.1
Example: "G" Type Receipt
21.6.2
Processing Options
22
Approve and Post Receipts
22.1
Reviewing and Approving Receipts for Posting
22.1.1
Before You Begin
22.2
Posting Receipts
23
Work with Alternative Methods of Application
23.1
Choosing a Group of Invoices
23.1.1
What You Should Know About
23.2
Allocating a Receipt Automatically
23.3
Spreading a Receipt Amount
23.3.1
Example: Spreading a Receipt Amount
23.4
Transferring an Unapplied Receipt to a New Account
24
Revise Receipts
24.1
Voiding a Receipt
24.2
Creating an NSF Receipt
25
Print Receipt Information
25.1
Printing the Receipts Journal
25.1.1
Before You Begin
25.1.2
What You Should Know About
25.1.3
Processing Options
25.1.4
Data Sequence for Receipts Journal
25.2
Printing the Receipt Deposit Journal
25.2.1
Before You Begin
25.2.2
What You Should Know About
25.2.3
Processing Options
25.2.4
Data Selection and Sequence for Receipt Deposit Journal
Part IV Receivables and Payables Netting
26
Overview to Receivables and Payables Netting
26.1
About Receivables and Payables Netting
27
Net Receivables and Payables
27.1
Understanding the Netting Program
27.1.1
Transaction Details
27.1.2
Features
27.1.3
Multi-Currency
27.2
Determining Liabilities
27.2.1
Before You Begin
27.3
Netting the Transactions
27.3.1
Netting Transactions in Stand-Alone Mode
27.3.2
Processing Options
27.3.3
Netting Transactions during Receipts Processing
27.3.4
What You Should Know About
27.3.5
Processing Options
27.3.6
Voiding Receipts and Reversing Net Transactions
28
Print Netting Reports
28.1
Printing Netting Reports
28.2
Creating the A/R and A/P Netting Report Workfile Table
28.2.1
Before You Begin
28.2.2
Processing Options
28.2.3
Data Selection
28.3
Printing the Netting - Aging Report
28.3.1
Before You Begin
28.3.2
Data Selection
28.3.3
Data Sequence
28.3.4
Processing Options
Part V Automatic Receipts Processing
29
Overview to Automatic Receipts Processing
29.1
Objectives
29.2
About Automatic Receipts Processing
29.2.1
What Is the Purpose of Batch Receipts?
30
Load Bank Tapes
30.1
Loading Bank Tapes
30.1.1
Before You Begin
30.1.2
What You Should Know About
30.1.3
Processing Options
30.1.4
What You Should Know About Processing Options
30.1.5
Data Selection
31
Work with Speed Receipts
31.1
Working with Speed Receipts
31.1.1
What You Should Know About
31.2
Setting Up Header Information
31.2.1
Example: Header Information
31.3
Selecting Open Items for Application
31.3.1
Before You Begin
31.3.2
What You Should Know About
31.4
Applying Receipts to Invoices
31.4.1
Example: Invoice Match Receipt
31.4.2
Before You Begin
31.4.3
What You Should Know About
31.5
Applying Receipts to Statements
31.5.1
Example: Statement Match Receipt
31.5.2
Before You Begin
31.6
Entering Unapplied Receipts
31.6.1
Example: Unapplied Receipt
31.6.2
Before You Begin
31.6.3
What You Should Know About
31.7
Entering Chargebacks
31.7.1
Example: Receipt with a Chargeback
31.7.2
Example: Stand-Alone Chargeback
31.7.3
Before You Begin
31.7.4
What You Should Know About
31.7.5
What You Should Know About
31.7.6
Processing Options
32
Enter Batch Receipts
32.1
Entering Scanned Receipts
32.2
Entering Manual Receipts
32.2.1
What You Should Know About
32.2.2
Processing Options
32.2.3
Data Selection
33
Process Batch Receipts
33.1
Processing Auto Receipts
33.1.1
Required Fields
33.1.2
Setting the Invoice Match Algorithms Processing Option
33.1.3
F0311 Example
33.1.4
F0312 Example
33.1.5
Using Only One Algorithm at a Time
33.1.6
F0311 Example
33.1.7
F0312 Example
33.1.7.1
Invoice Match Algorithms Settings
33.1.7.2
Successful Cash Application
33.1.7.3
Successful Cash Application
33.1.8
Discounts
33.1.9
Write-Offs
33.1.10
After the Process
33.1.11
Additional Notes
33.1.11.1
Bringing in A/R Receipts History
33.1.12
Before You Begin
33.1.13
What You Should Know About
33.1.14
Processing Options
34
Work with Unprocessed Items
34.1
Reviewing Unprocessed Items
34.1.1
Reviewing a List of Unprocessed Batches
34.1.2
Reviewing Detail within a Batch
34.2
Changing Unprocessed Items
34.2.1
What You Should Know About
34.3
Reviewing Batch Receipts Activity
34.3.1
Reviewing the Bank Deposit Journal
34.3.2
Reviewing Receipt Application Activity
Part VI Revenue Recognition (Release A9.3 Update)
35
Overview to Revenue Recognition (Release A9.3 Update)
35.1
Overview to Performance Liability Accounting
35.2
Tables Used in Revenue Recognition
35.3
Revenue Recognition Example
36
Set Up Revenue Recognition (Release A9.3 Update)
36.1
Setting Up Revenue Recognition Constants
36.2
Setting Up AAIs
36.2.1
RN AAI
36.2.2
RJ AAI
36.2.3
DMAAI
36.2.4
RO AAI
36.3
Setting Up UDCs
36.4
Setting Up Revenue Recognition Triggers for Invoices
36.4.1
Setting Up Revenue Recognition Triggers for A/R Invoices
36.4.1.1
Setting Up Revenue Recognition Trigger Hierarchy and Dates for A/R Invoices
36.4.1.2
Setting Up Revenue Recognition Trigger Configuration for A/R Invoices
36.4.2
Setting Up Revenue Recognition Triggers for Sales Order Invoices
36.4.2.1
Setting Up Revenue Recognition Trigger Hierarchy and Dates for Sales Order Invoices
36.4.2.2
Setting Up Revenue Recognition Trigger Configuration for Sales Order Invoices
36.4.3
Setting Up Revenue Recognition Triggers for Contract Billing Invoices
36.4.3.1
Setting Up Revenue Recognition Trigger Hierarchy and Dates for Contract Billing Invoices
36.4.3.2
Setting Up Revenue Recognition Trigger Configuration for Contract Billing Invoices
36.4.4
Setting Up Revenue Recognition Triggers for Service Billing Invoices
36.4.4.1
Setting Up Revenue Recognition Trigger Hierarchy and Dates for Service Billing Invoices
36.4.4.2
Setting Up Revenue Recognition Trigger Configuration for Service Billing Invoices
36.4.5
Reviewing Revenue Recognition Triggers Setup
37
Work with Revenue Recognition (Release A9.3 Update)
37.1
Entering Invoices into Revenue Recognition
37.1.1
Automatically Entering Invoices into Revenue Recognition
37.1.2
Manually Entering Existing Invoices into Revenue Recognition
37.1.2.1
Entering Invoices into Revenue Recognition using Batch Processing
37.1.3
Entering Invoices into Revenue Recognition using Standard Invoice Entry
37.1.3.1
Processing Options
37.2
Recognizing Revenue
37.2.1
Recognizing Revenue for Pay Items or Invoices
37.2.1.1
Processing Options P03116
37.2.2
Recognizing Revenue for Invoices Using Batch Processing
37.2.2.1
Processing Options
37.2.2.2
Data Selection
37.2.2.3
Data Sequence
37.3
Reviewing the G/L Distribution
37.3.1
Multi Currency Processing
37.4
Removing Invoices from Revenue Recognition
37.5
Reversing Revenue Recognition
37.6
Purging Revenue Recognition Data
Part VII Credit and Collections Management
38
Overview to Credit and Collections Management
38.1
Objectives
38.2
About Credit and Collections Management
39
Set Up Credit and Collection Information
39.1
Defining Finance Charges
39.2
Defining a Credit Limit
39.2.1
What You Should Know About
39.3
Defining Collection Information
39.4
Setting Up Category Codes for A/R
39.5
Setting Up Credit Messages for A/R
40
Update A/R Information for Customer Analysis
40.1
Updating A/R Information for Customer Analysis
40.1.1
Temporary Credit Messages
40.1.2
Example: Updating Credit Messages
40.1.2.1
Before
40.1.2.2
After
40.1.3
Technical Considerations
40.1.4
Before You Begin
40.1.5
Processing Options
40.1.6
Data Selection and Sequence
40.2
Import Mass Data into A/R
40.2.1
Processing Options
40.2.2
Data Selection
40.2.3
Data Sequence
41
Determine Average Days Late
41.1
Calculations
41.1.1
DREAM Writer Considerations
41.1.2
Guidelines
42
Calculate High Balance
42.1
Overview
42.1.1
Current Day Method
42.1.2
As Of Method
42.2
Multi-Currency
42.3
Guidelines
42.3.1
Processing Options
43
Review Account Status Information
43.1
Reviewing Aged "As Of" Information
43.2
Reviewing Real-Time Information
43.2.1
Processing Options
44
Manage Credit Information
44.1
Reviewing Customer Accounts
44.1.1
Before You Begin
44.1.2
What You Should Know About
44.2
Working Customer Accounts
44.2.1
What You Should Know About
44.2.2
Processing Options
44.3
Reviewing Account Balances
44.3.1
Before You Begin
44.3.2
What You Should Know About
45
Create Credit Reporting Tapes
45.1
Creating Credit Reporting Tapes
45.1.1
What Are the Requirements for Credit Reporting Tapes?
45.1.2
Before You Begin
45.1.3
What You Should Know About
45.1.4
Processing Options
46
Manage Collections Information
46.1
Reviewing Past-Due Accounts
46.1.1
Before You Begin
46.1.2
What You Should Know About
46.1.3
Processing Options
46.2
Reviewing Customer Payment History
46.2.1
Before You Begin
46.2.2
What You Should Know About
46.2.3
Processing Options
46.3
Reviewing Account Balances
46.3.1
Reviewing Balances by Administrator
46.3.2
What You Should Know About
46.3.3
Reviewing Balances by Business Unit
46.3.4
What You Should Know About
46.4
Working Past-Due Accounts
46.4.1
Reviewing Promises Messages
46.4.2
Entering Promises Messages
46.4.3
What You Should Know About
46.5
Using the Accounts Receivable Activity Log
46.5.1
Managing Account Activities
46.5.2
Reviewing Account Activities
46.5.3
Processing Options
46.5.4
Setting Up Activity Type Master
46.5.5
Printing the Activity Log
46.5.6
Purging the Activity Log
46.6
Reviewing Collection Management Information
47
Print Credit and Collections Reports
47.1
Printing the Open Credit/Collection Items Report
47.1.1
Printing the Outstanding Collections Items Version
47.1.2
Printing the Outstanding Credit Items Version
47.1.3
Processing Options
47.2
Printing the A/R Account Summary Report
47.2.1
Processing Options
47.3
Printing the Promises Listing Report
47.3.1
Processing Options
47.3.2
Data Selection for Promises Listing
Part VIII A/R Reports
48
Overview to A/R Reports
48.1
Objectives
48.2
About A/R Standard and Analytical Reports
48.2.1
Why Would You Print Standard Reports?
48.2.2
Why Would You Print Analytical Reports?
49
Print Standard Reports
49.1
Printing the Open A/R Summary Report
49.1.1
Printing A/R Summary by Company
49.1.2
Processing Options
49.1.3
Printing A/R Summary by Category Code
49.1.4
Data Selection and Sequence for A/R Summary by Category Code
49.1.5
Printing A/R Summary by Parent
49.2
Printing the Open A/R Detail Report
49.2.1
Processing Options
49.2.2
Data Selection for Open A/R Detail
49.3
Printing the Open A/R Foreign Amounts Report
49.3.1
Processing Options
50
Print Analytical Reports
50.1
Printing the Summary by Pay Status Report
50.1.1
Processing Options
50.2
Printing the Summary by Parent/Child Report
50.2.1
Processing Options
50.3
Printing the Open A/R by Business Unit and Address Report
50.3.1
Processing Options
50.3.2
Data Selection and Sequence for Open A/R by Business Unit
50.4
Printing Additional Credit and Collections Reports
50.4.1
Printing the Customer Receipts History Report
50.4.2
Processing Options
50.4.3
Data Selection for the Customer Receipts History Report
50.4.4
Printing the Disputed Items (Outstanding Chargebacks) Report
50.4.5
Printing the Unresolved Matters Report
50.4.6
Processing Options
50.4.7
Data Selection and Sequence for the Unresolved Matters Report
50.4.8
Printing the Receivables/Payables Netting Report
50.4.9
Before You Begin
50.4.10
Data Selection and Sequence for Receivables/Payables Netting
50.4.11
Printing the Problem Accounts Receivable Report
50.4.12
Processing Options
50.4.13
Data Sequence for the Problem Accounts Receivable Report
50.5
Printing the Customer Totals by G/L Account Report
50.5.1
Processing Options
50.5.2
Data Sequence for the Customer Totals by G/L Account Report
Part IX A/R Draft Processing
51
Overview to A/R Draft Processing
51.1
Objectives
51.2
About A/R Draft Processing
51.2.1
What Are the Types of Drafts?
51.3
What Are the Steps for Processing Drafts?
51.3.1
Invoice Creation
51.3.2
Draft Origination
51.3.3
Draft Acceptance
51.3.4
Draft Remittance
51.3.5
Draft Collection
51.4
Setup
51.4.1
AAIs
51.4.2
Payment Instruments
51.4.3
Drafts Pay Status Codes
51.4.4
Customer Bank Account Information
51.4.5
G/L Bank Account Information
51.5
Tracking Changes to Draft Status
52
Print Invoices and Statements with Drafts
52.1
Printing Invoices with Draft Attachments
52.1.1
Processing Options
52.1.2
Data Selection and Sequence for Invoice Print with Draft
52.2
Printing Statements with Draft Attachments
52.2.1
Before You Begin
52.2.2
Processing Options
52.2.3
Data Selection and Sequence for Statement Print with Draft
53
Enter Drafts
53.1
Entering Drafts
53.2
Entering Manual Drafts
53.2.1
What You Should Know About
53.2.2
Processing Options
53.3
Creating Automatic Drafts
53.3.1
What You Should Know About
53.3.2
Processing Options
54
Revise Drafts
54.1
Locating Drafts
54.2
Changing Draft Information
54.2.1
Processing Options
54.2.2
What You Should Know About
55
Approve and Post A/R Drafts
55.1
Reviewing and Approving Drafts for A/R
55.1.1
Before You Begin
55.2
Printing the A/R Draft Journal Report
55.2.1
Processing Options
55.3
Posting Drafts for A/R
56
Select Drafts for Remittance
56.1
Creating and Revising Bank Registers
56.1.1
Example: Bank Register
56.1.2
Before You Begin
56.1.3
What You Should Know About
56.1.4
Processing Options
56.2
Reviewing A/R Draft Bank Registers
57
Work with Draft Remittance
57.1
Remitting Magnetic Drafts
57.1.1
Creating Draft Tape Tables
57.1.2
What You Should Know About
57.1.3
Copying Draft Tables to Tape
57.1.4
Before You Begin
57.1.5
Processing Options
57.1.6
Resetting the Draft Tape Copy Sequence for A/R
57.2
Remitting Paper Drafts
57.2.1
Running Paper Draft Remittance
57.2.2
Correcting Problems with Paper Draft Remittance
57.2.3
Processing Options
57.2.4
Data Selection for Paper Draft Remittance
57.3
Posting Draft Remittance Journal Entries
58
Work with A/R Draft Collection
58.1
Updating Draft Payment Status
58.1.1
Processing Options
58.2
Notifying Customers of Non-Sufficient Funds
58.2.1
Before You Begin
58.2.2
Example: Non-Sufficient Funds Letter
58.2.3
Processing Options
58.3
Reviewing and Approving Journal Entries for A/R Draft Collections
58.4
Posting Journal Entries for A/R Draft Collections
Part X Period-End Processes
59
Overview to Period-End Processing
59.1
Objectives
59.2
About Period-End Processing
60
Work with Credit Note Reimbursements
60.1
Working with Credit Note Reimbursements
60.1.1
Before You Begin
60.1.2
What You Should Know About
60.2
Generating Credit Note Reimbursements
60.2.1
What You Should Know About
60.2.2
Processing Options
60.3
Reviewing and Approving Credit Note Reimbursements
60.4
Posting Credit Note Reimbursements
60.5
Voiding Credit Note Reimbursements
61
Process "As Of" Reports
61.1
Generating "As Of" Date Information
61.1.1
Before You Begin
61.1.2
What You Should Know About
61.1.3
Processing Options
61.2
Printing "As Of" Reports
61.2.1
Before You Begin
61.2.2
What You Should Know About
61.2.3
Printing the Open A/R Detail Report
61.2.4
Processing Options
61.2.5
Printing the Open A/R Summary Report
61.2.6
Printing the Open A/R by Business Unit and Address Report
61.2.7
Processing Options
61.2.8
What You Should Know About
62
Process A/R Integrity Reports
62.1
Understanding A/R Integrity Reports
62.1.1
Before You Begin
62.2
Running the A/R to G/L by Batch Report
62.2.1
What You Should Know About
62.3
Running the A/R to G/L by Offset Account Report
62.3.1
Processing Option Considerations
62.3.2
Processing Options
62.4
Correcting A/R Out-of-Balance Conditions
62.5
Running the A/R Drafts to G/L by Offset Report
62.5.1
How It Works
62.5.2
Processing Options
62.6
Running the Revenue Recognition Integrity Report (Release A9.3 Update)
62.6.1
Processing Option Considerations
62.6.2
Processing Options
Part XI Statement and Reminder Processing
63
Overview to Statement and Reminder Processing
63.1
Objectives
63.2
About Statement and Reminder Processing
63.2.1
Applying Late Payment Charges
63.2.2
Customizing Statement Messages
63.2.3
Printing Statements
63.2.4
Printing Invoices
63.2.5
Processing Past Due Notifications
63.2.5.1
Delinquency Notices
63.2.5.2
Payment Reminders
63.2.6
Processing Collection and Reminder Reports
64
Work with Late Payment Charges
64.1
Working with Late Payment Charges
64.2
Processing Finance Charge Invoices
64.2.1
Update Finance Charges
64.2.2
Processing Options
64.2.3
Print Finance Charge Invoices
64.2.4
Before You Begin
64.2.5
What You Should Know About
64.2.6
Processing Options
64.2.7
Correcting Discrepancies
64.3
Processing Interest Invoices
64.3.1
Creating Interest Invoices
64.3.2
Before You Begin
64.3.3
What You Should Know About
64.3.4
Processing Options
64.3.5
Reviewing and Approving Interest Invoices
64.3.6
Posting Interest Invoices
65
Print Statements
65.1
Printing Statements
65.2
Printing A/R Statements
65.2.1
Before You Begin
65.3
Building the Temporary Work File
65.3.1
Running Credit Analysis Refresh
65.3.2
Creating the Work File from the Print Statement Processing Options
65.3.3
A/R Statement Print Messages - Optional
65.4
Producing Statements
65.4.1
Additional Parameters
65.4.2
Data Selection
65.5
Producing Statements - Credit Card Format
65.5.1
Producing Statements for - "As Of" Date
65.5.2
Printing Statements with or without Consolidation of Companies
65.5.2.1
Statement without Consolidation of Companies by Customer Number
65.5.2.2
Statement with Consolidation of Companies by Customer Number
65.5.3
What You Should Know About
65.5.4
Processing Options
65.6
Printing Multi-Currency Statements
66
Print A/R Invoices
66.1
Printing A/R Invoices
66.1.1
Before You Begin
66.1.2
What You Should Know About
66.1.3
Processing Options
67
Work with Past Due Notifications
67.1
Working with Past Due Notifications
67.2
Printing Payment Reminders
67.2.1
Before You Begin
67.2.2
Number of Reminders
67.2.3
Setting up Reminders Text
67.2.4
Printing Payment Reminders in Proof Mode
67.2.5
Printing Payment Reminders in Final Mode
67.2.6
What You Should Know About
67.2.7
Processing Options
67.2.8
Data Selection for Print Payment Reminders
67.3
Printing Delinquency Notices
67.3.1
Determining the Level of Severity
67.3.1.1
Example: Determining the Level of Severity for a Delinquency Notice
67.4
Printing Notices
67.4.1
Credit/Cash Management
67.4.1.1
Writing a Tickler Message to the Message Log Ledger File
67.4.1.2
As Of Process
67.4.2
Before You Begin
67.4.3
What You Should Know About
67.4.4
Printing a Multi-Currency Delinquency Notice
67.4.5
Printing Delinquency Notices in Multiple Languages
67.4.5.1
Creating Data Dictionary Items
67.4.5.2
Creating Vocabulary Overrides
67.4.6
Data Selection
67.4.7
Processing Options
68
Work with Collection and Reminder Information
68.1
Choosing a Customer for Collections
68.2
Choosing an Invoice for Collections
68.3
Printing the Reminder Report/Update
68.3.1
Before You Begin
68.3.2
What You Should Know About
68.3.3
Processing Options
68.4
Printing the A/R Detail Report with Reminders
68.4.1
Processing Options
Part XII System Setup
69
Overview to System Setup
69.1
Objectives
69.2
About System Setup
69.2.1
What Do the A/R Setup Features Do?
70
Set Up A/R Constants
70.1
Setting Up the Default Company
70.2
Setting Up A/R Notification Controls
70.3
Setting Up Automatic Receipts Processing
70.4
Setting Up A/R Aging Information
70.5
Setting Up Batch Control for A/R
70.6
Setting Up A/R Batch Approval
70.7
Setting Up the Automatic Offset Method for A/R
70.7.1
Example: Journal Entry Created by Automatic Offset
70.8
Setting Up the G/L Interface Control for A/R
70.9
Setting Up Suspended Tax Processing for A/R
70.10
Setting Up Exchange Rate difference for A/R
71
Set Up Payment Terms
71.1
Setting Up Net Payment Terms for A/R
71.2
Setting Up Net with Discount Payment Terms for A/R
71.3
Setting Up Proximate Date Payment Terms for A/R
71.4
Setting Up Due Upon Receipt Payment Terms for A/R
71.5
Setting Up Split Payment Terms for A/R
72
Set Up Advanced Payment Terms
72.1
Setting Up Advanced Payment Terms
72.2
Setting Up Due Date Rules
72.2.1
What You Should Know About
72.3
Setting Up Work Day Calendars
72.3.1
What You Should Know About
72.4
Setting Up Payment Term Codes
72.4.1
Payment Term Codes
72.4.2
Before You Begin
72.5
Setting Up Installment Payments
72.5.1
What You Should Know About
72.6
Working with Payment Terms for Multi-Tiered Discounts
72.6.1
Before You Begin
72.6.2
Setting Up a Multi-Tiered Due Date Rule
72.6.3
What You Should Know About
72.6.4
Updating the Discount Available for Multi-Tiered Terms
72.6.5
Processing Options
73
Understand Automatic Accounting Instructions
73.1
About Automatic Accounting Instructions
73.2
About AAI Naming Conventions for A/R
73.2.1
Why Are AAI Suffixes Used?
73.2.2
Additional Information
73.3
About Default AAIs for A/R
73.3.1
How Does the System Use AAIs for Company 00000?
73.3.2
How Does the System Search for AAIs?
73.3.3
How Does the System Search AAIs for a Multi-Currency Environment?
74
Work with Automatic Accounting Instructions
74.1
Reviewing AAIs
74.2
Revising AAIs
74.3
Setting Up AAIs for A/R
75
Understand User Defined Codes
75.1
About User Defined Codes for A/R
75.2
Which User Defined Codes Are Available for A/R?
75.2.1
Document Type Codes
75.2.2
Payment Status Codes (00/PS)
75.2.3
Payment Instrument Codes (00/RY)
75.2.4
Tax Explanation Codes (00/EX)
75.2.5
Aging Vocabulary Codes (03/AG)
75.2.6
Adjustment Reason Codes (03/AR)
75.2.7
Valid Credit Message Codes (00/CM)
75.2.8
Collection Reason Codes (03/CL)
75.2.9
Credit Reporting Payment Terms Codes (03/PT)
75.2.10
Receipt Type Input Codes (03/TI)
75.2.11
Dun & Bradstreet Rating Codes (01/DB)
75.2.12
TRW Rating Codes (01/TR)
75.2.13
Autocash Algorithm Codes (01/AA)
75.2.14
Language Preference Codes (01/LP)
76
Set Up User Defined Codes
76.1
Setting Up User Defined Codes for A/R
76.1.1
Example: User Defined Codes Form
76.1.2
What You Should Know About
77
Set Up Next Numbers
77.1
Setting Up Next Numbers for A/R
77.1.1
What You Should Know About
77.2
Reviewing Standard Next Numbers
77.3
Activating Check Digits on Standard Next Numbers
77.4
Assigning Next Numbers by Company and Fiscal Year
78
Set Up Customer Bank Information
78.1
Setting Up Customer Bank Information
78.1.1
Bank Type Code
78.1.2
Bank Type Code User Defined Table
78.1.3
What You Should Know About
78.1.4
Bank Account by Currency
78.1.5
Effective Date/Expiration Date
78.1.6
What You Should Know About
78.2
Adding Customer Bank Account Information
78.2.1
What You Should Know About
78.3
Setting Up Bank Account Cross-References for A/R
78.3.1
Adding A/R Cross-References
78.3.2
What You Should Know About
78.3.3
Verifying Cross-References for A/R
78.3.3.1
Reviewing the Bank Account Exception Report
78.3.3.2
Reviewing the Address Book Exception Report
78.4
Setting Up Bank Account Addresses
78.4.1
What You Should Know About
78.5
Setting Up Bank Account Information for A/R
78.5.1
Before You Begin
78.5.2
Processing Options
79
Set Up A/R Draft Processing
79.1
Setting Up AAIs for A/R Drafts
79.1.1
AAIs for Drafts Receivable (RD1x)
79.1.2
AAIs for Drafts Remitted for Cash (RD2x)
79.1.3
AAIs for Drafts Remitted for Discount (RD3x)
79.2
Setting Up User Defined Codes for A/R Drafts
79.2.1
Payment Instrument Codes
79.2.2
Pay Status Codes
79.3
Setting Up Drafts as the Default Payment Instrument
79.4
Setting Up Statements for A/R Drafts
79.5
Setting Up Bank Account Information for A/R Drafts
79.5.1
Setting Up Customer Bank Information for A/R Drafts Bank Accounts
79.5.2
What You Should Know About
79.5.3
Printing the Bank Account Exception Report for A/R Drafts
79.6
Setting Up Letters for Non-Sufficient Funds
79.6.1
Processing Options
Part XIII Statement and Reminder Setup
80
Overview to Statement and Reminder Setup
80.1
Objectives
80.2
About Statement and Reminder Setup
81
Set Up Statement Messages
81.1
Entering Messages for A/R Statements
81.1.1
What You Should Know About
81.2
Setting Up Model Messages for Statements
81.2.1
What You Should Know
81.2.2
Processing Options
82
Set Up Text for Payment Reminders
82.1
Entering Reminder Messages
82.1.1
What You Should Know About
82.2
Setting Up Model Reminder Messages
82.2.1
What You Should Know About
83
Revise Text For Delinquency Notices
83.1
Revising Text For Delinquency Notices
83.1.1
Before You Begin
83.1.2
What You Should Know About
84
Work with Interest Rate Information
84.1
Defining Interest Rates
84.1.1
What You Should Know About
84.2
Entering Text For Interest Invoices
84.2.1
What You Should Know About
Part XIV Batch Invoice Processing
85
Overview to Batch Invoice Processing
85.1
Objectives
85.2
About Batch Invoice Processing
85.2.1
What Happens When You Process Batch Invoices?
85.2.2
Before You Begin
85.2.3
What You Should Know About
85.3
How it Works
85.3.1
Mandatory Fields to Populate in the F0311Z1 File
85.3.2
Mandatory Fields to Populate in the F0911Z1 File
85.4
Additional Processing (Receipts, Taxes, Multi-Currency)
85.4.1
Creating Receipt Information
85.4.2
Taxes
85.4.2.1
How to Populate Corresponding F0911Z1 Records for Tax Processing
85.4.3
Multi-Currency
85.4.3.1
F0311Z1
85.4.3.2
F0911Z1
85.4.3.3
F0311Z1
85.4.3.4
F0911Z1
85.4.4
Processing Transactions
85.4.5
Suggestions for Batch Invoice Processing
85.5
Purging
86
Review Batch Invoices
86.1
Reviewing Batch Information
86.2
Reviewing Batch Invoice Detail
86.2.1
What You Should Know About
86.2.2
Processing Options
87
Work with Batch Invoices
87.1
Adding Batch Invoices
87.2
Revising Unprocessed Batch Invoices
87.2.1
Processing Options
88
Process Batch Invoices
88.1
Submitting Invoices for Processing
88.2
Verifying Batch Invoice Information
88.2.1
What You Should Know About
88.3
Revising Batch Invoices
88.3.1
What You Should Know About
88.4
Posting Batch Invoices
88.4.1
Processing Options
89
Purge Processed Batch Invoices
89.1
Purging Processed Batch Invoices
89.1.1
What You Should Know About
89.1.2
Processing Options
Part XV A/R Cash Forecasting & ABC Customer Analysis
90
Forecast A/R Cash Flow
90.1
Objectives
90.2
About A/R Cash Forecasting
90.3
A/R Cash Forecasting
90.3.1
What You Should Know About
90.3.2
Processing Options
91
ABC Customer Analysis
91.1
Objectives
91.2
About ABC Customer Analysis
91.3
Analyzing Customer Account Activity
91.3.1
Before You Begin
91.3.2
How the System Determines the Codes to Assign
91.3.3
Processing Options
Part XVI Technical Processes
92
Overview to Technical Processes
92.1
Overview
93
Update A/R from the Address Book
93.1
Updating A/R from the Address Book
93.1.1
Example: Updating A/R from the Address Book
93.1.2
Updating A/R Category Codes
93.1.3
Processing Options
94
Work with YTD Invoice Amounts
94.1
Updating Customer YTD Invoice Amounts
94.1.1
How It Works
94.1.2
Before You Begin
94.1.3
What You Should Know About
94.1.4
Processing Options
94.2
Reworking Customer YTD Invoiced Amounts
94.3
Reviewing Customer YTD Invoice Amounts
94.3.1
Before You Begin
95
Update Balance Forward Records
95.1
Updating Balance Forward Records
95.1.1
Example: Creating Balance Forward Records
95.1.2
Before You Begin
95.1.3
What You Should Know About
95.1.4
Processing Options
96
Customer Master Conversion
96.1
Customer Master Conversion
96.1.1
Overview
96.1.2
Processing Options Detail
96.1.3
Conversion
96.1.4
Processing Options
97
Global Updates to Customer Records
97.1
Global Updates - Customer Master
97.1.1
Processing Options
97.2
Global Updates - Customer Company/Business Unit Records
97.2.1
Processing Options
98
Update Credit Messages
98.1
Updating Credit Messages
98.1.1
Before You Begin
98.1.2
What You Should Know About
98.1.3
What You Should Know About
99
Purge A/R Information
99.1
Purging Closed A/R Records
99.1.1
Before You Begin
99.1.2
After the Purge
99.1.3
What You Should Know About
99.1.4
Processing Options
99.1.5
Data Selection and Sequence for Purge Closed A/R Records
99.2
Purging Batch Receipts
99.2.1
Before You Begin
100
Work with Automatic Debits
100.1
Objectives
100.2
About Automatic Debits
100.3
Processing Automatic Debits
100.3.1
Before You Begin
100.3.2
Processing Options
100.3.3
Data Selection for Processing Automatic Debits
100.4
Reviewing and Approving Automatic Debits
100.5
Posting Automatic Debits
100.6
Copying Files to Tape or Diskette
100.6.1
Processing Options
100.6.2
Data Sequence for Copy Files to Tape or Diskette
Part XVII Processing Options
101
Customer Information Processing Options
101.1
Customer Master Information (P01053)
101.2
Name Search (P01200)
102
Invoice Processing - Processing Options
102.1
Invoice Entry (P03105)
102.2
A/R and A/P Journal Entries (P03101)
102.3
Speed Invoice Entry (P031015)
102.4
General Ledger Post (P09800)
102.5
Invoice Journal Report (P03305)
102.6
Customer Ledger Inquiry with SQL (P032002)
102.7
Account Status Summary (P03203)
102.8
Recycle Recurring Invoices (P038101)
102.9
Rev Rec - Hierarchy/Date Setup - All (P0325)
102.10
Revenue Recognition - Batch Recognition (P03502)
102.11
Batch Invoice Add to Revenue Recognition (P03503)
102.12
Remove Invoices from RR Process (P03504)
102.13
Revenue Recognition Workbench (P03116) (Release A9.3 Update)
103
Manual Receipts Processing - Processing Options
103.1
A/R Speed Release (P03114)
103.2
Receipts Entry (P03103)
103.3
Cash Receipts Statement Inquiry Selection (P03205)
103.4
Receipts Entry (P03103)
103.5
A/R Receipt and Adjustment Journal Report (P03311)
103.6
Receipt Deposit Journal (P03408)
104
Receivables and Payables Netting Processing Options
104.1
A/P and A/R Netting (P03455)
104.2
Build A/P and A/R Netting File (P03465)
104.3
A/P and A/R Netting Report (P03466)
105
Automatic Receipts Processing - Processing Options
105.1
Auto Cash Processing - Load Bank Tape (P03551)
105.2
Speed Cash Receipts Entry (P03122)
105.3
Batch Cash Entry (P03121)
105.4
A/R Batch Cash (P03550)
106
Credit and Collections Management Processing Options
106.1
Credit Analysis Refresh (P03525)
106.2
Account Status Summary (P03203)
106.3
Credit Granting and Management (P0305)
106.4
Address Book Credit Management/Granting Z File (P0305Z)
106.5
Credit Reporting Tape - TRW/Dun & Bradstreet (P03920)
106.6
Credit Reporting Tape - CREDITEL (P03920C)
106.7
Collections Manager (P03218)
106.8
Customer Payment History (P03204)
106.9
Activity Log (P0331)
106.10
Calculate High Balance (P03526)
106.11
Outstanding Credit/Collection Items (P03440)
106.12
A/R Summary Report (P03413)
106.13
Print Promises, Promises (P013151)
107
A/R Reports Processing Options
107.1
A/R Summary Report (P03413)
107.2
A/R Detail Report (P034201)
107.3
A/R Currency Detail (P03429)
107.4
Receivable Summary by Pay Status (P03416)
107.5
Multi-Level Open A/R Summary by Parent (P03415)
107.6
Open A/R by Business Unit and Address (P03445)
107.7
A/R Detail Report (P034201)
107.8
A/R Unresolved Matters (P03601)
107.9
Problem Accounts Receivable (P036001)
107.10
Customer Totals by G/L Account (P09450)
108
A/R Draft Processing - Processing Options
108.1
A/R Invoice Print with Draft (P035051)
108.2
A/R Statement Print with Draft (P03506)
108.3
A/R Batch Draft Creation (P03571)
108.4
Receipts Entry (P03103)
108.5
Draft Revisions (P03150)
108.6
A/R Receipt and Adjustment Journal Report (P03311)
108.7
Draft Selection for Bank Payment (P03255)
108.8
A/R Magnetic Draft Remittance (P03572)
108.9
A/R - Manual Draft Remittance (P03570)
108.10
A/R Draft Collection (P03576)
108.11
A/R Draft NSF Notification (P03574)
109
Automatic Debits Processing Options
109.1
Automatic Debits - USA (P03575)
109.2
Copy File to Tape (P03579)
110
Period-End Processing - Processing Options
110.1
A/R Credit Note Reimbursements (P03610)
110.2
Date File Generation (P03900)
110.3
A/R Detail Report (P034201)
110.4
Open A/R by Business Unit and Address (P03445)
110.5
A/R to G/L by Offset Integrity Report (P037001)
110.6
A/R Drafts to G/L by Offset Account (P037002)
110.7
Revenue Recognition Integrity Report (P037116) (Release A9.3 Update)
111
Statement and Reminder Processing - Processing Options
111.1
Finance Charge Update (P01830)
111.2
Finance Charge Journal (P03435)
111.3
Interest Invoices (P03540)
111.4
A/R Statements (P035001)
111.5
A/R Invoice Print (P03505)
111.6
Payment Reminders (P03530)
111.7
Delinquency Notices (P035111)
111.8
Reminder Report/Update (P03461)
111.9
A/R Detail Report with Reminders Info (P034202)
112
System Setup Processing Options
112.1
Batch Update for Multi-Tiered A/P (P005141)
112.2
Batch Update for Multi-Tiered A/R (P005142)
112.3
Bank Account Information (P04130)
112.4
A/R Draft NSF Notification (P03574)
113
Statement and Reminder Set Up Processing Options
113.1
A/R Print Messages (P03280)
114
Batch Invoice Processing - Processing Options
114.1
Batch Invoice Entry (P0301Z1)
114.2
A/R Invoice Batch Processing (P03110Z)
114.3
Batch File Purge (P00PURGE)
115
A/R Cash Forecasting Processing Options
115.1
A/R Cash Forecasting (P03520)
116
ABC Customer Analysis Processing Options
116.1
Customer Analysis (P03602)
117
Technical Processes Processing Options
117.1
Update A/R from Address Book (P03802)
117.2
Update YTD Invoice Amount (P03820)
117.3
Balance Forward Update (P03501)
117.4
Customer Master Conversion (P0301E)
117.5
Global Update Customer Master (P03490)
117.6
Global Update - A/R Company/Business Unit Defaults (P034905)
117.7
Purge Closed A/R Records (P03800)
A
Quick Reference Codes for A/R
A.1
Menus
A.2
Payment Status Codes
A.3
Payment Hold Types
A.4
Terms of Payment
A.5
Original Document Types
A.6
Matching Document Types
B
Batch Input Setup
B.1
Overview of Tables
B.2
Table 1 - Required or Conditionally Required Fields
B.3
Table 2 - Optional Control Fields
B.4
Table 3 - Additional Fields
B.5
Table 4 - Ignored Fields
C
A/R Statement Processing
C.1
A/R Print Statements
D
Functional Servers
D.1
About Functional Servers
D.1.1
Example: Voucher Processing Functional Server
Index
Scripting on this page enhances content navigation, but does not change the content in any way.