Purchase invoice has wrong exchange rate

(0) Share

Report

Posted on by MbokJamu

140

Dear all,

I have problem when posting invoices, the calculation of the exchange rate is wrong. Voucher can be seen in the picture below

Accounting and reporting currency is IDR, Invoice is USD. Exchange rate is 1 USD = 13756 IDR. It's like reporting currency is divide not multiply. Question is why when product receipt has correct calculation, but invoice not.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

ZvikaR 168 on at

Like (0)

Report

First, I will comment that your set up does not make much sense.

There is no value in setting both accounting and reporting currency to be the same currency - unless you have other legal entities with different accounting currencies, you do not have any value in Dynamics calculating every amount twice to be exactly the same.

to your question - it sounds like you populate your exchange rates incorrectly.

To verify that, can you post a screenshot of your exchange rate form, for the rate USD to IDR?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Dudik Andriyanto,

Is this the first time you see this issue or do you also have other purchase order postings that have this problem?

What AX2012 version do you operate?

Do you know if somebody changed the currency in the PO header after the product receipt was posted in order to post the PO invoice?

Best regards,

Ludwig

Was this reply helpful? Yes No
MbokJamu 140 on at

Like (0)

Report

Hi zvika, thanks for your reply, this is exchange rate screenshoot

Was this reply helpful? Yes No
MbokJamu 140 on at

Like (0)

Report

Hello ludwig, thanks for your replay

Yes this is first time. This is happen when using foreign currency only. If PO is IDR, no problem with invoice.

Just info, In previous year we are using USD base currency and no problem with invoice. Now we using IDR base currency on new environment, but all master is copied from previous year.

We operated AX2012 R2/CU6. I already check PO and no body change the currency.

Thanks

Was this reply helpful? Yes No
Verified answer

MbokJamu 140 on at

Like (0)

Report

My problem is solve already. This happen cause my consultant add some code in closeok method on VendJournalMatch_PackingSlip form. They add code because when click 'match product receipt' the exchange rate does not change according to the date of receipt.

Was this reply helpful? Yes No
Christophe BOURNAC 115 on at

Like (0)

Report

Hello

is it possible to share the code which was updated please ? We may have the same issue.

Christophe

Was this reply helpful? Yes No