To download transactional data from Dynamics 365 F&O for audit purposes, you can try the following approaches:
Data Entity Export: you can utilize the Data Management workspace to export the required transactional data using data entities. You can select the relevant data entity (e.g., General Ledger transactions) and apply filters if necessary. This method allows you to export data in manageable chunks.
Data Export Service: Another option is to set up the Data Export Service. This service enables continuous replication of data from the Finance and Operations database to an Azure SQL Database. You can then access and export the transactional data from the Azure SQL Database, providing a more reliable and efficient way to handle large data volumes.
Customized Reports: If the standard voucher transaction report is causing issues due to size limitations, you may consider creating a customized report that extracts the necessary transactional data within acceptable file size limits.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156