web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Fixed Assets balance, ...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Fixed Assets balance, which tables are necessary?

(0) Share

Report

Report

Posted on by Community member

2

Hi guys, I try to combine tables like AssetBook, AssetTable and AssetBookTable in D365FO to form the asset balance in SQL Server.

The Link between these tables are pretty obvious, but I cannot find the actual balance values through time that take depreciation into account.

Any idea which tables have this information?

Or is this only being calculated when you retrieve this information in D365FO?

If the latter is the case, can someone help me with the necessary tables and columns to generate the fixed assets balance?

Kind regards,

Igor

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

André Arnaud de Cal... 303,085 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Igor,

The posted details related to the assets are stored in the table AssetTrans.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 577 Super User 2026 Season 1

#2

Giorgio Bonacorsi 309

#3

Diego Mancassola 259

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans