Sage 100 Inventory Management

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

Accurately identify items using up to 30 alphanumeric characters according to the needs of each of your companies. Embed meaningful information in smart part numbers such as UPCs, a vendor’s number, recycling codes, special handling requirements information, and more.

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 that highlights the difference between current physical count and the count shown in the system.

Assign alias item numbers to each customer and vendor. Alias items permit you to type alias item numbers in the Purchase Order and Sales Order modules, allowing the system to find regular item records and stock status. All alias item numbers print on invoices and purchase orders.

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 Report are available. Sales kits can be entered during order entry to automatically explode the components.

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.

A detailed history of all inventory transactions can be retained indefinitely, and a transaction audit trail can be produced for a specified date range.

Inventory labels with bar codes can be printed for inventory items. Both Code 39 and Code 128 bar-code formats are supported for a variety of printers.

The Reorder Report lists stock on hand that 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 point.

Commission on each item can be calculated using different methods. Commissions can be based upon percentage of price, percentage of cost, or percentage of gross profit plus a base commission amount.

You can 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 Item Masterfile Audit Report that allows you to review any changes, deletions, or additions.

View inventory items in sales history and drill down to all invoices for that item and a specific customer. Details include invoice number, invoice date, quantity, and price.

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.

The warranty expiration date for items, optionally calculated on shipment or invoice date, prints on invoices and packing slips for your customers.

Items may be tracked by lot or serial number. This helps improve quality while providing an audit trail to the source purchase order or work order.