Oracle Applications
Training Course
Oracle Receivables
應收帳款
MIS SDD Justin Hsu
Contents
Main Flow
Customer, 客戶
Invoices/Transactions, 立帳
Receipt and Remit, 收款
Applications, 沖帳
Accounting, 會計
Collection, 客戶應收帳款管理
Main Flow
Transactions
立帳作業
Receipt
收款作業
POST
Accounting,會計(GL)
介面
手動
收款 會計 立帳 沖帳
Collections
客戶應收帳款
Customer, 客戶
Customer
Payment Method
Bank Account
Contact
Phone
Address
Profile Class
Relations Ship
Contact
Phone
Role
Customer, 客戶 ‘cont
Address
Payment Method
Bank Account
Contact
Phone
Profile Class
Business Purpose
Transactions,立帳
Invoice Transactions (立帳)
零星開立(Enter transactions)
介面(Batch, from OE/PAPR)
Credit Memo Transactions (銷退)
Manual Enter
With Invoice/Transactions (Credit Memo)
Without Invoice/Transactions (On Account Credit)
From OE RMA Process
Maintenance Transactions
Adjustment Transactions (Authorization/Approval)
Update Transactions(Before posted)
Debit Memo (New Invoice)
Void Invoice
Transactions,立帳
(Invoice Accounting)
Invoice Accounting
Dr. Receivables 10000
Cr. Revenue 8900
Cr. Tax 100
Cr. Freight 1000
Invoice with Accounting Rule (Invoice for Service)
Bill in Advance
Bill in Arrears
Run Revenue Recognition
Generate each period account
Transactions,立帳
Bill in Advance
Bill in Advance (Accounting Rule)
Period 1
Dr. Receivables 3000
Cr. Unearned Revenue 3000
Dr. Unearned Revenue 1000
Cr. Revenue 1000
Period 2
Dr. Unearned Revenue 1000
Cr. Revenue 1000
Period 3
Dr. Unearned Revenue 1000
Cr. Revenue 1000
Transactions,立帳
Bill in Arrears
Bill in Arrears (Accounting Rule)
Period 1
Dr. Unbilled Receivables 1000
Cr. Revenue 1000
Period 2
Dr. Unbilled Receivables 1000
Cr. Revenue 1000
Period 3
Dr. Unbilled Receivables 1000
Cr. Revenue 1000
Dr. Receivables 3000
Cr. Unbilled Receivables 3000
Commitment And Invoice
Enter Deposit OR Guarantee
Enter Invoice
Apply to the Commitment Number
Under Invoicing
Adjusted Invoice
Updated Invoice
Debit Memo
Over Invoicing
Refund
Adjusted Invoice
Updated Invoice
Credit Memo
Invalid Transactions
Void Invoice
Commitment And Invoice
(Accounting)
Accounting (Enter Commit, Guarantee)
Dr. Unbilled Receivable* Amount
Cr. Unearned Revenue Amount
Enter Applied Invoice
Dr. Receivable(Invoice) Amount
Cr. Revenue Amount
Dr. Unearned Revenue Amount
Cr. Unbilled Receivable Amount
* Unbilled Receivable will be Receivable(Deposit) for Deposit
Credit Memo
Credit Memo
Apply Invoice
On-Account Credit Memo
Apply Customer
Accounting
Dr. Revenue Amount
Cr. Receivable Amount
Credit Memo Accounting
Example
Initial Invoice
Dr. Receivables 1000
Cr. Revenue 900
Cr. Tax 80
Cr. Freight 20
Credit Memo 800 against above invoice
(Credit 700, 80 to tax , 20 to freight)
Dr. Revenue 700
Dr. Tax 80
Dr. Freight 20
Cr. Receivables 800
Credit Invoice with Rules
LIFO
FIFO
Prorate
Unit
Void Transactions
Void invoices, credit memo, and on-account credits to invalidate transactions
User entry or Customer mistake
Unchecked Compete check first
Must NOT posted
No activity transactions against
Could delete records, allow or disallow by setup
Run Report to check/review
Incomplete Invoice Report
Invoice Exception Report
Debit Memo
Used just like Invoice but are usually created for additional charge
Accounting
Dr. Receivables 1000
Cr. Revenue 800
Cr. Tax 80
Cr. Freight 20
Cr. Finance Charge 100
Enter at Transactions Windows, except assign debit memos to transactions types with a class of Debit Memo
Adjust Invoice
Manual Adjustments to the original transactions
Invoice, Debit Memo, Chargebacks, Credit Memo, On Account Credit and Commitments
Control Approval of Adjustments
Accounting
Example : Increase Invoice Amount
Original Invoice
Dr. Receivables 1000
Cr. Revenue 1000
Adjustment
Dr. Receivables 500
Cr. Revenue 500
Adjust Invoice Automatically
Refund
Customer ask return the cash to him (Use AP to pay)
Accounting
Original Invoice
Dr. Receivables 1000
Cr. Revenue 1000
Original Receipt
Dr. Cash 1000
Cr. Receivables 1000
Credit Memo (Customer RMA)
Dr. Revenue 200
Cr. Receivables 200
Refund (cont’)
Because Customer ask refund so …….
Debit Memo to Transfer AR to Clearing Account
Dr. Receivables 200
Cr. Clearing Account 200
Create AP Invoice to Payment
Dr. Clearing 200
Cr. Payables 200
Issue Check to send refund to Customer
Dr. Payables 200
Cr. Cash 200
Receipt,收款
Enter Receipt(收款)
Cash
Cash Receipts
Notes Receipts (required clear)
Misc (none transactions related)
Miscellaneous Receipts
Clear(票據兌現)
Undo Clear
Receipt after clear
Receipt,收款 ‘cont
Receipts Others
Rate Adjustments
Reverse
Difference Currency Receipts
Applications, 沖帳
Applications (沖帳)
Link receipt with invoices/transactions
Credit Memo Application
Link credit memo with invoices/transactions
Adjustment Receipt
Link adjustment of receipt with invoices/transactions
Accounting, 會計
Assign Voucher Number(傳票號碼)
Post to GL
Open/Close Period
Collection, 客戶應收帳款管理
Reviewing a Customer Account
Viewing Dunning History
Customer Correspondence
Dunning Letters
Calculating Finance Charges
Statements
