web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Vendor invoice transac...
Microsoft Dynamics AX (Archived)

Vendor invoice transaction report shows incorrect invoice amount if which invoice has been revalued ex rate.

(0) ShareShare
ReportReport
Posted on by Community Member

Dear all,

I would like to ask about the Vendor invoice transaction report.

as below table, I have picked one invoice to ask you.

Voucher Date Invoice Invoice amount Balance Method of payment Currency Invoice amount in a currency

Cash discount

amt in curr

 Balance in currency  Due date Approved
PIV1811573 3/12/2018 304000 -68,521.84 -68,758.84 HSB-AND USD -2,200.00 0.00 -2,200.00 5/10/2018 Yes

Accounted currency = THB

Invoice currency = USD

Invoice Amount = $ 2,200.00

Exchange rate on invoice = 31.20

Accounted amount =  68,640.00 ?

======at the month end we have did revaluation currency exchange rate ======

Revaluation exchange rate = 31.253800

Revaluation =  68,758.36?

Unrealized loss on exchange rate =  -118.36 

======================

Balance is the revaluation amount. I think it's correct.

Invoice amount  = Accouted amount on invoice + (unrealized loss on exchange rate)

 = 68,640 + (118.36) 

 = 68,521.64 ?

Why are invoice amount calculating this, I think it's incorrect ??

and I would like to know which value should be shown in this column ??

 

rrrr.png

Thank you very much

Walaiporn K.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Did you record the invoice in USD or in THB?

    From what you write I assume that THB is your accounting currency and that the USD is a foreign currency stated on the invoice document.

    In this case, your foreign currency liability remains constant at $2200 even after the currency revaluation.

    What changes though is the liability that you have in local currency THB. This liability needs to be adjusted upward or downward - depending on the exchange rate change - in order to reflect the correct liability in your financial statements.

    Does this make things clear to you?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thank you for you replied, and so sorry that my question has not cleared.

    My case...

    There is invoice currency USD and Accounting currency is THB same as you understood. on the month end I have to do Foreign currency revaluation.

    The unrealized loss on exchange rate to be 118.36 (Ex rate on invocie is 31.20 and Ex rate on revalued is 31.253800, so this invoice has to be loss)

    After revalued I have printed "Vendor invoce transaction" report for checking

    but I am uncertain the amount in "Invoice amount" column that Shoud be which amount?

    (I have attached the sample report as above)

    In my opinion, I think amount in "Invoice amount" column should be 68,640.00 ฿

    (Invoice Amt * Ex rate on Invoice)

    I tried to diagnose the calculation and finally I found,

    Invoice amount is getting the revaluation amount - Unrealized gain/Loss

    For this invoice =   68,758.36฿ + (118.36฿ )  = 68,521.64 ฿

    This amount is less than accouting amout on invoice, So that is impossible!

    Could you please confiem me for the correctly amount in this coulumn.

    Thank you very much.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    You are right that the local currency amount that is shown in the report is a bit confusing.

    I took your data and made the following calculation

    5732.fx.png

    First, the invoice amount is and remains USD2200.

    The question then is what local currency do you show in the report in the invoice amount column.

    According to the latest revaluation the total invoice amount is THB68758,36.

    This amount is shown in the balance column.

    In your report the invoice column then shows the difference between this balance and the FX gain/loss.

    I would call this 'theoretical' invoice amount in THB because originall we had THB 68640.

    Yet, this is a report design choice that has been made.

    In my opinion what might help is if you add an additional column that shows the FX gain/loss attached to this line (=> requires development)

    or

    if you change the invoice amount column to THB 68640

    (=> requires development)

    or

    that you teach your colleagues what this column actually shows.

    I would probably go with the last option because it does not require any adjustment and those unrealized FX gains are temporary anyway. However, this is a decision only you can make.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you very much to clarified.

    Best Regards,

    Walaiporn K.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans