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 Credit and Collections Management

35 Overview to Credit and Collections Management

• 35.1 Objectives
• 35.2 About Credit and Collections Management

36 Set Up Credit and Collection Information

• 36.1 Defining Finance Charges
• 36.2 Defining a Credit Limit
  • 36.2.1 What You Should Know About
• 36.3 Defining Collection Information
• 36.4 Setting Up Category Codes for A/R
• 36.5 Setting Up Credit Messages for A/R

37 Update A/R Information for Customer Analysis

• 37.1 Updating A/R Information for Customer Analysis
  • 37.1.1 Temporary Credit Messages
  • 37.1.2 Example: Updating Credit Messages
    • 37.1.2.1 Before
    • 37.1.2.2 After
  • 37.1.3 Technical Considerations
  • 37.1.4 Before You Begin
  • 37.1.5 Processing Options
  • 37.1.6 Data Selection and Sequence
• 37.2 Import Mass Data into A/R
  • 37.2.1 Processing Options
  • 37.2.2 Data Selection
  • 37.2.3 Data Sequence

38 Determine Average Days Late

• 38.1 Calculations
  • 38.1.1 DREAM Writer Considerations
  • 38.1.2 Guidelines

39 Calculate High Balance

• 39.1 Overview
  • 39.1.1 Current Day Method
  • 39.1.2 As Of Method
• 39.2 Multi-Currency
• 39.3 Guidelines
  • 39.3.1 Processing Options

40 Review Account Status Information

• 40.1 Reviewing Aged "As Of" Information
• 40.2 Reviewing Real-Time Information
  • 40.2.1 Processing Options

41 Manage Credit Information

• 41.1 Reviewing Customer Accounts
  • 41.1.1 Before You Begin
  • 41.1.2 What You Should Know About
• 41.2 Working Customer Accounts
  • 41.2.1 What You Should Know About
  • 41.2.2 Processing Options
• 41.3 Reviewing Account Balances
  • 41.3.1 Before You Begin
  • 41.3.2 What You Should Know About

42 Create Credit Reporting Tapes

• 42.1 Creating Credit Reporting Tapes
  • 42.1.1 What Are the Requirements for Credit Reporting Tapes?
  • 42.1.2 Before You Begin
  • 42.1.3 What You Should Know About
  • 42.1.4 Processing Options

43 Manage Collections Information

• 43.1 Reviewing Past-Due Accounts
  • 43.1.1 Before You Begin
  • 43.1.2 What You Should Know About
  • 43.1.3 Processing Options
• 43.2 Reviewing Customer Payment History
  • 43.2.1 Before You Begin
  • 43.2.2 What You Should Know About
  • 43.2.3 Processing Options
• 43.3 Reviewing Account Balances
  • 43.3.1 Reviewing Balances by Administrator
  • 43.3.2 What You Should Know About
  • 43.3.3 Reviewing Balances by Business Unit
  • 43.3.4 What You Should Know About
• 43.4 Working Past-Due Accounts
  • 43.4.1 Reviewing Promises Messages
  • 43.4.2 Entering Promises Messages
  • 43.4.3 What You Should Know About
• 43.5 Using the Accounts Receivable Activity Log
  • 43.5.1 Managing Account Activities
  • 43.5.2 Reviewing Account Activities
  • 43.5.3 Processing Options
  • 43.5.4 Setting Up Activity Type Master
  • 43.5.5 Printing the Activity Log
  • 43.5.6 Purging the Activity Log
• 43.6 Reviewing Collection Management Information

44 Print Credit and Collections Reports

• 44.1 Printing the Open Credit/Collection Items Report
  • 44.1.1 Printing the Outstanding Collections Items Version
  • 44.1.2 Printing the Outstanding Credit Items Version
  • 44.1.3 Processing Options
• 44.2 Printing the A/R Account Summary Report
  • 44.2.1 Processing Options
• 44.3 Printing the Promises Listing Report
  • 44.3.1 Processing Options
  • 44.3.2 Data Selection for Promises Listing

Part VII A/R Reports

45 Overview to A/R Reports

• 45.1 Objectives
• 45.2 About A/R Standard and Analytical Reports
  • 45.2.1 Why Would You Print Standard Reports?
  • 45.2.2 Why Would You Print Analytical Reports?

46 Print Standard Reports

