documentgl
TRANSCRIPT
Mass Allocation:-Mass Allocation is used to distribute the Expenses to various Expensive heads using simple formula.
Cost Pool A/C*Usage FactorFormula is = ------------------------------------- =Target Account Total Usage Factor
A*B = ------ = T CC: Constant:-The segment is constant does not require sum or loop. And Balances will be picked against “A” as a constant.L: Looping:-This segment needs looping the value is provided in STAT JournalS: Summing:-This segment needs to sum the values is provided in STAT Journal
Step1:-Create the Cost Poll and Usage Factor Account Codes.Navigation:-Setup>Financial>Flex Field>Key >Values
Save and close.Step2:-Define one Parent Department Value and Assign child values.Navigation:-Setup>Financial>Flex Field>Key >Values
Click on the “Find”
Define Parent Department Value.SaveClick on the “Define the Child Ranges”
Select the From Value and To Value
Step3:-Create one Cost Pool Journal and Post it.Navigation:-Journal>Enter
Step4:-Enter one STAT JournalNavigation:-Journal>Enter
Select the Currency is “STAT”Enter the Debit Side amountsNote:-STAT Journal balances will not impacted on the Trial Balance or any other reports.Click on the “Post”
Step5:-Define the Mass Allocation FormulaNavigation:-Journal>Define>Allocation
Enter the Batch Name and Description
Click on the “Formula”
Enter the Mass Allocation Name and DescriptionSelect the Category and Currency
Save and close the form.
Step6:-Generate the Mass JournalNavigation:-Journal>Generate>Mass Journal
Select the Company Segment Value.Select the Batch Name Select the Period Name
Click on the “Generate”After Click on the Generate button system will run the one concurrent program
After complete this program, we can query the JournalNote:-Generally in Vision Instance the above concurrent program will be completed with error. If the concurrent program completed with Normal, the journal will be created like below.
After Completes the Concurrent Program System will calculate amounts like below.
100-Finance = 12000*4/26=1846200-Marketing = 12000*7/26=3230300-HR = 12000*9/26=4154400-Admin = 12000*6/26=2770 ------- 12000 --------
Accounting Entry
LineAccountDebit Credit 1 10.100.74201.0000.000.000 1846 2 10.200.74201.0000.000.000 3230 3 10.300.74201.0000.000.000 4154 4 10.10074201.0000.000.000 2770 5 10.100.50100.0000.000.000 12,000 ----------- ----------- 12,000 12,000 ----------- -----------
Consolidation:-Consolidation is used to consolidate the multiple subsidiary Ledger data into parent LedgerNormal Consolidation:-A parent ledger with one subsidiary is called a Normal ConsolidationGlobal Consolidation: - A Parent Ledger having more than one subsidiary Ledger is called a Global Consolidation There are 2 Consolidation Method
(1) Transaction(2) Balances
(1)Transaction:-We can use this consolidation method, when parent primary Ledger and Subsidiary Ledgers share the same Currency(2)Balance:-The Balance Method consolidates using the balances with out Journal Details. If we have different function currency. We have to use this consolidation method.
There are 3 segment Rules(a) Copy Value From(b) Assign Single Value(c) Use Rollup Rules From
(a)Copy Value From:-Copies the segment values of the subsidiary ledger directly into segment values of the parent ledger. The Two Ledger does not need to share the same value set. But it must have same valid segment values.(b)Assign Single Value:-Use a constant as a segment value for the parent Ledger.(c)Use Rollup Rules From:-Maps the segment values from the subsidiary ledger to parent Ledgers using the Use Rollup Rules From specified in the Rollup Rules From.
Step1:-Define the Parent and Subsidiary Ledgers Note:-Primary Ledger and one secondary Ledger alreadydefined. So we have define the one more Secondary Ledger with currency of “EUR”Query the Primary LedgerNavigation:-Setup>Financial>ASM>Accounting Setup
Click on the “Add Secondary Ledger”
Enter the Secondary Ledger NameSelect the COASelect the Calendar nameSelect the Currency and Sub ledger Accounting Method.Select the Data Conversion Level.
Click on the “Apply”Scroll down select the Secondary Ledger
Click on the Ledger Options “Update”
Click on the “Next”
Enter the Retained Account and Click onthe “Next”Again Click on the “Next”Finally Click on the “Finish”
Click on the Primary to secondary Ledger Mapping “Update”
Click on the “Complete”
Step3:-Define the Responsibility for Secondary Ledger.Navigation:-Security>Responsibility>Define
Save and close
Step4: Assign the Profile and assign to user id also.Navigation:-Profile>System
Click on the “Find”
Save and Close
Assign to User id.
Step5:-Open the periods for Secondary LedgerNavigation:-Setup>Open/Close
Step6:-Define the Exchange Rates for Subsidiary Ledgers (Daily and Average)
Navigation:-Setup>Currency>Rates>Daily
Save and Close.
Step7:-Enable the Translation Options at Secondary and Primary Ledger Level.Navigation:-Setup>Financial>ASM>Accounting SetupQuery the Primary Verify the Translation Options.
Enabled the XYZ Primary Ledger Level.Query the XYZ Secondary Ledger
Enabled the XYZ Secondary Ledger Level
Query the XYZ EUR Secondary Ledger
Enabled the XYZ EUR Secondary Ledger Level
Step8:-Enter the Journal under Secondary Ledgers, If Balances has not available.Navigation:-Journal>EnterEnter the Journal under XYZ Secondary Ledger and post it.
Step9:-Enter the Journal under Secondary Ledgers, If Balances has not available.Navigation:-Journal>EnterEnter the Journal under XYZ EUR Secondary Ledger and post it.
Save and Post.Step10:-Define the Consolidation Navigation:-Consolidation >Define>Consolidation
Enter the Consolidation name and DescriptionSelect the Parent Ledger and CurrencySelect the Subsidiary Ledger
Click on the “Mapping”
Enter the Mapping and DescriptionSelect the Target and Source COA
Click on the “Segment Rules”
Select the Action for Source Accounting Structure
Save and Close the form.
Assign the Mapping Set.Save and close the form.
Define the Mapping for XYZ EUR Secondary Ledger also in same manner.
Click on the “Mapping”
Click on the “Segment Rules”
Save and close the form
Assign the Mapping Save and close.
Step11:-Define the Consolidation SetNavigation:-Consolidation>Define>Consolidation Set.
Enter the Consolidation Set NameSelect the Parent Ledger nameSelect the secondary Ledgers
Save and close.
Step12:-Run the Translation from Subsidiary LedgersNavigation:-Currency>TranslationRun the Translation from XYZ Secondary Ledger
ddSelect the Company CodeSelect the Target CurrencySelect the Period
Click on the “Translate”
Once the concurrent program completed, Translation got completed.
Run the Translation from XYZ EUR Secondary LedgerNavigation: Currency>Translation
Select the Company CodeSelect the Target CurrencySelect the Period
Click on the “Translate”
Step13:-Run the Consolidation Transfer SetNavigation:-Consolidation >Transfer >Data Set
Select the Consolidation SetSelect the Default PeriodSelect the standard Period
Click on the “Query Consolidations”
Select the Consolidation and click on the “Transfer”
System has run there are two concurrent programsClick on the “OK”Step14:-Verify the Concurrent ProgramNavigation:-View>Request>Find
After complete the above concurrent, then only we can go the below steps.
Step15:-Verify the Un-posted Journals in Primary Ledger and Post it.Navigation:-Journal>Enter
Select the source Name “Consolidation”Click on the “Find”
System has created there are two journals from two different Secondary Ledgers.Click on the “Review Journal” and verify and Post Journal
Post it.
Post it.