11i AR SETUPS


    11i AR SETUPS


Accounts Receivables

Transactions Work Bench
Recites Work Bench
Collections Work Bench
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











Labels: