RECEIVABLES

(1)

Oracle

r

Receivables

User Guide

RELEASE 11i VOLUME 1

September 2001

(2)

Oracler Receivables User Guide Release 11i

The part number for this volume is A81018–02. Please use the set part number to reorder this book, A80838–02.

Primary Author: Charles Ahern, Stephen R. Damiani, Robert MacIsaac, Kristin Penaskovic Major Contributors: Craig Borchardt, William Hogan, Lee Konstantinou, Essan Ni

Contributors: Nilesh Acharya, Vikram Ahluwalia, Ramakant Alat, Chelvi Balasubramian, Olga Basman, Sharmila Bhavsar, Victoria Crisostomo, Ed Cheng, Ravi Dasani, Vish Bhupathiraju Editt, Alan Fothergill, Sushama Borde, K.C. Buckley, Renee Connors, Dianna Ferguson, Editt Gonen–Fried-man, Manoj Gudivaka, Miranda Ho, Debbie Jancis, Govind Jayanth, Martin Johnson, Charity Kocher, Yanya Kong, Peggy Larson, Joyce Leung, Scott Lucey, Kavi Namdakumar, Sai Rangarajan, Saloni Shah, Oliver Steinmeier, Mien Lin Tan, Tasman Tang, Anne Truitt, Genneva Wang, Kathy Weitzel

The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual and industrial property law. Reverse engineering, disassembly or decompilation of the Programs is prohibited.

Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other purpose.

The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation.

If the Programs are delivered to the US Government or anyone licensing or using the Programs on behalf of the US Government, the following notice is applicable:

RESTRICTED RIGHTS LEGEND

Programs delivered subject to the DOD FAR Supplement are ’commercial computer software’ and use, duplication and disclosure of the Programs including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are ’restricted computer software’ and use, duplication and disclosure of the Programs shall be subject to the restrictions in FAR 52.227–19, Commercial Computer Software – Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065.”

(3)

Overview of Setting Up. . . 2 – 2 Related Product Setup Steps . . . 2 – 3 Setup Checklist . . . 2 – 7 Setup Steps . . . 2 – 10 Accounting Rules . . . 2 – 30 Aging Buckets. . . 2 – 33 Application Rule Sets. . . 2 – 37 Approval Limits . . . 2 – 40 Using the Account Generator in Oracle Receivables . . . 2 – 42 Decide How to Use the Account Generator . . . 2 – 45

(4)

The Default Account Generator Process

for Oracle Receivables . . . 2 – 46 Customizing the Account Generator

for Oracle Receivables . . . 2 – 49 AutoAccounting . . . 2 – 52 AutoCash Rule Sets . . . 2 – 56 AutoInvoice Line Ordering Rules . . . 2 – 62 Automatic Receipt Programs . . . 2 – 64 Banks . . . 2 – 66 Defining Banks. . . 2 – 67 Defining Bank Accounts. . . 2 – 69 Banks Window Reference. . . 2 – 75 Bank Accounts Window Reference. . . 2 – 78 Bank Branch Validation by Country . . . 2 – 84 Bank Account Validation by Country . . . 2 – 85 Bank Charges . . . 2 – 86 Bank Transaction Codes . . . 2 – 87 Collectors . . . 2 – 88 Distribution Sets . . . 2 – 90 Implementing Document Sequences . . . 2 – 92 Overview of Document Sequencing. . . 2 – 94 Setting Up Document Sequences . . . 2 – 96 Sample Implementation . . . 2 – 100 Dunning Letters . . . 2 – 103 Dunning Letters Format Files . . . 2 – 105 Creating Dunning Letters . . . 2 – 107 Creating Dunning Letter Sets . . . 2 – 109 Freight Carriers. . . 2 – 115 Grouping Rules. . . 2 – 116 Header and Line Level Rounding . . . 2 – 120 Item Status . . . 2 – 122 Items . . . 2 – 123 Deleting Items . . . 2 – 124 Defining Receivables Lookups . . . 2 – 126 Reviewing and Updating Receivables Lookups. . . 2 – 128

(5)

Lockboxes . . . 2 – 138 Organizations . . . 2 – 143 Using the Multiple Organization Support Feature . . . 2 – 145 Payment Methods. . . 2 – 146 Payment Terms . . . 2 – 157 Payment Terms Field Reference . . . 2 – 163 Receipt Classes . . . 2 – 164 Receipt Sources . . . 2 – 167 Receivables Activities . . . 2 – 170 Remit–To Addresses. . . 2 – 176 Salespersons . . . 2 – 179 Standard Memo Lines . . . 2 – 184 Standard Messages. . . 2 – 188 Statement Cycles. . . 2 – 189 Defining Receivables System Options. . . 2 – 191 Accounting System Options . . . 2 – 193 Tax System Options. . . 2 – 196 Transactions and Customers System Options. . . 2 – 204 Miscellaneous System Options . . . 2 – 208 Tax Codes and Rates . . . 2 – 214 Tax Locations and Rates . . . 2 – 219 Defining Tax Accounting for Tax Codes and Locations . . . 2 – 222 Reviewing Sales Tax Rates . . . 2 – 224 Tax Authorities . . . 2 – 226 Tax Exemptions. . . 2 – 228 Tax Groups. . . 2 – 232 Tax Rate Exceptions . . . 2 – 238 Territories. . . 2 – 240 Territory Flexfield . . . 2 – 241 Maintaining Countries and Territories. . . 2 – 242 Transaction Batch Sources. . . 2 – 244 Transaction Batch Sources Field Reference . . . 2 – 250 Transaction Types . . . 2 – 251 Transmission Formats . . . 2 – 260 Unit of Measure Classes . . . 2 – 267 Units of Measure. . . 2 – 268

(6)

Chapter 3 Customers . . . 3 – 1

Customer Overview. . . 3 – 2 Entering Parties and Customer Accounts . . . 3 – 6 Fuzzy Search . . . 3 – 12 Customer Accounts Field Reference. . . 3 – 19 Assigning Banks to Customer Accounts . . . 3 – 24 Assigning Payment Methods to Customer Accounts . . . 3 – 27 Entering Marketing Information. . . 3 – 29 Entering Addresses for Customer Accounts. . . 3 – 30 Addresses Field Reference . . . 3 – 35 Characteristics Field Reference . . . 3 – 37 Assigning a Business Purpose to a Customer Address . . . 3 – 38 Defining Customer Account Drawee Sites . . . 3 – 43 Business Purposes Field Reference. . . 3 – 46 Entering Customer Account Contacts . . . 3 – 50 Entering Customer Account Contact Roles. . . 3 – 52 Contacts and Roles Field Reference . . . 3 – 53 Entering Customer Telephone Numbers . . . 3 – 55 Creating Customer Account Relationships . . . 3 – 58 Defining Customer Profile Classes . . . 3 – 61 Customer Profile Classes Field Reference . . . 3 – 65 Assigning Profile Classes to Customers or Addresses . . . 3 – 68 Updating a Customer Profile Class . . . 3 – 70 Flexible Addresses . . . 3 – 72 Address Style Mappings . . . 3 – 74 Flexible Addresses with the Sales Tax Location Flexfield . . . 3 – 85 Setting Up Flexible Addresses. . . 3 – 86 Creating Custom Address Styles . . . 3 – 89 Using Flexible Addresses. . . 3 – 94 Address Validation. . . 3 – 96 Sales Tax Location Flexfield Structure . . . 3 – 97 Address Validation Level. . . 3 – 98 Defining Flexible Address Validation . . . 3 – 100

(7)

