We’re attempting to bulk import price lists from our legacy ERP into CloudSuite Pricing Management using the Data Import Utility. The import consistently fails with currency validation errors. Our source data contains price lists in multiple currencies (USD, EUR, GBP, CAD), and we’ve verified the ISO currency codes match exactly. However, the staging table rejects records where conversion rates aren’t defined between certain currency pairs. We have over 15,000 price list items across 8 currencies, and manually fixing these would take weeks. The error log shows “Invalid currency conversion” for EUR to CAD and GBP to CAD pairs specifically. Is there a way to configure the staging table to accept these records, or do we need to pre-populate all possible currency conversion rates before import? Our go-live is in three weeks.
One thing people often miss: the staging table doesn’t just validate currency codes and rates - it also checks the temporal alignment. If your conversion rates have gaps in their effective date ranges, imports will fail even if the rates exist. Run a query against your currency rate table to find any gaps between start and end dates for your required pairs.
The staging table configuration is actually the key issue here. CloudSuite requires conversion rates to be defined in the system BEFORE importing price lists that reference those currency pairs. You can’t bypass this validation because it’s a data integrity check. Check your Currency Conversion Rate setup in Financial Management and ensure all pairs are defined with effective dates that cover your price list validity periods.
I’ve seen this exact scenario. The problem is that the import tool validates currency relationships during staging, not just ISO codes. Your EUR to CAD and GBP to CAD conversions are missing from the master currency table. Go to Setup > Financial > Currency Conversion Rates and add these pairs with appropriate rates. Make sure the effective date range covers all your price list dates. Once those are in place, re-run your import batch. The staging validation will pass, and your 15,000 items should load without issues.