Control over stock is an extremely important aspect for any company whose revenue depends on manufacturing and/or selling goods. A considerable proportion of a company’s capital base may be invested in stock and the valuation of stock can make a huge difference in profitability. Stock Control system requirements differ widely from one company to another and any two companies stock control procedures can be entirely different. One company may have multiple locations, another only one; one company may assemble goods from components, another a stockist of finished goods only. The Datafile Stock Control application is designed to meet a wide range of requirements whilst retaining the ease of use of the best systems.
Stock Maintenance and Item Types
The Stock Record can be configured for different types of SKU ranging from normal stocked items, drop-ship items, stock assemblies and service items. Stock items can be bought, held or sold in differing units and from different warehouse locations. Bar Code information can be recorded against the stock record and used in when moving stock. Images and PDF Documentation can be held against the stock record for review and inclusion in Order Processing documents to customers or suppliers.
Up to 9 standard price lists are available – including options for currency specific price bands. More complex trade agreements can be supported via a Discount Matrix which can store prices based on individual net prices, discounts or quantity breaks. Additional support is available for the use of date sensitive promotional pricing.
For valuation and margin purposes stock costs can be calculated on a standard (fixed) cost basis, or on a FIFO basis, Average or Last Cost basis.
An extensive range of standard reports are available to manage re-ordering, identify slow moving or excess stock holdings, price catalogues, valuation reports and transaction audit trails. Reports can be sent to Screen, PDF, MS Excel, MS Excel Pivot Tables, MS Word, Email as well as the usual Print Devices. A reporting pack can be defined and processed for each period end ensuring that all required reports are printed or archived as PDF documents. In addition user-definable smart lists can be created to highlight and review stock items, for example to flag up items for re-order or build.