Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Automated transformati...
Finance | Project Operations, Human Resources, ...
Suggested answer

Automated transformation of data

(4) ShareShare
ReportReport
Posted on by MBates237 184
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
  • MBates237 Profile Picture
    MBates237 184 on at
    Automated transformation of data
    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.
  • Suggested answer
    Tom_Gioielli Profile Picture
    Tom_Gioielli 851 on at
    Automated transformation of data
    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.
     
     
     
  • Sami Ullah Profile Picture
    Sami Ullah 310 Super User 2025 Season 1 on at
    Automated transformation of data
    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


     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,245 Super User 2025 Season 1 on at
    Automated transformation of data
    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?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans