Category Archives: Sage 100

Sage 100 – Lot and Serial Number History Report

Lot and Serial Number History Report is used to view a history of lot and/or serial items sold and invoiced, detailed by lot and/or serial number. If a lot or serial number valuation method is used for inventory items, you can print this report quarterly, annually, or as necessary to satisfy auditing requirements. This report… Read More »

Sage 100 Open sales order report – by Item

The Open Orders by Item Report lists open sales orders by item code to facilitate the tracking of the outstanding orders for each item. This report can be used in conjunction with Inventory Management reports to determine what products should be ordered and the quantities necessary to meet customer commitments. New Stuff: Sage 100 Open Sales… Read More »

Sage 100 Open Sales Order Report

The report can be used to track the status of all open orders, pending processing, and shipment. It can be sorted by sales order number, customer number, shipping date, bill-to-name, salesperson, and bill-to-customer number. The Report can calculate extension amounts for master orders, include component lines, print tax detail, and/or print only unauthorized and expired… Read More »

Sage 100 Business Insights Explorer

Business Insights Explorer is the most convenient way to navigate your business-related activities. It brings ad hoc inquiry, drill-down, and drill-around analysis up to a whole new level. It turns data into knowledge that can act on by using powerful sorting, grouping, filtering, and charting capabilities that can be personalized to specific needs and roles… Read More »

How to create a memo in Sage 100 ERP?

The Memo Manager option in Sage 100 ERP gives users the ability to create memos for Employees, Vendors, Customers and General Ledger accounts, Inventory Items, Sales Orders, Purchase Orders and Invoices. Normally a Sage 100 ERP accounts receivable credit memo is done because of a return of some kind, such as you originally ordered 6… Read More »

Create drop-ship purchase orders in Sage 100

In this blog, we shall discuss the drop-ship feature available in the Sage 100 i.e. Sage MAS 90. Before we proceed, let’s understand what is meant by the Drop-Ship orders. ‘A drop-ship return item is merchandise returned directly to the vendor by the customer’. The above is the definition provided in Sage 100 Help documentation.… Read More »

How to customize and create look-ups in Sage 100 -Part 1

Most of the data entry screens in Sage 100 ERP contain a lookup option for various fields which can be identified by a magnifying-glass. If we select the magnifying-glass lookup icon, we will be able to scroll through a listing of all our records and data. For example, Customer Maintenance contains a lookup for the… Read More »