MAS 90 200 500 SalesLogix Abra JobOps Texas Colorado Arizona Sage

Sage MAS 90 and Sage MAS 200 Inventory Management Module
Efficient, secure, well-organized inventory control is a necessity for the successful operation of your business. The ability to rapidly and accurately know where your stock is, its value, its movement, and what commitments are pending for it, enable you to make accurate, strategic decisions that not only save your company money—they can earn your company money. Sage MAS 90 and Sage MAS 200 Inventory Management module has been engineered to provide the kind of detailed information and tools that enable you to keep just the right quantities on hand. Serving as the backbone for many organizations, Inventory Management can stand-alone or integrate tightly with Sage MAS 90’s distribution and manufacturing modules to offer a complete solution.
Quick Links
Data Entry	Screen Shots	Utilities	Integration
Forms	Transaction History	Inquires	Features
Pricing & Costing	Report Examples	Other Reports
Operational Flexibility
Decimal Precision	Item quantity entries support up to three decimal places. Price and cost entries support from two to four decimal places.	Unit of Measure	Maintain a separate unit of measure for purchase, sales, and stock reporting. The conversion between these units occurs automatically.
Defaults By Product Line	Many item attributes, such as Product Type, Valuation Method, Commission Method, Unit of Measure, etc. may be maintained in the item’s Product Line masterfile, enabling default values for items within the product line, yet allowing overrides for individual items.	General Ledger Posting Flexibility	Default General Ledger accounts are maintained by Product Line, with the ability to override the account during transaction entry. For each account, elect to further designate the account used by warehouse substitution. Facilitates intricate, yet accurate posting for multiple location processing.
Multiple Warehouse Support	Literally thousands of warehouse may be designated. For each warehouse code, the ship-to name, address may be maintained. Additionally, the segment of the General Ledger account into which the warehouse code may be substituted is maintained here.	Warranty code maintenance	Enter and maintain a library of warranty codes, their corresponding description and the number of days before expiration. Apply these codes to each item as the warranty offered to your customer, and to each vendor/item combination as the warranty offered by your vendor.
Data Entry Features
On the Fly Additions	Inventory items can be added on the fly during receipt transactions in Transaction Entry.	Transaction Entry	The Transaction Entry option within Inventory Management supports: receipts, issues, adjustments, and transfers. Additionally, when integrated with the Purchase Order and Sales Order module, the transactions from these modules flow automatically into the inventory files.
Physical Count	Perform physical count operations without interrupting normal business operations. Physical Count Worksheets with flexible sort options speed the count process. An Inventory Cycle code assigned to item numbers provides logical groupings for items to be counted on the same schedule. A variance report illustrates the difference between the current physical count and the count according to your books.
Screen Shots
	Inventory Maintenance		Inventory History
	Inventory Quantity		Inventory Sales Information
	Inventory Alias		Inventory Alternates
	Inventory Pricing by Schedule		Inventory Pricing by Customer
	Inventory Vendor Pricing
	Inventory Options		Inventory Transactions
	Inventory Inquiry - Sales Order		Inventory Inquiry - Purchase Order
	Inventory Cost Detail		Inventory Extend Desciptions
	Inventory Transaction Entry		Inventory Transaction Detail
	Inventory Physical Inventory
	Inventory Setup Options - Main		Inventory Setup Options - Additional
	Inventory Unit of Measurement Maintenance		Inventory Product Line Maintenance
	Inventory Product Line Maintenance- GL		Inventory Warehouse Maintenance
