Sage MAS 90 and 200 - Inventory Management



Precise control and safeguarding of inventory is an essential task for a successful, well-organized company; businesses require timely and accurate information on inventory location, movement and valuation. The Sage MAS 90 Inventory Management module provides data pertaining to the receipt of goods, the movement of goods within or between location, the sale, removal or other disposition of goods, and the precise valuation and status of goods remaining in inventory at any point in time. When used in conjunction with other Sage MAS 90 modules, Inventory Management is the cornerstone of an effective manufacturing or distribution solution.

Inaccurate inventory counts can cost you sales and delay shipments past the promise date. Out-of-stock items as well as overstocked items in inventory can be devastating to your business. Additionally, an overstated or understated inventory valuation results in incorrectly reported profits within your financial statements.

The Inventory Management system offers comprehensive reporting capabilities to keep you on top of inventory status. Generate reports on item pricing, stock status, detailed sales history, backorder information, reorder points and recommendation, valuation, turnover, sales analysis and much more. Properly used, the Inventory Management module can help bring about the formulation of new or improved purchasing policies, sales policies, pricing methods, and even enhanced customer service. Inventory Management could also provide your company with an additional edge over competitors who are unable to access the same strategic information.

Multiple Warehouses

A separate inventory of each inventory item can be maintained at any number of locations. In addition, items can be transferred between warehouse locations.

Physical Count Inventory can be physically counted without interrupting the normal sales order entry process. Physical Count worksheets simplify the physical count process and speed data entry. A variance report provides data highlighting the difference between current physical count and the count shown in the system.
Alias Item Numbers Alias items provide the ability to assign alias item numbers to each customer and/or vendor. Alias items permit the user to type alias item numbers in Purchase Order and Sales Order allowing the system to find regular item records and stock status. All alias item numbers print on invoices and purchase orders.
Sales Kit Processing Groups of items priced and sold together can be defined as Sales Kits. A single-level bill of components can be defined for each kit. The Sales Kit listing, Sales Kit where-used listing and Costed Sales Kit reports are available. Sales Kits can be entered during Sales Order processing to automatically explode the components.
Comprehensive Pricing And Costing Methods Detailed price schedules based upon customer price levels and the quantity sold can be created for each item. Prices can be calculated as a discount of the standard price or markup of the standard cost, and can be calculated based on standard cost, average cost, LIFO, FIFO and lot/serial methods. Sales promotions and customer contract pricing may also be established. Standard, last and average costs are maintained for each item regardless of costing method.
Transaction History A detailed history of all inventory transactions can be retained indefinitely, and a transaction audit trail can be produced for a specified date range.
Bar Code Printing Inventory labels with bar codes can be printed for inventory items. Botch Code 39 and Code 128 bar code formats are supported for a variety of printers.
Reordering The Reorder reports lists items whose stock on hand has reached a specified reorder point (which is unique to each item at each location). The suggested reorder quantity can be based upon an economic order quantity, maximum stock quantity or reorder quantity.
Commission Method Commission on each item can be calculated using a different method. Commissions can be based upon percentage of price, percentage of cost, or percentage of gross profit plus a base commission amount.
Item Delete/
Renumber/
Merge
This program allows you to delete, renumber or merge existing Item Numbers, using wildcard characters to mask selected groups of Item Numbers. All changes are recorded in a Delete/Renumber/Merge log. There is an audit report that allows you to review any changes, deletions or additions to the Item masterfile.
Drill-Down From Item Inquiry When viewing an inventory item in sales history, you can see all the invoices that contain the item (s) sold to a particular customer. The list shows the invoice number with invoice date that contains the item (s) purchased. From the list of invoices, you can select an invoice and drill down to the invoice line item to see the details of the quantity and price of the item that was sold.
Unlimited Vendors Per Item The lookup displays the last purchase price of an item, the lead time (based on the date of the last purchase order compared with the date of the last receipt), and available quantity price discounts. You can even sort vendors by last cost and by lead time.
  • Transaction Journal
  • Inventory Price List
  • Inventory Backorder Fill Report
  • Inventory Stock Status Report
  • Automatic Cost/Price Change Register
  • Inventory Reorder Report
  • Sales Promotion Application Register
  • Inventory Valuation Report
  • Sales Promotion Report
  • Inventory Turnover Report
  • Inventory Valuation Report by Period
  • Daily Transaction Register
  • Inventory Sales Analysis
  • Physical Count Worksheet
  • Inventory Sales History Report
  • Physical Count Variance Register
  • Inventory Issue History Report
  • Sales Kit Listing
  • Detail Transaction Report
  • Sales Kit Where-Used Listing
  • Inventory Trial Balance Report
  • Costed Sales Kit Report
  • Inventory Negative Tier Report
  • Inventory Item Listing
  • General Ledger Posting Recap
  • Inventory Labels
  • Item Masterfile Audit Report
  • Inventory Memos
  • Receipts History Report

Click here to view the Inventory Management PDF File

 
© Copyright 2004. All Kleer Computer Systems and it's Licensors. All rights reserved.
Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned
herein are registered trademarks or trademarks of Sage Software, Inc., or its affiliated entities.
Windows is a registered trademark of Microsoft Corporation.
All other trademarks are property of their respective owner.