Fixed Asset Transactions

(0) Share

Report

Posted on by Shart2019

I am tasked with building a Fixed Asset report in Power BI. One of the requirements is to show net book value. We use BYOD. I am using data from the entity = AssetJournalV2.

This entity, however, does not include transactions made through the Accounts Payable module (vouchers starting with API). It only has transactions from the Fixed Asset module (vouchers starting with FADP).

I found the transactions made via Accounts Payable in the General Journal Account Entry, but I don't see how to tie the transactions back to the Fixed Asset.

Any suggestions are much appreciated.

Thank you!

Sheila

All responses (2)

Answers (1)

Suggested answer

BillurSamdancioglu 17,153 Most Valuable Professional on at

Like (2)

Report

RE: Fixed Asset Transactions

Hi,

Actually the transactions you see with the type of Acquisition should come from AP module.
Verified answer

Magno Pereira 2,431 Super User 2025 Season 1 on at

Like (1)

Report

RE: Fixed Asset Transactions

I see no solution other than to create a custom data entity.

learn.microsoft.com/.../build-consuming-data-entities

But for reporting it might be worth considering Azure Data Lake feature.

learn.microsoft.com/.../Azure-Data-Lake-GA-version-overview

Thus, you can export for example the AssetTrans table.