Eagle Consulting Group Joins Net@Work

Eagle Consulting Group Has Merged With Net@Work, A Top Worldwide Sage Software Business Partner.

The Eagle team will continue to work with you and support your Sage MAS and CRM installations. We remain committed to your IT and business needs - rest assured that the voices and faces you've come to know and trust will still be there to take your calls.

This is a big win our valued customers. With our combined teams we can now offer you expanded services and support, providing a true advisor for all your IT initiatives.

Visit us at www.netatwork.com

Phone: 212-997-5200
575 Eighth Avenue (corner of 38th st.) New York, NY 10018

Phone: 201-735-9560
29J Commerce Way Totowa, NJ 07512

» View Message from Debra Ellis, President, Eagle Consulting

» View Official News Release

Eagle Consulting is now part of Net@Work, a leading Sage MAS 500 VAR Headquarted in NY with offices nationwide.

Please call 212-997-5200 or click here For MAS 500 Support, Sales, Consulting in New York, New Jersey, Connecticut, North Carolina, and Texas

Sage MAS 500 Inventory Management
Your company’s inventory is one of its most valuable assets. The Sage MAS 500 Inventory Management module maximizes profitability and customer service by controlling every aspect of your inventory process. Inventory Management can be run with General Ledger only or integrated with other Sage MAS 500 modules. It can help you decide which products to stock, which products to discontinue, how much inventory to buy and when to buy it. Inventory Management's replenishment feature suggests profit-maximizing strategies that can help you succeed in today's highly competitive business environment.
Quick Links
Screen Shots Activities Inquires Reports Examples
Setup Utilities Integration Other Reports
Operational Flexibility
Multiple Bin Locations Allocate each item to one or more bin locations per warehouse. Bin Types Each bin is designated a type of: fixed bins, random bins, holding bins. Any bin may further be designated as temporary, deleted when its quantity falls to zero.
Unlimited Warehouses Set up an unlimited number of warehouses for each company. Numerous default values are established at the warehouse level. Landed Cost Specify estimated landed costs for each item. You create landed costs to set up estimates of additional charges or costs that you may incur when you purchase an item from a vendor. Landed cost can be applied to items or vendors.
Account Substitution Track inventory by department or location with the warehouse, batch, purchase product line, and sales product line account segment override features. These features allow you to override specific General Ledger segments during data entry with values assigned to warehouses, purchase product lines, sales product lines, or batches of transactions. Sales Product Line Create and maintain sales product lines to group items for sales analysis purposes. Enter a description, indicate a target gross margin percentage, and select a commission class for each sales product line. Specify a trade discount and allow price overrides by product line.
Purchase Product Line Use Set Up Purchase Product Lines to group inventory items into product lines that can be placed on a purchase order to accurately calculate order cycles. Unlimited Unit Of Measure Conversion Employ an unlimited unit of measure conversions for items. Classify separate units of measure for stocking, selling, buying, and pricing each item.
Item Attributes By Warehouse Establish a variety of item attributes for more efficient processing. Apply inventory attributes on a warehouse-by-warehouse basis. Designate an inventory item as seasonal. Designate whether or not an item can be back ordered or drop-shipped. Highly Flexible Pricing Maintain pricing for user-defined pricing types. Retain and compare different prices for an unlimited number of years. Maintain pricing information separately for each inventory and fiscal year and retain this information indefinitely. Maintain price sheets for each warehouse. View comparisons of current-year activity, current-year price, revised price, user-defined price sheets, and prior year activity by period for each item. Set up multiple price lists (in multiple currencies), multiple companies, and multiple warehouses and bins. Implement pricing for specific contracts and volume price breaks.
Customer Price Groups Use customer price groups to classify customers for pricing purposes. These groups are typically assigned to each customer or customer address record. Price Groups Product price groups, in conjunction with customer price groups, are used to relate pricing information to groups of items within a company.
Contract Pricing Use Contract Pricing to create and maintain specific customer pricing strategies. Establish specific customer discount policies for buying a certain inventory item or inventory items assigned to a product price group. Vendor And Customer Item Numbers Track both vendor and customer specific item numbers for each inventory item number to be used as a cross-reference.
Flexible Costing Changes Revise the cost for each item by selecting from among several methods. Retain original cost figures to provide proper fiscal reporting. Flexible Item Tracking System Group items by classification for faster and easier data entry. Sort reports by item classes to produce more meaningful and informative reports. Track item purchase history and item class history by posting date. Track changes made to item accounts, providing an audit trail of changes, deletions, or additions made to item data.
Vendor Pricing Set up vendor price lists and define multiple break and price tiers for each vendor/item combination. Noninventory Items Noninventory items are used for noninventory items such as services, comments, and business expenses. On-hand quantity and warehouse information are not tracked for noninventory items. Transaction quantities, sales, and cost of sales accounts are tracked for each item.
Kits Both Build To Order and Assembled Kits are supported. Posting Audit Trails Printed reports and registers provide a complete audit trail of detail activity before posting. You can retain detail postings for an unlimited number of years, or you can retain monthly summaries.
Item Audit Trail Inventory Management provides an audit trail of any changes, deletions, or additions to the Inventory Management accounts. You can view a report that contains all changes made to data fields. Future Period Posting Post to future inventory periods from Inventory Management or other modules without closing the current period. You can produce Inventory Management reports for the next inventory year without closing the current inventory year.
Set Up
Inventory And Fiscal Calendar Change both the inventory and fiscal calendars. When a fiscal calendar change occurs, General Ledger updates the General Ledger account history. Prior inventory management history is not revised. Multi-Year History Retention You can retain detail postings for an unlimited number of years, or you can retain monthly summaries. Historical and transactional storage of inventory, purchase product line, and lot/serial transaction data allow you more insight into year-to-year comparisons, trends, and analysis.
Flexible Inventory Periods You can define an unlimited number of inventory periods in a year. You can also define different ending dates for each inventory period. Commodity Codes Use commodity codes to classify items for tax and other regulatory purposes.
Freight Classes Enter and modify freight classifications and their descriptions in Set Up Freight Classes, and then assign freight classes to each item in your warehouse. Item Classes Item classes provide a way to link items in groups and use these classes to supply defaults when setting up individual items, thus saving the time and effort in establishing and maintaining individual items.
Five Valuation Methods Choose from five different valuation methods: LIFO, FIFO, Moving Average, Actual, and Standard Cost. Lot And Serial Number Support Use serial and lot tracking for situations where inventory is serialized (such as cars or appliances) or grouped into lots (such as carpet or pharmaceuticals).
Custom Fields Customize sorting of Inventory Management information by creating up to four user fields for warehouses and four user fields for items.
Create Inventory Use the Create Inventory to stock these warehouses with selected items. Create Inventory provides an alternative to individually adding the items to a warehouse. Batch Processing Inventory Management processes most transactions in batches. One batch may contain either a single transaction or hundreds of transactions.
Item Ranking Inventory Management independently ranks products based on four different criteria: cost of goods sold, units sold, hits (number of times sold), and margin dollars. Use Rank Inventory Items to have the system calculate the rank for the item in a single warehouse or all warehouses. Rank codes can be entered manually in Maintain Inventory, but processing this task overrides and updates those codes. Physical Inventory Receive and ship orders during inventory cycle counting. Execute a complete physical inventory process without the need to interrupt other business processes, such as receiving and shipping. Perform cycle counts based on user-defined criteria, such as items, bins, inventory hits, or inventory turns. Create general ledger and adjusting transactions automatically.
Inventory Transactions Sage MAS 500 offers a complete set of inventory transaction options, including physical inventory processing, cost tier adjustments, and in-warehouse transfers. Inventory items can also be transferred between warehouses using the Three-Step Transfer method. Process Cost Tier Adjustments Use Process Cost Tier Adjustments to create cost adjustment transactions to track the value of inventory.
Process Assembled Kits Use Process Assembled Kits to build preassembled kits for stock. Enter the batch number, description, posting date, and warehouse. Move Stock Within Warehouse Use Move Stock Within Warehouse to move a quantity of a product, including lot and serial items, from one bin location to another within the same warehouse. Consolidate stock and open a bin for other items.
Inventory Status Inquiry Use this inquiry to view item information in a specific warehouse. Determine the selection of items for distribution when increasing or decreasing inventory from another task, such as Sales Order shipping or Purchase Order receiving. View the serial number, lot number, expiration date, bin, preferred bin, and available quantity. Inventory Transaction Inquiry Use this inquiry to view the pending and posted transactions for a specific item in one or more warehouses. Select the warehouse, item, transaction number, transaction type, transaction status, reason code, transaction date, post date, transaction quantity, and transaction amount. Drill down to the Bin/Lot/Serial Inquiry by right clicking a transaction in the grid.
Items Inquiry Use the Items Inquiry to view a list of items within the company. Item History Inquiry Use this inquiry to list the transaction history for a specific item in one or more warehouses. You can display data based on the inventory period, warehouse, and item. This inquiry is useful for reviewing trends in the market for an item.
Lot Summary Inquiry Use this inquiry to quickly access information regarding lot data and to drill down to the original transaction. Serial Number Inquiry Use this inquiry to quickly access information regarding serial data and drill down to the original transactions, including the serial availability within each selected warehouse.
Stock Status Inquiry Use this inquiry to view the status of an inventory item for each warehouse in a company. Price Inquiry Use this inquiry to view price and availability quotations.
Screen Shots
Maintain Item-Main
Maintain Item-UOM
Maintain Item-Buy/Sell
Maintain Item-Categories
Maintain Items-Landed Cost
Maintain Item Classes
Maintain Inventory-Main
Maintain Inventory-Replenishment
Maintain Inventory-GL Accounts
Maintain Inventory-Preferred Bins
Maintain Vendor Items-Main
Maintain Vendor Items-Cost Breaks
Maintain Customer Items
Maintain Price Sheets
Maintain Customer Price Groups
Maintain Contract Pricing
IM Options-Main
IM Options-General Ledger
IM Options-Data Retention
IM Options-Miscellaneous
IM Options-Custom Fields
IM Options-Inventory Calendar
Setup Purchase Product Lines
Setup Rank Codes
Setup Warehouses-Main
Setup Warehouses-Transfers
Setup Bins
Inventory Transactions
Process Physical Inventory
Process Kit Assembly
Enter Transfer Orders
Move Stock Within Warehouse
Global Inventory Change
Inventory Inquiry
Inventory Transaction Inquiry
Inventory Item History
Stock Status Inquiry
Price Inquiry
Useful Utilities
Purge IM Data
Use Purge IM Data to selectively purge records outside the normal period-end processing task. When using this task, you specify the inventory transactions to purge, or use the defaults from the data retention settings selected in setup.
Global Item Change
Use Global Item Change to make changes to a number of items in inventory. This function allows you to customize the replenishment, stocking, and reporting characteristics for the current company.
Global Inventory Change
Use Global Inventory Change to make changes to inventory for customizing the replenishment, stocking, and reporting characteristics in each warehouse for the current company.
Lot/Serial Adjustment
Use Lot/Serial Adjustment to adjust an incorrectly entered serial or lot number. You can also adjust the expiration date of the lot item
Data Exchange
Import item and inventory item data directly from an external file. Use ASCII text and delimited text files to import data.
Integration With Other Sage MAS 500 Modules

