G/L Import - Attempt to change read-only field “Currency Rate” (2 replies)
Steve, there needs to be an improvement made to the Journal Import to handle this scenario, however there is a workaround:
In a Map transform prior to the G/L Import, on the Currency Rate field, enter the following formula.
Dim Result 'CurrencyRate is your field name. Result = %CurrencyRate 'If the currency of the detail is equal to the HomeCurrency If %Currency = "GBP" Then 'Clear the Value of the Currency Rate Field....SetFieldNull returns an empty string. Result = SetFieldNull("CurrencyRate") End If 'Now set the Result back to the field. Result
Dim Result
'CurrencyRate is your field name.
Result = %CurrencyRate
'If the currency of the detail is equal to the HomeCurrency
If %Currency = "GBP" Then
'Clear the Value of the Currency Rate Field....SetFieldNull returns an empty string.
Result = SetFieldNull("CurrencyRate")
End If
'Now set the Result back to the field.
Result
Well that worked a treat thanks very much. I didn't know that was a way to handle it so not an issue at all.
Can you possibly advise on a Sage 300 GL journal problem please? We are developing a job that creates GL journal entries with multiple details. The details are always mixed currencies so we provide an exchange rate for each detail and put it to Currency Rate on the Journal Details. If the source and functional currencies are the same then the rate is 1.
However, when source currency of a detail is the same as the functional currency we get the following Sage 300 error:
Accpac API Error 1144 – Journal Detail
Attempt to change read-only field “Currency Rate”
Do you have any ideas what we can do here? We can’t process the source=functional transactions separatley from others because the journals wouldn’t balance.