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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Magno Pereira 2,435 Moderator 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.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 19,120 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.

Was this reply helpful? Yes No