web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Download Item Ledger E...
Small and medium business | Business Central, N...
Suggested Answer

Download Item Ledger Entries from different Companies in one time.

(1) ShareShare
ReportReport
Posted on by Szymon Smolak 45
Hello,
 
to download ILE from different companies I have to go one by one and switch between companies. 
 
Is there any other solution to do it in faster way?
 
Thank You in advance,
 
Regards,
 
Szymon Smolak
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Shauna Langley Profile Picture
    Shauna Langley 903 Moderator on at
    Hi,
     
    Depending on your version that they best way could be to use a reporting tool like PowerBI, if you are not on-premise then SQL extracts may not be an option.
     
    I don't believe there is any other automatic way of doing this for the Item Ledger Entry table without having to create a report as I know you used to be able to code CHANGECOMPANY.
     
    Thanks,
    Shauna
  • Suggested answer
    Gerardo Rentería García Profile Picture
    Gerardo Rentería Ga... 27,054 Most Valuable Professional on at
    HI
     
    At the same time I don't see an option, you could use Apis targeting each company.

    We have some native Apis. This is the one that obtains the general ledger entries.
     
    And some Apis (beta) with financial information. This is the one that obtains the general ledger entries.
     
    Best Regards
    Gerardo
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 101,846 Super User 2026 Season 1 on at
    Hi, If you consider customizing, hope the following can give you some hints.
    Dynamics 365 Business Central: Collect data from different companies and Drilldown into the data of another company
     
    In addition, it should be possible to use Power Automate. Based on the example below, add the export steps of other companies and then create the file.
    How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv
     
    Thanks.
    ZHU

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,466 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,829 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,505

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans