Hi,
I am struggling to do the following:
Retrieve EBT value and multiply with the tax rate applicable for that time. The tax rate is stored in the same application. On a specific datasource : ADJ_Tax and account = "Perc_tax".
The rate should have the same TIME. The result needs to be written to account A_97010
I tried the below logic and the result that is written is 0 on each intersection.
I actually started with option 3. Which did not work and then i tried 1 and 2 as well, without luck.
(a second problem i have, is that i get an error on, if i use the code:
*xdim_memberset Account= bas(A_EBT))
Help would be highly appreciated.
//=============================================
*lookup Legalapp
*dim Company= company.id
*dim DataSrc= "ADJ_TAX"
*dim TPER: Account= "PERC_TAX"
*dim Time = %Time_Set%
*Endlookup
*select(%PLaccounts%,"ID","ACCOUNT","[Group]='PL' AND [ID] <> 'A_97010'")
*xdim_memberset PROFIT_center=<ALL>
*xdim_memberset Currency=LC
*xdim_memberset Cost_Center=<ALL>
*xdim_memberset DataSrc=<ALL>
*xdim_memberset Category = Actual
*xdim_memberset Account= %PLaccounts%
*xdim_memberset Time = %Time_Set%
*xdim_memberset GROUPS=GSTAR
*calculate_difference=0
*WHEN *
*IS "*"
// option 1
*rec(expression=(%value%*GET(ACCOUNT = "PERC_TAX"),DataSrc= ADJ_TAX,Account= A_97010 , PROFIT_center=PC_NONE,Cost_Center=CC_NONE,Productgroup=PG_NONE, INTCO=I_NONE)
// option 2
//*rec(expression=(GET(ACCOUNT = "PERC_TAX"),DataSrc= ADJ_TAX,Account= A_97010 , PROFIT_center=PC_NONE,Cost_Center=CC_NONE)
// option 3
// *rec(expression=(*lookup(TPER)),DataSrc= ADJ_TAX,Account= A_97010 , PROFIT_center=PC_NONE,Cost_Center=CC_NONE)
*ENDWHEN
*COMMIT