Version BC14 or BC15 Saas and OnPremise
Generate the tax audit file for French market (known as "Fichier des Ecritures Comptables" = Export G/L Entries) is very long.
For only one month, we need 25 minutes for 17,000 GL Entries (2700 G/L Register entries).
If we do the same request 1 minute later, we have the file in 15 seconds (because of the SQL cache).
We cannot delegates this export to Job Queue because the XMLPort generates a file for the user.
We need to have the capability to delegate this export to Job Queue.
Idea : Job queue could store the file in sharepoint on line ! Please add a url setup in BC :)
Thank you
Comments
Hello, Microsoft could improved this export by a factor 10.90% of the export time is done in the procedure GetGLRegister. Considering that GL entries are processed by entry no in the export and one GL Register holds many GL Entries, the GL register record should be cached between each call and recycled, without a need to hit the database with a GLRegister.FindFirst. The PoC for the fix has been proposed to Microsoft throw the support case TrackingID#2211290050001589
Category: Geographies and Localization
Dea Jean-Noel
Please send me an email on soalex@microsoft.com
We would like to investigate this further and include you in the process.
Thanks
Søren Alexandersen
Program Manager, Localization
Category: Geographies and Localization
Business Central Team (administrator)