Useful Utilities
Inventory Item Valuation Change	A utility enabling you to change an item’s valuation method, even if there is quantity on hand. If appropriate, a General Ledger adjustment is generated.	Automatic Cost/Price Change	A convenient utility to change the cost, retail price, or standard price of a large group of items automatically. The cost can be changed by a percentage of the current cost, a flat dollar amount, the cost of the last receipt, or the current average cost. The price can be changed by a percentage of the current price, a flat dollar amount, a percentage of the current cost, or a dollar amount added to cost.
Item Delete/Renumber/Merge	This utility allows you to delete, renumber, or merge existing item numbers. The changes made flow to the appropriate subsidiary modules where the item number is referenced.	Item Masterfile Audit Report	Changes, deletions, and additions to the item masterfile are tracked, including the date of change and user code or workstation ID. An audit report provides a written record.
Product Line Information Update to Inventory Items	An Apply feature in Product Line Maintenance allows item masterfile to be refreshed with changes made to product line data.
Integration With Other Sage MAS 90 or Sage MAS 200 Modules
Purchase Order	Purchase Order transactions such as receipts and returns flow automatically to the Inventory Management module. Detailed information about last cost, average cost, and lead-time is calculated automatically and stored within the Inventory module. From within the Inventory Management module, full detail of on file purchase orders is available.	Sales Order	Sales Order transactions such as sales and returns flow automatically to the Inventory Management module. Detailed sales information by item/customer/warehouse may be stored within the Inventory module and readily accessed.
Job Cost Integration	When Inventory Management is integrated with the Job Cost module, issued can be posted to specific jobs.	Bill of Materials
Work Order Processing		Material Requirements Planning (MRP)
General Ledger
Forms
Item Label Printing	Flexible item label forms are offered. You may select from dozens of item attributes to include on the label for use as shelf tags, price tags, inventory control stickers, etc.	Bar Code Printing	Inventory item labels with bar codes can be printed using both code 39 and code 128 bar code formats, with support for most printers.
Transaction History
Sales History	Extensive item sales history may be maintained within the module. Year to date, prior year, and current period quantities, dollars and costs sold for each item by warehouse. Detailed history of the quantity and dollars sold for selected item by warehouse and/or customer. History for non-sale activity such as manufacturing can also be retained.	Drill Down from Item Inquiry	Detailed sales history inquiries are provided. From item maintenance and inquiry you can view all invoices that contain the item sold to a particular customer, even drilling down to the line section of an invoice to view the details.
Transaction History Inquiry	View detailed transaction history by item/warehouse. The date, transaction type, reference, quantity, and cost are displayed. For Purchase Order Receipts and Sales Order Invoice transactions, zoom down to view the details of the source document.	Cost Detail	View the detailed costing tiers for items of LIFO/FIFO and Lot/Serial valued items. The receipt date, receipt number, quantity and unit cost are displayed. Drill down to view the source documents.
Inquiries
Inventory Inquiry	Provides much the same view of the item as Inventory Item Maintenance, but in a read-only format. Using security features, restrict some users to inquiry options only, giving them access to the data while preserving its integrity.	Price Lookup	Pricing information for any item is easily viewed from within Inventory, Sales Order, and Accounts Receivable modules. View quantity price breaks, customer price levels, and contract pricing.
Purchase Order/Sales Order Inquiry	Open purchase order and sales order information, complete with line item drill down, can be viewed at any time.
Rich Feature Set
Alias Item Numbers	Maintain a list of customer and vendor part numbers for each item. These part numbers may be entered in Sales Order Entry, Purchase Order Entry, and Return of Goods Entry. Handy search engine makes finding alias item numbers easy.	Alternate Items	Create up to eight user-defined alternate items for each inventory item. During Sales Order Processing, if the original item is out of stock, you will be offered the list of alternates to select from.
Item Memos	Enter and maintain unlimited memos for inventory items. Memos may be viewed and maintained during Inventory Item Maintenance	Extended Item Descriptions	Item descriptions may contain up to 99 lines of 50 characters each.
Commission Methods	The commission method for each item may be specified as a percentage of price, percentage of cost, or a percentage of gross profit, plus a base commission amount.	Unlimited Vendors per Item	Each inventory item may reference an unlimited number of vendors, each with a unique vendor item number, standard lead time, last lead time, last cost, and last receipt data. In addition, vendor pricing tiers may be maintained for a product line, with overrides for individual items. For each item, a primary and secondary vendor number may be indicated.
Sales Kit Processing	Define sales kits as groupings of items priced and sold together. Sales Kits may be entered during Sales Order Processing to explode the component items automatically.	User-Defined Sort Fields	Four user-defined classifications are offered (e.g. size, color, version) for each item. Reports can be sorted by these criteria.
Multiple Warehouses	Support for literally thousands of individual warehouses, each capable of maintaining a separate inventory of each item. Many item attributes (e.g. reorder point, minimum order quantity) are specific to the warehouse. Easily transfer items between warehouses.	Reordering	The Inventory Reorder Report lists items whose on hand quantity has reached a specified reorder point, which is specific to the item/warehouse. The suggested reorder quantity may be based on economic order quantity, maximum stock quantity, or reorder quantity.
Future Period Posting	Most reports distinguish between transactions processed for the current period from transactions processed for future periods.	Warranty tracking	Warranty codes can be applied to inventory items, allowing an expiration date to calculate at the time of shipping or invoice data entry. The expiration date can be printed on several forms for easy communication to the customer.
Vendor warranty	For each vendor/item combination, maintain a warranty code that this vendor offers you for the item.
Pricing & Costing Flexibility
Contract Pricing	Indicate a range of dates and either a discount percent or sale price for individual items. Alternately set up broad sales and apply them to groups of items, produce lines, vendors, and price codes.	Sales Promotions	Contract pricing schedules for specific customers can be established. Sales Order Processing accesses the contract pricing instead of the standard price for each item.
Costing Method	Inventory valuation may be based on standard cost, average cost, LIFO, FIFO, and lot or serial methods, with a different valuation method possible by item. Regardless of the valuation method, the standard cost, last cost, and average cost are maintained for each item.	Price Schedules	Twenty-six (26) comprehensive price schedules based on customer price levels and the quantity sold may be maintained for each item. Calculate price based on a discount of the standard price or a markup of the standard cost. The Sales Order Processing module utilizes pricing.
Reports
Inventory Stock Status Report click to expand report selection	The Inventory Stock Status Report offers invaluable information useful on a daily basis. Current stock levels and pending purchase orders, sales orders, and back orders are summarized by warehouse. A quantity available for sale is calculated by subtracting the quantities on sales order and back order from the quantity on hand.	Inventory Reorder Report click to expand report selection	Provides on hand, purchase order, sales order, and back order quantity information for each item in the selected range. A recommended reorder quantity is shown based on the item’s reorder information.
Inventory Valuation Report click to expand report selection	This report shows the total value of the on-hand quantity for each item, using the item’s specified valuation method. Print the report for all or selected items, and one or all product lines, product types, or warehouse locations. Elect to include or exclude cost detail for LIFO, FIFO, lot, or serialized items.	Inventory Sales Analysis click to expand report selection	The Inventory Sales Analysis provides a summary of each item’s sales activity and gross profit data for the current period, year to date, and the prior year. Enter a sales volume range to find top sellers.
Inventory Sales History Report click to expand report selection	The Inventory Sales History Report offers a detailed look at items’ sales histories for up to 13 inventory periods. Includes quantity sold, dollars, sold, profit percentage, cost, and quantity returned. Flexible selection criteria allow you to include only items with an increase or decrease in sales over the previous period.	Inventory Trial Balance Report click to expand report selection	The Inventory Trial Balance Report is a valuable tool to assist in reconciling the Inventory General Ledger account balances. Beginning balance and cost for the current period is shown, as are ending balance and cost.
Other Reports
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
Transaction Journal	Inventory Price List	Inventory Backorder Fill Report	Automatic Cost/Price Change Register
Sales Promotion Application Register	Sales Promotion Report	Inventory Turnover Report	Inventory Valuation Report by Period
Daily Transaction Register	Physical Count Worksheet	Physical Count Variance Register	Inventory Issue History Report
Sales Kit Listing	Detail Transaction Report	Sales Kit Where-Used Listing

Inventory Control Management