General Ledger & Intercompany

Get Involved. Join the Conversation.


    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
    Alocation Rule with multiple source parents and multiple offset Accounts
    Alocation Rule with multiple source parents and multiple offset Accounts


    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


    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