Crystal Reports Library—Inventory Management

Report

Price

Product Demand Report    IM-100 (pdf 11kb)
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.

$ 325.00

Drop Ship Order Date Scheduler w-Warning      IM-101  (pdf 5 kb)
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.

Inventory Turnover Report     IM-102 (pdf 21 kb)
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 Non-moving Report   IM-103 (pdf 15 kb)
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.

Shipping Schedule by Week     IM-104 (pdf 5 kb)
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. Sage 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.n

Obsolete Inventory Report     IM-105 (pdf 11 kb)
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.

Inventory with No Transactions Report    IM-106 (pdf 5 kb)
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.

Inventory Analysis Report     IM-108 (pdf 13 kb)
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.

We will contact you shortly to complete your order, adding applicable sales tax and shipping costs.