General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Subhash Valiveti
    AllocationsAnswered
    Topic posted December 20, 2017 by Subhash ValivetiGold Medal: 3,500+ Points, last edited January 30, 2019, tagged Allocations 
    116 Views, 6 Comments
    Title:
    Allocations
    Summary:
    Allocations for Budget and Forecasting in Cloud ERP
    Content:

    Hi,

    We have a requirement to do allocations of the Budgets and Forecasting for our client in Cloud ERP

    The below note mentions that this functionality is not possible in the current date.

    Need a confirmation on the same and know if there are any workarounds. The client does not want to use EPM Cloud.

    How to Allocate Budgets in Fusion? (Doc ID 2204193.1)

    Regards,

    Subhash

    Best Comment

    Ba Kwon

    I would expect you to use the same calendar and COA for the new "budget" ledger so it will be in the same cube as your Actual primary ledger. The new "budget" ledger is just another member of the Ledger dimension in the same cube. You don't need to have separate allocation rules with one in each ledger.

    Comment

     

    • Ba Kwon

      We can't use Allocations to create budget because Budget data is stored directly in the Essbase cube whereas the GL contains Actual. Allocations process produces a journal entry in Actual only. You can use budget as source for Allocations, but not target. I have never tried it but I think a potential workaround is to create a another ledger intended to hold the budget data (but it would be stored as Actual). Your Allocations rule would use the budget data as source from your current ledger, and target the new "budget" ledger (Actual). You post the Allocations journal in the "budget" ledger, then run a trial balance. You would then use it as source data for budget spreadsheet to load into your current ledger. You would only assign the "budget" ledger Data Access Set to users that run the budget Allocations so no one else has access. Worth testing it?

      • Subhash Valiveti

        Thank you for response Ba Kwon. We have the requirements to do allocations for budgets and forecasts also. The client's desire is to accomplish these requriements in ERP itself.

        The allocation requirements includes several cascading steps and formulae which have to be done based on the allocated amount rather than the actual (budget) amount.

        Is the suggestion to create a Secondary ledger and do the allocation for budgets (as actuals) and bring them back to the Actual Ledger?

        Regards,

        Subhash

    • Ba Kwon

      The new ledger doesn't have to be a secondary ledger. You can create a primary ledger. It's sole purpose is for storing the "budget or forecast" data that you're trying to allocate to, and then extract via TB as source data for your budget spreadsheet. That's the general idea. I would call it a "special purpose" ledger.  In fact you may not want to use a secondary ledger so that it has no association with your current primary ledger.

      • Subhash Valiveti

        Thank you for the clarification Kwon. Allocation rules are defined per ledger (cube). If we create separate ledger for only budget allocations, we have to configure the allocation rules in both the ledgers. One set for actual ledger another for Budget ledger.

        The client has a requirement where they do the maintenance of allocation rules on a monthly basis which will be same for actuals and Budgets.

        Regards,

        Subhash

    • Ba Kwon

      I would expect you to use the same calendar and COA for the new "budget" ledger so it will be in the same cube as your Actual primary ledger. The new "budget" ledger is just another member of the Ledger dimension in the same cube. You don't need to have separate allocation rules with one in each ledger.