Skip to Content
0
Former Member
Jan 11, 2011 at 10:23 AM

Importing Foreign Currency AR & AP Invoices from Legacy system via DTW

189 Views

Hi all,

We're in the process of importing legacy AP and AR transactions using the DTW (Data Transfer Workbench). We've come across an "interesting" issue which I'm sure other implementers must have come across.

It's quite straight forward importing Local Currency Invoices using the DTW (in our case the LC is GBP).

However when we want to import invoices in foriegn currency (in our case either EUR or USD), the customer also has a "set" GBP value for these Invoices, e.g.

550 USD (Business Partner/Document Currency which is a FC) - this is is the actual Document value

330 GBP (Local Currency value at that posting date in the legacy system)

What basically seems to happen in SAP Business One is that firstly it needs an exchange rate defined for the posting date that it's going into SBO for and secondly, even though we added the additional RowTotalFC column to the DTW template and explicity stated the Sterling value in the LineTotal column, it's STILL translating to LC based on the exchange rate from the posting date.

There's too many invoices to create manually and ideally these need to go in via the DTW. Have any of you come across a situation such as this when, using the DTW, the Sterling value for imported foreign invoices needs to explicity be a certain value?

Does anyone how to handle this in the DTW?

Any help will be appreciated.

Many thanks,

Mohsen