Oracle SETUPS FOR ALL MODULES (AP, AR, GL, TAX)

ACCOUNTS PAYABLE - INVOICE

1. SUPPLIER CREATION

Name – supplier Name
organisation – Type

Address – supplier site

Accounting – liability & prepaymetn account

Purchasing – Purchasing tab ( Ship to & Bill to Location), Self Billing tab ( Pay on & Invoice summary level)

Receiving – Receipt Routing & match option

Payment Details – payment Method.

2.ITEM CREATION

 Item Name

Copy Template ( Purchase Item)

 Assign Organisation

 Check in Purchasing Tab – expense account to be changed

 Check in order management Tab – It is returnable or not.

 3.  PAYABLE OPTION

Accounting Option – payment Accounting, Accounting offset method, Discount method,Interest, Prepayment Account.

Currency – Realised Gain & Loss Account and Rounding Off account.

Tax Reporting

Invoice – Allow online Validation, document category override, adjustemt to paid invoice, 

                GL date basis – System date.

Approval Matching

Interest – Enable Allow Interest invoice, Interst Invoice Account ( Expense & Liability)

Expense Report – Enable Employee as supplier

Payment – Allow Pre date, Void & Reissue, Document category override.

Supplier – Invoice Currency ,Term date basis, payment Terms Report

4.      FINANCIAL OPTION

Accounting – GL Accounts ( Liability, Prepayment,bills payable,discount taken,PO rate variance Gain & Loss)

Supplier – purchasing – Link IMO & Ship to Bill to Location.

Encumbrance – Use Requition, P.O. & Reserve at completion ( Only For Budget)

Human Resource – Link B.G. & Expense Reimbursement Add. Employee Number(Auto)
                                

5. PAYABLE SYSTEM SETUP

Supplier       

Supplier Number – Automatic & manual

Control – Invoice Match Option ( Receipt & P.O.)

payment – Invoice Currency, pay group, Term Date basis, pay date basis, payment Term

Enable 'Create interest invoice' If needed.         

6. PURCHASING OPTION

Enforce full lot quantity – (advisory, mandatory & none)

Receipt close point – (Accepted, Delivered & Receipt)

match Approval level – 2,3 & 4 way

Receipt Accounting – Expense AP Accural Account ( Defaults from Payable Option)

Document Numbering(Numeric & Alpha Numeric) - ( RFQ, Quotation, P.O. & Requisition ) Automatic & manual.

7. RECEIVING OPTION

Receipt Days – Early & Late

Over Receipt Tolerance

Next Receipt number

Receipt Routing – Direct Delivery,Standard Receipt & Inspection Required.

Accounting – Receiving Inventory Account & Claering Account.

8.ERS SETUPS

Payment Method

Liability account

Payment term

Invoice Summary Level

Pay on Receipt..

PAYMENT MANAGER(BATCH PAYMENT) SETUPS

1. Create Template

2. Schedule Selection Criteria

1.      Name

2.      No. of pay from days - 0

3.      Add. Pay through days - 0

3. Payment Attributes

Ø  Exchange Rate – Corporate, User & Spot

4. Process Automation

Ø  Enable Stop Process for Review

Ø  Enable Stop Process After creation of proposed payment

5. Validation Failure Results

Ø  Documents – Reject all documents for payee when any Documents fails

Ø  Payments – Reject only payments with Errors

6. Addtional Information

7. Create Payment Process Request

Ø  Payment Process Request Name

Ø  Schedule Selection Criteria

Ø  Name

Ø  No. of pay from days - 0

Ø  Add. Pay through days – Current Date

Ø  Payee – Supplier Name

8. Payment Attributes

Ø  Payment Date

Ø  Disbursement Bank Account

Ø  Payment Document

Ø  Payment Process Profile

Note: All other are defined in Template

Ø  Payment instruction

Ø  Payment

EXPENSE REPORT

1. Create Expense Report Template

Ø  Template Name

Ø  Expenses Item 

Ø  Expense Category

Ø  Tax Code

Ø  G.L.Account

2. Expense Report

Ø  Name ( Employee)

Ø  G.L.Account

Ø  Invoice No.

Ø  Currency

Ø  Date

Ø  Amount

Ø  Apply Advances

2.1 Accounting

Ø  Item – Amount – G.L.Account

ACCOUNTS RECEIVABLE

1. AR SETUPS

       1. Transaction Type –

Ø  Invoice Class( Deposit, Invoice,C.M. , D.M.,B.R.,Guarantee,Chargeback)

Ø   Transaction Status (Open, Closed,Void & Pending),

Ø  Application Rule Set(Line First–Tax After,Line first–tax Prorate, prorate All)

Ø   Accounts ( Receivable, Revenue,Unbilled Receivable, tax, Freight,clearing & Unearned  Revenue Account)

2. Transaction Source

Ø  Batch Source

Ø  Type – Manual & Imported

Ø  Automatic Transaction Numbering ( Enter last Number)

Ø  Copy Document Number to transaction No. (Instead of Doc Seq.)

Ø  Attach the invoice transaction type

( If Automactic)

Ø  Auto Invoice option

Ø  Allow Sales Credit

Ø  Customer info ( Change Values into ID)

Ø  Accounting Info (Change Values into ID)

Ø  Other Info(Change Values into ID)

Ø  Sales Credit Validation ( Change Values into ID)

3. Auto Accounting Rule – Sales Rep, Site, Standard memo Lines  & Transation Type

4. Invoicing Rule – Bills in Arrear & Advance

5. Grouping Rule

6. System option

Ø  Accounting

Ø  Reliased Gain & Loss Account

Ø  Tax Account

Ø  Enable Automatic journal Import

Ø  Trans and Customer

Ø  Allow Transaction Deletion

Ø  Alow payment for unrelated transaction

Ø  Enable Automatic Customer Numbering

Ø  Document number generation Level – (None, When Saved & Completed)

Ø  Attach the Grouping Rule

Ø  Claims

Ø  Miscellaneous

Ø  Write – off Limit

Ø  Allow unearned Discount

Ø  Discount on partial payment

ORDER MANAGEMENT SETUPS

1.Order Header

Ø  Sales Document Type – Sales order & Agreement

Ø  Order category – Order, Mixed & Return

Ø  Transaction Type Code – Order & Line

Ø  Fulfillment Flow  - Order Flow – Generic

Ø  Negotiation Flow – Nogotiation Flow – Generic

Ø  Default Transaction phase – Fulfillment

Ø  Main

Ø  Attach price List

Ø  Shipping

Ø  Warehouse

Ø  Scheduling Level – Allow all scheduling Action

Ø  Enable Auto Schedule & Fulfillment set.

Ø  Finance

Ø  Invoicing Rule

Ø  Accounting Rule – (Immediate, Monthly,Quarterly, halferly & yearly Billing)

Ø  Invoice Source – Attach the  created Transaction Source

Ø  Receivable transaction type – Attach the created inv Trasaction type

2.Create Order Line.

Ø  Assign Line flow in Order header

Ø  Line type – Created Order line

Ø  Process name

Ø  Line Flow – Generic (normal)

Ø  Line Flow – Standard Service ( Service)

Ø  Line Flow – Generic Bill only ( Bill only)

Ø  Line Flow – Return for credit with Receipts (Return)

A.R. RECEIPT SETUPS

1.Receipt Class

Ø  cash & Cheque

Ø  Creation Method – Automatic, Manual, Bills Receivable, Bills Receivable Remittance& AP AR Netting.

Ø  Remittance Method – Standar , Factoring, Standard&Factoring, No remittance

Ø  Clearance Method – Directly, By Automatic Clearing, By matching

2.Receipt Method

Ø  Add your bank

Ø  Receipt Write off setups

Ø  Receivable Activity – Type ( Receipt Writeoff)

Ø  Approval Limit

Ø  System Option – Miscellaneous ( Receipt Write off limit)

