General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Pablo Schenquerman
    Alocation Rule with multiple source parents and multiple...
    Topic posted January 17, 2019 by Pablo SchenquermanRed Ribbon: 250+ Points, last edited February 6, 2019, tagged Allocations, Financials, Fusion, General Ledger, Intercompany 
    97 Views, 2 Comments
    Title:
    Alocation Rule with multiple source parents and multiple offset Accounts
    Summary:
    Alocation Rule with multiple source parents and multiple offset Accounts
    Content:

    Hello:

    Does anyone can share some print scrrens or PDF if you have a similar requirement

    I have a requirement to create an allocation rule where the source are multiple parent values from different segments and require multiple offset accounts as well

    Scenario

    Source Journal

    Segment 2- Account can have all values

    Segment 8 Market segment can have all values

                                                                                                                                                                            DEBIT          CREDIT     USD

    30000.615600.9999.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.     10,000.00
    30000.615500.9999.99999.CURRENTEXP.9999.99999.11.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.     40,000.00
    30000.615600.9999.99999.CURRENTEXP.9999.99999.99.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.     50,000.00
    30000.110003.9999.99999.CURRENTEXP.9999.99999.99.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT.                        100,000.00

    Allocation range                                                                                                                           

    Based on STAT,

    Account 910410 (segment 2)

    Departmens: ALL (Segment 3)                                                                                                                                   

                                                                                                                                                                                   DEBIT     STAT

    30000.910420.1400.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 6,000.00
    30000.910420.1410.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 2,000.00
    30000.910420.1415.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 3,000.00
    30000.910420.1430.99999.CURRENTEXP.9999.99999.61.00000.DFLTF.DFLTCC.DEFAULTMA.DFLT 1,000.00
     
    I have included the expected result as attachment
     
    Any help is appreciated
     

    Comment