Oracle Receivables User Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Overview of Oracle Receivables

Receivables Workbenches

Receipts Workbench

Transactions Workbench

Bills Receivable Workbench

Transactions

Entering Transactions

Transactions Window Field Reference

Lines Window Field Reference

Entering Tax Information

Detail Tax Lines Window Field Reference

Entering Freight Information

Freight Window Field Reference

Reviewing Accounting Information

Distributions Window Field Reference

Creating Accounting Information

Entering Revenue Credits

Entering Quick Transactions

Entering Invoices with Rules

Foreign Currency Transactions

Adjusting an Exchange Rate

Viewing Exchange Rate Information for a Receipt or Transaction

Entering Invoices with Installments

Invoices with Rules

Using Rules

Entering Commitments

Batching Transactions for Easy Entry and Retrieval

Completing Transactions

Voiding Transactions

Viewing Transactions

Account Details Field Reference

Placing an Item In Dispute

Copying Invoices

Recurring Invoice Program Report

About Adjustments

Entering Manual Adjustments

Adjustments Field Reference

Creating Automatic Adjustments

AutoAdjustment Reports

Approving Adjustments

XML Receivables Documents

XML Invoices Process Flow

XML Messages

Implementation Considerations

Setting Up Your System for XML Invoice Documents

Sending XML Invoice Documents

Confirming the Import Status of XML Invoice Documents

Troubleshooting XML Invoice Documents

Reviewing and Retransmitting XML Invoice Documents

Document Transfer Message Workflow

Workflow Troubleshooting

Maintaining Transactions

Maintaining Transactions Field Reference

Crediting Transactions

Crediting Transaction Lines

Credit Transactions Field Reference

Reviewing Accounting Information

Reviewing Revenue Credits

Reviewing Freight Information

Reviewing Tax Information

Unapplying Cash when Crediting a Transaction

Updating Credit Memo Installments

Batching Credit Memos

Querying Credit Memos and On-Account Credit Memos

Creating On-Account Credit Memos

Applying On-Account Credit Memos

Updating Credit Memos and On-Account Credit Memos

Accounting for Credit Memos

AME Credit Memo Request Workflow

Setting Up the AME Credit Memo Request Workflow

AME Attributes for the AME Credit Memo Request Workflow

The AME Credit Memo Request Workflow Item Type

Notifications

Customizing the AME Credit Memo Request Process

Summary of the AR Credit Memo Request Approval Process

AR Credit Memo Request Approval Process Activities

Summary of the Collector Approval Subprocess

Collector Approval Subprocess Activities

Summary of the Limits Only Subprocess

Limits Only Subprocess Activities

Summary of the HR Hierarchy Approval Subprocess

HR Hierarchy Approval Subprocess Activities

Summary of the Receivables Approval Subprocess

Receivables Approval Subprocess Activities

Summary of the Credit Memo Creation Subprocess

Credit Memo Creation Subprocess Activities

Running AutoInvoice

AutoInvoice Reports

Correcting AutoInvoice Exceptions

Importing Transaction Information Using AutoInvoice

Overview of AutoInvoice

Preparing Receivables for AutoInvoice

Importing Data From Your Feeder System

AutoInvoice Validation

Using AutoInvoice

Passing Receipt Methods and Customer Bank Accounts

Importing Freight Lines

Importing Tax Lines

Importing Invoices with Rules

Importing Credit Memos

Late Charges

Account Assignments

Transaction Flexfields

Using Grouping Rules to Create Transactions

Using Line Ordering Rules

Determining Dates

Validating Dates

Adjusting General Ledger Dates

Determining Exchange Rates

Receivables Tables

Oracle Exchange Invoice Import Request Set

Using Commitments

Setup and Accounting for Commitments

Printing Transactions

Understanding Your Printed Transactions

Balance Forward Billing

How Receivables Selects Transactions for Balance Forward Billing

Creating Balance Forward Bills

Generating and Printing Draft and Final Balance Forward Bills

Accepting or Rejecting Draft Balance Forward Bills

Reprinting Balance Forward Bills

Imported Billing Number

Revenue Management

Recognizing Revenue

Revenue Recognition Program Execution Report

Revenue Accounting

Adjusting Sales Credits

Using the Revenue Accounting Management (RAM) Wizard

Event-Based Revenue Management

Evaluating Invoices for Event-Based Revenue Management

Payment-Based Revenue Management

Calculating Revenue for Partial Receipt Application

Overpayments

Receipt Application Examples

Monitoring Contingencies with the Revenue Contingency Analyzer

Modifying Invoices Under Collectibility Analysis

Receipts

Entering Receipts

Receipts Field Reference

Applying Receipts

Applying Receipts in Detail

Applications Field Reference

Managing Prepayment Receipts

Prepayments Process Flow

Setting Up Prepayments

Managing Your Customers' Prepayments

Cross Currency Receipts

Setting Up Cross Currency Receipts

Applying Cross Currency Receipts - Examples

Applying Cross Currency Receipts

Cross Currency Exchange Gain/Loss Report

Receivables Application Rule Sets

Chargebacks and Adjustments

Entering Miscellaneous Receipts

Reversing Receipts

Reapplying Receipts

Reviewing Receipts and Applications

Batching Receipts for Easy Entry and Retrieval

Notes Receivable

Setting Up Notes Receivable

Creating a Note Receivable

Clearing Notes Receivable

Reversing a Note Receivable

Accounting for Notes Receivable

Notes Receivable Report

Reversed Notes Receivable Report

Using AutoLockbox

AutoLockbox Validation

How AutoLockbox Identifies Customers for a Receipt

How AutoLockbox Applies Receipts

Implementing a Custom Matching Rule

How AutoLockbox Creates Claims

Importing and Applying Cross Currency Receipts

Alternate Name Receipt Matches Window

Commonly Asked Questions

Running AutoLockbox

AutoLockbox Field Reference

Lockbox Execution Report

Maintaining Lockbox Transmission Data

Viewing Transmission History

QuickCash

Post QuickCash

Running Post QuickCash

Post QuickCash Execution Report

AutoCash

Discounts

Writing Off Receipts

Creating Manual Receipt Write-Offs

Creating Automatic Receipt Write-Offs

Write-Off Process

Create Receipt Write-off Field References

Working with Claims

Creating Claims

Resolving Claims

Payables and Receivables Netting

Cash Application Work Queue

Electronic Payment Processing

Remitting Electronic Payments

Automatic Receipts

Troubleshooting the Automatic Receipts Process

Flagging Transactions for Automatic Receipts

Creating Automatic Receipts

Manually Entering Automatic Receipts

Numbering Automatic Receipts

Viewing Receipts at Risk

Automatic Receipts and Remittances Execution Report

Approving Automatic Receipts

Formatting Automatic Receipts

Format Automatic Receipts Report

Confirming Automatic Receipts

Reporting on Automatic Receipts and Remittances

Accounting for Automatic Receipts and Remittances

About Remittances

Formatting Remittance Layouts

Factoring Remittances

Creating Remittance Batches

Approving Remittance Batches

Formatting Remittance Batches

Format Automatic Remittances Report

Automatic Clearing for Receipts

Automatic Clearing for Receipts Execution Report

Using Oracle Cash Management to Clear Receipts

Reconciling Receipts Using Oracle Cash Management

Credit Cards

Credit Card Validation and Integration

Setting Up Receivables for Credit Card Transactions and Payments

Processing Credit Card Transactions

Creating Credit Card Transactions

Importing Credit Card Transactions

Creating and Approving Automatic Receipt Batches

Creating and Approving Remittance Batches

Creating Manual Receipts

Credit Card Chargebacks

Correcting Funds Transfer Errors

Creating Refunds

Credit Card Refunds

Processing Credit Card Refunds

Viewing Credit Card Refund Activity on the Customer Account

Correcting Credit Card Refund Errors

Reversing Receipts with Credit Card Refunds

Accounting for Exchange Rate Gains and Losses When Applying Credit Card Refunds

Automated Receipt Handling for Credits

Automated Receipt Handling Process Flow

Setting Up the Automated Receipt Handling Process

Exception Conditions for the Automated Receipt Handling Process

Bills Receivable

Bills Receivable Overview

Bills Receivable Creation

Bills Receivable Accounting

Manually Creating a Bill Receivable

Entering Bills Receivable Bank Account Information

Manually Assigning Transactions to a Bill Receivable

Using Selection Criteria to Assign Transactions to a Bill Receivable

Flagging Transactions for Automatic or Direct Exchange into Bills Receivable

Batching Transactions for Bills Receivable

Batching Transactions Using the Bills Receivable Batch Creation Concurrent Program

Exchanging a Transaction for a Bill Receivable

Exchanging a Bill Receivable for a New Bill Receivable

Completing a Bill Receivable

Accepting a Bill Receivable

Printing a Bill Receivable

Bills Receivable Stamp Values

Stamp Values Report

Bills Receivable Management

Viewing Bills Receivable

Bills Receivable Portfolio Management Window Reference