• 46.1 Printing the Open A/R Summary Report
  • 46.1.1 Printing A/R Summary by Company
  • 46.1.2 Processing Options
  • 46.1.3 Printing A/R Summary by Category Code
  • 46.1.4 Data Selection and Sequence for A/R Summary by Category Code
  • 46.1.5 Printing A/R Summary by Parent
• 46.2 Printing the Open A/R Detail Report
  • 46.2.1 Processing Options
  • 46.2.2 Data Selection for Open A/R Detail
• 46.3 Printing the Open A/R Foreign Amounts Report
  • 46.3.1 Processing Options

47 Print Analytical Reports

• 47.1 Printing the Summary by Pay Status Report
  • 47.1.1 Processing Options
• 47.2 Printing the Summary by Parent/Child Report
  • 47.2.1 Processing Options
• 47.3 Printing the Open A/R by Business Unit and Address Report
  • 47.3.1 Processing Options
  • 47.3.2 Data Selection and Sequence for Open A/R by Business Unit
• 47.4 Printing Additional Credit and Collections Reports
  • 47.4.1 Printing the Customer Receipts History Report
  • 47.4.2 Processing Options
  • 47.4.3 Data Selection for the Customer Receipts History Report
  • 47.4.4 Printing the Disputed Items (Outstanding Chargebacks) Report
  • 47.4.5 Printing the Unresolved Matters Report
  • 47.4.6 Processing Options
  • 47.4.7 Data Selection and Sequence for the Unresolved Matters Report
  • 47.4.8 Printing the Receivables/Payables Netting Report
  • 47.4.9 Before You Begin
  • 47.4.10 Data Selection and Sequence for Receivables/Payables Netting
  • 47.4.11 Printing the Problem Accounts Receivable Report
  • 47.4.12 Processing Options
  • 47.4.13 Data Sequence for the Problem Accounts Receivable Report
• 47.5 Printing the Customer Totals by G/L Account Report
  • 47.5.1 Processing Options
  • 47.5.2 Data Sequence for the Customer Totals by G/L Account Report

Part VIII A/R Draft Processing

48 Overview to A/R Draft Processing

• 48.1 Objectives
• 48.2 About A/R Draft Processing
  • 48.2.1 What Are the Types of Drafts?
• 48.3 What Are the Steps for Processing Drafts?
  • 48.3.1 Invoice Creation
  • 48.3.2 Draft Origination
  • 48.3.3 Draft Acceptance
  • 48.3.4 Draft Remittance
  • 48.3.5 Draft Collection
• 48.4 Setup
  • 48.4.1 AAIs
  • 48.4.2 Payment Instruments
  • 48.4.3 Drafts Pay Status Codes
  • 48.4.4 Customer Bank Account Information
  • 48.4.5 G/L Bank Account Information
• 48.5 Tracking Changes to Draft Status

49 Print Invoices and Statements with Drafts

• 49.1 Printing Invoices with Draft Attachments
  • 49.1.1 Processing Options
  • 49.1.2 Data Selection and Sequence for Invoice Print with Draft
• 49.2 Printing Statements with Draft Attachments
  • 49.2.1 Before You Begin
  • 49.2.2 Processing Options
  • 49.2.3 Data Selection and Sequence for Statement Print with Draft

50 Enter Drafts

• 50.1 Entering Drafts
• 50.2 Entering Manual Drafts
  • 50.2.1 What You Should Know About
  • 50.2.2 Processing Options
• 50.3 Creating Automatic Drafts
  • 50.3.1 What You Should Know About
  • 50.3.2 Processing Options

51 Revise Drafts

• 51.1 Locating Drafts
• 51.2 Changing Draft Information
  • 51.2.1 Processing Options
  • 51.2.2 What You Should Know About

52 Approve and Post A/R Drafts

• 52.1 Reviewing and Approving Drafts for A/R
  • 52.1.1 Before You Begin
• 52.2 Printing the A/R Draft Journal Report
  • 52.2.1 Processing Options
• 52.3 Posting Drafts for A/R

53 Select Drafts for Remittance

• 53.1 Creating and Revising Bank Registers
  • 53.1.1 Example: Bank Register
  • 53.1.2 Before You Begin
  • 53.1.3 What You Should Know About
  • 53.1.4 Processing Options
• 53.2 Reviewing A/R Draft Bank Registers

54 Work with Draft Remittance

• 54.1 Remitting Magnetic Drafts
  • 54.1.1 Creating Draft Tape Tables
  • 54.1.2 What You Should Know About
  • 54.1.3 Copying Draft Tables to Tape
  • 54.1.4 Before You Begin
  • 54.1.5 Processing Options
  • 54.1.6 Resetting the Draft Tape Copy Sequence for A/R
• 54.2 Remitting Paper Drafts
  • 54.2.1 Running Paper Draft Remittance
  • 54.2.2 Correcting Problems with Paper Draft Remittance
  • 54.2.3 Processing Options
  • 54.2.4 Data Selection for Paper Draft Remittance
• 54.3 Posting Draft Remittance Journal Entries

55 Work with A/R Draft Collection

• 55.1 Updating Draft Payment Status
  • 55.1.1 Processing Options
• 55.2 Notifying Customers of Non-Sufficient Funds
  • 55.2.1 Before You Begin
  • 55.2.2 Example: Non-Sufficient Funds Letter
  • 55.2.3 Processing Options
• 55.3 Reviewing and Approving Journal Entries for A/R Draft Collections
• 55.4 Posting Journal Entries for A/R Draft Collections

Part IX Period-End Processes

56 Overview to Period-End Processing

• 56.1 Objectives
• 56.2 About Period-End Processing

57 Work with Credit Note Reimbursements

• 57.1 Working with Credit Note Reimbursements
  • 57.1.1 Before You Begin
  • 57.1.2 What You Should Know About
• 57.2 Generating Credit Note Reimbursements
  • 57.2.1 What You Should Know About
  • 57.2.2 Processing Options
• 57.3 Reviewing and Approving Credit Note Reimbursements
• 57.4 Posting Credit Note Reimbursements
• 57.5 Voiding Credit Note Reimbursements

58 Process "As Of" Reports

• 58.1 Generating "As Of" Date Information
  • 58.1.1 Before You Begin
  • 58.1.2 What You Should Know About
  • 58.1.3 Processing Options
• 58.2 Printing "As Of" Reports
  • 58.2.1 Before You Begin
  • 58.2.2 What You Should Know About
  • 58.2.3 Printing the Open A/R Detail Report
  • 58.2.4 Processing Options
  • 58.2.5 Printing the Open A/R Summary Report
  • 58.2.6 Printing the Open A/R by Business Unit and Address Report
  • 58.2.7 Processing Options
  • 58.2.8 What You Should Know About

59 Process A/R Integrity Reports

• 59.1 Processing A/R Integrity Reports
  • 59.1.1 Before You Begin
• 59.2 Running the A/R to G/L by Batch Report
  • 59.2.1 What You Should Know About
• 59.3 Running the A/R to G/L by Offset Account Report
  • 59.3.1 Processing Option Considerations
  • 59.3.2 Processing Options
• 59.4 Correcting A/R Out-of-Balance Conditions
• 59.5 Running the A/R Drafts to G/L by Offset Report
  • 59.5.1 How It Works
  • 59.5.2 Processing Options

Part X Statement and Reminder Processing

60 Overview to Statement and Reminder Processing

• 60.1 Objectives
• 60.2 About Statement and Reminder Processing
  • 60.2.1 Applying Late Payment Charges
  • 60.2.2 Customizing Statement Messages
  • 60.2.3 Printing Statements
  • 60.2.4 Printing Invoices
  • 60.2.5 Processing Past Due Notifications
    • 60.2.5.1 Delinquency Notices
    • 60.2.5.2 Payment Reminders
  • 60.2.6 Processing Collection and Reminder Reports

61 Work with Late Payment Charges

• 61.1 Working with Late Payment Charges
• 61.2 Processing Finance Charge Invoices
  • 61.2.1 Update Finance Charges
  • 61.2.2 Processing Options
  • 61.2.3 Print Finance Charge Invoices
  • 61.2.4 Before You Begin
  • 61.2.5 What You Should Know About
  • 61.2.6 Processing Options
  • 61.2.7 Correcting Discrepancies
• 61.3 Processing Interest Invoices
  • 61.3.1 Creating Interest Invoices
  • 61.3.2 Before You Begin
  • 61.3.3 What You Should Know About
  • 61.3.4 Processing Options
  • 61.3.5 Reviewing and Approving Interest Invoices
  • 61.3.6 Posting Interest Invoices

62 Print Statements

• 62.1 Printing Statements
• 62.2 Printing A/R Statements
  • 62.2.1 Before You Begin
• 62.3 Building the Temporary Work File
  • 62.3.1 Running Credit Analysis Refresh
  • 62.3.2 Creating the Work File from the Print Statement Processing Options
  • 62.3.3 A/R Statement Print Messages - Optional
• 62.4 Producing Statements
  • 62.4.1 Additional Parameters
  • 62.4.2 Data Selection
• 62.5 Producing Statements - Credit Card Format
  • 62.5.1 Producing Statements for - "As Of" Date
  • 62.5.2 Printing Statements with or without Consolidation of Companies
    • 62.5.2.1 Statement without Consolidation of Companies by Customer Number
    • 62.5.2.2 Statement with Consolidation of Companies by Customer Number
  • 62.5.3 What You Should Know About
  • 62.5.4 Processing Options
• 62.6 Printing Multi-Currency Statements

63 Print A/R Invoices

• 63.1 Printing A/R Invoices
  • 63.1.1 Before You Begin
  • 63.1.2 What You Should Know About
  • 63.1.3 Processing Options

64 Work with Past Due Notifications

• 64.1 Working with Past Due Notifications
• 64.2 Printing Payment Reminders
  • 64.2.1 Before You Begin
  • 64.2.2 Number of Reminders
  • 64.2.3 Setting up Reminders Text
  • 64.2.4 Printing Payment Reminders in Proof Mode
  • 64.2.5 Printing Payment Reminders in Final Mode
  • 64.2.6 What You Should Know About
  • 64.2.7 Processing Options
  • 64.2.8 Data Selection for Print Payment Reminders
• 64.3 Printing Delinquency Notices
  • 64.3.1 Determining the Level of Severity
    • 64.3.1.1 Example: Determining the Level of Severity for a Delinquency Notice
• 64.4 Printing Notices
  • 64.4.1 Credit/Cash Management
    • 64.4.1.1 Writing a Tickler Message to the Message Log Ledger File
    • 64.4.1.2 As Of Process
  • 64.4.2 Before You Begin
  • 64.4.3 What You Should Know About
  • 64.4.4 Printing a Multi-Currency Delinquency Notice
  • 64.4.5 Printing Delinquency Notices in Multiple Languages
    • 64.4.5.1 Creating Data Dictionary Items
    • 64.4.5.2 Creating Vocabulary Overrides
  • 64.4.6 Data Selection
  • 64.4.7 Processing Options

65 Work with Collection and Reminder Information

• 65.1 Choosing a Customer for Collections
• 65.2 Choosing an Invoice for Collections
• 65.3 Printing the Reminder Report/Update
  • 65.3.1 Before You Begin
  • 65.3.2 What You Should Know About
  • 65.3.3 Processing Options
• 65.4 Printing the A/R Detail Report with Reminders
  • 65.4.1 Processing Options

Part XI System Setup

66 Overview to System Setup

• 66.1 Objectives
• 66.2 About System Setup
  • 66.2.1 What Do the A/R Setup Features Do?

67 Set Up A/R Constants

• 67.1 Setting Up the Default Company
• 67.2 Setting Up A/R Notification Controls
• 67.3 Setting Up Automatic Receipts Processing
• 67.4 Setting Up A/R Aging Information
• 67.5 Setting Up Batch Control for A/R
• 67.6 Setting Up A/R Batch Approval
• 67.7 Setting Up the Automatic Offset Method for A/R
  • 67.7.1 Example: Journal Entry Created by Automatic Offset
• 67.8 Setting Up the G/L Interface Control for A/R
• 67.9 Setting Up Suspended Tax Processing for A/R
• 67.10 Setting Up Exchange Rate difference for A/R

68 Set Up Payment Terms

• 68.1 Setting Up Net Payment Terms for A/R
• 68.2 Setting Up Net with Discount Payment Terms for A/R
• 68.3 Setting Up Proximate Date Payment Terms for A/R
• 68.4 Setting Up Due Upon Receipt Payment Terms for A/R
• 68.5 Setting Up Split Payment Terms for A/R

69 Set Up Advanced Payment Terms

• 69.1 Setting Up Advanced Payment Terms
• 69.2 Setting Up Due Date Rules
  • 69.2.1 What You Should Know About
• 69.3 Setting Up Work Day Calendars
  • 69.3.1 What You Should Know About
• 69.4 Setting Up Payment Term Codes
  • 69.4.1 Payment Term Codes
  • 69.4.2 Before You Begin
• 69.5 Setting Up Installment Payments
  • 69.5.1 What You Should Know About
• 69.6 Working with Payment Terms for Multi-Tiered Discounts
  • 69.6.1 Before You Begin
  • 69.6.2 Setting Up a Multi-Tiered Due Date Rule
  • 69.6.3 What You Should Know About
  • 69.6.4 Updating the Discount Available for Multi-Tiered Terms
  • 69.6.5 Processing Options

70 Understand Automatic Accounting Instructions

• 70.1 About Automatic Accounting Instructions
• 70.2 About AAI Naming Conventions for A/R
  • 70.2.1 Why Are AAI Suffixes Used?
  • 70.2.2 Additional Information
• 70.3 About Default AAIs for A/R
  • 70.3.1 How Does the System Use AAIs for Company 00000?
  • 70.3.2 How Does the System Search for AAIs?
  • 70.3.3 How Does the System Search AAIs for a Multi-Currency Environment?

71 Work with Automatic Accounting Instructions

• 71.1 Reviewing AAIs
• 71.2 Revising AAIs
• 71.3 Setting Up AAIs for A/R

72 Understand User Defined Codes

• 72.1 About User Defined Codes for A/R
• 72.2 Which User Defined Codes Are Available for A/R?
  • 72.2.1 Document Type Codes
  • 72.2.2 Payment Status Codes (00/PS)
  • 72.2.3 Payment Instrument Codes (00/RY)
  • 72.2.4 Tax Explanation Codes (00/EX)
  • 72.2.5 Aging Vocabulary Codes (03/AG)
  • 72.2.6 Adjustment Reason Codes (03/AR)
  • 72.2.7 Valid Credit Message Codes (00/CM)
  • 72.2.8 Collection Reason Codes (03/CL)
  • 72.2.9 Credit Reporting Payment Terms Codes (03/PT)
  • 72.2.10 Receipt Type Input Codes (03/TI)
  • 72.2.11 Dun & Bradstreet Rating Codes (01/DB)
  • 72.2.12 TRW Rating Codes (01/TR)
  • 72.2.13 Autocash Algorithm Codes (01/AA)
  • 72.2.14 Language Preference Codes (01/LP)

73 Set Up User Defined Codes

• 73.1 Setting Up User Defined Codes for A/R
  • 73.1.1 Example: User Defined Codes Form
  • 73.1.2 What You Should Know About

74 Set Up Next Numbers

• 74.1 Setting Up Next Numbers for A/R
  • 74.1.1 What You Should Know About
• 74.2 Reviewing Standard Next Numbers
• 74.3 Activating Check Digits on Standard Next Numbers
• 74.4 Assigning Next Numbers by Company and Fiscal Year

75 Set Up Customer Bank Information

• 75.1 Setting Up Customer Bank Information
  • 75.1.1 Bank Type Code
  • 75.1.2 Bank Type Code User Defined Table
  • 75.1.3 What You Should Know About
  • 75.1.4 Bank Account by Currency
  • 75.1.5 Effective Date/Expiration Date
  • 75.1.6 What You Should Know About
• 75.2 Adding Customer Bank Account Information
  • 75.2.1 What You Should Know About
• 75.3 Setting Up Bank Account Cross-References for A/R
  • 75.3.1 Adding A/R Cross-References
  • 75.3.2 What You Should Know About
  • 75.3.3 Verifying Cross-References for A/R
    • 75.3.3.1 Reviewing the Bank Account Exception Report
    • 75.3.3.2 Reviewing the Address Book Exception Report
• 75.4 Setting Up Bank Account Addresses
  • 75.4.1 What You Should Know About
• 75.5 Setting Up Bank Account Information for A/R
  • 75.5.1 Before You Begin
  • 75.5.2 Processing Options

76 Set Up A/R Draft Processing

• 76.1 Setting Up AAIs for A/R Drafts
  • 76.1.1 AAIs for Drafts Receivable (RD1x)
  • 76.1.2 AAIs for Drafts Remitted for Cash (RD2x)
  • 76.1.3 AAIs for Drafts Remitted for Discount (RD3x)
