In order to keep up the pace, a wholesale and distribution company needs a stable ERP solution able to effectively manage inventory control for large volumes of data.
During Q2 2015, we conducted a set of tests on the volume of transactions in Socrate, on cloud and on-premise instances. In top position there were the stocks where we have observed an increase in the number of transactions, situation that led to the depreciation of the execution time for reports and inventory evaluation. At the same time, and taking user feedback, we agreed that the time was right for a full adjustment of the inventory set of reports.
During the first quarter of 2016 we conducted a series of optimizations on inventory reports in order to get the lowest possible execution time, a diminished server consumption and a comprehensive data report results. These improvements were achieved by our team of senior programmers who have rewrote completely the reporting processes.
The results were felt immediately, inventory reports were standardized and the environment with a large volume of data (tens of thousands of items stored thousands and million transactions), lead times have been reduced significantly:
- The current stock report displays physical stock and the actual quantity available, reserved and in progress grouped by item and detail at lot level level => execution time under 60 seconds!
- The quantity and value stock report date displays the state of the stock items, quantity and value at any time. This report presents data grouped at both item-level and detailed lot-level. Values are calculated and presented depending on how the discharge set for each article separately, relative to the selected accounting scheme, including PMP typology => runtime under 10 minutes!
- Inventory balance report contains the inputs, outputs, initial and final stocks in a given period of time, both in quantity and value => runtime under 30 minutes!
By significantly reducing execution time for these operational reports, we have helped improve execution and decision-making time in the inventory management area. Managers can make faster decisions affecting stocks, where real-time human decision is needed, with positive effects on the entire business.
When you choose Socrate ERP for distribution, you get a reliable partner with a proven solution that dozens of distribution companies use for decades and that is continually improved.
