How do I override the FX rate?

OSAdmin
Valued Contributor
Originally posted by Jeff Wood

10/21/2019

I have a point of view in local currency that looks like the following:

Cb#OSTP:E#VCOC_CTX:P#Legal_CTX:C#Local:S#TXActualRTP:T#2017M12:V#YTD:A#TXPTIBA001:F#RTPProvisionVar:O#BeforeAdj:I#Top:U1#CA:U2#Gross_Input:U3#USGAAP_Total:U4#National:U5#None:U6#None:U7#None:U8#None

When I pull the USD point of view for this same calculation, I get the following:

Cb#OSTP:E#VCOC_CTX:P#Legal_CTX:C#USD:S#TXActualRTP:T#2017M12:V#YTD:A#TXPTIBA001:F#RTPProvisionVar:O#BeforeAdj:I#Top:U1#CA:U2#Gross_Input:U3#USGAAP_Total:U4#National:U5#None:U6#None:U7#None:U8#None

My client does not want T#2017M12 for the FX rate but wants to use a 2018 FX rate. How do I override the FX rate? Any help is greatly appreciated. Thanks.

1 REPLY 1

OSAdmin
Valued Contributor
Originally posted by Chul Smith

you can set up a UD8 to dynamically calc it using whatever rate you want (assuming there will be a parameter for the user to select at run-time). The down side is that it'll just translate the entire local balance rather than PVA method. Not exactly sure if that's sufficient for your requirements.