Allocation

[Former Member]

I am trying to allocate data entered (input template)to one acct to multiple accts based on prior period actuals will below logic work for the scenario?

*XDIM_MEMBERSET ACCOUNT = BAS(LIFO_INVENTORIES)

*XDIM_MEMBERSET AUDIT_ID = BAS(TOTALAUDIT)

*XDIM_MEMBERSET CURRENCY = LC

*XDIM_MEMBERSET TIME = 2017.01,2016.12

*XDIM_MEMBERSET VERSION =PLAN,ACTUAL

*XDIM_MEMBERSET ENTITY = PC2000

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT WHAT=LIFO_INVENTORIES;WHERE=BAS(LIFO_INVENTORIES);USING=BAS(LIFO_INVENTORIES);

*DIM AUDIT_ID WHAT=MANUAL; WHERE=IC_ALLOC; USING=TOTALAUDIT;

*DIM INTERCO WHAT=I_NONE; WHERE=BAS(I_ALL); USING=BAS(I_ALL);

*DIM VERSION WHAT=PLAN; WHERE=<<<; USING=ACTUAL;

*DIM TIME WHAT=2017.01; WHERE=<<<; USING=2016.12 ;

*ENDALLOCATION

[former_member186338 · Accepted solution]

First: Using the line *FACTOR=USING/TOTAL you have to specify TOTAL in each *DIM line!

Second: *DIM AUDIT_ID WHAT=MANUAL; WHERE=IC_ALLOC; USING=TOTALAUDIT; - is TOTALAUDIT a base member?

Also the following lines are useless (dimensions are specified in RUNALLOCATION):

*XDIM_MEMBERSET ACCOUNT = BAS(LIFO_INVENTORIES)
*XDIM_MEMBERSET AUDIT_ID = BAS(TOTALAUDIT)
*XDIM_MEMBERSET TIME = 2017.01,2016.12
*XDIM_MEMBERSET VERSION =PLAN,ACTUAL

[Former Member · Accepted solution]

TotalAudit is parent member.

Lifo_inventories is a parent member

[Former Member · Accepted solution]

*RUNALLOCATION

*FACTOR=USING/TOTAL

*DIM ACCOUNT WHAT=BAS(LIFO_INVENTORIES);WHERE=BAS(LIFO_INVENTORIES);USING=<<<;TOTAL=<<< *DIM AUDIT_ID WHAT=ENTRY; WHERE=IC_ALLOC_CALC; USING=BAS(TOTALAUDIT); TOTAL=<<<

*DIM INTERCO WHAT=I_NONE; WHERE=BAS(I_ALL); USING=<<<;TOTAL=<<<

*DIM VERSION WHAT=PLAN; WHERE=<<<; USING=ACTUAL;TOTAL=<<<

*DIM TIME WHAT=2017.01; WHERE=<<<; USING=2016.12;TOTAL=<<<

*ENDALLOCATION

[former_member186338 · Accepted solution]

You can't use parent member in USING, please read help! Only BAS(TOTALAUDIT) allowed.

[former_member186338 · Accepted solution]

Like this!

[former_member186338 · Accepted solution]

But I am not sure about this line:

*DIM ACCOUNT WHAT=BAS(LIFO_INVENTORIES);WHERE=BAS(LIFO_INVENTORIES);USING=<<<;TOTAL=<<<

WHAT is a single account in your screenshot

[Former Member · Accepted solution]

*DIM ACCOUNT WHAT=BAS(LIFO_INVENTORIES);WHERE=BAS(LIFO_INVENTORIES);USING=<<<;TOTAL=<<<

from input template data is sent to one acct under lifo_inventorries.

instead of harcoding the base account , can we use LIFO_inventories(parent member) in WHAT section?

[former_member186338 · Accepted solution]

It looks strange!

You have some dedicated account to enter amount for distribution. Use single account in the script!