Extra field in Transaction Lines to auto convert unit price to transaction currency

ideas
1

Continuing the discussion from Invoice conversion is ignored by Manager:

If you allow me @Abeiku, I will jump on your band wagon and make another suggestion, what if there was two fields for Unit Price, one called Price - base, the other Price - currency – just for the sake of argument.

And it should work like this:

  1. Price - base gets autofilled on Item selection
  2. Price - currency is always calculated as Price - base × (Exchange rate OR 1) and it should be dynamically recalculated as exchange rate changes,
  3. Price - base should not appear in the UI of the invoice and therefore, the Price - currency field should retain the name Unit price .

This way we avoid the need to manually edit Unit price eveytime we issue a foreign currency invoice. Which proved very prone to errors and could potentially cause serious losses to the users.