General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Sunil KK
    Allocation based on Account balance (without STAT...
    Topic posted October 18, 2019 by Sunil KKGreen Ribbon: 100+ Points, tagged Allocations, Financials, General Ledger 
    32 Views, 3 Comments
    Title:
    Allocation based on Account balance (without STAT journal)
    Summary:
    Allocation based on Account balance
    Content:

    Hi All,

    I would like to know if anyone has achieved similar allocation as below:

    Scenario:

    Jan-19 PTD Balances are as follows:

    A1) All expenses are recorded in Account    50001 and product 101 , say 100 USD (This is for expenses belong to both product 101 and 102)

    B1) Revenue is correctly recorded against : 40001 and product 101, say 200 USD

    B2) Revenue is correctly recorded against :  40002 and product 102, say 100 USD

    I would like to allocate Expenses from 50001.101 to 50002.102 based on % revenue derived from B1 and B2 ). i.e, Target amount A2 = (B2/B1+B2) * A1 

    Offset Account = A1

    As seen above, the allocation is based on balance instead of STAT journal. Is this possible using either formula or Allocation ? Any thoughts?

     

    Thanks,

    Sunil

    Version:
    19C

    Comment