One of our customers wanted their system to be more manageable in terms of recording their specific stock items. Due to the nature of their business they have a high volume of stock items with different variations. The dimensions of each stock item were: size, material, colour and character and each dimension could differ per stock item.
Due to the complicated variations of each stock dimension the customer found it complicated and time consuming to have a stock item for every combination. Our Stock Plus module was modified to create a bespoke solution to counteract this problem.

Another requirement was the ability to store an available letter and number against each Stock Item in order to quickly add these onto a Sales Order and Purchase Order. Quantities can then be typed onto a grid and added directly onto the Sales Order without the extra step of generating a Stock Item of every combination.

Stock Item Amendments:
Each character variance is held against the stock item record. An extra tab being was added onto each stock record which held valid character combination for each particular Stock Item.
Additional Stock Item Dimensions can be imported via a CSV file import routine.

Each variation of a Stock Item is assured to have the same selling price as items held against the stock item.

Sales Order Amendments:
Once the Stock Items were set up they were then used to quickly add stock variations into both Sales Orders and Purchase Orders. An additional button was provided on both the sales order and purchase order screens called “add dim items”. This allows for quick searching of a particular product by code or name and adding it quickly onto sales order by typing values directly into the grid.

Modifying our original Stock Plus module to meet the needs and wants of our customer has created a more manageable system which enables the business to quickly and easily store the varying dimensions of each Stock Item.

For more details about our bespoke solutions please contact the office on 01355 581 960 or email development@eurekasoutions.co.uk