Skip to Content
0

Allocation

Dec 08, 2016 at 10:38 PM

65

avatar image

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

capture.jpg (76.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Dec 09, 2016 at 07:55 AM
0

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

Show 7 Share
10 |10000 characters needed characters left characters exceeded

TotalAudit is parent member.

Lifo_inventories is a parent member

0

*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

0

Like this!

0

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

0

*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?

0

It looks strange!

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

0

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

0