Business Central / NAV UG
Experts:
Multi-currency for bank statement import bank reconciliations
-
Multi-currency for bank statement import bank reconciliations
Hello.
I am looking to do a bank statement import for bank reconciliations. My bank is a UK bank operating in GBP and my D365 Business Central system entity is in USD local currency. When I do the statement import, it is setting the amount in USD. I tried setting my UK bank account card in GBP currency, thinking that during the bank statement import will import the lines in GBP and convert the amount to USD, but it is only taking it in USD. I have Currencies set up properly in D365 BC as well as the daily FloatRate job queue that have been operating fine in my Live BC environment. I am not sure if I need to update the Data Exchange mapping to an indirect table than table 274 for bank reconciliations as there is no currency field mapping to that table in the xml. I have also tried to import lines in the bank rec card, which still operates the same.
How can I get the amount to be acknowledged in GBP and then convert that amount to BC’s USD local currency? Do I need an extension? Thank you very much in advance.
-
0 Replies
Sorry, there were no replies found.
Log in to reply.