Ø  Adjustment Setups

Ø  Receivable Activity – Type ( Adjustment)

Ø  Approval Limit

Ø  Miscellaneous Receipt ( Dividend & Other Income)

Ø  Receivable Activity – Type (Miscellaneous Cash)

AP – AR NETTING

1. Customer and Supplier should same

2. Transaction of AP & AR should be posted

3. Agreement Between party & Organisation (Netting Agreement)

Ø  Netting Agreement Name

Ø  Start Date

Ø  Netting Preferences

Ø  Netting Bank Account (Netting Flag 'yes' in Netting bank Creation)

Ø  Select only Past Due Reeivable Transaction – Yes / No

Ø  Netting Order Rule  - Due Date (Oldest to Most Recent)

Ø  Netting Balance Rule – Net Always

Ø  Netting Currency Rule – Net within Each Currency

Ø  Payable Invoice Type

Ø  Credit & Debit Memo

Ø  Standard

Ø  Mixed

Ø  Receivable Transaction Type

Ø  invoice & Credit Memo Transaction Type

Ø  Select Supplier

Ø  Select Customer

4.Netting Batch

Ø  Batch Name

Ø  Netting Agreement

Ø  Transaction Due date – next day date

Ø  Settlement Date – Current date

Ø  Exchange Rate Type- Corporate , User & Spot

Ø  Review Payable and Rceivable Transaction and Submit

RECEIPT WRITE OFF SETUPS

1.Receivable Activity – Type- Write Off

2.Approval Limit

3.System Option – Miscellaneous – Receipt Write Off

ADJUSTMENT SETUPS

1.Receivable Activity – Type - Adjustment

2.Approval Limit

MISCELLANEAOUS RECEIPTS

1.Receivable Activity – Type- Miscellaneous Cash

Unearned & Earned Discount

1.Payment Term – Discount Tab -

2.Receivable Activity – Type- unearned Discount

BANK CREATION SETUPS

1. Bank

Ø  Country

Ø  Bank Name

Ø  Address

2. Bank Branches

Ø  Country

Ø  Bank Name

3. Branch Info

Ø  Branch Name

Ø  Branch Type – ABA, CHIPS, SWIFT & Others

Ø  Address

4. Account Creation

Ø  Account Owner And use

Ø  Bank Account Owner – Legal Entity

Ø  Account use – payable, Receivable & payroll

Ø  Account Information

Ø  Account Name

Ø  Account Number

Ø  Currency ( Enable Multiple Currencies , If that bank use different Currencies)

Ø  Account control

Ø  General Controls

Ø  Cash Account (G.L. Code)

Ø  If it is Netting Bank (Enable Netting Bank As 'YES')

Ø  Payable Controls

Ø  Enable Multiple Currencies

Ø  Enable Allow zero payments

Ø  Receivable Controls

Ø  Enable Multiple Currency receipts

Ø  Account Access (Click Add Organization Access)

Ø  Acount Use – payable & Receivable

Ø  Organisation – Operating Unit

Ø  Contact – Bank Contact Details

5. Manage Payable Documents

Ø  Document Name

Ø  Paper Stock Type – Blank Stock & Prenumbered Stock

Ø  Format – Standard Check Format

Ø  First Available Document Number - 1^st cheque Number

Ø  Last Available Number – last Cheque Number

INDIA LOCALIZATION EXCISE AND VAT SETUPS (P2P)

1. Org Addtional Info ( With & Without site)

Ø  Accounting Info -  Excise and CENVAT account code

Ø  Tax Info -  Excise, CST, Income Tax & VAT Reg Details

Ø  Preferences

Ø  Allow Negative balance in PLA & RG Register

Ø  Register Preference (RG23A , 23C, PLA)

Ø  Allow tax change on Receipt

2. Supplier Addtional Info (With & Without Site)

Ø  Supplier Name & Vat No.

3. Create Separate Statutory Authority for Excise & VAT as Supplier