Customer Interface. . . 3 – 121 Preparing Receivables. . . 3 – 124 Interface Data Required to Run Customer Interface . . . 3 – 125 System Tables Updated by Customer Interface . . . 3 – 130 A Sample Customer Import. . . 3 – 132 Creating Unique Customer References . . . 3 – 135 Importing Customers Using Customer Interface. . . 3 – 137 Customer Interface Transfer Report . . . 3 – 140 Party or Customer Search Scenarios and Display Results . . 3 – 143 Contact Search Scenarios . . . 3 – 146 Setting Up Word Replacement Rules for Fuzzy Searches . . . 3 – 147

Chapter 4 Transactions . . . 4 – 1

Entering Transactions. . . 4 – 2 Transactions Window Field Reference . . . 4 – 7 Lines Window Field Reference . . . 4 – 12 Reviewing Accounting Information. . . 4 – 16 Accounting Window Field Reference. . . 4 – 18 Entering Freight Information. . . 4 – 19 Freight Window Field Reference. . . 4 – 20 Entering Tax Information . . . 4 – 21 Tax Window Field Reference . . . 4 – 24 Entering Revenue Credits . . . 4 – 25 Entering Quick Transactions . . . 4 – 28 Entering Invoices with Rules. . . 4 – 30 Foreign Currency Transactions. . . 4 – 33 Recognizing Revenue. . . 4 – 38 Revenue Recognition Program Execution Report . . . 4 – 41 Revenue Accounting . . . 4 – 42 Entering Invoices with Installments . . . 4 – 47 Entering Commitments . . . 4 – 48 Batching Transactions for Easy Entry and Retrieval . . . 4 – 51 Completing Transactions. . . 4 – 53 Voiding Transactions. . . 4 – 56 Copying Invoices . . . 4 – 57 Recurring Invoice Program Report. . . 4 – 61 Printing Transactions . . . 4 – 62

(8)

Maintaining Transactions . . . 4 – 65 Maintaining Transactions Field Reference. . . 4 – 66 Crediting Transactions. . . 4 – 75 Crediting Transaction Lines. . . 4 – 79 Credit Transactions Field Reference . . . 4 – 81 Reviewing Accounting Information. . . 4 – 85 Reviewing Revenue Credits . . . 4 – 87 Reviewing Freight Information . . . 4 – 88 Reviewing Tax Information . . . 4 – 90 Unapplying Cash when Crediting a Transaction . . . 4 – 91 Updating Credit Memo Installments . . . 4 – 92 Batching Credit Memos . . . 4 – 93 Querying Credit Memos and On–Account Credits . . . 4 – 95 Creating On–Account Credits . . . 4 – 96 Applying On–Account Credits . . . 4 – 98 Updating Credit Memos and On–Account Credits . . . 4 – 100 Accounting for Credit Memos . . . 4 – 102 Credit Memo Request Workflow . . . 4 – 129 Customizing the Credit Memo Request Process . . . 4 – 130 The Credit Memo Request Workflow Item Type . . . 4 – 132 Summary of the Credit Memo Request Process. . . 4 – 136 Credit Memo Request Process Activities. . . 4 – 138 Summary of the Collector Approval Subprocess . . . 4 – 144 Collector Approval Subprocess Activities. . . 4 – 146 Summary of the Primary Approval Subprocess . . . 4 – 154 Primary Approval Subprocess Activities . . . 4 – 156 Summary of the HR Management Approval Subprocess . . . 4 – 163 HR Management Approval Subprocess Activities. . . 4 – 165 Summary of the Receivables Approval Subprocess . . . 4 – 173 Receivables Approval Subprocess Activities . . . 4 – 175 Summary of the Credit Memo Creation Subprocess. . . 4 – 181 Credit Memo Creation Subprocess Activities . . . 4 – 183 Notifications . . . 4 – 186 Setting Up Credit Memo Request Workflow . . . 4 – 187 Initiating the Credit Memo Request Process . . . 4 – 191

(9)

Importing Invoice Information Using AutoInvoice . . . 4 – 204 Overview of AutoInvoice. . . 4 – 205 Preparing Receivables for AutoInvoice . . . 4 – 206 Importing Data From Your Feeder System . . . 4 – 212 AutoInvoice Validation. . . 4 – 214 Using AutoInvoice . . . 4 – 216 Passing Payment Methods and

Customer Bank Accounts. . . 4 – 220 Importing Freight Lines . . . 4 – 222 Importing Tax Lines . . . 4 – 224 Importing Invoices with Rules . . . 4 – 228 Importing Credit Memos . . . 4 – 230 Finance Charges. . . 4 – 231 Account Assignments. . . 4 – 232 Transaction Flexfields . . . 4 – 234 Using Grouping Rules to Create Transactions . . . 4 – 240 Using Line Ordering Rules . . . 4 – 243 Determining Dates . . . 4 – 245 Validating Dates . . . 4 – 250 Adjusting General Ledger Dates. . . 4 – 252 Determining Exchange Rates. . . 4 – 253 Receivables Tables. . . 4 – 253 Importing Transactions Using AutoInvoice . . . 4 – 254 AutoInvoice Reports . . . 4 – 257 Correcting AutoInvoice Exceptions . . . 4 – 259 About Adjustments . . . 4 – 262 Entering Manual Adjustments . . . 4 – 265 Adjustments Field Reference. . . 4 – 268 Creating Automatic Adjustments. . . 4 – 269 AutoAdjustment Reports . . . 4 – 272 Approving Adjustments . . . 4 – 274 Invoices with Rules . . . 4 – 276 Using Rules . . . 4 – 282 Using AutoAccounting . . . 4 – 289 AutoAccounting Structure. . . 4 – 290 How to Use AutoAccounting . . . 4 – 293 Defining AutoAccounting – Overview . . . 4 – 295 Using Commitments . . . 4 – 296 Understanding Your Printed Transactions . . . 4 – 303 Consolidated Billing. . . 4 – 307 Setting Up Consolidated Billing . . . 4 – 310

(10)

Imported Billing Number . . . 4 – 313 How Receivables Selects Transactions

for Consolidated Billing . . . 4 – 315 Printing Consolidated Billing Invoices . . . 4 – 317

Chapter 5 Bills Receivable . . . 5 – 1

Bills Receivable Overview. . . 5 – 2 Bills Receivable Creation . . . 5 – 4 Bills Receivable Accounting. . . 5 – 5 Manually Creating a Bill Receivable . . . 5 – 6 Entering Bills Receivable Bank Account Information . . . 5 – 9 Manually Assigning Transactions to a Bill Receivable . . . 5 – 11

Using Selection Criteria to Assign Transactions

to a Bill Receivable . . . 5 – 13 Flagging Transactions for Automatic or

Direct Exchange into Bills Receivable . . . 5 – 15 Batching Transactions for Bills Receivable . . . 5 – 17

Batching Transactions Using the

Bills Receivable Batch Creation Concurrent Program . . . 5 – 20 Exchanging a Transaction for a Bill Receivable . . . 5 – 22 Exchanging a Bill Receivable for a New Bill Receivable. . . 5 – 24 Completing a Bill Receivable . . . 5 – 25 Accepting a Bill Receivable . . . 5 – 27 Printing a Bill Receivable. . . 5 – 28 Bills Receivable Stamp Values . . . 5 – 30 Stamp Values Report. . . 5 – 31 Bills Receivable Management . . . 5 – 33 Bills Receivable View and Analysis . . . 5 – 33 Bills Receivable Updates . . . 5 – 34 Viewing Bills Receivable . . . 5 – 35 Bills Receivable Portfolio Management Window Reference . . . . 5 – 36

Bills Receivable Portfolio Management

Window Field Restrictions. . . 5 – 39 Viewing Bills Receivable Assignments . . . 5 – 42 Viewing Bills Receivable History . . . 5 – 43

(11)

