Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Friday, August 5, 2011

Oracle Account Receivables Setups

Transactions Work Bench: -

Profile Class: -

To create profile class first we setup these three.

I. Payment Terms

II. Collector

III. Statement Cycle

Payment Terms: -

Nav: - Setup – Transactions – Payment Terms

Table Name: RA_TERMS_LINES

Then Click on Discounts – Enter Discounts

Table Name: RA_TERMS_LINES_DISCOUNTS

Collectors: -


Nav: - Setup – Collections – Collectors

Table Name: AR_COLLECTORS

Statement Cycle: -

Nav: - Setup – Print – Statement Cycle

Table Name: AR_STATEMENT_CYCLE_DATES

Profile Classes: -

Nav: - Customers – Profile Classes

Profile Class Tab

Table Name: AR_CUSTOMER_PROFILE_CLASSES_V

Credit Profile Tab

Profile Class Amount Tab

Table Name: AR_CUSTOMER_PROFILE_CLASSES_V

Creating Customers: -

Customers are two types

ü Organization Customers

ü Individual Customers

We can create Customers in two ways

1. Standard Customer

2. Quick Customer

Standard Customer: -

Nav: - Customers – Standard

First enter some dummy name into Name field then it’s gives some prompt then click

On New

Then click on open its open another form Customer Address

Table Name: HZ_SITE_USES_V

Table Name: AR_CUSTOMERS_V

Quick Customer: -

Nav: - Customers – Quick

First enter some dummy name into Name field then it’s gives some prompt then clickOn New

Table Name: AR_ADDRESSES_V

Table Name: AR_CUSTOMERS_V

Setups for Transaction Work Bench:

Setup Transaction Type

Setup Transaction Source

Setup Standard Memo Lines

Setup Auto Accounting

Define Items

Setup Tax codes

Fright Carriers

Setup Approval Limits

Define Payment Terms

Transaction Classes: -

Invoice

Debit Memo

Credit Memo

Charge back

Deposit

Guarantee

Bills Receivable

1. With out Transaction Type and Transaction Source we cannot create a Transaction.

2. The Definition of customer used in more than 80 Modules.

Transaction Type: -

Nav: - Setup – Transactions – Transaction Type

Table Name: RA_CUST_TRX_TYPES

Transaction Status: -

Open – Did not make a payment

Close – After Receiving Payment

Pending – Waiting for some approval

Void -- Cancel Invoice

Transaction Source: -

Nav: - Setup – Transactions – Sources

Table Name: RA_BATCH_SOURCES

Transaction: -

Nav: - Transactions – Transactions

Table Name: RA_CUST_TRX_LINE_GL_DIST_V

After Complete: -

View Transactions: -

Nav: - Collections – Customer Accounts

Tax Codes: -

Nav: - Setup – Tax – Codes

Table Name: AR_VAT_TAX_VL

Accounting Hierarchy: -

Auto Accounting is a powerful flexible tool, which create GL Accounting Flex Field.

Customer Bill to site

Customer Header

Transaction Type

Auto Accounting

Freight Carriers: -

These are two types.

Header Level

Line Level

1. Create Freight carriers

Nav: - Setup – System – Quick Codes – Freight Carriers

Table Name: WSH_CARRIER_SERVICES_V

Table Name: WSH_ORG_CARRIER_SERVICES_V

2. Enter Transaction for freight

Nav: - Transactions – Transactions

After Complete: -

Copy Transaction: -

Nav: - Transactions – Copy Transactions

When ever we copy Transaction then we complete the transaction then only it shows

Balance.

After Complete: -

Standard Memo Line: -

It Useful only we entering non inventory invoices.

Nav: - Setup – Transactions – item -- Memo Line

Table Name: AR_MEMO_LINES_VL

Print Invoice: -

Nav: - Print Document – Invoice

Then go to view – Request

View Output: -

Foreign Currency transactions: -

Setup: -

1. Enable foreign Currency

Nav: - Setup – Financials – Currencies -- Currencies

2. Define Conversion Rate

Nav: - Setup – Financials – Currencies -- Rates – Daily

Table Name: GL_DAILY_RATES_V

3. Change currency rate type to Spot in System Options in accounting tab

Nav: - Setup – System – System Options

Table Name: AR_SYSTEM_PARAMETERS

4. Enter Transaction

Nav: - Transactions – Transactions

After Complete : -

View Accounting: -

Receivable Activities: -

It shows all details of discount given by customer

1. Earned Discount

2. Unearned Discount

Earned Discount: -

Nav: - Setup – Receipts – Receivable Activity

Table Name: AR_RECEIVABLES_TRX

Unearned Discount: -

Nav: - Setup – Receipts – Receivable Activity

Table Name: AR_RECEIVABLES_TRX

Invoice Rules: -

Invoicing rule determined the period in which the receivable will be recognized.

These are two types

Bills in Advance

Bills in Arrears

Accounting Rules: -

Accounting Rule determine the period in which revenue will be recognized.

These are two types

Fixed

Variable

Bills in Advance: -

Nav - Setup – Transactions – Accounting Rules

Table Name: RA_RULE_SCHEDULES

Transaction for Bills in Advance: -

Nav: - Transactions – Transactions

After Complete: -

View Accounts: -

For these transactions we run a program for to view the accounting

Nav: - Control – Requests – Run

Tools – View Account

Table Name: XLA_AEL_SL_V

Bills in Arrears: -

Nav: - Setup – Transactions – Accounting Rules

Table Name: RA_RULE_SCHEDULES

Transaction for Bills in Arrears: -

Nav: - Transactions – Transactions

Before save these line item open periods in Control – Accounting – open close

Tools – View Account

Credit Memo: -

Setup: -

1. Create Credit Memo Transaction Type

Nav: - Setup – Transactions – Transaction Type

1. Enter Invoice

Nav: - Transactions – Transactions

1. Enter Credit Memo Transaction

Nav: - Transactions – Transactions Summary

Debit Memo: -

1.Create Debit Memo Transaction Type

Nav: - Setup – Transactions – Transaction Type

2.Create Debit Memo Transaction Source

Nav: - Setup – Transactions – Source

3.Enter Invoice

Nav: - Transactions – Transactions

4.Enter Debit Memo

Nav: - Transactions – Transactions

View Debit Memo: -

Nav: - Collections – Customer Accounts

Deposit and Guarantee: -

Deposit and Guarantee are called commitment Transactions. For these two we can’t adjust freight and Tax

Setup: -

  1. Create Transaction Type

Nav: - Setup – Transactions – Transaction Type

  1. Create Transaction Source

Nav: - Setup – Transactions – Source

  1. Enter Deposit Transactions

Nav: - Transactions – Transactions

  1. Enter Invoice

Nav: - Transactions – Transactions

Receipt Work Bench: -

Setup: -

1. Setup Receivable Activities for earned and unearned Accounts.

2. Setup Bank

3. Setup Receipt Class

4. Setup Receipt Source

Receipts are two types

1.Income from Operations

2. Other Income (Miscellaneous Receipts)

We can create Receipts in two ways

1.Manual

2. Automatic

Bank: -


Nav: - Setup – Receipts – Bank

Receipt Class: -

Nav: - Setup – Receipts – Receipt Class

Receipt Source: -

Nav : - Setup – Receipts – Receipt Source

Receipt Transaction: -

Nav: - Receipts – Batches

Reversal of Receipts: -

These are two Types

Standard Reversal

Debit Memo Reversal

Standard Reversal: -

In Standard Reversal method when we reverse a receipt then original invoice status will

Become open.

1.Enter Transaction

Nav - Transactions – Transactions

2.Enter receipt for above Transaction

Nav: - Receipts – Receipts

1. Reverse of receipt

Nav - Receipts – Receipts

Query for previous receipt

Debit Memo Reversal: -

In DM Reversal the original invoice not disturb the status is closed only but sys will

Create a Debit Memo.

1.Enter Transaction

Nav - Transactions – Transactions

2.Enter receipt for above Transaction

Nav: - Receipts – Receipts

3.Reverse of receipt

Nav: - Receipts – Receipts

Query for previous receipt

Charge back: -

We create charge back when we receive partial Amounts.

Setup: -

1.Create Charge back Type

Create charge back source

. Enter a transaction for normal invoice

4. Enter receipt for above transaction

Adjustments: -

1.Setup for receivables activities

Nav: - Setup – Receipts – Receivable Activities

Setup for Approval Limits

Nav: - Setup – Transactions – Approval Limits

Enter transaction for adjustments

Enter receipts for above transaction

Miscellaneous Receipts: -

Setup: -

1.Setup receivable activity for Miscellaneous Cash

Nav: - Setup – Receipts – Receivable Activity

Enter Receipts

Nav: Receipts – Receipts

Collections Work Bench: -

Aging Buckets: -

These are two types

4 Bucket Aging

7 Bucket Aging

Bucket Aging: -

Nav: Setup --Collections – Aging Buckets

Bucket Aging: -

Nav: Setup --Collections – Aging Buckets

Transfer to GL: -

Nav: Interfaces – General Ledger

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect