General Inventory Management Module

General Inventory Management Module

There are a number of different types of Articles that the system can manage

  • Stocked items
  • Kits and Assemblies (to n levels) including JIT (to 3 levels deep)
  • Configurable Products configured at time of sale including stock and services options
  • Perishable Items - with expiry dates and batch numbers
  • Reverse BOM items (eg meat processing)
  • Dual Unit of Measure items (eg meat in KG and Each)
  • Serialised items
  • Clothing - colour size style
  • Manufactured items - both internally and externally manufactured
  • Services
  • Non Stocked items
  • Parent items (holding shared information across a product family)
  • Owned by others (eg supplier or customer)

All types of items share

  • Can be sold on the Webstore or the Customer Portal and have icons, images and web html held at the article level.  
  • Are members of Article categories that are hierarchical and can cross across Brands from different suppliers - see Article Categories
  • Can be supplied by a single suppler/supplier Factory or multiple suppliers
  • Can be linked to one of the Brands for reporting and analysis purposes
  • can be imported directly into the system making it much easier to enter large volumes (eg a seasonal range) of all information including cost prices.
  • Can be linked to Seasons or have individual availability dates
  • Can be linked to Promotions
  • Article Status includes Proposed, Active, Run Out and Archived
  • Can be linked to MSDS documents or through Suppliers to Certificates (eg: Organic Food Growers Certifications)
  • Warrantee durations
  • The ability to Add New Fields that are tracked and reported on Articles

Stocked Articles

  • Stocked articles have weights, sizes, packing factors (for Cartonising process) shipping UOM and selling UOM
  • Can be flagged as requiring special locations (such as freezers) for storage - see Warehouses and Stock Locationss and Warehouse Module
  • Have sell rates (calculated over standard or unique number of days), min days of stock levels, PO to delivery days override, useby horizon days, min supplier expiry days override
  • Scarce stock can be allocated to Level 1 customers in priority to Level 2 customers with sharing or manual allocations

There are a number of Stock Reports across the system

  • Stock Turns report - stock turn values at warehouse, Category and Brand level and down to SKU level
  • Stock value reports - value by warehouse and across the system
  • Where used recall reports - to find where suppliers batches ended up
  • Aging Stock - risk into the bin
  • Short stock - risk of runout
  • Maximum shipment of Scarce stock - to maximise partial fulfilment of orders eg: end of season runout stock

See /wiki/spaces/SI/pages/33054918