Eliminating or Reestablishing Risk on a Bill Receivable . . . . 5 – 50 Holding or Releasing from Hold a Bill Receivable . . . 5 – 51 Endorsing a Bill Receivable . . . 5 – 52 Exchanging a Bill Receivable. . . 5 – 53 Restating a Bill Receivable . . . 5 – 53 Marking a Bill Receivable as Under Protest . . . 5 – 54 Bills Receivable Reports. . . 5 – 55 Bills Receivable Remittance . . . 5 – 56 Creating Receipts for Bills Receivable Remittances . . . 5 – 57 Accounting for Bills Receivable Remittances and Receipts . 5 – 58 Exporting and Importing Bills Receivable Remittances . . . . 5 – 65 Creating a Bills Receivable Remittance Batch . . . 5 – 67 Maintaining Bills Receivable Remittances . . . 5 – 74 Formatting and Printing Bills Receivable Remittances . . . 5 – 76 Payments Received Prior to Remittance Approval . . . 5 – 77 Bills Receivable Maturity and Risk Program and Report. . . 5 – 78 Reversing and Unapplying Receipts for Bills Receivable . . . 5 – 80

Chapter 6 Receipts . . . 6 – 1

Entering Receipts . . . 6 – 2 Receipts Field Reference. . . 6 – 7 Applying Receipts . . . 6 – 11 Cross Currency Receipts . . . 6 – 18 Setting Up Cross Currency Receipts. . . 6 – 21 Applying Cross Currency Receipts – Examples . . . 6 – 23 Applying Cross Currency Receipts . . . 6 – 30 Cross Currency Exchange Gain/Loss Report . . . 6 – 34 Applications Field Reference. . . 6 – 37 Receivables Application Rule Sets . . . 6 – 39 Chargebacks and Adjustments. . . 6 – 46 Entering Miscellaneous Receipts . . . 6 – 51 Reversing Receipts . . . 6 – 54 Reapplying Receipts. . . 6 – 58 Reviewing Receipts and Applications. . . 6 – 60 Batching Receipts for Easy Entry and Retrieval . . . 6 – 63 Bills of Exchange. . . 6 – 67

(12)

Creating Bills of Exchange . . . 6 – 70 Notes Receivable. . . 6 – 72 Setting Up Notes Receivable . . . 6 – 76 Creating a Note Receivable . . . 6 – 77 Clearing Notes Receivable . . . 6 – 79 Reversing a Note Receivable . . . 6 – 80 Accounting for Notes Receivable . . . 6 – 82 Notes Receivable Report . . . 6 – 83 Reversed Notes Receivable Report. . . 6 – 85 Using AutoLockbox . . . 6 – 87 How AutoLockbox Identifies Customers for a Receipt. . . 6 – 92 How AutoLockbox Applies Receipts . . . 6 – 96 Importing and Applying Cross Currency Receipts . . . 6 – 105 AutoLockbox Validation . . . 6 – 111 Alternate Name Receipt Matches Window . . . 6 – 115 Commonly Asked Questions. . . 6 – 116 Running AutoLockbox . . . 6 – 121 AutoLockbox Field Reference . . . 6 – 126 Lockbox Execution Report . . . 6 – 129 Maintaining Lockbox Transmission Data . . . 6 – 132 Viewing Transmission History . . . 6 – 135 QuickCash . . . 6 – 137 Post QuickCash . . . 6 – 142 Running Post QuickCash . . . 6 – 145 Post QuickCash Execution Report . . . 6 – 147 AutoCash . . . 6 – 149 Discounts . . . 6 – 162 Automatic Receipts . . . 6 – 171 Troubleshooting the Automatic Receipts Process. . . 6 – 173 Flagging Transactions for Automatic Receipts . . . 6 – 177 Creating Automatic Receipts . . . 6 – 179 Manually Entering Automatic Receipts. . . 6 – 184 Automatic Receipts and Remittances Execution Report . . . . 6 – 185 Approving Automatic Receipts. . . 6 – 186 Formatting Automatic Receipts . . . 6 – 188

(13)

Factoring Remittances . . . 6 – 201 Creating Remittance Batches . . . 6 – 203 Approving Remittance Batches. . . 6 – 209 Formatting Remittance Batches. . . 6 – 211 Format Automatic Remittances Report . . . 6 – 212 Automatic Clearing for Receipts . . . 6 – 213 Automatic Clearing for Receipts Execution Report . . . 6 – 215 Using Oracle Cash Management to Clear Receipts . . . 6 – 216 Reconciling Receipts Using Oracle Cash Management . . . 6 – 217 Writing Off Unapplied Receipts . . . 6 – 218 Creating Manual Receipt Write–Offs . . . 6 – 218 Creating Automatic Receipt Write–Offs . . . 6 – 220 Write–Off Process . . . 6 – 222 Create Receipt Write–off Field References. . . 6 – 224 Other Receipt Applications Report. . . 6 – 226

Chapter 7 Collections . . . 7 – 1

Reviewing a Customer Account. . . 7 – 2 Customer Accounts Window Reference . . . 7 – 5 Viewing Account Activity for a Specific Period of Time. . . . 7 – 6 Viewing Account Balances by Aging Bucket . . . 7 – 8 Aging Window Field Reference . . . 7 – 11 Viewing Transactions . . . 7 – 13 Account Details Field Reference . . . 7 – 20 Viewing Dunning History. . . 7 – 21 Customer Calls . . . 7 – 22 Recording Call Actions. . . 7 – 25 Placing an Item In Dispute. . . 7 – 28 Credit Holds. . . 7 – 32 Customer Correspondence . . . 7 – 34 Reviewing Collector Actions . . . 7 – 35 Printing a Collection Report . . . 7 – 38 Dunning Letters . . . 7 – 40 Specifying a Days Past Due Range . . . 7 – 41 Defining Dunning Profiles for

Customers and Customer Sites . . . 7 – 43 How Receivables Selects Items for Dunning. . . 7 – 45 Staged Dunning. . . 7 – 47 Printing Dunning Letters . . . 7 – 57 Table and Column Descriptions . . . 7 – 59 Calculating Finance Charges . . . 7 – 62

(14)

Determining the Past Due Amount . . . 7 – 64 Currencies Without Rates. . . 7 – 66 Accruing Finance Charges . . . 7 – 67 Compounding Finance Charges . . . 7 – 68 Preparing Receivables for Accruing and

Compounding Finance Charges . . . 7 – 70 Setting Up Receivables to Calculate Finance Charges . . . 7 – 71 Statements . . . 7 – 74 Defining a Statement Site . . . 7 – 78 Printing Statements . . . 7 – 79 Cross Site and Cross Customer Receipts . . . 7 – 82 Sample Statement . . . 7 – 83

Chapter 8 Accounting for Receivables. . . 8 – 1

Posting . . . 8 – 2 Running General Ledger Interface . . . 8 – 6 Posting Execution Report. . . 8 – 8 Opening and Closing Accounting Periods . . . 8 – 10 Reconciling Receivables. . . 8 – 12 Reconcile Outstanding Customer Balances. . . 8 – 14 Reconcile Transactions . . . 8 – 16 Reconcile Receipts . . . 8 – 17 Reconcile Account Balances. . . 8 – 19 Using Cash Basis Accounting . . . 8 – 22 Accrual vs. Cash Basis Accounting. . . 8 – 23 Journal Entries . . . 8 – 29 Preparing Receivables. . . 8 – 30 Accounting for Transactions . . . 8 – 32 Technical Perspective: Transactions . . . 8 – 40 Invoices . . . 8 – 49 Debit Memos . . . 8 – 52 Commitments . . . 8 – 53 Invoice Against a Deposit . . . 8 – 55 Invoice Against a Guarantee . . . 8 – 58 Credit Memos . . . 8 – 61

(15)

Adjustments. . . 8 – 81 Viewing Accounting Lines. . . 8 – 83 Drilling Down to Oracle Receivables

from Oracle General Ledger . . . 8 – 87

Chapter 9 Archive and Purge. . . 9 – 1

