P.O. Box 32534, Knoxville, TN 37930

Inventory Control Software

Inventory Control ERP for Warehouse and Distribution

Our Inventory Control Software Module offers many custom features not found in other Supply Chain Software packages. It’s full-featured, customizable and extensible, making it the perfect choice for your warehouse and distribution operations.

Here are some of the many features:

Master file overview

  • Internal item number 15 alphanumeric
  • Manufacture’s part number 25 alphanumeric
  • UPC and vendor EDP code
  • Description 30 characters with unlimited extended description
  • Serial number 20 characters
  • Lot number internal 5 numeric external 15 alpha numeric
  • Costs tracked Average, replacement, next, last cost, last cost alternate currency (all 5 decimal precision) and bracket costing by vendor FIFO
  • Selling prices (4 decimal precision) base from item master and bracket by customer type or quantity
  • Multiple inventory item locations with warehouse tracked
  • Substitute, Follow on, equivalent, MSDS sheet, and Core charge cross references
  • DOT hazardous material descriptions, class, exemptions
  • Bill of material list
  • Items classified as stock, non-stock, lot product, miscellaneous, and two dimensional
  • Multiple UOM cross reference
  • Items inventoried at (either 0 or 2 decimal precision)
  • Allocation based system (i.e. calculated inventory quantity available)

Management Reports Generated

  • Summary Dead & Slow Inventory Rankings – ranks vendor lines in worst to best shape
  • Detailed Dead and Slow inventory listings by vendor or by buyer
  • Customer Dead and Slow inventory report lists contracted items that have become dead or slow
  • Turn & Earn reporting by manufacture or inventory product division
  • On hand inventory evaluations
  • Aged inventory value
  • ABC Rankings
  • Non-Stock Sales Report – utilized to view non-stock sales to evaluate whether to add to inventory
  • Item sales by vendor drop-shipped vs. out of inventory.

Processing Features in our Supply Chain Software

  • Adjustment processing (quantity or cost adjustments tied to General Ledger accounts)
  • Inventory receiving – linked to purchase order or inventory transfer document calculates average lead time
  • Inventory receipts automatically generate picking tickets for covering backorders. Pick and hold tickets are generated for items involved with customer orders not fully allocated. Consider complete option available
  • Landed costing for imported items
  • Branch transfer process (one to one or one to many)
  • Back out receipt for receipt reversal allowed for purchase orders and transfers
  • New item review will allow the inventory manager to review new items for sales trends and if not moving will generate a vendor return or transfer to a branch location that is moving the item
  • Inventory inquiry gives the user the ability to view volumes of information pertaining to the inventory item. Such as: Sales History Detailed, Sales History summarized, Demand history summarized, Open Orders, Receipt History, Purchase History, Price and Costing Information, Bill of Material list and much more
  • Lot product inquiry displays current lot quantities, lot sales history…for handling recalls, and scraping history
  • Intra part number transfer allows user to transfer quantities and history from one part to another
  • Manufacturing process transfer i.e. internal process to manufacture item from component inventories
  • Vendor merchandise return allows inventory personnel to enter and print document to return inventory back to vendor…generates a debit to account payable optionally
  • Mass price updating from vendor databases
  • Physical inventory count sheets and entry process
  • Lost sales inquiry view date, by vendor items where sales were lost for various reasons user can increase demand history for the item if inclined
  • Staged inventory location processing.

Web Based Order Entry

Let us help you increase your ROI

Time saving, profit increasing software for wholesale distributors:

Magnatron Web Based Order Entry allows your company to utilize the internet to not only expand your customer base and Enhance your customer relations, but to also improve existing sales relationships, Remove costs from the sales process and increase efficiency in the Supply Chain Software.
Web Based Order Entry

Some features include:

  • Full featured shopping cart

  • Customer specific pricing

  • More than just e-mail inquiries

  • Multi-level item searches

  • Live link to Magnatron databases

  • Web accessed order traces

The ROI (Return on Investment) that an order entry management system provides is much more than monetary gains. Your employees are able to focus on being productive and will be happier and more efficient. Your sales reps will be able to do their job better, making them happier and more efficient. Your customers will be happier and more satisfied, leading to greater customer loyalty and retention. It is far less costly to keep a customer than it is to find new ones.

A web-based order entry management system allows you to do both effectively, bridging the gap between your back-office and your customers, while greatly improving your bottom line and works great with our other Supply Chain Software.

Return on Investment

