Skip to Content
0
Former Member
Dec 16, 2016 at 08:20 PM

BPC MS Script Logic take old values

64 Views

Hello Experts

I have a problem with logic script, when I press the send button in the report this sends data to the default script, then logic script takes the value and calculates the new currency but in the original currency the old value is maintained. If I add a new value to the report and record again, the new currency is calculated correctly but in the original currency it takes the first value to send to save.

Thanks in advance!

BPC MS 10.1 SP 5 EPM SP27

default script:

LOOKUP RATE
*DIM ESCENARIO="ACTUAL"
*DIM KCLF:INPUTCURRENCY="CLF"
*DIM RATE="AVG"
*DIM RATEENTITY="DEFAULT"
*ENDLOOKUP

*WHEN CUENTA

*IS <> FLOBPT_I00,FLOBPT_C00,FLOB_I10,FLOB_I20,FLOB_I30,FLOB_I30_98,FLOB_I30_N98,FLOB_C10,FLOB_C20,FLOB_C30,FLOB_C40,FLOB_C50,FLOB_C60,FLOB_C60_98,FLOB_C60_N98,ROAC_I10,ROAC_I10_98,ROAC_I10_N98,ROAC_C10,ROAC_C10_98,ROAC_C10_N98,ROAN_I10,ROAN_I10_98,ROAN_I10_N98,ROAN_C10,ROAN_C10_98,ROAN_C10_N98,CO_I10,CO_I20,CO_I30,CO_I40,CO_C10,CO_C20,CO_C30,CO_C40,FLOBAC_I10,FLOBAC_I20,FLOBAC_I30,FLOBAC_C10,FLOBAC_C20,FLOBAC_C30,FLOBAC_C40,FLOBAC_C50,FLOBAC_C60,FLOBAC_PI00,FLOBAC_PC00,CO_IUN,CO_CUN
*WHEN CUENTA.AUX
*IS Y

*WHEN MONEDA
*IS "CLP"
*REC(EXPRESSION=%VALUE%,MONEDA="CLF")
*ENDWHEN

*WHEN MONEDA
*IS "CLF"
*REC(EXPRESSION=%VALUE%,MONEDA="CLP")
*ENDWHEN

*IS <> Y

*WHEN MONEDA
*IS "CLP"
*REC(EXPRESSION=%VALUE%/LOOKUP(KCLF)*(-1),MONEDA="CLF")
*ENDWHEN

*WHEN MONEDA
*IS "CLF"
*REC(EXPRESSION=%VALUE%*LOOKUP(KCLF)*(-1),MONEDA="CLP")
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT

*WHEN CUENTA
*IS OR_TO
*WHEN SIGNEDDATA
*IS -6
*SELECT(%ACCSET%,"[ID]",CUENTA,"[PROVISIONES]='Y'")
*SELECT(%AUDSET%,"[ID]",AUDIT)
*FOR %AUXCUENTAS% = %ACCSET%
*FOR %AUXAUDIT% = %AUDSET%
*REC(FACTOR=0,ESTADO = ABIERTO,ESCENARIO=ACTUAL,AUDIT=%AUXAUDIT%,CUENTA=%AUXCUENTAS%)
*NEXT
*NEXT
*ENDWHEN
*ENDWHEN
*COMMIT