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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Fixed Asset amount
Microsoft Dynamics AX (Archived)

Fixed Asset amount

(0) ShareShare
ReportReport
Posted on by axerp 2,600

Hi All ,

My Legal Entity currency - INR and Reporting currency  - USD.

Now when i purchase the asset from the purchase order , acquistion value is posting to FA  transaction table in INR currency , but it is not posting in the reporting currency to FA trans table.

( But same can be seen in Vend trans, Cust trans, Voucher trans .)

If i want to show that INR currency in Reporting currency in FA trans table , what is your suggestion?

*This post is locked for comments

I have the same question (0)
  • Maxim Gorbunov Profile Picture
    Maxim Gorbunov 456 on at
    RE: Fixed Asset amount

    The answer depends on where you need to show this amount. For example, if you would like to see it in the Fixed asset currency transaction inquiry, you can convert all accounting currency amounts to any currency using an exchange rate from the exchange rates table. Simply open the fixed asset currency inquiry. Then click on the File -> Tools -> Select currency and choose USD. Note that this conversion will not consider the date of fixed asset transaction but convert all INR amounts to USD using the same rate.

    If you acquire only one FA per voucher, you can also link the GL journal account entry table to the FA transactions table using the voucher number. Then filter the GL entry table by the Posting type = Fixed asset debit. This will return you a voucher transaction that corresponds to the FA acquisition, and you will be able to get the reporting currency amount from there. But note that this will not work if you have multiple FA transactions per voucher because the GL entry will contain the total amount for all acquisitions in this case. If that is a requirement then I would consider a modification that saves the reporting currency amount in the FA transaction table.

  • axerp Profile Picture
    axerp 2,600 on at
    RE: Fixed Asset amount

    [quote user="Maxim Gorbunov"]Then click on the File -> Tools -> Select currency and choose USD. [/quote]

    Thanks Maxim ,

    I am already aware of this funcitonality.

    What i am looking is system should show automatically in the FA trans table in Company currency and Reporting currency .

    Any suggestion ?

  • Maxim Gorbunov Profile Picture
    Maxim Gorbunov 456 on at
    RE: Fixed Asset amount

    This cannot be done with the standard application. FA transaction amount is only recorded in transaction currency and accounting currency. You will have to modify the application to enable recording the amount in reporting currency.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans