Allocation based on Account balance (without STAT journal)
Summary
Allocation based on Account balanceContent
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?
Tagged:
0