Importing data with dates and multi-currencies
Hi please refer the following attached screenshots:
210325 Line Items
210325 Line Items (alternative view)
210325 Line Items (Data Import)
210325 Import with Failures
210325 Import with Failures Details
To import data from a flat file comprising dates, names and billing rates in different (foreign) currencies e.g. AUD, JPY, SGD and so on. The plan is to convert them to USD (our reporting currency) but first I need to import the raw data. I initially had the dates in Date format and the currencies Line Formatted but converted both to text as Anaplan didn't seem to like different currencies being associated with the same date. I gather from the failure log that Anaplan is expecting only one currency to be associated with each date but the actual situation requires us to handle multicurrency situations where a person could be billing to more than one projects on any given day in different currencies.
So how does one go about doing this? Because of the failures I tried different approaches like removing the Time dimension and converting dates to text rather than Date. I additionally removed the Line Formatting on the Local Currency line item but neither of this works as well.
Look forward to advice on how we resolve this.
ClarenceLine ItemsLine Items (alternative view)Data ImportImport with FailuresImport with Failures Details