14 Oracle Receivables

Oracle Receivables allows you to streamline invoicing, receipt, and customer deduction processing while improving cash flow, optimizing customer relationships, and providing strategic information. As a sub ledger, Oracle Receivables provides the flexibility to meet the demands of a global market with strong financial controls to assist in instilling corporate and fiscal discipline.

This chapter describes the following test flows in Oracle Receivables:

  • Create Adjustment - within Approval Limits

  • Create Automatic Receipt

  • Create Chargeback

  • Create Debit Memo Receipt Reversal

  • Create Deposit and Attach to Invoice

  • Create Foreign Currency Invoice

  • Create Foreign Currency Receipt

  • Create Guarantee and Attach to Invoice

  • Create Invoice

  • Create Invoice with Accounting Rule in Arrears

  • Create Invoice with Document Number when Saved

  • Create Invoice with 'In Advance' Accounting Rule

  • Create Invoice with Split Payment Term and Apply Credit Memo

  • Create Miscellaneous Receipt and Remit the Receipt

  • Create On Account Credit Memo and Apply to Invoice

  • Create Receipt and Take Earned Discount

  • Create Receipt and Clear using Cash Management

  • Create Receipt with Quick Cash (Application Type as Multiple)

  • Create Salary Invoice with Sales Credits

  • Create Standard Receipt Reversal

Prerequisites

None.

Profile Options

Table 14-1 Profile Options for Oracle Receivables

Profile Name Profile Value

POS: SM: Enable Supplier Profile Management Extension

No

POS: SM: Supplier Data Hub Configuration

None


Predefined Data

Not applicable.

Setup Data

Table 14-2 Setup Data for Oracle Receivables

Window Name Field Name Field Value

AutoAccounting

Type: Factored Bills Receivable

01 000 1245 0000 000

 

Type: Bills Receivable

01 000 1220 0000 000

 

Type: Remitted Bills Receivable

01 000 1245 0000 000

 

Type: Unpaid Bills Receivable

01 000 1220 0000 000

 

Type: Freight

01 430 7220 0000 000

 

Type: Receivable

01 000 1210 0000 000

 

Type: Revenue

01 000 1150 0000 000

 

Type: AutoInvoice Clearing

01 000 1222 0000 000

 

Type: Tax

01 000 5110 0000 000

 

Type: Unbilled Receivable

01 000 1232 0000 000

 

Type: Unearned Revenue

01 000 2550 0000 000


14.1 Create Adjustment - within Approval Limits

Creates receivable activity for adjustment, creates invoice and adjusts it, and verifies the invoice and adjustment accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.2 Create Automatic Receipt

This flow creates a transaction type for a deposit, creates the deposit, raises an invoice on the customer and applies the deposit, verifies the deposit balance, creates accounting, creates receipt and applies to the deposit, verifies the deposit balance, and finally, verifies the receipt accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.3 Create Chargeback

This flow creates transactions and receipts with chargeback.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.4 Create Debit Memo Receipt Reversal

Creates transaction type, creates invoice, creates receipt and reverse receipt, and verifies receipt accounting, invoice balance and debit memo balance.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.5 Create Deposit and Attach to Invoice

Creates transaction type for deposit, creates deposit, raises an invoice on the customer, and applies the deposit. Verifies deposit balance, creates accounting, creates receipt and applies to deposit. Verifies deposit balance and receipt accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.6 Create Foreign Currency Invoice

This flow creates a foreign currency invoice.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.7 Create Foreign Currency Receipt

This flow creates a foreign currency receipt.

Prerequisites

The daily rate is set as follows:

CAD to USD: 0.72046

USD to CAD: 1.38800

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.8 Create Guarantee and Attach to Invoice

This flow creates an invoice with transaction type as Guarantee, verifies the transaction adjustment details and creates the adjustment accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.9 Create Invoice

This flow creates an invoice, verifies it once it is created, and then creates accounting on it.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.10 Create Invoice with Accounting Rule in Arrears

This flow creates an invoice with an accounting rule in arrears.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.11 Create Invoice with Document Number when Saved

Creates transaction type, sets document sequence, defines category, creates invoice, and verifies the generated document.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.12 Create Invoice with 'In Advance' Accounting Rule

Creates accounting rule, raises an invoice on the customer with in-advance invoicing rule. Runs Revenue Recognition program and verifies accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.13 Create Invoice with Split Payment Term and Apply Credit Memo

Creates invoice with split payment term, verifies invoice balance, and applies credit memo to invoice.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.14 Create Miscellaneous Receipt and Remit the Receipt

This flow creates distribution sets and receivable activity. It creates a receipt by choosing Manual as the receipt method and Miscellaneous as the receipt type. Finally, it creates a remit receipt for the receipt class which was created earlier.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.15 Create On Account Credit Memo and Apply to Invoice

This flow creates on-account credit memo and applies it to an invoice.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.16 Create Receipt and Take Earned Discount

Creates payment term without discount, creates invoice and receipt, and takes earned discount. Verifies invoice balance and receipt accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.17 7 Create Receipt and Clear using Cash Management

Creates a receipt class method by matching, creates invoices, creates receipts, verifies receipt accounting, clears receipt through cash management, and verifies receipt accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.18 Create Receipt with Quick Cash (Application Type as Multiple)

This flow creates transactions, copies transactions, and creates receipt batches.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.19 Create Salary Invoice with Sales Credits

This flow sets up auto accounting and creates an invoice with sales credit details.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.

14.20 Create Standard Receipt Reversal

Creates receipt, reverses receipt, and verifies invoice balance and receipt accounting.

Prerequisites

None.

Profile Options

Not applicable.

Predefined Data

Not applicable.

Setup Data

Not applicable.