R12 ORACLE SUBLEDGER ACCOUNTING STEPS

 

INTRODUCTION – GL, SLA

CREATE A USER WITH RELEVENT RESPONSIBILITIES

                GL, AP, AR, SYS ADMIN, ETC.,

DEFINE MULTI ORG SETUPS

        Legal Entity, Primary Ledger (Operation Accounting Flex)

        Business Group, Operating Unit, Inventory Master Org

DEFINE RESPONSIBILITY

        General Ledger, Payable, Receivables

        Attach the same to the our USER

COMPLETE STEPS:

        General Ledger

                Open Period Status

        Accounts Payable:

                Financial Options, Payable Setup Options, Payable Options

                Define Distribution Sets,

                Create Supplier with One Site (Purchasing, Payment)

        Accounts Receivable:

                System Setups,

                Define Customer with One Site (Bill to, Ship to)

                Define Transaction Type, Manual Sources    

INTRODUCTION – CREATE ACCOUNTING PROCESS

        (Draft, Final & Final Post)

ENTER INVOICES – THROUGH PAYABLES

ENTER A TRANSACTION – THROUGH RECEIVABLES

            Online Accounting Process

        Create Accounting Process –    Draft Method

-          Final Method

-          Final Post Method

               

INQUIRES

    View Subledger Journal Entries / T-Account Format

Navigation: Payables: Accounting/Subledger Accounting/Journal Entries

Nav : Receivables: Accounting/Subledger Accounting/Journal Entries

        View Detailed, Delete, Update, Duplicate, Reverse Journal Entry,

       

   Accounting Events Inquiry Process / T-Account Format

Nav : Payables: Accounting/Subledger Accounting/Journal Entries/Accounting

          Events

        Nav : Receivables: Accounting/Subledger Accounting/Journal Entries/Accounting

          Events

        View Accounting Events, View Subledger Journal Entry

    Drilldown from GL Balance Inquiry Window

ACCOUNTING METHOD BUILDER – OVERVIEW

        (AMB to define the way in which Subledger transactions are accounted)
        Explain the Hierarchy of the AMB

                7      Ledger

                6      Subledger Accounting Method

                5      Application Accounting Definition

                4      Journal Line Definition

3      Account Derivation Rule

                2      Journal Line Descriptions

1      Journal Line Types

       

Step 1 :

        Res : Payables, Vision Operations

        Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting  

            Methods Builder / Journal Entry Setups / Journal Line Types

Click on New

In the Event Class field, Select Invoices

In the Line Type Code field, enter 01_MISC_EXPS_JLT

In the Name field, enter 01_MISC_EXPS_JLT

In the Description field, enter 01_MISC_EXPS_JLT

In the Balance Type region, select Actual

In the Side region select the Radio button as Debit

Select Yes from the Switch Debit/Credit from Dropdown List.

In the Merge Merging Lines field, select No

In the Transfer to GL region, select Summary.

Click on Conditions Button

In the Seq field, enter 10

In the Source field, select Invoice Distribution Type

In the Operator field, select ‘=’

In the Value type field, select Constant

In the Value field, select Item or Miscellaneous

Click on Save.

Click on New

In the Event Class field, Select Invoices

In the Line Type Code field, enter 01_AP_LIABILITY_JLT

In the Name field, enter 01_AP_LIABILITY_JLT

In the Description field, enter 01_AP_LIABILITY_JLT

In the Balance Type region, select Actual

In the Side region select the Radio button as Credit

Select Yes from the Switch Debit/Credit from Dropdown List.

In the Merge Merging Lines field, select No

In the Transfer to GL region, select Summary.

No Conditions are required for the Liability Journal Type

Click on Save.

Res : Receivables, Vision Operations

        Nav : Setup /Accounting /Accounting Methods Builder / Journal Entry Setups /

                     Journal Line Types

Click on New

In the Event Class field, Select Invoices

In the Line Type Code field, enter 01_AR_REVENUE_JLT

In the Name field, enter 01_AR_REVENUE_JLT

