Finance | Project Operations, Human Resources, ...

Mixed currencies in project posted transactions

(0) Share

Report

Posted on by M Anas Khan

1,424

It looks like that project posted transactions are showing up in mixed currencies. The accounting currency is Tanzanian Shilling (TZS) and the project contract sales currency is USD. If you see the total cost amount in the project posted transactions, the big amounts at the top seem to be in TZS and the smaller amounts at the bottom in USD. I need your help to understand whether something is wrong in the setup which is causing this discrepancy.

If we view the transaction details, I do not understand how the system is calculating the cost price values and what's the currency of these values?

If we view the transaction details of the cost amount 215, it looks like the cost price is in USD here.

Your help would be appreciated to explain these mixed up currencies in project posted transactions.

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Mixed currencies in project posted transactions

Good morning Muhammad,

Many thanks for the feedback.

To me there seems something wrong.

First, the project/posting date of the line and the voucher seem different.

Second, if I translate the TZS amount of 20525269 into USD then I do not even come close to the 1200 USD shown above.

Do you have a developer around who could have a look at the data?

Also, have a look at LCS.

There are a number of hotfixes available when it comes to foreign currency transactions.

Maybe one of those fixes matches your issue.

Best regards,

Ludwig
M Anas Khan 1,424 on at

Like (0)

Report

RE: Mixed currencies in project posted transactions

Hi Ludwig, this is what I see when I click on View voucher button.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Mixed currencies in project posted transactions

Good morning Muhammad,

The voucher transactions form that you show in front shows a date in August (17 August)

The form that you show in the background shows a different date in September.

Does this voucher really belong to the project no. TZP-000003?

Can you please double check?

Many thanks,

Ludwig
M Anas Khan 1,424 on at

Like (0)

Report

RE: Mixed currencies in project posted transactions

The accounting currency is Tanzanian Shilling (TZS). Project contract sales currency is (USD). Please find the voucher screenprint below.
Suggested answer

MauricioSaldana on at

Like (0)

Report

RE: Mixed currencies in project posted transactions

Hi Muhammad,

There are a number of known issues regarding currency conversion on project transactions, for example these two fixes that you can find in LCS.

My suggestion will be for you to open a support case so we can investigate what is the exact scenario and provide the correct fix.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Mixed currencies in project posted transactions

Hello Muhammad Anas Khan,

The project transactions should all be posted in your accounting currency.

Project sales prices are different because you can define that you invoice a customer in a currency other than your accounting currency.

What is your accounting currency?

Also, can you share a screenprint of a voucher of one of your transactions?

Many thanks,

Ludwig