Data Import and Multicurrency
When using Multicurrency, there may be instances were you need to import cash receipts where the receipt currency and source currency are different or where there is no source amount specified.
The Data Import utility for Cash Receipts allows you to import amounts in different currencies or automatically calculate a Source Amount during the import process. In this case, Data Entry Mapping grids for both Text and ODBC differ as follows:
- The Amount column is labeled Receipt Amount.
- A Source Amount column displays. This column remains blank for non-invoice receipts. You can choose to either enter data in this field, or this field will populate with an exchanged amount. It only populates if there is data in the invoice field and the Billing Currency differs from the Bank Currency. This is calculated as: ReceiptAmount * (exchange rate based upon TransDate) .
When also using a Multicompany database, the Data Entry Mapping grids for both Text and ODBC have a new row called
Due From Company. The import process validates both of these requirements for this new row:
- This field is required if the Account is defined as a journal entry or transfer cost account in Intercompany Billing.
- This row expects a Company Code that is different from the company assigned to the current Cash Receipt.