I'm having an issue with a Global Expense form built using Nintex Forrms for Office 365. Expenses are calculated using a lookup from a list of currency rates which convert the cost to USD.
The Fx Rate is updated monthly and this results in the calculated value changing on all previously submitted forms and not just the current form.
I am using a repeating section to add expenses for approval as below: As you will see the
There is no copy item function in Nintex workflow for Office 365 in order to copy all approved expenses with attachments to a separate list as that would have been an option, The create item does not include attachments
Hope someone can tell me if I'm missing something easy here, I've also considered using workflow to store the FX rate to a text field on each row then changing the lookup to the text field value on form approval too.
Hey thanks for the quick response,
I have spoken to the customer who need more instructions on how this will impact the Finance Department who ultimately will be responsible for updating the FX rate for all 170 currencies each month.
So when you say "In your FxRate list insert the concatenation of year with month number in front of the currency value all in one field." do you mean GBP would change to 201911GBP, and what about the December update??
i did have an idea to create a separate column for each update eg 201911 would have this month's FXRates, then a new column 201920 for December etc. But how to reference that in the formula??
There is an added layer of complexity however, the form has 2 stages, Travel Authorisation where estimated expenses are submitted and approved in advance of travel, this then activates the Travel Claim process where actual expenses are submitted and the FX rate may have changed.
They can't have staff being left out of pocket because of the change in FX Rate.
Your advice here has been really helpful Thanks!