Skip to Content
avatar image
Former Member

BPC MS Script Logic take old values

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 08, 2017 at 11:11 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 19, 2017 at 11:22 AM

    Hi Camillo,

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

    Add comment
    10|10000 characters needed characters exceeded