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
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:
Post a Comment