The architecture of Inventory II is based on the new revolutionary Watermark database technology.
This technology ensures that even large and complex inquiries can be addressed by the database without performance penalties, even on fast growing databases.
All database inquiries will target a very small amount of data, as transactions are divided into relevant and non-relevant data in a very efficient way without use of deep complex index keys - the result is a second to none performance.
What is the impact of this technology?
High query performance is ensured by a combination of Watermark technology and avoiding joins in queries in the central transaction processing.
High scalability is ensured by the clean insert approach. This means that the process of updating on-hand levels is based on pure record-inserts, thus resulting in no wait time due to concurrent users attempting to update the very same records.
Blocking lock issues in inventory are nonexistent. The improved concurrency will set new standards for scalability.
Inventory inquiries execute incredibly fast, independent of transaction volume, even on historical data.
True cost prices are calculated real-time, but individual users are not affected by this processing since it is handled by a smart and very efficient background process.
Cost prices and adjustments can actually be calculated and applied real-time
Fast on-hand inquiries in forms and reports
No traditional inventory closing
The traditional Inventory closing function is not relevant any more as cost prices are calculated real-time. Because of that there is no need for allocating exclusive time slots for this task during weekends or nights.
True 24/7 capabilities
No worries regarding blocking locks. Neither Inventory closing, which is now just a matter of changing a date, nor Master scheduling causes blocking locks that could prevent the daily operation from taking place.