documentgl

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.