Skip to Content
avatar image
Former Member

Allocation

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 09, 2016 at 07:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded