documentgl

31
Mass Allocation:-Mass Allocation is used to distribute the Expenses to various Expensive heads using simple formula. Cost Pool A/C*Usage Factor Formula is = ------------------------------------- =Target Account Total Usage Factor A*B = ------ = T C C: 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 Journal S: 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

Upload: rgarg

Post on 21-Dec-2015

219 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: 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

Page 2: DocumentGL

Click on the “Find”

Define Parent Department Value.SaveClick on the “Define the Child Ranges”

Page 3: DocumentGL

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

Page 4: DocumentGL

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

Page 5: DocumentGL

Click on the “Formula”

Enter the Mass Allocation Name and DescriptionSelect the Category and Currency

Page 6: DocumentGL

Save and close the form.

Page 7: DocumentGL

Step6:-Generate the Mass JournalNavigation:-Journal>Generate>Mass Journal

Select the Company Segment Value.Select the Batch Name Select the Period Name

Page 8: DocumentGL

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 --------

Page 9: DocumentGL

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

Page 10: DocumentGL

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”

Page 11: DocumentGL

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”

Page 12: DocumentGL

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

Page 13: DocumentGL

Click on the “Find”

Save and Close

Assign to User id.

Page 14: DocumentGL

Step5:-Open the periods for Secondary LedgerNavigation:-Setup>Open/Close

Step6:-Define the Exchange Rates for Subsidiary Ledgers (Daily and Average)

Page 15: DocumentGL

Navigation:-Setup>Currency>Rates>Daily

Page 16: DocumentGL

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.

Page 17: DocumentGL

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

Page 18: DocumentGL

Enter the Consolidation name and DescriptionSelect the Parent Ledger and CurrencySelect the Subsidiary Ledger

Click on the “Mapping”

Page 19: DocumentGL

Enter the Mapping and DescriptionSelect the Target and Source COA

Click on the “Segment Rules”

Page 20: DocumentGL

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.

Page 21: DocumentGL

Click on the “Mapping”

Click on the “Segment Rules”

Page 22: DocumentGL

Save and close the form

Assign the Mapping Save and close.

Step11:-Define the Consolidation SetNavigation:-Consolidation>Define>Consolidation Set.

Page 23: DocumentGL

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

Page 24: DocumentGL

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

Page 25: DocumentGL

Select the Company CodeSelect the Target CurrencySelect the Period

Click on the “Translate”

Step13:-Run the Consolidation Transfer SetNavigation:-Consolidation >Transfer >Data Set

Page 26: DocumentGL

Select the Consolidation SetSelect the Default PeriodSelect the standard Period

Click on the “Query Consolidations”

Page 27: DocumentGL

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.

Page 28: DocumentGL

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

Page 29: DocumentGL

Post it.

Post it.

Page 30: DocumentGL