Skip to Content
0

BPC MS Script Logic take old values

Dec 16, 2016 at 08:20 PM

38

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Dorra KHEZAMI
Jan 08, 2017 at 11:11 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Nilanjan Chatterjee Jan 19, 2017 at 11:22 AM
0

Hi Camillo,

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

Share
10 |10000 characters needed characters left characters exceeded