• 76.2 Setting Up User Defined Codes for A/R Drafts
  • 76.2.1 Payment Instrument Codes
  • 76.2.2 Pay Status Codes
• 76.3 Setting Up Drafts as the Default Payment Instrument
• 76.4 Setting Up Statements for A/R Drafts
• 76.5 Setting Up Bank Account Information for A/R Drafts
  • 76.5.1 Setting Up Customer Bank Information for A/R Drafts Bank Accounts
  • 76.5.2 What You Should Know About
  • 76.5.3 Printing the Bank Account Exception Report for A/R Drafts
• 76.6 Setting Up Letters for Non-Sufficient Funds
  • 76.6.1 Processing Options

Part XII Statement and Reminder Setup

77 Overview to Statement and Reminder Setup

• 77.1 Objectives
• 77.2 About Statement and Reminder Setup

78 Set Up Statement Messages

• 78.1 Entering Messages for A/R Statements
  • 78.1.1 What You Should Know About
• 78.2 Setting Up Model Messages for Statements
  • 78.2.1 What You Should Know
  • 78.2.2 Processing Options

79 Set Up Text for Payment Reminders

• 79.1 Entering Reminder Messages
  • 79.1.1 What You Should Know About
• 79.2 Setting Up Model Reminder Messages
  • 79.2.1 What You Should Know About

80 Revise Text For Delinquency Notices

• 80.1 Revising Text For Delinquency Notices
  • 80.1.1 Before You Begin
  • 80.1.2 What You Should Know About

81 Work with Interest Rate Information

• 81.1 Defining Interest Rates
  • 81.1.1 What You Should Know About
• 81.2 Entering Text For Interest Invoices
  • 81.2.1 What You Should Know About

Part XIII Batch Invoice Processing

82 Overview to Batch Invoice Processing

• 82.1 Objectives
• 82.2 About Batch Invoice Processing
  • 82.2.1 What Happens When You Process Batch Invoices?
  • 82.2.2 Before You Begin
  • 82.2.3 What You Should Know About
• 82.3 How it Works
  • 82.3.1 Mandatory Fields to Populate in the F0311Z1 File
  • 82.3.2 Mandatory Fields to Populate in the F0911Z1 File
• 82.4 Additional Processing (Receipts, Taxes, Multi-Currency)
  • 82.4.1 Creating Receipt Information
  • 82.4.2 Taxes
    • 82.4.2.1 How to Populate Corresponding F0911Z1 Records for Tax Processing
  • 82.4.3 Multi-Currency
    • 82.4.3.1 F0311Z1
    • 82.4.3.2 F0911Z1
    • 82.4.3.3 F0311Z1
    • 82.4.3.4 F0911Z1
  • 82.4.4 Processing Transactions
  • 82.4.5 Suggestions for Batch Invoice Processing
• 82.5 Purging

83 Review Batch Invoices

• 83.1 Reviewing Batch Information
• 83.2 Reviewing Batch Invoice Detail
  • 83.2.1 What You Should Know About
  • 83.2.2 Processing Options

84 Work with Batch Invoices

• 84.1 Adding Batch Invoices
• 84.2 Revising Unprocessed Batch Invoices
  • 84.2.1 Processing Options

85 Process Batch Invoices

• 85.1 Submitting Invoices for Processing
• 85.2 Verifying Batch Invoice Information
  • 85.2.1 What You Should Know About
• 85.3 Revising Batch Invoices
  • 85.3.1 What You Should Know About
• 85.4 Posting Batch Invoices
  • 85.4.1 Processing Options

86 Purge Processed Batch Invoices

• 86.1 Purging Processed Batch Invoices
  • 86.1.1 What You Should Know About
  • 86.1.2 Processing Options

Part XIV A/R Cash Forecasting & ABC Customer Analysis

87 Forecast A/R Cash Flow

• 87.1 Objectives
• 87.2 About A/R Cash Forecasting
• 87.3 A/R Cash Forecasting
  • 87.3.1 What You Should Know About
  • 87.3.2 Processing Options

88 ABC Customer Analysis

• 88.1 Objectives
• 88.2 About ABC Customer Analysis
• 88.3 Analyzing Customer Account Activity
  • 88.3.1 Before You Begin
  • 88.3.2 How the System Determines the Codes to Assign
  • 88.3.3 Processing Options

