add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, December 6

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 Invoicefrom 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 Invoicefrom 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_ACCRUALto  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, SelectProduct 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

No comments: