Business Central has functionality to compress General Ledger Entries, Customer Ledger Entries, etc. We would like this functionality to be extended to need to be able to compress Item Ledger Entries (which would necessarily include subsidiary tables such as Value Entry, Item Application Entry, etc.).
A large amount of data in these tables slows down many other functions such as:
- Adjust Cost Item Entry
- Implement Standard Cost
- Inventory Valuation report
- Inventory Reconcile to G/L report
Compressing Item Ledger Entries would improve performance in all of the above functions.
Comments
I fully support this initiative. Some clients require the compression of more tables than what is currently supported by standard Business Central functionality. Implementing this enhancement would significantly improve performance and scalability within BC. Please add this on the roadmap!
Category: Inventory
As a Business Central tenant with a very very large database size and table sizes, this would greatly improve the users experiences navigating/filtering item ledger entries, value entries and general ledger entries.Our ILE screen will spin and spin as users are filtering and navigating. Very frustrating for them.We would see improved reporting through Jet Reports or BI as these also take extra time to work through the large db size.PLEASE add this to the roadmap!!
Category: Inventory
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team