Bills Receivable Portfolio Management Window Field Restrictions

Viewing Bills Receivable Assignments

Viewing Bills Receivable History

Viewing Bills Receivable Transaction Information

Updating Bills Receivable

Accepting a Bill Receivable

Canceling a Bill Receivable

Recalling a Bill Receivable

Marking a Bill Receivable as Unpaid

Eliminating or Reestablishing Risk on a Bill Receivable

Holding or Releasing from Hold a Bill Receivable

Endorsing a Bill Receivable

Exchanging a Bill Receivable

Restating a Bill Receivable

Marking a Bill Receivable as Under Protest

Bills Receivable Reports

Bills Receivable Remittance

Creating Receipts for Bills Receivable Remittances

Accounting for Bills Receivable Remittances and Receipts

Exporting and Importing Bills Receivable Remittances

Creating a Bills Receivable Remittance Batch

Maintaining Bills Receivable Remittances

Formatting and Printing Bills Receivable Remittances

Payments Received Prior to Remittance Approval

Bills Receivable Maturity and Risk Program and Report

Reversing and Unapplying Receipts for Bills Receivable

Customers

Customers Overview

Data Quality Management Overview

Searching for Customers

Entering and Updating Customer Information

Creating and Updating Customers

Creating a Customer

Adding and Updating Accounts

Adding and Updating Customer Profiles

Entering and Updating Customer Communication Information

Defining and Updating Party Relationships

Using Party Paying Relationships

Adding and Updating Customer Tax Profiles

Creating and Updating Accounts

Creating an Account

Adding and Updating Account Sites

Adding and Updating Account Profiles

Defining and Updating Account Profile Amounts

Entering and Updating Account Payment Details

Entering and Updating Account Communication Information

Defining and Updating Account Relationships

Entering and Updating Account Order Management Information

Adding and Updating Account Late Charges

Creating and Updating Account Sites

Creating an Account Site

Adding and Updating Account Site Business Purposes

Entering and Updating Account Site Details

Entering and Updating Account Site Communication Information

Entering and Updating Account Site Payment Details

Adding and Updating Account Site Profiles

Defining and Updating Account Site Profile Amounts

Adding and Updating Account Site Tax Profile

Adding and Updating Account Site Late Charges

Customer and Account Site Duplication Prevention

Customer Duplication Prevention

Address Duplication Prevention

Invalid Address Creation Prevention

Contact Duplication Prevention

Creating and Updating Contacts

Creating and Updating Account Contacts

Creating and Updating Account Site Contacts

Creating and Updating Contact Points

Creating and Updating Customer Contact Points

Creating and Updating Contact Points for Account Contacts

Creating and Updating Account Site Contact Points

Creating and Updating Contact Points for Account Site Contacts

Defining Customer Account Drawee Sites

Oracle Exchange Customer Import Request Set

Collections

Managing Collections

Collections Features for Receivables

Oracle Advanced Collections Features

Reprinting Historical Dunning Letters

Printing a Collection Report

Credit Holds

Calculating Late Charges

Determining the Past Due Amount

Currencies Without Rates

Generating Late Charges

Reviewing Late Charge Batches

Statements

Defining a Statement Site

Printing Statements

Cross Site and Cross Customer Receipts

Sample Statement

Accounting for Receivables

Opening and Closing Accounting Periods

Accounting in Receivables

Multi-Fund Accounts Receivable

Receivables Accounting Event Model

Using AutoAccounting

Defining AutoAccounting - Overview

AutoAccounting Structure

How to Use AutoAccounting

Creating Accounting in Receivables

Using Oracle Subledger Accounting Inquiries

Oracle Subledger Accounting Reports

Posting

Reconciling Receivables

Reconciling Subledger Details

Reconciling Receipts

Reconciling General Ledger Details

Using Cash Basis Accounting

Accrual vs. Cash Basis Accounting

Journal Entries

Preparing Receivables

Viewing Accounting Lines in Receivables

Drilling Down to Oracle Receivables from Oracle General Ledger

Viewing MRC Details for a Transaction

Default Accounting for Transactions

Technical Perspective: Transactions

Invoices

Debit Memos

Commitments

Invoice Against a Deposit

Invoice Against a Guarantee

Credit Memos

On-Account Credit Memos

Unapplied Receipts

Applied Receipts

Reverse Receipts

Miscellaneous Receipts

Chargebacks

Adjustments

Receivables Standard Reports and Listings

Running Standard Reports and Listings

Common Report Parameters

Common Report Parameters for Reconciliation Reports

Common Report Headings

Accounting Reports

Reconciliation Reports

Execution Reports

Collection Reports

Invoice Print Reports

Listing Reports

Country-Specific Reports

Account Status Report

Accounting Rules Listing Report

Actual Receipt Report

Adjustment Approval Report

Adjustment Register

Aging Reports

Alternate Customer Name Receipt Matching Report

Applied Receipts Register

AR Reconciliation Report

AR to GL Reconciliation Report

Audit Report by Document Number

AutoCash Rules Report

Automatic Receipt Batch Management Report

Automatic Receipts Awaiting Confirmation Report

Automatic Transactions Batch Report

Bad Debt Provision Report

Bank Risk Report

Billing and Receipt History

Billing History Report

Bills Receivable By Status Report

Bills Receivable Format Report Program

Bills Receivable Reminder Letters

Bills Receivable Remittance Batch Management Report

Bills Receivable Summary Report

Collection Effectiveness Indicators

Commitment Balance Report

Contingency-Based Deferred Revenue Report

Credit Hold Report

Credit Limit Usages Report

Cumulative Activity Balance Report

Customer Balance Revaluation Report

Customer Credit Snapshot Report

Customer Listing Detail and Summary Reports

Customer Open Balance Letter

Customer Profiles Report

Customer Relationships Listing

Deposited Cash Reports - Applied Detail and Open Detail

Discount Projection Report

Disputed Invoice Report

Dunning History - Receivables Generated Letters Only

Duplicate Customer Report

European Sales Listing

Incomplete Invoices Report

Intercompany Invoice Report

Intercompany Receipts Report

Invoice Exception Report

Invoice Print Preview Report

Invoices Posted to Suspense

Journal Entries Report

Journal with GL Details Report

Late Charges Report

Miscellaneous Receipts Register

Open Items Revaluation Report

Ordering and Grouping Rules Listing

Other Applications Report

Other Receipt Applications Report

Past Due Invoice Report

Payment Terms Listing

Print Invoice Reports

Potential Reconciling Items Report

Projected Gains and Losses Report

Receipt Analysis - Days Late Report

Receipt Forecast Report

Receipt Journal

Receipt Register

Receipts Awaiting Bank Clearance

Receipts Awaiting Remittance Report

Receipts Without Sites Report

Receivables Key Indicators Report and Receipts Key Indicators Report

Remittance Batch Management Report

Revenue Exceptions Report

Reversed Receipts Report

Sales Journal by Customer

Sales Journal by GL Account

Sales Register

Setup Details Report

Standard Memo Lines Listing

Statements

Transaction Batch Sources Listing

Transaction Detail Report

Transaction Reconciliation Report

Transaction Register

Transaction Types Listing

Transactions Awaiting Consolidation

Transactions Check Report

Transactions Key Indicators Report/Customers and Transactions Key Indicators Report

Unapplied and Unresolved Receipts Register

Unposted Items Report

Update Customer Profiles Report

Work Load Review Report

Archive and Purge

Using Archive and Purge

Preparing to Run Archive and Purge

Archive and Purge Cycle

Purge Criteria

Tables Purged

Archive Level

Data not Archived

Monitoring Your Archive and Purge

Archive Tables

Running Archive and Purge

Archive and Purge Parameters

Archive Summary/Detail Reports

Oracle Receivables Menu Paths

Receivables Navigation Paths

Oracle Receivables Documents on the Desktop

Desktop Documents

Attachments in Oracle Receivables

Attachments in Receivables

Oracle Receivables Transaction Printing Views

Transaction Printing Views

Multi-Fund Accounts Receivable Accounting Examples

Multi-Fund Accounts Receivable Balancing and Accounting Method Example

Balancing Method

Account Method

Cash Receipts in Multi-Fund Accounts Receivable Model

Cash Receipts Example

Credit Memo Examples

Multi Fund Accounts Receivables Receipt Examples

Adjusting Multi-Fund Accounts Receivable Invoice Examples

Image Reference

Text description of the Receipts Workbench Graphic

Text description of the Transactions Workbench Graphic

Text description of the Collections Workbench Graphic

Text Description of the AutoInvoice Overview Graphic

Text Description of the Bill in Advance Accounting Entries Graphic

Text Description of the Bill in Arrears Entries Graphic

Text Description of the Processing Notes Receivable Graphic

Text Description of the Automatic Receipts Graphic

Text Description of the Reporting on Automatic Receipts and Remittances Graphic

Text Description of the Statement Cycles Graphic

Index

Oracle Receivables User Guide

Contents