Inventory Reporting Analysis Solution
Problem
Doing a stock take is laborious and expensive particularly when the factory has to shutdown. Our client's primary concern was to solve the following problems
- Minimize the factory shutdown period.
- Generate report screens to identify items counted, items missing, duplicate counts, false counts and remaining items to be counted.
- Give a financial breakdown and an item breakdown of the above.
- Give a breakdown by personnel, department and warehouse.
- Display all this information in graphical and tabular format as well as Excel exporting facility.
Solution
Due to the fact that this was an old legacy system where each product was not a unique id but an amalgamation of 4 fields this added an extra degree of complexity since we never knew if an item was truly unique. This required further exception reporting to identify non-unique stock items. The solution we developed was a drill-down reporting solution with the ability to sort, search and filter according to various criteria.
Benefits
Factory shutdown was minimized to a few hours. The number of items remaining unidentified or indeed missing was negligible.
Technologies
SQL, C# , vb.net, Ajax, ado.net, asp.net, Java, Dos Scripting.
