BPC MS Script Logic take old values

[Former Member]

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

[Former Member]

Hi Camillo,

Can you please explain the problem with an example. It would be easier to understand.

[former_member283908]

Hello Camillo,

Can you please upgrade to BPC MS 10.1 SP6. Similar issues has been introduced in this SP like in SAP Note :

2324312 - Currency conversion process fails in a specific case

Best Regards,

Dorra.