Hello Experts,
We are using Washington release. We are using SPM and my question relates to pm_project record.
We have 2 custom fields on the pm_project form -- (Sales Price/Piece) of type FX Currency and Sales (EUR) of type Currency.
I am importing project records from an xls where I have USD, INR and EUR currencies. I populate these in the Sales Price/Piece i.e. FX Currency and since the System Import/Transform program uses setDisplay values, these various values show up with correct currency code in the form. I also find that there is an entry in the table fx_currency2_instance since we are converting the total sales of INR or USD into EUR and populating the Sales field.
My question is - how can we programmatically set the Exchange Rate in the table fx_currency2_instance for each project? Currently after the import, I find that the "Exchange Rate Used" column is blank hence on the form the converted to EUR value does not show in the Sales (EUR) field. We have created a custom table to store currency exchange rates that extends table "Currency Conversion Rate"
