Import general journal with exchange rate

(0) Share

Report

Posted on by MS-22051230-0

Dears,

I was trying to import data using .CSv file in a general journal and i want Ax 2012 to accept the exchange rate i set on the csv file to be imported.However,Ax is not automatically accepting the exchange rate i give on csv file. instead,it uses the default exchange rate i gave manually on my previous transactions in order to calculate the EUR amount. I use DIFX in order to import the transaction.please help.

Template i used to import the data

JournalName,JournalNum,LineNum,CurrencyCode,TransDate,Voucher,Invoice,Txt,ExchRate,TaxCode,AccountType,LedgerDimension,DefaultDimension,AmountCurDebit,AmountCurCredit,OffsetAccountType,OffsetLedgerDimension

All responses (3)

Answers (0)

Hana Xue Microsoft Employee on at

Like (1)

Report

Import general journal with exchange rate

Hi,
Not sure exactly what is causing this, you can check if there is a column in the CSV file that contains the exchange rate information and that the column mapping in DIXF is set up correctly. If mapping is incorrect, the system may not interpret and accept exchange rate data correctly. For this issue, perhaps you can wait for guidance from other experienced experts.
Best Regards,
Hana
André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (1)

Report

Import general journal with exchange rate

Hi Michel,

AX2012 and DIXF is a long time ago for me, but I think there is an option to set the order for the fields. Can you check if it makes a difference if you put the Exchange rate field after the account type and ledger dimension?
BillurSamdancioglu 15,786 Most Valuable Professional on at

Like (1)

Report

Import general journal with exchange rate

Hi,

What do you mean by previous transactions?