PDFPrintE-mail

Spectrum's Inventory Control module tracks all inventory activity. Inventory may be requisitioned to jobs or sold directly to customers. Advanced reporting capabilities provide all of the information needed to make better purchasing and sales decisions.

Inventory Control supports the use of multiple warehouses and an unlimited number of inventory items. The user-defined alpha-numeric item code can be up to 15 characters in field length, and multi-level pricing is also supported. In addition, quantity breaks, customer special pricing, and promotional discounts can easily be built into the pricing structure.

The physical inventory system facilitates the counting of inventory and provides effective reporting of any variances. The Reorder Report, with six months of sales history, serves as an essential tool in planning future purchases. Full integration with Job Cost provides for easy handling of inventory requisitions to jobs.

Dexter + Chaney is a technology partner with Trade Service Corporation, providers of TRA-SER® Pro, the industry standard pricing service. Spectrum's Inventory Control module interfaces with TRA-SER® Pro for automated product pricing and costing updates.

Features

  • Physical Count Transaction Listing, Physical Inventory Exceptions Report, and Physical Inventory Variance Reports include a 'Location' field. The Transaction and Variance reports include a 'unit of measure' field.
  • The inquiry screen shows the use tax percentage for shipped requisitions.
  • The Inventory Item File Maintenance screen allows entry for a virtually unlimited number of user-defined fields.
  • A G/L Error Correction window (modeled after the Payroll G/L Error Correction screen) appears on the Inventory Transaction Update screen.
  • Four costing methods are available: LIFO, FIFO, weighted average cost, and standard cost.
  • Five transaction types are available: receipts, orders, transfers, adjustments, and credit returns.
  • Screen display of current total inventory valuation is available on demand.
  • Multiple General Ledger inventory accounts is fully supported.
  • Primary and secondary vendors and alternate items can be recorded so that these are offered automatically if the desired item is out of stock.
  • Updating standard cost is easy when vendor price increases occur.
  • Up to five prices per item is allowed.
  • Percentage price changes can be processed automatically.
  • Unlimited item comments are allowed.
  • Option to tie item to phase/cost type is available. High volume, high turnover, or other critical criteria can be tracked with user-defined ABC classification of inventory items.
  • Dates of last order, receipt, adjustment, and shipment are maintained for every item at every warehouse.
  • Inventory receipts may be entered manually or processed when the purchase order is created.
  • Separate units of measure for purchase or sale transactions are available.
  • Discontinued items are easily tracked.
  • Actual location of stock within each warehouse can be recorded.
  • Supports multiple warehouse locations for each item.
  • Item reorder points and suggested quantities for reorder are maintained for each warehouse.
  • Reorder reports, stock status reports, and inventory valuation reports may be printed on demand.
  • Detailed inventory transaction history is available on screen or in reports.
  • Quick lookup screens throughout give access by category, primary vendor code, vendor part number, item code, and item.
  • Easy-to-use physical inventory system facilitates the counting of inventory.
  • Directing reports to the printer of choice is quick and easy.
  • Security clearance among staff members can be carefully controlled to prevent unauthorized access to sensitive information.
  • Pop-up windows allow convenient lookup of items, categories, and other key fields.
  • The job requisition transfer from Inventory to Job Cost provides for actual cost plus mark up.
  • TRA-SER program is now integrated with Spectrum, allowing items to be imported directly into Spectrum entry screens using the TRA-SER Quick Link screen.
  • Quantity price breaks may be offered by item or category, calculated from either list or sell price.
  • Customer special pricing and discounts supported, plus percentage price changes can be processed automatically.
  • Inventory Control supports the use of multiple warehouses and unlimited number of inventory items.
  • Mixes are processed automatically from raw items to mix assembly.
  • Inventory Control is fully integrated with the General Ledger, Job Cost, Time + Material, Work Order, Purchase Order, Order Processing, Equipment Control, Scale Interface, Equipment Tracking, and Sales Analysis modules which reduces input time and ensures accuracy.

Inquiry Screens

  • Item History Inquiry
  • Job Requisition Inquiry
  • Display Total Inventory Valuation
  • Category / Item Inquiry
  • Mix Component Availability Inquiry
  • Warehouse Quantity Inquiry

Reports

Reorder Report:

The Reorder Report offers valuable information for planning purchases from vendors. It includes quantities on hand and already on order, as well as vendor information and sales volumes of the item over the past six months.

Items on Hand Valuation Report:

This report provides the current cost basis value of inventory stock on hand. The cost may be stated either as "actual", FIFO, or LIFO accounting value, or may be printed in standard cost format for insurance valuation.

Physical Inventory Variance Report:

This report serves to identify items that may require recounting or other investigation. It details items in which the physical count entered does not match the quantity on hand in the warehouse.

Inventory Item History Report:

Here, detailed information regarding any transactions recorded for specified items is provided. This report is a useful tool for isolating discrepancies between system records and physical counts. The report may be printed for any date range stored on the system.

Other Inventory Control Reportss

  • Inventory GL Summary Report
  • Inventory Activity Report
  • Inventory Item Listing
  • Item History Inquiry Report
  • Job Requisition Report
  • Inventory Price Listing
  • Inventory Receiving Report
  • Inventory Transaction Report
  • Excess Inventory Report
  • Physical Count Sheet
  • Physical Count Transaction Listing
  • Physical Count Exception Listing
  • Purchase Order Receipts Listing
  • Item/Warehouse Detail Listing
  • Mix Pick Sheet
  • Mix Transaction Report
  • Inventory Labels
  • Item Location Listing
  • Area Code Listing
  • GL Department Listing
  • Customer Special Pricing Listing
  • Change Item Code Listing
  • Cost Adjustment Reports
phone: 800-875-1400