Using Archive and Purge . . . 9 – 2 Preparing to Run Archive and Purge. . . 9 – 4 Archive and Purge Cycle . . . 9 – 7 Purge Criteria. . . 9 – 13 Tables Purged. . . 9 – 17 Archive Level. . . 9 – 18 Data not Archived . . . 9 – 23 Monitoring Your Archive and Purge . . . 9 – 24 Archive Tables . . . 9 – 32 Running Archive and Purge . . . 9 – 60 Archive and Purge Parameters . . . 9 – 62 Archive Summary/Detail Reports. . . 9 – 66

Chapter 10 Receivables Standard Reports and Listings. . . 10 – 1

Running Standard Reports and Listings. . . 10 – 2 Common Report Parameters . . . 10 – 3 Common Report Headings . . . 10 – 6 Accounting Reports . . . 10 – 7 Collection Reports. . . 10 – 9 Execution Reports . . . 10 – 10 Invoice Print Reports . . . 10 – 10 Listing Reports. . . 10 – 11 Other Reports. . . 10 – 12 Tax Reports. . . 10 – 13 Reports and Listings . . . 10 – 14 Account Status Report . . . 10 – 15 Accounting Rules Listing Report . . . 10 – 16 Actual Receipt Report . . . 10 – 18 Adjustment Approval Report. . . 10 – 20 Adjustment Register. . . 10 – 22

(16)

Aging – 4 and 7 Bucket Reports . . . 10 – 25 Aging Reports . . . 10 – 30 Alternate Customer Name Receipt Matching Report . . . 10 – 34 Applied Receipts Register . . . 10 – 35 AR Reconciliation Report . . . 10 – 38 Audit Report by Document Number. . . 10 – 39 AutoCash Rules Report . . . 10 – 41 Automatic Receipt Batch Management Report . . . 10 – 42 Automatic Receipts Awaiting Confirmation Report . . . 10 – 44 Automatic Transactions Batch Report . . . 10 – 45 Bad Debt Provision Report . . . 10 – 48 Bank Risk Report . . . 10 – 50 Billing and Receipt History. . . 10 – 51 Billing History Report . . . 10 – 53 Bills Receivable By Status Report. . . 10 – 55 Bills Receivable Format Report Program . . . 10 – 58 Bills Receivable Reminder Letters . . . 10 – 60 Bills Receivable Remittance Batch Management Report . . . 10 – 62 Bills Receivable Summary Report . . . 10 – 65 Call Actions Report . . . 10 – 67 Collection Effectiveness Indicators . . . 10 – 68 Collection Key Indicators Report . . . 10 – 71 Collections by Collector Report . . . 10 – 72 Collections Receipt Forecast Report . . . 10 – 73 Collector Call History Report . . . 10 – 74 Collector’s Follow Up Report. . . 10 – 75 Commitment Balance Report . . . 10 – 76 Credit Hold Report. . . 10 – 77 Customer Balance Revaluation Report . . . 10 – 80 Customer Credit Snapshot Report. . . 10 – 82 Customer Follow Up History Report . . . 10 – 86 Customer Listing Detail and Summary Reports . . . 10 – 87 Customer Open Balance Letter. . . 10 – 95

(17)

Dunning Letters – Preliminary Report . . . 10 – 109 Dunning Letter Generate. . . 10 – 112 Duplicate Customer Report . . . 10 – 114 European Sales Listing. . . 10 – 115 Incomplete Invoices Report . . . 10 – 117 Intercompany Invoice Report . . . 10 – 118 Intercompany Receipts Report . . . 10 – 119 Invoice Exception Report . . . 10 – 120 Invoice Print Preview Report . . . 10 – 121 Invoices Posted to Suspense . . . 10 – 123 Journal Entries Report . . . 10 – 125 Journal with GL Details Report . . . 10 – 128 Miscellaneous Receipts Register . . . 10 – 131 Open Items Revaluation Report . . . 10 – 134 Ordering and Grouping Rules Listing . . . 10 – 138 Other Applications Report . . . 10 – 140 Past Due Invoice Report . . . 10 – 141 Payment Terms Listing . . . 10 – 142 Print Invoice Reports . . . 10 – 143 Projected Gains and Losses Report . . . 10 – 154 Receipt Analysis – Days Late Report. . . 10 – 156 Receipt Journal Report. . . 10 – 157 Receipt Promises Report . . . 10 – 159 Receipt Register . . . 10 – 160 Receipts Awaiting Bank Clearance . . . 10 – 162 Receipt Forecast Report . . . 10 – 163 Receipts Awaiting Remittance Report. . . 10 – 165 Receipts Without Sites Report . . . 10 – 167 Receivables Key Indicators Report/

Receipts Key Indicators Report . . . 10 – 168 Remittance Batch Management Report. . . 10 – 173 Reversed Receipts Report . . . 10 – 175 Sales Journal by Customer . . . 10 – 177 Sales Journal by GL Account . . . 10 – 179 Sales Register. . . 10 – 181 Sample Dunning Letter Print . . . 10 – 184 Standard Memo Lines Listing. . . 10 – 185 Statements . . . 10 – 186 Supplier Customer Netting Report . . . 10 – 191

(18)

Transactions Awaiting Consolidation . . . 10 – 193 Transaction Batch Sources Listing . . . 10 – 195 Transactions Check Report . . . 10 – 196 Transaction Detail Report . . . 10 – 198 Transaction Reconciliation Report . . . 10 – 201 Transaction Register . . . 10 – 203 Transaction Types Listing . . . 10 – 206 Transactions Key Indicators Report/

Customers and Transactions Key Indicators Report. . . 10 – 207 Unposted Items Report . . . 10 – 211 Unapplied Receipts Register. . . 10 – 213 Update Customer Profiles Report . . . 10 – 215

Appendix A Oracle Receivables Menu Paths . . . A – 1

Receivables Navigation Paths. . . A – 2 Oracle Receivables Character Mode Forms and Corresponding GUI Windows . . . A – 9

Appendix B Oracle Receivables Profile Options. . . B – 1

Profile Options . . . B – 2 Overview of Receivables User Profile Options. . . B – 4 Profile Options in Oracle Order Management . . . B – 31 Profile Options in Oracle General Ledger . . . B – 32

Appendix C Oracle Receivables Function Security. . . C – 1

Function Security in Oracle Receivables . . . C – 2 Receivables Functions. . . C – 4 Customer Window Parameters . . . C – 11

Appendix D Attachments in Oracle Receivables . . . D – 1

(19)

Error Messages . . . F – 2 Customer Interface Error Messages . . . F – 2 AutoInvoice Error Messages . . . F – 13 AutoLockbox Error Messages . . . F – 23

Appendix G Oracle Receivables Table and Column Descriptions. . . G – 1

Customer Interface Table Descriptions and Validation . . . G – 2 AutoInvoice Table and Column Descriptions . . . G – 38 Lockbox Tables and Column Descriptions . . . G – 97 Receipt and QuickCash Tables . . . G – 97 Lockbox Interface Table and Column Descriptions . . . G – 98

Appendix H Oracle Receivables Transaction Printing Views . . . H – 1

Transaction Printing Views . . . H – 2

(20)

(21)

Preface

Welcome to Release Release 11i of the Oracle Receivables User Guide. This user guide includes the information you need to work with Oracle Receivables effectively. It contains detailed information about the following:

• Overview and reference information

• Oracle Receivables implementation suggestions

• Specific tasks you can accomplish using Oracle Receivables • How to use Oracle Receivables windows

• Oracle Receivables programs, reports, and listings • Oracle Receivables functions and features

• Oracle Receivables system setup

The preface explains how this user guide is organized and introduces other sources of information that can help you.

(22)

Audience for This Guide

This guide assumes you have a working knowledge of the following: • The principles and customary practices of your business area. • Oracle Receivables

If you have never used Oracle Receivables, we suggest you attend one or more of the Oracle Receivables training classes available through Oracle University.

