Inventory Reports

Shows a complete list of all stock items in inventory. It displays the following information: stock number, item description, product type, and stock location. You can also choose to print last cost and quantity on hand.

Choose the information you want included on your labels and print them for a single stock number, a range of stock numbers, or all stock numbers.

Shows all information from the Master file for the selected stock items. It has variable sorting ability and can be printed for a single stock item, a range of stock items, all stock items, and for one or all Inventory Codes.

Generate this report prior to performing an inventory count. Space is provided on the report to write in the actual physical inventory and for noting any discrepancies between physical and computer counts for later adjustments. For each stock item selected, this report lists the following information: inventory code, stock number, item description, product type, stock location, and unit package. You can also choose to print last cost and quantity on hand.

Shows both the quantity on hand and the various pricing breaks for each inventory item. This report shows only retail pricing breaks and is often provided to customers as a pricing reference. The report includes: stock number, item description, vendor, product type, location (only available if multi-location inventory installed), and pricing type.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

This report provides cost and quantity information about all inventory on hand. If this report is run with detail, each purchase of inventory and the associated cost is presented. This report is useful when adjusting inventory levels after taking a physical inventory. It is also useful for reconciling your General Ledger. The On Hand detail report shows the following for each item selected: stock number, item description, stock location, last order date, quantity on order, quantity on hand, detail serial number, date, cost, and quantity. You can also choose to print detail, last cost, and skip zero quantity.

The Stock Value Report reads the cost and quantity for each stock item and gives a total dollar amount of inventory for a particular period. The Condensed report shows the totals for each item, while the Detailed report contains a separate line for each purchase of each item, detailing how many of each item are on hand at each cost. The Stock Value Report shows the following for each selected item: stock number, item description, product type, location, date, on hand quantity, unit package, method, weighted/average cost, and value. You can also choose to print: last cost, and skip zero quantity.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

Shows minimum acceptable levels of inventory and the required quantities needed to return inventory to the predetermined levels. This report is considered an exceptions report to management, indicating inventory items that are not being replenished often enough. The Understock Report includes the following detail for each stock item: stock number, item description, understock quantity, stock location, vendor, vendor's stock number, product type, alternate stock number, interchangeable stock number, quantity on order, and minimum quantity. You can also choose to print: last cost, quantity on hand, quantity committed, and vendor's stock number.

Select Advanced Understock for the report type to monitor which stock items need to be replenished along with the total sold of each item in 5-, 30-, and 60-day increments. The Inventory Advanced Understock Report includes the following detail for each stock item: stock number, item description, understock quantity, stock location, vendor, product type, quantity on order, minimum quantity, last cost, quantity on hand, quantity committed, and quantity sold in the last 15, 30, and 60 days.

Shows maximum acceptable levels of inventory and the quantity by which an inventory item exceeds this level. This report is considered an exceptions report, indicating inventory items that are moving slower than expected. The report includes: stock number, item description, overstock quantity, vendor, product type, stock location, alternate stock number, interchangeable stock number, quantity on order, and maximum quantity.

Includes those items that have quantities in the On Order box of the item Master Record. The On Order Report shows the following information for each included stock item: stock number, item description, vendor, product type, location, quantity on order, and date of last order.

The Back Order Report includes those items that have quantities in the Back Order box of the stock item master record. The Back Order Report can be sorted by stock number, description, or product type. It includes the following: stock number, item description, product type, vendor, stock location, quantity on order, and quantity on back order. You can also choose to print last cost, and quantity on hand.

Shows a brief history of each stock item you carry. This report includes the following: stock number, item description (includes transaction description, serial number, and ending serial number), product type, quantity on hand (includes quantity, cost, and price), and multi-pack (if Specialty Shop is installed).

Provides an indication of how fast inventory items are selling. The movement is presented as a percentage, calculated as the number of items sold over the sum of inventory on hand and purchased during the period. It is sorted by percentage. The Movement Report shows the following for each item: stock number, item description, product type, location, beginning quantity, quantity bought, quantity sold, quantity on hand, and movement percent.

When you run a promotion, it's important to know if it was successful. You need to know what was sold at regular prices, what was discounted, and how many were sold at different prices. The Promotional Sales Report shows the following for a selected promotion code or range of promotion codes, or for a range of stock items, departments, salespersons, inventory codes, or product types over a promotion date range: promotion code, sale dates, stock items sold and quantity, promotion price and extended price, gross sales, free/discounted items, and net sales. You can run this report in either a detailed or condensed format depending on what you want to see.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

This report is important in that it will show errors with your data files. You may want to run this report whenever you find a discrepancy in your on-hand quantities; whether the quantities vary between reports, lookups and reports, or between any two places in the system where the numbers do not match. The Control Report shows the following for a selected inventory code or for all inventory codes: total number of items on hand, or the book value of each of those items. Report totals are calculated for both values and are shown at the bottom of the report. You can specify which vendors to include in the report by selecting a range of vendors.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

Kits allow you to group inventory items - and the ability to create kits allows you to streamline your inventory management process. The ability to quickly view your kits and closely monitor them is an added benefit. With the Master Kit Report in Inventory, you can quickly view the current cost and quantity requirements for any or all kits set up in the system.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.