We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Allocation based on Account balance (without STAT journal)

Received Response
39
Views
3
Comments
edited Oct 19, 2019 4:52AM in General Ledger & Intercompany 3 comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!