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: -
- Create Transaction Type
Nav: - Setup – Transactions – Transaction Type
- Create Transaction Source
Nav: – Setup – Transactions – Source
- Enter Deposit Transactions
Nav: – Transactions – Transactions
- 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
No comments:
Post a Comment