• The Oracle Applications graphical user interface.

To learn more about the Oracle Applications graphical user interface, read the Oracle Applications User Guide.

See Other Information Sources for more information about Oracle Applications product information.

How To Use This Guide

This guide contains the information you need to understand and use Oracle Receivables.

This preface explains how this user guide is organized and introduces other sources of information that can help you. This guide contains the following chapters:

• Chapter 1 provides a brief introduction to the graphical user interface (GUI) and the three Receivables workbenches. • Chapter 2 describes the steps required to set up Oracle

Receivables.

Note: There is no separate implementation manual for Oracle Receivables. All implementation information is included in this user guide.

• Chapter 3 explains how to enter and maintain customers in Oracle Receivables. This chapter also includes information about profile classes, flexible addresses, and the Customer Merge and Customer Import programs.

(23)

• Chapter 5 explains how to create, track, analyze, and modify bills receivables.

• Chapter 6 explains how to enter, apply, and remit receipts in Receivables. This chapter also explains how to set up discounts, use AutoLockbox, create Automatic Receipts, and reconcile receipts.

• Chapter 7 explains the collections process and the various forms and windows that are part of the Collections workbench. This chapter also tells you how to use dunning letters, calculate finance charges, and print customer statements.

• Chapter 8 describes the accounting entries that Oracle

Receivables creates when you enter transactions, apply receipts, and create adjustments. This chapter also tells you how to reconcile customer accounts and transfer transactions to the General Ledger.

• Chapter 9 explains the Archive and Purge program which you can run periodically to improve system performance.

• Chapter 10 explains how to submit a report request and briefly describes each Oracle Receivables report and listing.

• Appendices A–H provide information about profile options, function security, attachments, documents on the desktop, open interface error messages, transaction printing views, table and column descriptions, and Oracle Receivables navigation paths.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle Corporation is actively engaged with other market–leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code

(24)

require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle Corporation does not own or control. Oracle Corporation neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Finding Out What’s New

From the HTML help window for Oracle Receivables, choose the section that describes new features or what’s new from the expandable menu. This section describes:

• New features in 11i. This information is updated for each new release of Oracle Receivables.

• Information about any features that were not yet available when this user guide was printed. For example, if your system administrator has installed software from a mini pack as an upgrade, this document describes the new features.

Other Information Sources

You can choose from many sources of information, including online documentation, training, and support services, to increase your knowledge and understanding of Oracle Receivables.

If this guide refers you to other Oracle Applications documentation, use only the Release 11i versions of those guides unless we specify otherwise.

(25)

The HTML version of this guide is optimized for onscreen reading, and you can use it to follow hypertext links for easy access to other HTML guides in the library. When you have an HTML window open, you can use the features on the left side of the window to navigate freely throughout all Oracle Applications documentation.

• You can use the Search feature to search by words or phrases. • You can use the expandable menu to search for topics in the

menu structure we provide. The Library option on the menu expands to show all Oracle Applications HTML documentation. You can view HTML help in the following ways:

• From an application window, use the help icon or the help menu to open a new Web browser and display help about that window. • Use the documentation CD.

• Use a URL provided by your system administrator.

Your HTML help may contain information that was not available when this guide was printed.

Related User Guides

Oracle Receivables shares business and setup information with other Oracle Applications products. Therefore, you may want to refer to other user guides when you set up and use Oracle Receivables. You can read the guides online by choosing Library from the

expandable menu on your HTML help window, by reading from the Oracle Applications Document Library CD included in your media pack, or by using a Web browser with a URL that your system administrator provides.

If you require printed guides, you can purchase them from the Oracle store at http://oraclestore.oracle.com.

User Guides Related to All Products

Oracle Applications User Guide

