Data Import - Set up to import Foreign Currency Customer Invoices

Good day,

We are using the Data Import feature successfully for out supplier invoices (that are in local currency) and for customer sales invoices (in local currency).

When I try to set up a document type to import foreign currency customer invoices, the import does not work properly.  Even though we enter the foreign unit price into the fUnitPriceExclForeign column, the amount imports as fUnitPriceExcl.  I need some assistance to set up the document type with the correct fields, so the import will work.

Thanks.