Hi

As the data is generated 'on the fly', you may not be able edit how the form calculates the data, but could use SQL Profiler to get which select statements are used to calculate the values using the standard Exchange Rate value on this form.  Then use them to create your own and substitute your custom value instead.

Hope this helps

Anthony

In the BeforeClick event, get hold of the adjustment using

Sage.Common.Helper.PropertyHelper.GetValue(form.UnderlyingControl,"Adjustment")

then you can do what you want with the adjustment.RevaluedTradingAccountEntries

I haven't tested it (no suitable demo data), but I think all you need to do (assuming it's a Period exchange rate) is set Adjustment.PeriodDocumentToBaseCurrencyRate.ExchangeRate in the BeforeClick event. The revaluation should then use that rate.

thank you. This method works for me. I also need to set the value for Adjustment.SingleDocumentToBaseCurrencyRate.ExchangeRate.

Sage.Accounting.TradeLedger.TradingRevaluationAdjustment Adjustment = (Sage.Accounting.TradeLedger.TradingRevaluationAdjustment) Sage.Common.Helper.PropertyHelper.GetValue(_form.UnderlyingControl, "Adjustment");
Adjustment.PeriodDocumentToBaseCurrencyRate.ExchangeRate = Convert.ToDecimal(periodExchangeRateTextBox.Text);
Adjustment.SingleDocumentToBaseCurrencyRate.ExchangeRate = Convert.ToDecimal(periodExchangeRateTextBox.Text);