Part XV Technical Processes

89 Overview to Technical Processes

• 89.1 Overview

90 Update A/R from the Address Book

• 90.1 Updating A/R from the Address Book
  • 90.1.1 Example: Updating A/R from the Address Book
  • 90.1.2 Updating A/R Category Codes
  • 90.1.3 Processing Options

91 Work with YTD Invoice Amounts

• 91.1 Updating Customer YTD Invoice Amounts
  • 91.1.1 How It Works
  • 91.1.2 Before You Begin
  • 91.1.3 What You Should Know About
  • 91.1.4 Processing Options
• 91.2 Reworking Customer YTD Invoiced Amounts
• 91.3 Reviewing Customer YTD Invoice Amounts
  • 91.3.1 Before You Begin

92 Update Balance Forward Records

• 92.1 Updating Balance Forward Records
  • 92.1.1 Example: Creating Balance Forward Records
  • 92.1.2 Before You Begin
  • 92.1.3 What You Should Know About
  • 92.1.4 Processing Options

93 Customer Master Conversion

• 93.1 Customer Master Conversion
  • 93.1.1 Overview
  • 93.1.2 Processing Options Detail
  • 93.1.3 Conversion
  • 93.1.4 Processing Options

94 Global Updates to Customer Records

• 94.1 Global Updates - Customer Master
  • 94.1.1 Processing Options
• 94.2 Global Updates - Customer Company/Business Unit Records
  • 94.2.1 Processing Options

95 Update Credit Messages

• 95.1 Updating Credit Messages
  • 95.1.1 Before You Begin
  • 95.1.2 What You Should Know About
  • 95.1.3 What You Should Know About

96 Purge A/R Information

• 96.1 Purging Closed A/R Records
  • 96.1.1 Before You Begin
  • 96.1.2 After the Purge
  • 96.1.3 What You Should Know About
  • 96.1.4 Processing Options
  • 96.1.5 Data Selection and Sequence for Purge Closed A/R Records
• 96.2 Purging Batch Receipts
  • 96.2.1 Before You Begin

97 Work with Automatic Debits

• 97.1 Objectives
• 97.2 About Automatic Debits
• 97.3 Processing Automatic Debits
  • 97.3.1 Before You Begin
  • 97.3.2 Processing Options
  • 97.3.3 Data Selection for Processing Automatic Debits
• 97.4 Reviewing and Approving Automatic Debits
• 97.5 Posting Automatic Debits
• 97.6 Copying Files to Tape or Diskette
  • 97.6.1 Processing Options
  • 97.6.2 Data Sequence for Copy Files to Tape or Diskette

Part XVI Processing Options

98 Customer Information Processing Options

• 98.1 Customer Master Information (P01053)
• 98.2 Name Search (P01200)

99 Invoice Processing - Processing Options

• 99.1 Invoice Entry (P03105)
• 99.2 A/R and A/P Journal Entries (P03101)
• 99.3 Speed Invoice Entry (P031015)
• 99.4 General Ledger Post (P09800)
• 99.5 Invoice Journal Report (P03305)
• 99.6 Customer Ledger Inquiry with SQL (P032002)
• 99.7 Account Status Summary (P03203)
• 99.8 Recycle Recurring Invoices (P038101)

100 Manual Receipts Processing - Processing Options

• 100.1 A/R Speed Release (P03114)
• 100.2 Receipts Entry (P03103)
• 100.3 Cash Receipts Statement Inquiry Selection (P03205)
• 100.4 Receipts Entry (P03103)
• 100.5 A/R Receipt and Adjustment Journal Report (P03311)
• 100.6 Receipt Deposit Journal (P03408)

101 Receivables and Payables Netting Processing Options

• 101.1 A/P and A/R Netting (P03455)
• 101.2 Build A/P and A/R Netting File (P03465)
• 101.3 A/P and A/R Netting Report (P03466)

102 Automatic Receipts Processing - Processing Options

• 102.1 Auto Cash Processing - Load Bank Tape (P03551)
• 102.2 Speed Cash Receipts Entry (P03122)
• 102.3 Batch Cash Entry (P03121)
• 102.4 A/R Batch Cash (P03550)

103 Credit and Collections Management Processing Options

