Rounding issue in BPC

[vamshib01]

Hi Experts,

I am trying to allocate a quantity from ALL_PRODUCTS to base level based on an allocation % that is calculated in different step. The allocation % is 4 decimal places and the quantity to be allocated is 5 decimal places. The output of both is more than 7 decimal places in some instances and because BPC has a limit of 7 decimal places, the output gets truncated as seen in Column F. There is a difference between Total Qty to Qty allocated. Even though in this example it is very negligible, in the grand scheme of things, it adds up to a 1000 difference thereby having to manually adjust it into a different account. Did anyone have this problem and what did you do ?

[former_member186338]

You can add to allocation script few lines to automatically post difference to some account.

[vamshib01]

Below is the code I have to do the allocation. How can I add few lines to automatically post difference to some account. Can you help me?

*XDIM_MEMBERSET RPTCURRENCY=LC
*XDIM_MEMBERSET AUDITTRAIL=INPUT  
*SELECT(%ORGS_WITH_MKT%,ID,SALESORG,SALGROUP=RSC) 
*XDIM_MEMBERSET SALESORG=%ORGS_WITH_MKT%

*RUNALLOCATION
	*FACTOR = (USING/100)
	*DIM ACCOUNTGM  WHAT=Gallons            ;WHERE=<<<             ;Using=ALLOCPERCENT    ;Total=<<<
	*DIM PRODUCT    WHAT=PS_ALLPLAN         ;WHERE=BAS(PS_ALL)     ;Using=<<<             ;Total=<<<
*ENDALLOCATION