10-05-2022 07:48 PM - last edited on 05-02-2023 10:28 AM by JackLacava
The below code copy the Prior Period FX Rates from one Type to Another. This will read the currency from the application properties. I have hard coded the Period but you can use WF or Global or Param and call in the DM/Dashboard.
'Get the Period
Dim CurrentPeriod As String = "2021M1"
Dim PriorPeriod As String = "2020M12"
'Get Currency from properties
Dim objAppProperties As AppProperties = BRApi.Utilities.GetApplicationProperties(si)
Dim currency() As String = objAppProperties.CurrencyFilter.Split(",")
'Add FX rates
For Each c As String In currency
Dim fxRatePkUsingNames As New FxRatePkUsingNames("AverageRate", PriorPeriod, c.ToString, "USD")
Dim objFxRateUsingNames As FxRateUsingNames = BRApi.Finance.Data.GetStoredFxRate(si, fxRatePkUsingNames)
If objFxRateUsingNames.Amount > 0 Then
Dim fxTargetRatePkUsingNames As New FxRatePkUsingNames("ActPriorMon", CurrentPeriod, c.ToString, "USD")
Dim objFxTargetRateUsingNames As New FxRateUsingNames(fxTargetRatePkUsingNames, objFxRateUsingNames.Amount)
Dim objXFResult As XFResult = BRApi.Finance.Data.SetFxRate(si, objFxTargetRateUsingNames)
End If
Next
Solved! Go to Solution.
10-07-2022 05:10 AM
Thanks @Krishna !
10-07-2022 05:10 AM
Thanks @Krishna !
05-26-2023 06:30 AM
HI
Thanks for this i created a Finance business rule and add this into it however when i consolidate i dont see anything happen. What should trigger this to copy from rate X to Y?
Thanks
05-26-2023 03:49 PM
Hi - This is not the finance rule it is an extensibility rule. You can trigger the finance rule using DM Job.