Foreign currency Invoice Approval through spreadsheet

Summary:

We want to configure AP approvals through spreadsheet where foreign currency invoice should be converted to to Functional currency (GBP) and then it should go for approval to User who has appropriate job level.

Content (please ensure you mask any confidential information):

Hi Team,

We have functional currency GBP so if 1000 USD Foreign currency invoice is created and if conversion rate is 0.5 then invoice amount should be converted to Functional currency GBP which will be 500 and then it should go for approval to the user who has job level which contains 500 amount limit and not to the one who has 1000 amount limit.