Invoice: KR INV 15 & KR INV 16 Distribution: As Required
Click: Hold & Fix a multiple holds for both the invoices Validate
Result: Needs Revalidation for both the invoices Block both the invoices
Click: Action 2 – Release: All & KR Release All – OK
It will release the both the invoices and validated automatically – Create Accounting 4. Distribution Variance Hold:
Invoice: KR INV 21 Amount: Rs.10000
Distribution: KR Skeleton
In Distribution: Distribute the values 8000 to 110 and 1500 to 120 Validate
Result: Needs Revalidation (Reason: Distributed amounts are not equal and it is varied) Result in Hold Window: Distribution Variance Hold
In Distribution: Make distribute the amount correctly Validate
Now, Result in Hold Window: Variance Corrected Create Accounting
Mixed Invoice:
Invoice Value: Rs.10000 (Actual Goods) Damages: (-3000)
Required Additional: +1000
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Therefore Actual Damage: (-2000) only – For our knowledgeCreate an invoice: KR INV 24 for Rs.10000 (Actual Goods) – Validate Create Mixed Invoice: KR MIX 01 for (-3000) – Validate
Match with Invoice – Select that invoice KR INV 22 – Enter (-3000) only Match it Again Match with the same invoice KR INV 22 – Enter (+1000) only Match it
Therefore, Invoice KR INV 24 = 10000-3000+1000=8000
Quick Invoices: When we want to enter large number of transactions and when it does not require extensive validation and defaulting invoice.
Quick: Standard Invoice & Credit Memo only can be entered Both the header and line information enter in single window Dates – Header information in header window
Dates – Line information in distribution window
Quick Invoice
Payable
open interface import process
Invoice>Entry>Quick Invoice Batch Name: KR BATCH 1 (Create)
Type: Standard Number: Q1
Supplier: KR Supplier (Attach) Amount: Rs.8000
Line Type Amount Account
1 Item 6000 KR – 110 – 7150 – 0000 – 000
2 Freight 2000 KR – 110 – 7220 – 0000 – 000
Payables open interface tables AP – Invoice – Interface AP – Invoice – Lines Interface
Main Table AP –Invoice – ALL AP – Invoice – Distribution – ALL
AP – Invoice – Schedule - ALL
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Click: Save & NextType: Credit Memo Number: Q2
Supplier: KR Supplier (Attach) Amount: (-2000)
Line Type Amount Account
1 Item -2000 KR – 110 – 7420 – 0000 – 000
Click: Create Invoices
View – Request – Completed – View Report Go to Quick Invoices – Find
Status: Processed (Invoice process in KR Batch 1) Go to Invoice Workbench – F11 – KR Sup% Q1%
Control F11 – Validate
Now, the quick invoices – View your invoices – Create invoices – Purge it. (Delete) Foreign Currency Invoice:
In Payable Options – Currency
Enable: Calculate User Exchange Rate & T Exchange Rate Type: User
Invoices>Entry>Invoice Invoice: KR INV 23
Currency: AUD Amount: 10000
Rate Type: User (Automatic)
Exchange Rate: 0.5 (Enter – User defined from daily newspapers) Validate – Create Accounting
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Entry: AUD AUD USD USDCharge 10000 0 5000 0
Liability 0 10000 0 5000
Invoice Batches:
For setup the invoice batches Edit – Preferences – Profiles Query: Ap% - Control F11
AP: User Invoice Batch Controls – Yes (Make it allow)
Existing Responsibility: Payable, however, once again clicks switch responsibility to Payable.
Now, we can create multiple invoices in one batch Invoice> Entry> Invoices:
Name: KR Batch 01 (Create) Control Count: 3
Amount: 50,000 Currency: USD
Terms: KR Immediate (Attach) Pay Group: KR Pay Group (Attach)
Click – Invoices & Enter 3 Invoices, which is equivalent to Rs.50000.
Save and close
Then Click – Validate 1 in Invoice batch window
View – Request – Status – Completed (Normal, view Output) Then, click Create Account in same window
View – Request – Status – Completed We have created account entries Go to Invoices – Approve and validate (Same window)
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
(We can enter various invoices in invoice workbench while using invoice batch control) Recurring Invoices:Create a Special Calendar for Recurring Invoice Setup>Calendar>Special Calendar
Name: KR SPL RECURRING Type of Calendar: Recurring Invoice (Enable) Periods: 12
Period Name Year Sequence From Date To Date
P1 2006 1 01-Apr-06 30-Apr-06
P2 2006 1 01-May-06 31-May-06
Save
Invoice Entry:
Attach: Pre – defined items Template Definition: KR REC 01
Amount: 10000 (Automatically generate full year amount) Change: 10% (Increase every month)
Special: 4000 (Particular Month only this amount will be an expense) No of Invoice: 12 (Number of recurring invoices to be created)
Click: Create Recurring Invoice
Go to Invoice workbench – Query F11
Paste that Recurring Journal No – Control F11 Validate every – month as required
(Recurring invoices based on period enKRg) Expensed Reports:
The format for the purpose of reimbursement to staff In Payable Options –Expense Report
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Enable: Apply Advances & automatically create employee as supplierTemplate: (Create template for reimbursements) Setup>Invoice>Expense Report Templates Template Name: KR EXPENSE REPORT TEMPLATE
Expense Item Expense Category Item type GL Account
Food Meals Miscellaneous
33-000-7690-0000-000
Travel Air Fare Miscellaneous
33-000-7699-0000-000
Accommodation Accommodation Miscellaneous 33-000-7670-0000-000
(Tax & Internet Expenses – Enable if required) Click: All Verified
View – Request – Single Request Name: Expense Report Import Parameters: Batch: KR EXP 01 Summarize Report: No
Source: Payables Expense Reports GL Date: 01-JAN-2001
Click: OK
View –Request – Status – Completed – View Output (Copy: KR EXP 01) In Invoice Workbench
Query F11 – KR EXP 01% - Control F11
Type: Expense Report (Automatically Generated) Validate – Approve – Create Account
TAX:
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Tax is a charge and pay to governmentTAX
Header Level Distribution Level
Always inclusive of Tax May be inclusive or exclusive of tax component
Tax = Income x Rate/ (100+Rate) Tax = Invoice x Rate/100
Types of Tax:
1. Sales Tax 2. Use Tax
3. User defined Tax 4. WithholKRg tax 5. Offset Tax 1. Sales Tax
Setup Tax Codes
Tax Code: KR Tax Code Tax Type: Sales
Rate: 10
From: 01-Apr-06
GL Account: 33-000-7710-0000-000 (Sales)
Attach this tax code in supplier Supplier>Entry
Query your supplier – KR Supplier
In Sites – Invoice – Attach KR Tax Code and
Disable – Use offset taxes & distribution amount includes tax Save
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Enter an invoice (Manual: In Payable – Invoice Tax – Disable Amount Tax Cal) Invoice>Entry>InvoiceInvoice: KR INV 25
Amount: 11000 (Based on Tax enter this invoice value)
In Tax Code: KR Tax Code & Header (Automatically Generated) Tax: 1000 (Enter Manually) (11000 x 10/110)
Validate – Create Accounting Entry:
Charge 10000
Non – recoverable tax 1000
Liability 11000
Enter an invoice (Automatic: Payable – Invoice Tax – Enable Automatic Tax & Head) Invoice>Entry>Invoice
Invoice: KR INV 26 Amount: 11000
In Tax Code: KR Tax Code & Header (Automatically Generated) Tax: 1000 (Enter Manually) (11000 x 10/110)
Validate – Create Accounting Entry:
Charge 10000
Non – recoverable tax 1000
Liability 11000
Enter an invoice (Automatic: Payable – Invoice Tax – Enable Automatic Tax &Line) Invoice>Entry>Invoice (Supplier – Sites – Invoice tax – Level: Line & Enable: Disable – Disl)
Invoice: KR INV 27
ORACLE FINANCIALS
J. Sureshraja M.com., MBA., CA (f).,
Amount: 100000Click Distribution – Attach KR Tax Code and Rate in each line Click Calculate Tax – Rs.10000 Tax will be calculated – Save it Go to invoice bench – Change the value as Rs.110000
Save it – Validate – Create Accounting Entry:
Charge110 40000 Charge120 60000
Non-recoverable tax 10000 Liability 110000
(Automatic: Payable – Invoice Tax – Enable Auto. Tax & Line & Enable – Dist Incl. Tax) (Supplier: Sites – Invoice Tax – Level: Line & Enable; Enable - Dist Incl. Tax)
Entry:
Charge110 40000 Charge120 60000
Non-recoverable tax110 4000 Non-recoverable tax120 6000 Liability 110000