Currency of lines in Expense Report

(0) Share

Report

Posted on by Melvin Barquero Red...

545

Hi
Recently we migrate one costumer from Dynamics R2 to R3 CU10, they use Expense Reports, normally they create lines in the expense report with multiple currency codes (USD, CRC, EUR etc), no problem there, but when they post the expense report, AX generate the invoice journal (for the employee) with the local currency code (CRC in this case), applying an exchange rate.

In R2 AX respect the currency code of the line, creating the invoice journal in the specific currency that they use in the expense reported, but now is diferent and we don't know why. Any clues about it? is there a new parameter to control this in R3, anyone can help me please? I need like before.

Thank you

Notes: kernel version and Application Version is 6.3.3000.111

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Melvin,

I have not found any hint for a change on the TechNet sites that describe the changes that have been made with R3.

Please check yourself here: technet.microsoft.com/.../mt628926.aspx

Are you absolutely sure that the setup of your old and new version is absolutely identical and that the Change in System behavior is not caused by a different Setup in the travel and expense module, your employees in HR, etc.?

Ludwig

Was this reply helpful? Yes No
Melvin Barquero Red... 545 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwing, thanks for the info, but already check there :(

And yes to your other question, is the same configuration, because we apply a full upgrade with MS Tools from R2 to R3, programs and data, nothing was reconfigure manually on AX.

The vendor of the employee, by default, have the local currency code (CRC), I change it to USD, but still the same behavior.

Any additional clues.

Thanks

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Melvin,

I have not found something specific on LCS regarding your issue and would thus recommend that you get into contact with one of your developers and/or contact MS Support. I believe that this might be related to a bug if no other modifications have been implemented. Would be great if you could keep us updated on how things are progressing.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Melvin Barquero Red... 545 on at

Like (0)

Report
Copy link

Link copied!

Hello Ludwing

We look into the code, and Microsoft indeed change the functionality, they replace one method (class TrvPostExpenseHeader), for worst if you ask my opinion.

Older Method: postSubledgerTransaccions

New Method: postExpenseSubLedgerTransactions

At the end, we change this new method to correct this "bug"

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Melvin,

Many thanks for sharing the solution you found.

Would you mind verifying your outcome as verified answer so that other users can easily identify what might help them in a similar Situation?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks for pointing this up, it was very helpful.

Just wanted to share that I found out why Microsoft made this change in the first place. This is from KB3023298:

PROBLEM

An expense report vendor invoice is posted in a foreign currency. When rate changes occur before a payment, the payment amount will not match the employee expense report amount.

DESCRIPTION OF CHANGE

The changes in the hotfix resolve this issue.

After posting an expense report, all the vendor, customer, and bank transactions will be created in company currency. This avoids any chance of amount change while settling (payment journal) vendor transactions.

Was this reply helpful? Yes No