All Dynamics SL users have the standard import capabilities through the transaction import tool. When using the transaction import screen, the process is powerfully enhanced by use of the Control Macro Generator, which dynamically adjusts for any customizations for field names, and layout. This tip addresses importing transactions say in Canadian dollars to a SL application which has a base currency in US dollars.
Dynamics SL users who have purchased the Multi Currency module, have the ability to enter transaction in multiple currencies for many of the data entry screens. One challenge the user of the multi currency module is how you import transactions in a currency different than the base currency for the application database.
This tip was created by Kevin Flynn, QA Associates, when he was helping an end user on the Solomon form. Here is Kevin's response:
It's quite easy actually for any screen that handles multi currency. The trick is to precede the normal TI data file with a currency line that states that currency, rate and effective date, after that everything else is the same, and you don't need to alter the TI control file. Remember, though, that you can only have ONE CURRENCY PER BATCH!!! Please see the example for
Voucher Entry (screen id : 03010.00) below:
Currency, CAD
CuryRate, SPOT, 03/03/2003, .74
"Batch",,200501,"H",100.00,
"Document",,"VO","VENDID",03/03/2003,,03/03/2003,01,100.00,0,"A",,,,,03/03/2003,,,,,,,,,,,,,,,,,,,,,,,,
"Transaction","N",5200,,,0000,,,,,100.00,,,,,,,,,,,,,,,,,,,,,
(where CAD = the correct currency and VendID = the correct Vendor ID etc...)
This example may be confusing until you realize that the import file is basically entering data into the selected screen in the same order as the field tab order on a screen.
Note the two special lines which start with Currency and CuryRate. These two lines are critical to alert the import that the information being imported in this batch is in a foreign currency, different than the base currency for the application database.
Drop me a note if you need more assistance,
Jeff Cozens
Comments