Inventory/Materials Management

The PROMIS Materials Management System is the integration of Inventory, Purchase Orders, Work Orders, and Job Cost to achieve the effective, efficient and cohesive processes and procedures to ensure on time material availability. The modules include:

INVENTORY MANAGEMENT: A complete inventory module is included which tracks inventory activity including Back Orders, Issues, Orders, Receipts, Reservations, Returns, and Scrapping. Each Item has a Warehouse and Bin Location so that an Item can be tracked across multiple warehouses. Re-Order Points, Economic Order Quantities (EOQ), and Order Lead-times are included to maximize ordering efficiency and minimize carrying costs. Bar Coding is available for efficient issuing and returns handling as well as receiving if the vendor has Bar Coding.
ASSET MANAGEMENT: An item can be designated as an Asset within the PROMIS Inventory. PROMIS allows tracking assets by location, vendor, user, serial #, VIN #, Pole Number and more. Also tracked is service information, maintenance costs, and added value. Depreciation is straight line. As an alternative, an item can be designated as a “class” of assets (eg. Poles) and inventory activity can be tracked by that “class”.
PURCHASE ORDERS: PROMIS also includes a Purchase Order Module which allows for Stock and Non-stock items to be ordered and tracked. Receiving can then be done directly through the Purchase Order and automatically update Inventory. Open Purchase Orders are then tracked by Item in Inventory. Optionally, a PO file can be passed to Accounts Payable if desired.
WORK ORDERS: Interfacing to Inventory, you can manage and track Work Orders by type for Labor, Equipment, Materials, and Other Costs. Included is the ability to establish Lists of Materials (a.k.a. Kits, or Standard Units of Cost), the ability to create WO picking lists and invoices to Bill To accounts.
JOB COSTING (aka PROJECT COSTING): Interfacing to Inventory, you can manage and track Job/Project Costs by type for Labor, Equipment, Materials, and Other Costs. Included is the ability to estimate by using standard Work Order Types if desired or creating unique Work Orders with Labor, Equipment, Material, and Other costs.
PAYROLL TIME ENTRY: PROMIS includes a Payroll Time Entry Module that can be used by department heads and supervisors to input employee time and pass it to Payroll, Work Orders, and/or Jobs. This file interfaces to an Employee File for demographics and pay rates.
GL INTERFACE: PROMIS Materials Management creates a GL Transaction File at the end of each processing run with all debit and credit transactions by account number. This file can then be imported to a General Ledger program for batch update.

BASIC INVENTORY DATA

Item ID (a.k.a. SKU ID)
Warehouse ID
Item Alias (nickname)
Item Group to allow grouping of items
Item Primary Description
Item Extended Description
2 Sell Prices
Avg Cost with Tax
Item Category
Item Type (Equipment, Labor, Material, Other)
Bin Number
Standard Cost
Average Cost
Unit of Measure (UOM)
Pack UOM (e.g. UOM = Roll., Pk UOM = FT.)
Conversion Factor to convert UOM to Pk UOM
Alt UOM for alternate ordering needs.
Kit ID for inclusion in special kits (e.g. cross arm)
Bill of Materials

MATERIALS MANAGEMENT DATA

Reorder Point - Normal
Reorder Point – Critical (COP)
Minimum Order Quantity (MOQ)
Economic Order Quantity (EOQ)
Standard Order Quantity (SOQ)
Delivery Lead-time
Maximum Warehouse Available Quantity
Replacement Cost
Beginning Stock Balance
Total Received
Total Returned
Total Issued
Total Lost
Total Scrapped
Total Sold
Total Whse/Xfer
Total Adjustments
Total In Stock
Total Reserved
Total Available
Total On Order
Total Requisitioned
Received-Pending
Last Issue Date
Last Order Date
Last Receipt Date

GL and PROJECT DATA

Default GL Asset Account Number (from the Item Category File)
Default GL Expense Account Number (from Item Category File)
Default GL Revenue Account Number (from the Item Category File)
GL Category (Capital Expense or Operating Expense from the Category File)
Project ID and Project Sub-Category

SPECIAL HANDLING DATA

Bid Item Y/N
Commodity Item Y/N
Critical Item Y/N
Fixed Asset Y/N
Hazardous Material Y/N
Inactive Item Y/N
Inspection Required Y/N
No Reorder Y/N
Retail Item Y/N
Serial # Item Y/N

WARNINGS AND ALERTS

Over Budget
Warehouse Surplus
Re-Order
Critical Re-order
Re-order Quantity
Hazmat Disposal Due

To learn more about the Inventory/Materials Management Module or INVISION system, download a software demo, download an informative brochure or contact us.