How To Import Multi-Currency Transactions Using Transaction Import

Resolution

Specify the Currency ID, Rate Type, and Effective Date in the Transaction Import (98.500.00) Data file. 


1. Currency and CuryRate lines may be added to a Transaction Import Data File. The following rules must be observed: 

  >> Only one currency per batch may be imported, while the Rate and Rate Type may change throughout the batch. Therefore, if entering a Currency line in a Data file it must be followed by a CuryRate line followed by a Batch line. However, a CuryRate line can be placed by itself in a Data file. 

  >> The currency cannot change while entering detail lines. Therefore, a Currency or CuryRate line cannot be placed between detail lines (i.e. Detail,"","" CuryRate,SPOT,"",1.2 Detail,"",""). 

  >> In order to use a CuryRate line, at least one Currency line must have been successfully processed. 

  >> A Currency ID on a Currency line cannot be left to defaults (i.e. ""). The Effective Date and the Rate on the CuryRate line canbe left to default. 

  >> Following is an example of a correct Voucher Data file entry: 

 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...) 

 2. No change to the Transaction Import Control File is required.

This article was TechKnowledge Document ID:114014

Egenskaper

Artikel-id: 844270 – senaste granskning 1 feb. 2017 – revision: 4

Feedback