• 103.1 Credit Analysis Refresh (P03525)
• 103.2 Account Status Summary (P03203)
• 103.3 Credit Granting and Management (P0305)
• 103.4 Address Book Credit Management/Granting Z File (P0305Z)
• 103.5 Credit Reporting Tape - TRW/Dun & Bradstreet (P03920)
• 103.6 Credit Reporting Tape - CREDITEL (P03920C)
• 103.7 Collections Manager (P03218)
• 103.8 Customer Payment History (P03204)
• 103.9 Activity Log (P0331)
• 103.10 Calculate High Balance (P03526)
• 103.11 Outstanding Credit/Collection Items (P03440)
• 103.12 A/R Summary Report (P03413)
• 103.13 Print Promises, Promises (P013151)

104 A/R Reports Processing Options

• 104.1 A/R Summary Report (P03413)
• 104.2 A/R Detail Report (P034201)
• 104.3 A/R Currency Detail (P03429)
• 104.4 Receivable Summary by Pay Status (P03416)
• 104.5 Multi-Level Open A/R Summary by Parent (P03415)
• 104.6 Open A/R by Business Unit and Address (P03445)
• 104.7 A/R Detail Report (P034201)
• 104.8 A/R Unresolved Matters (P03601)
• 104.9 Problem Accounts Receivable (P036001)
• 104.10 Customer Totals by G/L Account (P09450)

105 A/R Draft Processing - Processing Options

• 105.1 A/R Invoice Print with Draft (P035051)
• 105.2 A/R Statement Print with Draft (P03506)
• 105.3 A/R Batch Draft Creation (P03571)
• 105.4 Receipts Entry (P03103)
• 105.5 Draft Revisions (P03150)
• 105.6 A/R Receipt and Adjustment Journal Report (P03311)
• 105.7 Draft Selection for Bank Payment (P03255)
• 105.8 A/R Magnetic Draft Remittance (P03572)
• 105.9 A/R - Manual Draft Remittance (P03570)
• 105.10 A/R Draft Collection (P03576)
• 105.11 A/R Draft NSF Notification (P03574)

106 Automatic Debits Processing Options

• 106.1 Automatic Debits - USA (P03575)
• 106.2 Copy File to Tape (P03579)

107 Period-End Processing - Processing Options

• 107.1 A/R Credit Note Reimbursements (P03610)
• 107.2 Date File Generation (P03900)
• 107.3 A/R Detail Report (P034201)
• 107.4 Open A/R by Business Unit and Address (P03445)
• 107.5 A/R to G/L by Offset Integrity Report (P037001)
• 107.6 A/R Drafts to G/L by Offset Account (P037002)

108 Statement and Reminder Processing - Processing Options

• 108.1 Finance Charge Update (P01830)
• 108.2 Finance Charge Journal (P03435)
• 108.3 Interest Invoices (P03540)
• 108.4 A/R Statements (P035001)
• 108.5 A/R Invoice Print (P03505)
• 108.6 Payment Reminders (P03530)
• 108.7 Delinquency Notices (P035111)
• 108.8 Reminder Report/Update (P03461)
• 108.9 A/R Detail Report with Reminders Info (P034202)

109 System Setup Processing Options

• 109.1 Batch Update for Multi-Tiered A/P (P005141)
• 109.2 Batch Update for Multi-Tiered A/R (P005142)
• 109.3 Bank Account Information (P04130)
• 109.4 A/R Draft NSF Notification (P03574)

110 Statement and Reminder Set Up Processing Options

• 110.1 A/R Print Messages (P03280)

111 Batch Invoice Processing - Processing Options

• 111.1 Batch Invoice Entry (P0301Z1)
• 111.2 A/R Invoice Batch Processing (P03110Z)
• 111.3 Batch File Purge (P00PURGE)

112 A/R Cash Forecasting Processing Options

• 112.1 A/R Cash Forecasting (P03520)

113 ABC Customer Analysis Processing Options

• 113.1 Customer Analysis (P03602)

114 Technical Processes Processing Options

• 114.1 Update A/R from Address Book (P03802)
• 114.2 Update YTD Invoice Amount (P03820)
• 114.3 Balance Forward Update (P03501)
• 114.4 Customer Master Conversion (P0301E)
• 114.5 Global Update Customer Master (P03490)
• 114.6 Global Update - A/R Company/Business Unit Defaults (P034905)
• 114.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