In the Description field, enter 01_AR_REVENUE_JLT

In the Balance Type region, select Actual

In the Side region select the Radio button as Credit

Select Yes from the Switch Debit/Credit from Dropdown List.

In the Merge Merging Lines field, select All

In the Transfer to GL region, select Summary.

Click on Conditions Button

In the Seq field, enter 10

In the Source field, select Transaction Distribution Account Class

In the Operator field, select ‘=’

In the Value type field, select Constant

In the Value field, select REV

Click on Save.

Click on New

In the Event Class field, Select Invoices

In the Line Type Code field, enter 01_AR_RECEIVABLE_JLT

In the Name field, enter 01_AR_RECEIVABLE_JLT

In the Description field, enter 01_AR_RECEIVABLE_JLT

In the Balance Type region, select Actual

In the Side region select the Radio button as Debit

Select Yes from the Switch Debit/Credit from Dropdown List.

In the Merge Merging Lines field, select No

In the Transfer to GL region, select Summary.

No Conditions are required for the Receivable Journal Type

Click on Save.

Step 2 :Res : Payables, Vision Operations

        Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting  

            Methods Builder / Journal Entry Setups / Account Derivation Rule

       

Click on New

        The Account Derivation Rules window appears

        In the Rule code field, enter 01 AP Misc_ADR

        In the Rule Name field, enter 01 AP Misc_ADR

        In the Rule Description Name field, enter 01 AP Misc_ADR

        In the Accounting Chart of Accounts field, Select Operations Accounting Flex

        Select the Radio button as Flexfield

        In the Priority field, enter 1

        In the Value Type field, select Source

        In the Value field, enter Invoice Distribution Account

Click on Save icon

Click on New again

        In the Rule code field, enter 01 AP_LIABILITY_ADR

        In the Rule Name field, enter 01 AP_LIABILITY_ADR

        In the Rule Description Name field, enter 01 AP_LIABILITY_ADR

        In the Accounting Chart of Accounts field, Select Operations Accounting Flex

        Select the Radio button as Flexfield

        In the Priority field, enter 1

        In the Value Type field, select Constant

        In the Value field, enter 01-000-2220-0000-000

        Click on Save icon

Res : Receivables, Vision Operations

        Nav : Setup /Accounting /Accounting Methods Builder / Journal Entry Setups /

                     Account Derivation Rule

Click on New

        The Account Derivation Rules window appears

        In the Rule code field, enter 01 AR_REVENUE_ADR

        In the Rule Name field, enter 01 AR_REVENUE_ADR

        In the Rule Description Name field, enter 01 AR_REVENUE_ADR

        In the Accounting Chart of Accounts field, Select Operation Accounting Flex

        Select the Radio button as Flexfield

        In the Priority field, enter 1

        In the Value Type field, select Source

        In the Value field, enter Transaction  Distribution GL Account

        Click on Save icon

Click on New again

        In the Rule code field, enter 01 AR_RECEIVABLE_ADR

        In the Rule Name field, enter 01 AR_RECEIVABLE_ADR

        In the Rule Description Name field, enter 01 AR_RECEIVABLE_ADR

        In the Accounting Chart of Accounts field, Select Operations Accounting Flex

        Select the Radio button as Flexfield

        In the Priority field, enter 1

        In the Value Type field, select Constant

        In the Value field, enter 01-000-1220-0000-000

        Click on Save icon

        Close the Account Derivation Rule window 

Step 3 :

Res : Payables, Vision Operations

         Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting  

            Methods Builder / Methods and Definition / Journal Line Definitions

       

Create a New Journal Lines Definitions

        The Journal Lines Definitions window appears

        In the Event Class field select Invoice from LOV

        In the Event Type field, select All or Each Event Type

        In the Definition Code field, enter 01_ACCRUAL_INVOICES_JLD

        In the Definition Name field, enter 01_ACCRUAL_INVOICES_JLD

        In the Description field, enter 01_ACCRUAL_INVOICES_JLD

        In the Accounting Chart of Account field, enter Operations Accounting Flex

        In the Journal Line Type field,

        Select 01_MISC_EXPS_JLT from LOV