You can use Inventory Management with General Ledger only or integrated with other modules. In an integrated system, modules share common information with related modules. This sharing eliminates double entry of information that is already stored in Sage MAS 500. The modules that can be integrated with Inventory Management are:

Multicurrency Management
If you have the Sage MAS 500 Multicurrency Management module, you can enter inventory transactions in different currencies.
Accounts Receivable
When you use the Sage MAS 500 Accounts Receivable module, you can enter customer specific price schedules and customer/item cross-references. You can also drill down to invoice information from an Inventory Management Inquiry. Inventory Management uses the customer home currency for retrieving pricing information. You can assign charge or discount schedules to customers or ship to addresses.
Accounts Payable
Use Sage MAS 500 Accounts Payable to create vendor cost schedules and vendor/item cross-references. During transaction entry, you can enter vendor minimum requirements, freight information, and reorder requirements. You can drill down to voucher information from an Inventory Management Inquiry task. You can assign charge and discount schedules to vendors.
General Ledger
General Ledger is required to run Inventory Management. When you establish Inventory Management for a company, the chart of accounts information that your entered in General Ledger is available. Sage MAS 500 uses those account numbers to establish accounts in Inventory Management.
Purchase Order
When you enter inventory transactions or cost tier adjustments, Sage MAS 500 checks the posting accounts and automatically creates the correct journal entries. You can use Purchase Order to match stock receipts to customer back orders, update inventory quantities with receipts, retrieve the correct vendor costs, and update purchase order commitments.
Sales Order
Use Sales Order to retrieve the appropriate customer cost, update sales order commitments, process shipments and returns, and update inventory quantities from sales transactions.
All Inventory Management reports can export data to an external file. Data types supported include ASCII text, HTML, delimited, DIF, Word, Excel, rich text format (.rtf), or Crystal Reports for Sage MAS 500 (.rpt) files.
The Inventory Transaction Report shows posted inventory transactions that were entered using Purchase Order or Sales Order. The Inventory Valuation Report determines inventory value based on transactions or posting that occurred within a specified date range.
Use the Stock Status Report to obtain an overview of current stock levels. Elect to display only current stock status or include replenishment information. The Low Cost Report displays purchasing opportunities from the primary vendor or an alternate vendor that result in a lower net adjusted cost for an item.
The Inventory Analysis Report compares the current dollar amount of inventory invested within a warehouse to the annual cash flow that results from the investment. Use the Inventory Performance Report to calculate five critical measurements of inventory performance of finished goods, pre-assembled and build-to-order kits.
Other Reports
Customer And Vendor Price Lists
Bin Labels
Physical Inventory And Count Cards
Physical Reconciliation
Unusual Usage
On-Hand Lot/Serial
Lot/Serial History
Negative On Hand Quantity
Kit Components Where Used
Inventory Cost
Lead Time Exception
Transit Warehouse Variance

(212) 997-5200

Sage Software Select Partner in New York City and the Tri-State Area for
Sage MAS 90, Sage MAS 200 and Sage MAS 500 accounting software

575 Eight Ave. 10th Floor | New York, NY 10018

(212) 997-2484 fax

site map | home

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. All other trademarks are property of their respective owners.

Visit Net@Work for Sage MAS 500, MAS 90, MAS 200, ACCPAC, SALESLOGIX, SAGECRM, SAGE ABRA HR, services in New York NY, New Jersey NJ, Texas TX, Connecitcut CT, North Carolina NC Boston, MA