Unwanted Foreign Currency amounts showing in journals posted via DTW

[Former Member]

I have created a journal and imported this via the DTW, a few lines are against fixed currencies the others are posted to multi currency accounts.

The imported journal has FC balances of RUR against all rows on accounts that are set as multi currency.

any ideas? i have removed all unused columns from the DTW template yet the posted journal includes the RUR balances.

[Former Member]

Do you mean RUR for Russian Ruble? I believe that is an obsolete code over 10 years. The new code should be RUB. Anyway, if your local currency is not RUR, you just need LC, right? What are the fields left in you DTW file?

[Former Member]

Hi, i did set up the Russian Rouble as RUR as provided by my client, I have changed this to RUB, Thankyou...

an example line of the journal data i have imported is :-

RecordKey-- LineNum--- AccountCode

---

Credit

---

Debit--

---

LineMemo

1--

---

0

---

112010

---

513--

---

SAGE Acct Code - 10

The GL code 112010 is set as multi currency

I have set the bank accounts GL codes to the relevant currencies.

When i import the journal i get these errors from the DTW -

Exchange Rate not Updated - I update the currencies

Transaction includes more than one currency - I go to document settings and remove the Block Multiple Currency Transactions.

The journal posts now with RUB Foreign Currency Postings...

I have now created the lines.csv spreadsheet again from scratch, ticked the block multi currency and the journal fails.

If i untick the block multi currency the journal again posts with RUB amounts...

[Former Member]

It is still not clear to me. What is your LC and what is your DTW currency? Have you tried by using Tab Delimited Text format which is more DTW friendly?

[Former Member]

apologies, the LC currency is GBP. The DTW file is using the standard Debit & Credit fields therefore i haven't used a currency symbol in the import.

I am tried importing a .txt tab delimited fil with the same errors

[Former Member]

Please explain:

I have set the bank accounts GL codes to the relevant currencies.

Which currency is that bank account? Is it the same as you used in the DTW file?

[Former Member]

Gordon,

thanks for your comments, i eventually found the problem...

i needed to allow unbalanced foreign currency postings on the document settings.