enter Line Description as Invoice  Distribution Description

In the Account Derivation field,

In the Segment field, Select All Segment or Required Segment,

In the Rule field, Select  01 AP Misc_ADR from LOV Save.

In the Journal Line Type field

Select 01_AP_LIABILITY_JLT

enter Line Description as Invoice  Distribution Description

Click on Save.

In the Account Derivation field,

In the Segment field, Select All Segment or Required Segment,

In the Rule field, Select  01 AP_LIABILITY_ADR from LOV Save.

Res : Receivables, Vision Operations

Nav : Setup /Accounting / Accounting Methods Builder / Methods and Definition / Journal Line Definitions

Create a New Journal Lines Definitions

        The Journal Lines Definitions window appears

        In the Event Class field select Invoice from LOV

        In the Event Type field, select All or Each Event Type

        In the Definition Code field, enter 01_ACCRUAL_AR_JLD

        In the Definition Name field, enter 01_ACCRUAL_AR_JLD

        In the Description field, enter 01_ACCRUAL_AR_JLD

        In the Accounting Chart of Account field, enter Operations Accounting Flex

        In the Journal Line Type field,

        Select 01_AR_REVENUE_JLT from LOV

enter Line Description as Transaction Distribution GL Account

In the Account Derivation field,

In the Segment field, Select All Segment or Required Segment,

In the Rule field, Select  01 AR_REVENUE_ADR from LOV Save.

In the Journal Line Type field

Select 01_AR_RECEIVABLE_JLT

enter Line Description as Invoice Header Description

Click on Save.

In the Account Derivation field,

In the Segment field, Select All Segment or Required Segment,

In the Rule field, Select  01 AR_RECEIVABLE_ADR from LOV

Save. Close the window

Step 4 : Res : Payables, Vision Operations

Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting Methods Builder / Method and Definitions / Application Accounting Definitions

Click on Find Button

Click on Copy Button

In the Copy Application Accounting Definitions Window

In the Definition Code field, enter 01_AP_ACC_AAD

In the Definition Name field, enter 01_AP_ACC_AAD

In the Description Field, enter 01_AP_ACC_AAD

In the Accounting field enter Operations Accounting Flex

Click on Done

Res : Receivables, Vision Operations

Nav : Setup /Accounting / Accounting Methods Builder / Method and Definitions / Application Accounting Definitions

Click on Find Button, Click on Copy Button

In the Copy Application Accounting Definitions Window

In the Definition Code field, enter 01_AR_ACC_AAD

In the Definition Name field, enter 01_AR_ACC_AAD

In the Description Field, enter 01_AR_ACC_AAD

In the Accounting field enter Operations Accounting Flex

Click on Done

Step 5 :Step 2 : Res : Payables, Vision Operations

Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting Methods Builder / Method and Definitions / Subledger Accounting Methods

In the Subledger Accounting Method Find window In the Method Name field enter Standard Accrual

Click on Find Button

Click on Copy Button

In the copy window Method Code field enter 01_STANDARD_ACCRUAL

                          In the Description field enter 01_STANDARD_ACCRUAL

                  In the Accounting field enter Operations Accounting Flex

Click on OK Button, Click on Done Button

Click on Payables Field under Application Accounting Definitions Assignments

Enter the end date as 31-Dec-2009

Click on New (+) I con

Select Applications as Payables from LOV

Name Select 01_AP_ACC_AAD from the LOV

Enter the date as 01-Jan-2010

Click on Save Icon

Assigning the Subledger Accounting Method 01_STANDARD_ACCRUAL to  our own Primary  Ledger

Step 6 :Nav : Setup / Accounting setups / Ledger Setup / Define / Accounting Setup

In the Search window enter 01 Primary Ledger, click on Search

Click on Update Accounting Options next to the Ledger

In the Primary Ledger Region, click the update Icon for the 01 Primary Ledger

In the Subledger Accounting Method field, update the Subledger accounting method to 01_STANDARD_ACCRUAL from LOV

