Tuesday, October 16, 2018

Oracle Receivables

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 Receipt and Take Earned Discount
  • Create Receipt and Clear using Cash Management
  • Create Standard Receipt Reversal
  • Create Invoice with 'In Advance' Accounting Rule
  • Create Debit Memo Receipt Reversal
  • Create Invoice with Split Payment Term and Apply Credit Memo
  • Create Adjustment - within Approval Limits
  • Create Invoice with Document Number when Saved
  • Create Deposit and Attach to Invoice
Prerequisites
None.
Profile Options
Table 12-1 Profile Options for Oracle Receivables
Profile NameProfile Value
POS: SM: Enable Supplier Profile Management ExtensionNo
POS: SM: Supplier Data Hub ConfigurationNone
Predefined Data
Not applicable.
Setup Data
Table 12-2 Setup Data for Oracle Receivables
Window NameField NameField Value
AutoAccountingType: Factored Bills Receivable01 000 1245 0000 000

Type: Bills Receivable01 000 1220 0000 000

Type: Remitted Bills Receivable01 000 1245 0000 000

Type: Unpaid Bills Receivable01 000 1220 0000 000

Type: Freight01 430 7220 0000 000

Type: Receivable01 000 1210 0000 000

Type: Revenue01 000 1150 0000 000

Type: AutoInvoice Clearing01 000 1222 0000 000

Type: Tax01 000 5110 0000 000

Type: Unbilled Receivable01 000 1232 0000 000

Type: Unearned Revenue01 000 2550 0000 000

12.1 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.

12.2 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.

12.3 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.

12.4 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.

12.5 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.

12.6 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.

12.7 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.

12.8 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.

12.9 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.

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...