4. Regime Registrsation (VAT) – Accounting code picked from here

Ø  Registration

Ø  Primary Registration Number

Ø  Same Inv No. For Excise & VAT

Ø  Deafault Excise & VAT invoice details in VAT Claim

5. Tax Type

Ø  Recovery A/c

Ø  Interim Recovery A/c

Ø  Liability A/c

Ø  Interim Liability A/c.

6. Taxes

Ø  VAT – Type (value Added Tax) , Percentage, Tax Account code.

Ø  Excise – Type(Excise -Basic, Edu Cess, Sh Edu Cess), percentage, Tax Code.

7. Tax Category

Ø  Assign the created tax with precedence (excise & VAT)

8.VAT Item Classification

Ø  Item/Tempalte – Item Attribute

Ø  Regime – Value added Tax

Ø  Organisation

Ø  Item Name

Ø  Attribute Registration

Ø  Applicable – Yes/No

Ø  Recoverable – Yes/No

Ø  Item Class – Raw Material /Capital Goods

9. Excise Item Classification

Ø  Item/Tempalte – Item Attribute

Ø  Regime – Excise

Ø  Organisation

Ø  Item Name

Ø  Attribute Registration

Ø  Tradable – Yes/No

Ø  Item Class – Finished Goods india/ Export

Ø  Modvatable – Yes/No

Ø  Excisable – Yes/No

10. VAT Claim Terms & Definition

Ø  Term Name

Ø  No. Of instalments

Ø  Claim Interval – Immediate, Next Financial year,Next month, Next Quarter, 

                             Specified Month

Ø  Claim Percentage

Ø  Assignments

Ø  Regime – Value Added Tax

Ø  Item Class – Raw materials

EXCISE AND VAT (O2C)

1. Customer Addtional Info.

Ø  Customer Name & VAT No.

2. Bond Register

Ø  Register Type – Bond Register, Domestic with Excise,Domestic Without Excise,Export with Excise.

Ø  Attach the Invoice Type And Order Type

3.  VAT Item Classification

Ø  Item/Tempalte – Item Attribute

Ø  Regime – Value added Tax

Ø  Organisation

Ø  Item Name

Ø  Attribute Registration

Ø  Applicable – Yes/No

Ø  Recoverable – Yes/No

Ø  Item Class – Finished Goods

4. Excise Item Classification

Ø  Item/Tempalte – Item Attribute

Ø  Regime – Excise

Ø  Organisation

Ø  Item Name

Ø  Attribute Registration

Ø  Tradable – Yes/No

Ø  Item Class – Finished Goods india/ Export

Ø  Modvatable – Yes/No

Ø  Excisable – Yes/No

5. Excise Numbering & Calendar ( Org Add. Info form)

Ø  Transaction Type – Invoice, Order, Return to Vendor, Domestic, Export,RMA

Ø  Attach the invoice/Order Type.

Ø  Give prefix and starting no.

6. VAT Sequencing

Ø  Required If Regime Registration -if 'no' in Same Invoice No for Excise and VAT Regimes.

Ø  Attach the Order and invoice type and give Start No.

7. Sub inventory Location

Ø  Assign the subinventory to india localization

SERVICE TAX SETUPS P2P

1. Org Addtional Info ( With & Without site)

Ø  Accounting Info -  Service Tax Reg Details

2. Supplier Addtional Info (With & Without Site)

Ø  Supplier Name & Service Tax Reg No.

Ø  Service Type

3. Regime Registration

Ø  Registration

Ø  Primary Registration Number

Ø  Jurisdiction & Range

Ø  Tax Type – Recovery A/c, Interim Recovery A/C,Liability A/c,Interim Liability A/c

4. Tax

Ø  Service Tax- Type (Service tax, Service Edu cess, Service tax SH EDU Cess)

Ø  Enter percentage

5. Tax Category

Ø  Attach the created  tax with precedence

6. Create Third party supplier for freight.

SERVICE TAX SETUPS (O2C)

