Finance | Project Operations, Human Resources, ...

Automated transformation of data

(4) Share

Report

Posted on by MBates237

211

Hello,

My organisation does component accounting on our fixed assets. We have around 40k fixed assets with 7 sub assets each, which all require depreciation every month. Currently this is done in Excel manually and loaded into huge journals.

Is it possible to connect to my fixed assets entity, calculate the value of the depreciation and transform this into a journal, automatically on a monthly basis? If so, what solutions should I be looking at using?

Thanks,

Michael

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

André Arnaud de Cal... 301,210 Super User 2025 Season 2 on at

Like (0)

Report

Hi Michael,

I'm not able to understand what you do today and want to change tomorrow. Can you please elaborate on your question? Do you want to start using fixed assets in Dynamics 365 Finance or do you want to use information from your Excel sheet to import data into journals?

Was this reply helpful? Yes No
Sami Ullah 315 Moderator on at

Like (0)

Report

Hello,

Yes, this is possible in both Dynamics 365 Business Central and Finance. However, you selected the Power Platform integration category for your question, which makes it a bit confusing. Could you clarify what exactly you want to do and where you intend to implement this automation?

Thanks

Was this reply helpful? Yes No
Suggested answer

Tom_Gioielli 2,797 Super User 2025 Season 2 on at

Like (0)

Report

Not sure which end product you are using, and as mentioned below it sounds like the Microsoft ERP applications have tools for this.

However, just in case you are not using one of those tools you could take a look at Dataflows as an option? You can use a dataflow to connect to your Assets and Sub-Assets, apply your depreciation logic, and then either update the records or create journal entries based on the updates. Dataflows are great at handling relatively large volumes, and they can be scheduled to run on a regular basis or initiated manually.

An overview of dataflows across Microsoft Power Platform and Dynamics 365 products - Power Query | Microsoft Learn

Was this reply helpful? Yes No
MBates237 211 on at

Like (0)

Report

Thanks for the replies. I am using D365 Finance, I posted it here as I assumed the solution would be something Power Platform related, but I am happy to be corrected.

Was this reply helpful? Yes No