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. |
 |
Inventory Analysis Report - For Items that can be sold and issued (kit sale) - view report
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. |
|
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 infany report. |
|
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. |
|
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. |
|
Item extended Description Report
The Item Extended Description Report generates an inventory listing and includes items extended description. |
|
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. |
|
Product Demand Report - click to view 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. |
|
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. |
|
Sales History analysis by Period - click to view report
Parameters for this report are for a specific period, year, and range of product lines. It displays columns of Quantity Sold, Quantity Returned, Dollars Sold, COGS, Gross Profit, and Profit Percentage for each item. |
|
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. |
|
Slow moving inventory Report - click to view report
In this report, the user enters a transaction date. Any item that hasn’t been sold or transferred since that transaction date will appear, as well as the quantity on hand and the last transaction date. |
|
Top Sales by Item
Grouped by item number, this report shows the top selling items by volume through selected invoice date range. |
|
Crystal Reports