Robust Order Process:

  • Access to customer via powerful search criteria (by account number, name (alpha or word), zip code, city, state or phone number)
  • Customer specific text is displayed for the user to review.
  • Customer specific notes sorted most recent first.
  • Customer specific criteria is followed (i.e. defaulted ship via, FOB point, PO number or requisition requirement job costing site information required)
  • Multiple order types – Regular, Consignment, Internal, WEB, Customer Inventory Software replenish system, EDI
  • Multiple order processing schemes: phone based (intense searching required), Multi item (part numbers known either internal, manufacture’s or customers) Billing (after the fact billing only process) Catalog (linked to catalog number for pricing)
  • Item searches by internal part number, manufacturer’s part number, item description alpha based or item description word based, customer’s part number, product division and user defined search word
  • Item inventory quantities displayed when in backorder/transfer situation arises by predefined sequence. User may direct transfer backorder or drop shipment out of any branch location.
  • Multiple inventory item types supported stock, non-stock, lot product, fixed bill of material, variable bill of material, kits, and two dimensional inventory such as conveyor belt

Productivity Features

  • Credit checking based upon credit amount and credit checking based on A/R aging criteria
  • Order lines may be generated based upon customer purchase history
  • Hold ship complete logic for whole order or groups
  • Invoice complete option for Drop shipments
  • User is notified of Substitute, follow on/complimentary and equivalent items
  • Notification of previous sale, date, quantity and price or currently quoted price and quantity are generated to the user automatically
  • Orders entered may be held as quotes or processed to become an open order
  • Quotes may be cloned to orders or to other customers
  • Lost sales may be tracked
  • Invoices once generated may be printed, faxed, emailed or processed to EDI
  • Forms can be laser based with overlays of Logo’s
  • Interval shipments may be automatically processed or the user is alerted to the pending release
  • Order notes may be entered on the header or detailed item level
  • Purchase orders can optionally be generated at the time of the Order Entry
  • Internal part number to customer part number cross reference may be generated at time of Order Entry
  • Credit card processing facilitated for customer order
  • Course Sales tracked by inside sales person, outside sales person, and optionally to product specialists
  • Optional interface to UPS WorldShip and Federal Express for out bound freight costs and tracking numbers
  • Order history linked via multiple search fields: Customer PO, Customer Requisition, Customer Number, Customer Invoice, Customer Item, Part Number, or Bill of Lading
  • Order review and change allow user to view open and closed order copies of picking tickets and invoices.
  • Order tracking gives the user all status’s of order and order lines: complete, partial, shipped, in production, etc.
  • Consolidated invoicing generated in multiple sort sequences date range based IE invoice for a week or months worth of packing slips.
  • Extensive pricing matrix
  • Unbilled order tracking report
  • Open customer order status report summary or detail generated
  • Inventory item allocation adjusted as order entered
  • Serial numbers optionally update during Work Order Review process or Billing Review process
  • Link to job costing system
  • Notes link to job sites

Purchasing Management Software

Purchasing Management ERP for Warehouse and Distribution

Magnatrons purchasing management software offers many custom features not found in other purchasing management software packages. It is a fully-featured, customizable and extensible ERP making our purchasing management software the perfect choice for your warehouse and distribution operations.

Purchasing management

Here are some of the features:

Inventory level replenishment process

  • Suggested order quantities are suggested by a nightly process – the process evaluates the item by a flag of how to calculate the SOQ Min/Max, Fixed reorder point reorder quantity, replenish to cover backorder quantity only and via 10 different forecasting models, Package rounding and standard package quantities are checked and SOQ’s rounded to meet those requirements
  • Forecasting based upon either demand or sales history, average lead time, safety stock requirements and vendor reorder cycle
  • SOQ’s for flagged vendors may automatically generate Purchase orders that are printed, faxed or submitted to EDI during the nightly process.
  • The suggested purchase order review details items with suggested order quantities and displays demand or sales summary information over 48 months, detailed sales history, previous purchase history, customer requested interval shipments, how the SOQ was calculated, and inventory levels of the item by branch location
  • PO’s may be consolidated for multiple branch locations (i.e. at receipt time inventory transfer generated) or shipped directly to branch location
  • Drop shipment requests generated via the Order processing system are displayed for review and PO generation
  • Prepaid freight minimums, small order dollar minimum, minimum order dollars and maximum PO amount are checked
  • Purchase order may be printed, faxed, emailed or sent via EDI to the Vendor

Purchasing management aids

  • Acknowledgment processing via manual entry or EDI
  • Vendor score – statistics providing number of items purchased, dollar value purchased, number of items received, number of items received past the requested ship date, number of items received damaged or number of items shipped wrong
  • The Purchase order inquiry details status of PO: receipts against detail, invoiced against detail, acknowledgment information, and log of cost or quantity changes
  • Vendor improved shipment request – process to generate list of items for vendor to review and provide ship dates for. Vendor is e-mailed request and provided a link to a page on your Web site where they may key in the acknowledgment information.
  • Receipt vs. PO vs. Invoice analysis – provides matching these documents and is extremely useful for closing month and year end processing
  • PO expedite listings either printed, emailed or fax to the vendor
  • Listing of acknowledgment ship date or quantity variances from the PO with links to Customer backorder information