1. Customer Addtional Info.(With & Without Site)

Ø  Servie Tax Reg No

Ø  Service Type

2. Create Service Order (Header & Line)

Ø  Header  - Assign line Flow.

Ø  Process Name – Line Flow – Standard Service

3. Document Sequence

Ø  For Service Order type.

CUSTOMS (P2P)

1. Org Addtional Info.

Ø  Accounting info.

Ø  BOE A/C & Write Off A/c

2. Create Custom Authority

Ø  Supplier Addtional Info.

3. Create BOE Agent

Ø  Agent Code

Ø  Agent Name

4. Taxes

Ø  Assesable value

Ø  Basic Custom Duty

Ø  CVD

Ø  Edu Cess on CVD

Ø  She Cess in CVD

Ø  Custom Edu Cess

Ø  Custom She Cess

Ø  Addtional Custom Duty

Ø  Assessable Value Reversal

5. Tax Category

Ø  Attach the Above taxes with precedence

        TCS (O2C)

1. Create a Screap Item – FG

2. Regime Registration – TCS

3. Item Classification

Ø  Regime  - TCS

4. Tax

Ø  Basic Tcs

Ø  Edu Cess on Tcs

Ø  She Cess on Tcs

5. Tax Category

Ø  Assign the created tax with precedence

GENERAL LEDGER - LEDGER CREATION SETUPS

1. Creation of  4-C's

Ø  Calendar

Ø  Calendar Name

Ø  Prefix – Type – Year – From Date – To date

Ø  Currency

Ø  Chart Of Accounts

Ø  Segments – (Company, Cost Centre, Natural Account)

Ø  Flexfeild Qualifiers

Ø  Value Sets – List Type, Security Level, Validation Type

Ø  Values – Assign Values for Value sets

Ø  Retained Earnings Account is Mandatory

Ø  Segment Qualifiers – (Allow Budgeting & Posting, Reconciliation Type,Third party Control & Account Type)

Ø  Conventional Accounting ( Sub Ledger Accounting)

BUDGET SETUPS

1. Accounting Setup manager

Ø  Enable Bugetary Control

Ø  Enter RFE Account

2. Open Encumbrance year

3. Encumbrance Types

Ø  REQ

Ø  P.O.

Ø  Invoice

Ø  Commitment

4. Fund check Level

Ø  Absolute

Ø  Advisory

Ø  None

5. Bugetary Control Group

Ø  Source – Other

Ø  Category – Other

Ø  Fund Check Level – Absolute, Advisory & None

6. Assign Budgetory Control Group

7. Financial Options

Ø  Emcumbrance

Ø  Use at RFQ

Ø  use at P.O.

Ø  Reserve at completion

8. Budget

Ø  Budget name

Ø  Ledger

Ø  Status – Open, Frozen & Current

Ø  Budget Period – April to March

9. Budget Organization

Ø  Budget Org Name

Ø  Ledger

Ø  Ordering Segment

Ø  Ranges

Ø  Low- Accounting Code

Ø  High – Accounting Code

Ø  Type- Entered & Calculated

Ø  Budgetary Control

Ø  Fund Check Level – Absolute, Advisory & none

Ø  Amount Type – PTD,QTD,YTD&PJTD

Ø  Boundary – Period, Project, Quater & Year

Ø  Funding Budget

Ø  Range Assignment

Ø  Account – Accounting Code

MASS ALLOCATION

1. Source Journal

Ø  Create an invoice

2. Cost Centre Mapping

Ø  Enter parent Values and Assign the child values to that

3. Stat J.V.

Ø   Create Recurring journal

Ø  Type- Stat

4. Formula

Ø  T= A*B/C

Ø  A – Cost Pool – Common Cost Centre – Constant (C)

Ø  B – Usage Factor – Parent Cost Centre – Looping (L) – Stat

Ø  C- Total usage – parent Cost Centre – Summing (S) – Stat

Ø  T- Target – parent Cost Centre – Constant (C)

Ø  O- Offset A/c – Common Cost Centre – Constant (C)

FINANCIAL STATEMENT GENERATOR

1. Row Set

Ø   Enter Row Name

Ø  Enter Accounting Code in Accounting Assignment

Ø  Row Set is variable

2. Column Set

Ø  Enter Column name

Ø  Enter Accounting Code in Accounting Assignment

Ø  Column set fixed

3. Report Set

Ø  Report set name

Ø  Define Report

Ø  Report name

Ø  Title Name

Ø  Attach Row and Column Set

GENERAL LEDGER CONSOLIDATION

1.Create Charts Of Accounts Mapping For Consolidation

Ø  Mapping name & Description

Ø  Select Target COA

Ø  Select Source COA

Ø  Action – 'Copy Value From' for Each Segment

Ø  Consolidation Type- Balance & Transaction

2. Pre-Requisite

Ø  Complete Journal Posting in Source journal

Ø  Open the period in the Destination ledger

3. Transfer Data

Ø  Transfer data from Source to Target

4. Eliminate intercompany balance

5. Run Report

Note :

     If u hav consolidated for (April to September) Already  and if u want to do consolidation for (April to March) then we have to reverse the journal for the period for (April to September) and then run consolidation for the whole period.

FIXED ASSETS SETUPS

1.Asset Book ( Book Control)

Ø  Book Name

Ø  Calendar

Ø  Ledger

Ø  Depreciation Calendar

Ø  Prorate Calendar

Ø  Current Period

Ø  Accounting Rules

Ø  Allow Revaluations

Ø  Allow Group Depreciation

Ø  Natural Account

Ø  Proceed to sale

Ø  Cost of Removal

Ø  Net Book Value Retired

Ø  Revaluation Reserve Account

Ø  Deferred Depreciation Reserve

Ø  Deferred depreciation Expense

Ø  Depriciation Adjustment

Ø  Account generator Default

2.Asset Category

Ø  Category

Ø  Major

Ø  Minor

Ø  Category Type- Leased , Non Leased And Lease hold Improvement

Ø  Ownership – Owned and leased

Ø  General Ledger Accounts

Ø  Book – Attach the book created

Ø  Asset Cost account

Ø  Asset Clearing account

Ø  Depreciation account

Ø  Accumalated Depreciation A/c

Ø  Bonus Expense A/C

Ø  bonus Reserve A/c

Ø  CIP Cost A/c

Ø  CIP Clearing A/c

3.Fiscal Year

Ø  Fiscal Year name

Ø  From Date – To date – Mid year start date – Fiscal Year

4.Calendar

Ø  Calendar Name

Ø  Fiscal Year Name

Ø  Period – Name – from Date – To date

5.Prorate Convention

Ø  Convention Name

Ø  Fiscal Year

Ø  Enable Depreciation When placed in service

Ø  From Date – To date – Prorate Date

6.System Control

Ø  Enterprise Name

Ø  Flexzfeild Structure

Ø  Category Flexfeild – Major & Minor ( Defined in G.L)

Ø  Location Flexfeild – State , City, Sub city (Defined in G.L.)

Ø  Asset Key Flexfeild – (Defined in G.L.)

Ø  Automatic Asset Numbering

Ø  Starting asset number

7.Depreciation Method

Ø  Method name

Ø  Method Type – Table,Calculated, Production,Flat & Formula

Ø  Calculation Basis – Cost & NBV (Net Book Value)

Ø  Enable Depreciate in Year period ( For WDV&SLM)

Ø  Enable Straight Line Method ( For SLM)

Ø  Rates – Year – Period and Annual Rate

8.Category Flexfield (G.L. Responsibility)

Ø  Major – Value – Description And Start Date

Ø  Minor – Independent Value(Major)

Ø  Value – Description – Start date

9.Asset key Flexfield (G.L. Responsibility)

Ø  Value – Asset No

Ø  Start Date – 01-Jan-1951

10.Location Flexfield (G.L. Responsibility)

Ø  City , State & Sub Location