Handles stocked and non-stocked inventory items at multiple sites. Item information includes: unit of measure conversions, valuation method (Serialized, Lot, FIFO, LIFO, Weighted Average, or Standard Cost), G/L accounts, price tables, kit components, and vendor associations. Detailed transaction and periodic summary information is tracked by item and site to allow analysis of inventory sales and purchasing trends for efficient inventory management.
|Items||The item record identifier is up to 32 characters in length. Allows stocked items with on-hand quantities and non-stocked items such as services. Each item can specify a valuation type: First In First Out (FIFO), Last In First Out (LIFO), Weighted Average, Standard Cost, Serialized, or Lot. Specific G/L accounts can be assigned to each item or to a group of items for use in transactions.|
|Multi-Site Inventory||An unlimited number of sites can be defined for an item. A site can be a physical location such as a warehouse. A site can also represent the current state of an item such as in use, in service, or damaged. Summary information is tracked for each item by site. A transaction which specifies a reduction in quantity of a stocked item is automatically allocated at a specified site to prevent its use in other transactions. After a transaction is posted the on-hand quantity is reduced.|
|Warehouse Management||Warehouse management allow the storage capacity of any site to be managed with tracking of items in each bin, transfer of items between bins, transfer of items to other sites, and transfer of items into manufacturing production orders.|
|Warehouse Carousel System||System can control the positioning of a warehouse carousel system to allow parts located in thousands of individual bins to be automatically delivered to warehouse personnel in a matter of seconds.|
|Item Activity Tracking||Monthly summary information can be tracked by item and by site including: sales amount, sales quantity and cost. Transaction information is tracked for an item including: transaction date, cost, price, quantity, serial/lot #, customer, vendor and transaction source document.|
|Graphs of Item Activity||Real-time graphs makes it easy to see trends in your item sales activity in terms of quantity, sales, and gross profit.|
|Serial # Tracking||Items designated for serial # tracking can be tracked through the entire cycle including receipt of goods, inventory, manufacturing, and sale. A defective item returned by a customer can be tracked back to the vendor from which the item was purchased for warranty repair or other quality control purposes.|
|Lot # Tracking||Items designated for lot # tracking can be tracked through the entire cycle including receipt of goods, inventory, manufacturing, and sale. Items which are part of the same lot can be received at various times and at different costs.|
|Comprehensive Reporting||A collection of 50+ reports can be used to extract information quickly. Modify existing reports or create new reports quickly.|
|Inventory Allocation||All inventory related transactions involving stocked items automatically allocate inventory upon entry to prevent items from being over committed.|
A kit template can be created for use in assembly or disassembly operations. A kit can contain an unlimited number of components. Kits can be used to construct a multi-level bill of materials.
|Item Shipping Dimensions||In addition to the weight of each item the shipping dimensions (length, width, height) can be specified for use in freight cost calculations.|
|Unlimited Unit of Measure Conversion||Supports an unlimited number of units of measure for use in any inventory based transaction. Conversion between different units of measure is performed automatically by the system.|
|Unlimited Alternate Items||Alternate items can be specified for substitution when an item is out of stock or has been discontinued.|
|Item Vendor Relationships||An unlimited number of vendors can be defined for each item. Summary information is tracked for each item by vendor to provide data for vendor performance analysis. Vendor related transactions such as purchase orders use the vendor item number, economic order quantity and other information automatically if available.|
|Customer Item # Cross Reference||Define relationships between your part numbers and the part numbers as defined by the customer. This allows the entry of orders to be performed using the part numbers as specified by the customer. This facility can also be used when receiving orders electronically via EDI or e-commerce integration.|
|Global Item # Cross Reference||Define relationships between your part numbers and common part numbers such as UPC (Universal Product Code) to allow the entry of order to be performed using the global part numbers. This facility can also be used when receiving orders electronically via EDI or e-commerce integration.|
|Merge Items||Combines all current and past activity of one item with another item. Can be used when items are assigned new part numbers.|
|Merge Sites||Combines all current and past activity of one site with another site. Can be used when separate warehouses are combined.|
|Notes and Attachments||Store all item related notes and document files such as pictures, design documents, scanned documents as attachments. All attachments are stored in the database for fast access.|
Increase or decrease quantities of items on-hand in any unit of measure defined by each item. The program supports increase/decrease due to adjustment or variance due to loss/damage. When a transaction involving item quantity reduction is saved, the quantities specified are committed to prevent another user from selecting the quantity in a different transaction.
|Inventory Transfers Between Sites||
Items can be transferred from one site to another site in any unit of measure. Sites can represent physical locations as well as logical grouping such as inspected, damaged, or good condition. When a transfer transaction is saved, the quantities specified are committed to prevent another user from selecting the quantity in a different transaction.
Finished goods or sub-assemblies can be assembled from kit components. The components and quantities of a kit can be changed during assembly. Items which use serial or lot number tracking can be specified as finished goods or as components in the kit. When an assembly transaction is saved, the quantities specified are committed to prevent another user from selecting the quantity in a different transaction.
|Unlimited Transaction History||All transactions entered in the system are available for review at any time, performance of the system is not effected by number of transactions.|
|No Month End or Year End Closing Process||Transactions can be entered for any period in any year which has not been locked. Periods can be locked or unlocked at any time.|