One of IMS’ clients wanted to perform a full stock count, although they had been perpetually counting the stock for some years. They asked our advice and we suggested the Stock Counting module within system 21 which performs all of the necessary reconciliations and also creates all of the adjustments with a full audit trail.

The challenge they had was the time and resources to key in 3,000 stock quantities within a short period of time. As they were collating the stock figures on a spreadsheet, IMS developed a simple utility to upload this data into System 21 against the stock count in the relevant stockroom. The client could then use the standard options to validate and process the approved count.

Although the utility was developed at very short notice, it went live and was used over a weekend with 100% results. This meant that the count was completed on the Saturday and overtime on the Sunday was not required. Good news all round!