Click on Finish

Res : Receivables, Vision Operations

Nav : Setup /Accounting / Accounting Methods Builder / Method and Definitions / Subledger Accounting Methods

In the Subledger Accounting Method Find window In the Method Name field enter 01_STANDARD_ACCRUAL

Click on Find Button

Click on Receivables field under Application Accounting Definitions Assignments

Enter the end date as 31-Dec-2009

Click on New (+) I con

Select Applications as Receivables from LOV

Name Select 01_AR_ACC_AAD from the LOV

Enter the date as 01-Jan-2010

Click on Save Icon

Verification

        Res : Payables, Vision Operations

Enter Invoices (1) having two lines through payables, validate,

 Invoice - Online Create Accounting (Final Post in GL)

         (Or)

Transaction - Through Concurrent Create Accounting Program

(Final Trf to GL)

    Reports View Accounting

 (or)

Nav : Accounting  / Subledger / Jounral Entries

Res : Receivables, Vision Operations

       

Enter  Transactions (1) having Multiple Lines

 Transaction - Online Create Accounting (Final Post in GL)

         (Or)

Transaction - Through Concurrent Create Accounting Program

(Final Trf to GL)

    Tools View Accounting (or)

Nav : Inquiry  / Subledger Accounting / Jounral Entries

MAPPING SET

      Step 1 : Res : Payables, Vision Operations

        Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting   

            Methods Builder / Journal Entry Setups / Mapping Sets

Click on New

The Mapping Sets Window appears

In the Mapping Set code field enter 01_Mapping_Set

In the Mapping Set Name field enter 01_Mapping_Set

In the Mapping Set Description field enter 01_Mapping_Set

In the Output Region select Operations Accounting Flex from LOV

Select the Radio button as Segment, Select Product from LOV

In the Mapping Set Value Retions

Value Type        Input Value       Output Value      Start Date

Default                                                 000

Input                   01 IBM Supplier       110

Input              02 IBM Supplier       120

Input                   03 IBM Supplier       130

Click on Save :

    Step 2 : Res : Payables, Vision Operations

        Nav : Setup /Accounting Setup / Subledger Accounting Setup / Accounting  

            Methods Builder / Journal Entry Setups / Account Derivation Rule

        The Find Account Derivation Rule windows open

        Click on New

        In the Rule code field, enter 01_Product_ADR

        In the Rule Name field, enter 01_Product_ADR

        In the Rule Description Name field, enter 01_Product_ADR

        In the Accounting Chart of Accounts field, Select Operations Accounting Flex

        Select the Radio button as Segment as Product

        In the Priority field, enter 1

        In the Value Type field, select Mapping Set

        In the Value field, Selectg 01_Mapping_Set

Click on Save icon

        Attach to the relevant place and verify the output.

REPORTS

        Journal Entries Report

        Account Analysis Report       

        Third Party Balances Report

        Period Close Exception Report

        Open Account Balances Listing

Generate the Journal Entries Report for Payables

Program Name Journal Entries Report

Generate the Journal Entries Report for Receivables

Program Name Journal Entries Report

CREATE MANUAL SUBLEDGER JOURNAL ENTRIES

        Payables / Accounting / Subledger Accounting / Journal Entries

        Click on Create Journal Entry Button

        In the Ledger field, select Vision Operations (USA)

        In the GL Date field, enter 01-Jan-2009

        In the Category field, select Purchase Invoices

        In the Description field, enter Project Meeting

        Click on Add 5 Lines

        Debit 01-450-7640-0000-000   1702

        Debit 01-450-7670-0000-000     750

        Debit 01-450-7650-0000-000     455

        Credit 01-000-2210-0000-000               2907

        Click on Calculate Totals

        Click on Continue Button

        In the Complete field, select, Draft

        Click on Finish.

ADVANCED OPTIONS

        Define Custom Sources

        Set up business flows

        Use Multi period Accounting

        Determine how and when accrual reversals are performed

        Set up third party control accounts

        Setup alternative accounts

        View errors

        Sequence Journal Entries