This guide explains how to navigate the system, enter data, and query information, and introduces other basic features of the GUI available with this release of Oracle Receivables (and any other Oracle

(26)

You can also access this user guide online by choosing “Getting Started and Using Oracle Applications” from the Oracle Applications help system.

Oracle Alert User Guide

Use this guide to define periodic and event alerts that monitor the status of your Oracle Applications data.

Oracle Applications Implementation Wizard User Guide

If you are implementing more than one Oracle product, you can use the Oracle Applications Implementation Wizard to coordinate your setup activities. This guide describes how to use the wizard.

Oracle Applications Developer’s Guide

This guide contains the coding standards followed by the Oracle Applications development staff. It describes the Oracle Application Object Library components needed to implement the Oracle

Applications user interface described in the Oracle Applications User

Interface Standards. It also provides information to help you build your

custom Oracle Developer forms so that they integrate with Oracle Applications.

Oracle Applications User Interface Standards

This guide contains the user interface (UI) standards followed by the Oracle Applications development staff. It describes the UI for the Oracle Applications products and how to apply this UI to the design of an application built by using Oracle Forms.

User Guides Related to This Product

Oracle General Ledger User Guide

Use this manual when you plan and define your chart of accounts, accounting period types and accounting calendar, functional currency,

(27)

Oracle Cash Management User Guide

This manual provides information about using Oracle Cash Management to clear your receipts, as well as reconciling bank statements with your outstanding balances, transactions, and receipts.

Oracle Purchasing User Guide

If you install Oracle Purchasing, refer to this user guide to read about entering and managing the purchase orders to which you match invoices.

Oracle Inventory User Guide

This manual explains how to define your items, units of measure classes, units of measure, and unit of measure conversions for use in measuring amounts for your units of production items, as well as other information about setting up and using Oracle Inventory.

Using Oracle HRMS – The Fundamentals

This manual explains how to enter your employees, so you can enter expense reports for them. It also explains how to set up organizations and site locations.

Country–Specific Manuals

Use these manuals to meet statutory requirements and common business practices in your country or region. They also describe additional features added to Oracle Receivables to meet those requirements. Look for a user guide appropriate to your country; for example, see the Oracle Financials for the Czech Republic User Guide for more information about using this software in the Czech Republic.

Multiple Reporting Currencies in Oracle Applications

If you use the Multiple Reporting Currencies feature to report and maintain accounting records in more than one currency, refer to this manual before implementing Oracle Receivables. The manual details additional steps and setup considerations for implementing Oracle Receivables with this feature.

(28)

Multiple Organizations in Oracle Applications

If you use the Oracle Applications Multiple Organization Support feature to use multiple sets of books for one Oracle Receivables installation, use this guide to learn how to set up and use Oracle Receivables with this feature.

Oracle Receivables Tax Manual

This manual provides everything you need to know about calculating tax within Oracle Receivables, Oracle Order Management, Oracle Sales and Marketing, and Oracle Web Customers. It includes information about implementation procedures, setup forms and windows, the Oracle Receivables tax calculation process, tax reports and listings, and tax–specific open interfaces.

Oracle Business Intelligence System Implementation Guide

This guide provides information about implementing Oracle Business Intelligence (BIS) in your environment.

Oracle Applications Flexfields Guide

This guide provides flexfields planning, setup, and reference

information for the Oracle Receivables implementation team as well as for users responsible for the ongoing maintenance of Oracle

Applications product data. This guide also provides information on creating custom reports on flexfields data.

Installation and System Administration Guides

Oracle Applications Concepts

This guide provides an introduction to the concepts, features,

technology stack, architecture, and terminology for Oracle Applications Release 11i. It provides a useful first book to read before an installation of Oracle Applications. This guide also introduces the concepts behind, and major issues, for Applications–wide features such as Business

(29)

is handled using Rapid Install, which minimizes the time it takes to install Oracle Applications and the Oracle 8i Server technology stack by automating many of the required steps. This guide contains

instructions for using Rapid Install and lists the tasks you need to perform to finish your installation. You should use this guide in conjunction with individual product user guides and implementation guides.

Upgrading Oracle Applications

Refer to this guide if you are upgrading your Oracle Applications Release 10.7 or Release 11.0 products to Release 11i. This guide describes the upgrade process in general and lists database upgrade and product–specific upgrade tasks. You must be at either Release 10.7 (NCA, SmartClient, or character mode) or Release 11.0 to upgrade to Release 11i. You cannot upgrade to Release 11i directly from releases prior to 10.7.

Maintaining Oracle Applications

Use this guide to help you run the various AD utilities, such as AutoUpgrade for 11i, AutoPatch, AD Administration, AD Controller, Relink, and others. It contains how–to steps, screenshots, and other information that you need to run the AD utilities.

(30)

Oracle Applications Product Update Notes

Use this guide as a reference if you are responsible for upgrading an installation of Oracle Applications. It provides a history of the changes to individual Oracle Applications products between Release 11.0 and Release 11i. It includes new features and enhancements and changes made to database objects, profile options, and seed data for this interval.

Oracle Applications System Administrator’s Guide

This guide provides planning and reference information for the Oracle Applications System Administrator. It contains information on how to define security, customize menus and online help, and manage

processing.

Oracle eTechnical Reference Manuals

Each eTechnical Reference Manual (eTRM) contains database diagrams and a detailed description of database tables, forms, reports, and programs for a specific Oracle Applications product. This information helps you convert data from your existing applications, integrate Oracle Applications data with non–Oracle

Oracle Workflow Guide

This guide explains how to define new workflow business processes as well as customize existing Oracle Applications–embedded workflow processes. You also use this guide to complete the setup steps necessary for any Oracle Applications product that includes workflow–enabled processes.

(31)

Training and Support

Training

We offer a complete set of training courses to help you and your staff master Oracle Applications. We can help you develop a training plan that provides thorough training for both your project team and your end users. We will work with you to organize courses appropriate to your job or area of responsibility.

Training professionals can show you how to plan your training throughout the implementation process so that the right amount of information is delivered to key people when they need it the most. You can attend courses at any one of our many Educational Centers, or you can arrange for our trainers to teach at your facility. We also offer Net classes, where training is delivered over the Internet, and many multimedia–based courses on CD. In addition, we can tailor standard courses or develop custom courses to meet your needs.

Support

From on–site support to central support, our team of experienced professionals provides the help and information you need to keep Oracle Receivables working for you. This team includes your Technical Representative, Account Manager, and Oracle’s large staff of

consultants and support specialists with expertise in your business area, managing an Oracle server, and your hardware and software environment.

(32)

Do Not Use Database Tools to Modify Oracle Applications Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle Applications data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle Applications data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle Applications tables are interrelated, any change you make using Oracle Applications can update many tables at once. But when you modify Oracle Applications data using anything other than Oracle Applications, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle Applications.

When you use Oracle Applications to modify your data, Oracle Applications automatically checks that your changes are valid. Oracle Applications also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.

(33)

About Oracle

Oracle Corporation develops and markets an integrated line of software products for database management, applications development, decision support, and office automation, as well as Oracle Applications, an integrated suite of more than 160 software modules for financial management, supply chain management, manufacturing, project systems, human resources and customer relationship management.

Oracle products are available for mainframes, minicomputers, personal computers, network computers and personal digital assistants,

allowing organizations to integrate different computers, different operating systems, different networks, and even different database management systems, into a single, unified computing and information resource.

Oracle is the world’s leading supplier of software for information management, and the world’s second largest software company. Oracle offers its database, tools, and applications products, along with related consulting, education, and support services, in over 145 countries around the world.

Your Feedback

Thank you for using Oracle Receivables and this user guide. We value your comments and feedback. This guide contains a Reader’s Comment Form you can use to explain what you like or dislike about Oracle Receivables or this user guide. Mail your

comments to the following address or call us directly at (650) 506–7000. Oracle Applications Documentation Manager

Oracle Corporation 500 Oracle Parkway

Redwood Shores, CA 94065 U.S.A.

(34)

(35)

C H A P T E R

1

T

Overview of Oracle

Receivables

his chapter provides a short introduction to the graphical user interface (GUI) available with Oracle Receivables as well as a detailed description of the three Oracle Receivables workbenches.

(36)

Receivables Workbenches

Oracle Receivables provides four integrated workbenches that you can use to perform most of your day–to–day Accounts Receivable

operations. You can use the Receipts Workbench to perform most of your receipt–related tasks and the Transactions Workbench to process your invoices, debit memos, credit memos, on–account credits, chargebacks, and adjustments. The Collections Workbench lets you review customer accounts and perform collection activities such as recording customer calls and printing dunning letters. The Bills Receivable Workbench lets you create, update, remit, and manage your bills receivable.

Each workbench lets you find critical information in a flexible way, see the results in your defined format, and selectively take appropriate action. For example, in the Transactions Workbench, you can query transactions based on the bill–to or ship–to customer, currency, transaction number, or General Ledger date. You can then review financial, application, and installment information, perform

adjustments, create a credit memo, or complete the transaction. All of the windows you need are accessible from just one window, so you can query a transaction once, then perform several operations without having to find it again.

Function Security

You may not have access to every window, button, or tabbed region within a workbench. This is because your system administrator may be using Function Security to prevent users with your responsibility from performing specific Receivables operations. For example, your

responsibility might allow you to enter receipts but prevent you from deleting them. For more information, see: Function Security in Oracle Receivables: page C – 2.

Folders

Several of the windows in the Receivables workbenches are folders. Folders let you choose which fields you want to view and where they appear in a window. You can tell if a window is a folder if an open

(37)

Summary and Detail Windows

The Receipts and Transactions workbenches let you view records one at a time or as a group. Detail windows display only one receipt or transaction at a time, but provide more information about the record because they contain more fields and tabbed regions. Summary windows, by contrast, can display multiple records at once but require that you ”drill down” to the detail window to view additional

information about the current record. Following is a list of the available detail and summary windows within the Receivables Workbenches:

• Receipts Workbench: Receipts, Receipts Summary, Receipt Batches and Receipt Batches Summary

• Transactions Workbench: Transactions and Transactions Summary, Transactions Batches and Transaction Batches Summary

• Remittances / Remittances Summary

Find Windows

Find windows are available within each of the Receivables

workbenches. These windows let you search for information based on a specific set of criteria that you specify. For example, the Find

Transactions window lets you search for multiple records by entering a range of transaction numbers, dates, batches, or transaction types. You can also retrieve a single record by entering a specific document or transaction number. You can access Find windows from the Query menu.

List of Values

The list of values is a powerful, time saving feature that lets you choose valid data for a field from a predefined list. If the <List> lamp appears when your cursor is in a field, you can choose the List of Values icon to view a list of valid entries for that field. Simply click on the value you want; Receivables enters the data you selected and moves the cursor to the next field in the window.

Tools menu

In the Receipts, Transactions, and Bills Receivable Workbenches, the Tools pulldown menu lets you perform operations in addition to those provided by the action buttons. For example, in the Receipts

Workbench, you can view the sum of multiple receipts in the Receipt Totals window, and review the functional currency gain or loss

(38)

resulting from a currency exchange rate adjustment in the Receipt History window.

In the Transactions Workbench, the Tools menu provides access to functions that are not accessible via action buttons. For example, in the Transactions window there is no Copy button, but you can still copy a transaction by choosing Copy To from the Tools menu. Similarly, the Balances button does not appear in the Transactions Summary window, but you can display the Transaction Balances window by choosing Balances from the Tools menu.

In the Bills Receivable Workbench, the Tools menu provides additional functionality for managing bills receivable. For example, in the Bills Receivable window you can view exchange rate information for currencies that are different from the functional currency, or use the Exchange option to exchange a bill receivable for a new bill receivable.

View Accounting Windows

In the Receipts and Transactions workbenches you can view the detail accounting lines for an item in the form of a balanced accounting entry (i.e., debits equal credits) by choosing View Accounting from the Tools menu. You can also choose to view the detail accounting as t–accounts. Use these features to see how a transaction affects the account balances in your general ledger.

Note: You can also view detail accounting lines for adjustments from the Adjustments window.

See Also

Receipts Workbench: page 1 – 5 Transactions Workbench: page 1 – 10 Collections Workbench: page 1 – 15 Bills Receivable Workbench: page 1 – 19

(39)

Receipts Workbench

Use the Receipts Workbench to create receipt batches and enter, apply, reverse, reapply, and delete individual receipts. You can enter receipts manually, import them using AutoLockbox, or create them

automatically. You can also use this workbench to clear or risk

eliminate factored receipts, remit automatic receipts, create chargebacks and adjustments, and submit Post QuickCash to automatically update your customer’s account balance.

Default Attributes

When you enter receipts individually, Receivables provides default values for the following attributes in the Receipts and Receipts Summary windows: • Currency • Deposit Date • Maturity Date • GL Date • Receipt Date • Receipt Type

When you enter receipts as part of a batch, receipts that you enter inherit the following attributes, in addition to those listed above:

• Payment method • Receipt class

You can also set up default values for new receipt batches. For example, you define the batch source ’Standard’ and set Automatic Batch Numbering to Yes for this source. You also set the profile option AR: Receipt Batch Source to ’Standard’ (see below). Then, when you create a new batch, Receivables uses Standard Source as the default batch source and automatically generates a unique batch number when you save.

Other profile options that you can setup to provide default values in the Receipts Workbench include:

• AR: Default Exchange Rate Type This option determines the default value for the exchange rate type that appears in the exchange rate window of the Receipts and Receipts Summary windows. Valid values are Corporate Exchange Rate, Spot Exchange Rate, and User Specified Rate.

(40)

• AR: Receipt Batch Source This option determines the default receipt batch source in the Receipts and Receipt Batches windows.

For more information, see: Overview of Receivables User Profile Options: page B – 4.

Folder Windows

The following windows in the Receipts Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu:

• Applications

• Lockbox Transmission Data • QuickCash

• Receipt Batches Summary • Receipts Summary • Remittances Summary

(41)

Figure 1 – 1 Receipts Workbench

Refer to the table below to help you use the Receipts Workbench and the corresponding Receivables documentation more effectively. An NA in the Window/ tabbed region column indicates that the

documentation for that topic is an essay or general description of the feature; therefore, the corresponding window name is not applicable.

(42)

Topic Section/Task Window/tabbed region

Adjustments Create an Adjustment: page 6 – 48 Applications window, choose the Adjustments button. Applying Receipts Apply Receipts: page 6 – 11 Receipts or Receipts Summary

window Approving

Remittances

Approve Remittance Batches: page 6 – 209

Remittances window AutoCash AutoCash: page 6 – 149 NA

AutoLockbox Using AutoLockbox: page 6 – 87 Running AutoLockbox: page 6 – 121

Submit Lockbox Processing window

Create Automatic Receipts: page 6 – 179

Receipt Batches window Automatically Create Remittance

Batches: page 6 – 203

Remittances window Automatically Select Transactions

for Application (Mass Apply button): page 6 – 11

Applications widow

Approve Automatic Receipts: page 6 – 186

Receipt Batches window Format Automatic Receipts: page

6 – 188

Receipt Batches window Manually Enter Automatic

Receipts: page 6 – 184

Receipts window Confirm Automatic Receipts: page

6 – 190

Receipts or Receipts Summary window

Batch Batching Receipts for Easy Entry and Retrieval: page 6 – 63

Receipt Batches or Receipt Batches Summary window Chargebacks Chargebacks and Adjustments:

page 6 – 46

Applications window, choose the Chargebacks button. Clearing Receipts Automatic Clearing for Receipts: Run Automatic Clearing

(43)

Window/tabbed region Section/Task

Topic

Entering Receipts Enter Receipts: page 6 – 2 Receipts; or Receipts Summary window

Factoring Remittances Factor Remittances: page 6 – 201 Remittances Formatting Automatic

Receipts

Format Automatic Receipts: page 6 – 188

Receipt Batches window Formatting Remittance

Batches

Format Remittance Layouts: page 6 – 198

Remittances window Lockbox Using AutoLockbox: page 6 – 87

Running AutoLockbox: page 6 – 121

Submit Lockbox Processing window

Maintaining Lockbox Transmission

Maintain Lockbox Transmission: page 6 – 132

Lockbox Transmission Data Note Receivable Create a Note Receivable: page

6 – 77

Receipts window

Post QuickCash Post QuickCash: page 6 – 145 Receipt Batches Summary window

QuickCash QuickCash: page 6 – 137 Receipt Batches window Reapplying Receipts Reapply Receipts: page 6 – 58 Applications window Reconciling Receipts Reconcile Receipts: page 6 – 217 Reconcile Bank Statements

window (Oracle Cash Management) Remitting Receipts Create Remittance Batches: page

6 – 197 Remittances window

Remittances Create Remittance Batches: page 6 – 203

Remittances window Format Remittance Layouts: page

6 – 198

NA Approve Remittance Batches:

page 6 – 209

Remittances window

Reversing Receipts Reverse Receipts: page 6 – 54 Receipts or Receipts Summary window

Reviewing Receipts and Applications

Review Receipts and Applications: page 6 – 60

Applications window

(44)

Topic

Risk Eliminating Factored Receipts

Automatic Clearing for Receipts: page 6 – 213

Run Automatic Clearing window

Transmission History Viewing Lockbox Transmission History: page 6 – 135

Transmission History window

Table 1 – 1 (Page 3 of 3)

See Also

Transactions Workbench: page 1 – 10 Collections Workbench: page 1 – 15

Transactions Workbench

Use the Transactions Workbench to create new and update existing invoices, debit memos, credit memos, on–account credits, chargebacks, and commitments within Receivables. You can also use this workbench to enter, review, or complete transactions, copy invoices, create

adjustments, credit transactions, and review invoice installments.

When you enter transactions individually, Receivables provides default values for the following attributes in the Transactions and the

Transactions Summary windows:

• Date

(45)

Folder Windows

The following windows in the Transactions Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu:

• Lines

• Transaction Batches Summary • Transactions Summary Figure 1 – 2 Transactons Workbench

Refer to the table below to help you use the Transactions Workbench and the corresponding Receivables documentation more effectively. An NA (not applicable) in the Window/ tabbed region column indicates that the documentation for that topic is an overview or topical essay.

(46)

Accounting Review Accounting Information: page 4 – 16

Accounting for Transactions: page 8 – 32

Accounting window NA

Adjustments About Adjustments: page 4 – 262 Enter Manual Adjustments: page 4 – 265

Create Automatic Adjustments: page 4 – 269

NA

Adjustments window

Create AutoAdjustments window Addresses Define Remit To Addresses: page

2 – 195

Remit To Addresses window AutoAccounting Using AutoAccounting: page

4 – 289

Define AutoAccounting: page 2 – 55

NA

AutoAccounting window AutoInvoice Import Transactions Using

AutoInvoice: page 4 – 254 Overview of AutoInvoice: page 4 – 205

Run AutoInvoice window NA

Banks Define Banks: page 2 – 69 Define Bank Charges: page 2 – 102

Banks window Bank Charges window Batch Batch Transactions: page 4 – 51

Define Transaction Batch Sources: page 2 – 273

Transaction Batches or Transaction Batches Summary window

Transaction Batch Sources window

Chargeback Enter Commitments: page 4 – 48 Using Commitments: page 4 – 296

Chargebacks window NA

Commitments Enter Commitments: page 4 – 48 Using Commitments: page 4 – 296

Transactions or Transactions Summary window

Complete Complete Transactions: page 4 – 53

(47)

Topic

Credit Credit Transactions: page 4 – 75 Create On–Account Credits: page 4 – 96

Credit Transactions window Applications window Finance Charges Calculate Finance Charges: page

7 – 62

Define Customer Profile Classes: page 3 – 61

Customer Profile Classes window Customer Profile Classes window Freight Define Freight Carriers: page

2 – 132

Enter Freight Information: page 4 – 19

Freight Carriers window Freight window

Guarantee Enter Commitments: page 4 – 48 Using Commitments: page 4 – 296

Import Import Transactions Using AutoInvoice: page 4 – 254

Run AutoInvoice window Installments Enter Invoices with Installments:

page 4 – 47

Line Enter Transaction Lines: page 4 – 2

Credit Transaction Lines: page 4 – 79

Lines window (from Transactions window

Lines window (from Credit Transactions window) Maintain Maintain Transactions: page

4 – 66

On–Account Credits Create On–Account Credits: page 4 – 96

Applications window Payment Methods Define Payment Methods: page

2 – 164

Payment Methods window Payment Terms Define Payment Terms: page

2 – 175

Payment Terms window Print Print Transactions: page 4 – 62

Understanding Your Printed Transactions: page 4 – 303

Print Transactions window NA

Rules Enter Invoice with Rules: page 4 – 30

Invoices with Rules: page 4 – 276

NA Sales Credits Entering Revenue Credits: page

4 – 25

Sales Credits window

(48)

Topic

Tax Enter or Review Tax Information: page 4 – 21

Calculating Tax (Oracle Receivables

Tax Manual)

Tax window NA

Transactions Enter Transactions: page 4 – 2 Accounting for Transactions: page 8 – 32

Import Transactions Using AutoInvoice: page 4 – 254 Print Transactions: page 4 – 62

Run AutoInvoice window Print Invoices window Types Define Transaction Types: page

2 – 280

Transaction Types window Update Transaction Maintain Transactions: page

4 – 66

Table 1 – 2 (Page 3 of 3)

See Also

Receipts Workbench: page 1 – 5 Collections Workbench: page 1 – 15

(49)

Collections Workbench

Use the Collections Workbench windows to view information about your customers’ transactions and account balances in a variety of ways. You can also use this workbench to place a customer account on credit hold, place items in dispute, view the dunning history for a transaction, and correspond with customers by recording customer calls.

Most of the windows in the Collections Workbench are view–only windows; that is, you can view information, but you cannot make any changes.

Folder Windows

The following windows in the Collections Workbench are Folder windows. You can customize the appearance of these windows by selecting options from the Folder menu:

• Account Details • Customer Account • Scheduler

(50)

Figure 1 – 3 Collections Workbench

Refer to the table below to help you use the Collections Workbench and the corresponding Receivables documentation more effectively. An NA (not applicable) in the Window/ tabbed region column indicates that the documentation for that topic is an overview or topical essay.

(51)

Account Review a Customer Account: page 7 – 2 View Account Activity for a Specific Period: page 7 – 6

View Balances by Aging Bucket: page 7 – 8

Customer Account window Account Overview window Aging or Account Details window

Actions Review Collector Actions: page 7 – 35 Completing a Collection Action: page 7 – 37

Scheduler window Actions window (from Customer Calls window) Aging View Balances by Aging Bucket: page

7 – 8

Define Aging Buckets: page 2 – 34

Aging or Account Details window

Aging Buckets window Calls Overview of Customer Calls: page

7 – 22

Record Call Actions: page 7 – 25 Complete a Call Action: page 7 – 37

Customer Calls window Actions window (from Customer Calls window) Actions window (from Customer Calls window) Collector Define Collectors: page 2 – 104 Collectors window Correspondence Overview of Customer

Correspondence: page 7 – 34

NA

Dispute Place an Item in Dispute: page 7 – 28 Actions window (from Customer Calls window) Dunning View Dunning History: page 7 – 21

Define Dunning Letters: page 2 – 120 Print Dunning Letters: page 7 – 57 Overview of Dunning Letters: page 7 – 40

Dunning History window Dunning Letters window Print Dunning Letters window NA

Finance Charges Overview of Calculating Finance Charges: page 7 – 62

Accruing Finance Charges: page 7 – 67 Compounding Finance Charges: page 7 – 68

NA

System Options window Customers window Holds Place/Remove Customer Credit Hold:

page 7 – 32

Customer Account window

(52)

Topic

Print Print Statements: page 7 – 79 Print Dunning Letters: page 7 – 57 Print a Collection Report: page 7 – 38

Print Statements window Print Dunning Letters window Print Collection Reports window

Report Print a Collection Report: page 7 – 38 Print Collection Reports window

Statements Print Statements: page 7 – 79 Define a Statement Site: page 7 – 78

Sample Statement: page 7 – 83

Print Statements window Business Purposes window (from Customer Addresses window)

NA Transactions View Transactions: page 7 – 13

View Transaction Balances: page 7 – 18 View Balances by Aging Bucket: page 7 – 8

Account Details or Transaction Overview window

Balances window Aging or Account Details window

Table 1 – 3 (Page 2 of 2)

See Also

Receipts Workbench: page 1 – 5 Transactions Workbench: page 1 – 10

(53)

☞

Bills Receivable Workbench

Use the Bills Receivable Workbench to create, update, remit, and manage bills receivable. You can create a bill receivable and assign transactions to the bill either manually or automatically. You can also use this workbench to review bills receivable, update the status of a bill, and create and maintain bills receivable remittance batches. The Bills Receivable Workbench also manages creating and applying receipts, and eliminating risk on remitted bills receivable. You can also exchange a transaction for a bill receivable in the Transactions Workbench, review a customer’s bills receivable transactions in the Collections Workbench, and use the Receipts Workbench to reverse or unapply receipts applied to bills receivable.

Enabling the Bills Receivable Workbench

To use bills receivable in Oracle Receivables, you must enable the Bills Receivable Workbench. Your system administrator or other responsible user must carry out the implementation steps necessary to enable Bills Receivable and make the Bills Receivable features available in the Navigator.

Enabling the Bills Receivable Workbench permanently disables the Bills of Exchange feature in Oracle Receivables. Receivables provides comparable features in the Bills Receivable Workbench that replace all of the Bills of Exchange functionality. See Chapter 17, Bills Receivable and your country–specific user guide for a description of all Bills of Exchange and Bills Receivable features, programs, and reports.

Attention: Enabling the Bills Receivable Workbench is an irreversible process. Once you enable Bills Receivable you cannot revert to the Bills of Exchange functionality.

For more information, see: Enabling the Bills Receivable Workbench: page 2 – 230.

When you create a bill receivable or a bills receivable remittance, Receivables provides default values for the following attributes in the Bills Receivable and Remittances windows:

• Date

• Currency

You can also define the AR: Bills Receivable Batch Source profile option to provide a default batch source for your bills receivable. This profile

(54)

option determines the value of the Batch field in the Bills Receivable and Bills Receivable Transaction Batches windows.

Profile Options

There are two profile options that belong to the Bills Receivable Workbench:

• AR: Bills Receivable Batch Source: This profile option defines a default batch source for bills receivable transactions.

• AR: Factor/Endorse Bills Receivable without Recourse: This profile option determines whether you can factor or endorse bills receivable remittances without recourse.

Other profile options that relate to bills receivable are:

• AR: Document Number Generation Level: This profile option determines at what point Receivables generates a document number for transactions. For bills receivable transactions, the valid value is ’When the transaction is completed.’

RECEIVABLES

Oracle

r

Receivables

User Guide

Contents

Preface

Audience for This Guide

How To Use This Guide

Finding Out What’s New

Other Information Sources

Do Not Use Database Tools to Modify Oracle Applications Data

About Oracle

Your Feedback

1

T

Overview of Oracle

Receivables

Receivables Workbenches

Receipts Workbench

Transactions Workbench

Collections Workbench

☞

Bills Receivable Workbench