maim100

Product Demand Report

This report produces a table illustrating product demand on a monthly basis based on quantity on open and closed sales orders. If order date spans months, the report provides a comparison of product demand across multiple months.

maim101

Required Order Date Report for Drop Ship Items

Click to View Report

This report is a valuable tool for companies that accept a sales order for a product, purchase the product and then drop ship to the customer. The report compares promise date with order date and lead time to calculate if the item can ship by the promise date. The report will warn you for each Sales Order line item if you cannot drop ship in time to meet the promise date.

maim102

Inventory Turnover Report

Click to View Report

This report computes the number of Inventory Turns based on the last four months Sales and current Inventory on hand. The report also shows by Part Number: Quantity on Sales Order, Back Order, Quantity Available, Quantity Sold Last 4 Months, Dollar Sales To Date and Prior Year Sales. This is a good report for monitoring your inventory levels.

maim103

Inventory Non-Moving Report

Click to View Report

This report is useful for highlighting non-moving inventory to identify obsolete or slow moving items. The report will return all Item Numbers by Warehouse that have had no activity from the date entered through the latest transaction date. An item with no transaction history will not show up in any report.

maim104

Shipping Schedule by Week

Click to View Report

This report shows the quantity of Inventory Items to be shipped for each week going out six weeks. The report is sorted by Customer and then by Inventory Item. MAS 90 users find this report very helpful when planning what items are to be shipped during an inputted date range. The ship date on the Sales Order Header is used to determine when the Inventory Items are to be shipped.

maim105

Obsolete Inventory Report

Click to View Report

This report looks at the Inventory Detail Transaction file (IM5). When you run the report, you will be prompted to enter an obsolete date and a number range for quantities on hand. The report will look for items with no transactions in that file later than that date. It will look at all activity types.

This report lists the Item Number, Item Description, Last Transaction Date, On Hand Quantity, Unit Cost and Total Cost for all inventory items that have had no activity after an inputted date.

This report is great for managing slow moving and obsolete inventory items. Also, this report can be purchased in combination with the "Delete Non Moving Zero Quantity Items" Visual Integrator import Viim101 and the Inventory With No Transactions Report. Call Jim Snell at 919-964-0377 for special pricing.

maim106

Inventory with No Transactions Report

Click to View Report

This report also looks at the Inventory Detail Transaction File (IM5) along with the Inventory Master File (IM1). It will show all items from the Master File that have no transactions in the detail file.

This report needs to be reviewed carefully because, a brand new item may be listed that you will be buying and/or selling and does not yet have any activity.

Also, this report can be purchased in combination with the "Delete Non Moving Zero Quantity Items" Visual Integrator import Viim101 and the Obsolete Inventory Report. Call Jim Snell at 919-964-0377 for special pricing.

maim108

Inventory Analysis Report

Click to View Report

This report provides a one line summary by Item # showing Sales History by Dollar and Quantity. The report also includes Gross Profit Dollars, Gross Profit %, On Hand Quantity, Months Supply (based on Sales History) and Quantity on Purchase Orders and Sales Orders. When running the report, you input the Year, Warehouse # and the Months. The report computes the Average Monthly Usage based on the "Months" input parameter.

maim109

Inventory Analysis Report

Click to View Report

This report is designed for items (normally part of a kit) that can both be sold AND issued (as part of a kit sale). This sorts by item, by warehouse, and will list sales and issues separately, but also give you a total for each item. There are prompts for Year, Warehouse (or blank for all), Item Range (or blank for all) and whether you want the sales/issue history detail to print. If yes, then a line for sales and a line for issue will print per item per warehouse. If No, then a total per warehouse per item will print. There is also a 12 month total to the right.