Data import with non-numeric values
While importing data from one module to another, one of the fields "currency" is non-numeric.
For example, we will have the following records:
Product A, Customer B, 02/2020, 1000, GBP
Product A, Customer B, 03/2020, 2000, USD
In the case above, the data values are loaded correctly to both months, but only the first occurrence of currency is loaded. The second record will also be shown as GBP in the database. Is there an easy solution for this? Thank you!