Hello,
I have an issue, where I tried to combine for quite a while but I dont get it work.
We have an overall currency table (with a curdoc rate). Additionally I have several data tables (i.e. WriteOff_Details, Invoice_Details) where I need to calculate the EUR-Value. We want this as additional field (or predefined formula in script, which calculated when the field is used in a table) but the main Currency Table must remain.
There are two important issues:
All tables have one date but the currency table has a valid_from and a valid_to field.
All tables have Landcode (UK, US,...) which is the second parameter to get the correct currency.
How can I reach, that Write-off from 15.02. in UK is taking the rate in GBP from 01.02. until 28.02.?