The Inventory Reports screen provides access to the following reports:
§ Inventory Summary: Displays a summary of units sold/purchased, the balance in inventory, the average cost, and the asset value for each inventory item. You can run this report in Summary mode, to view a summary of all activity for the item, or in Detail mode, to view each transaction listed separately. You can sort the report by product name or code.
§ Cost of Goods Sold: Compares the sales price for each item to its cost, to calculate net profit for a specified date range.
§ Profitability: Computes the profitability of each inventory item for a selected date range. You can sort the report by item, sales, or profit percentage.
§ Transactions: Displays each inventory transaction for a specified date range, including both purchases and sales so that each line of the report displays the quantity on hand and total dollar balance for the item.
To view the reports available from the Inventory Reports screen:
1. Select Inventory from the Reports menu to open the Inventory Reports screen.
2. Click the name of the report you want to view from the panel on the left.
The panel lists all of the available Inventory reports. When you select a report, the report criteria screen for that report appears.
The Inventory Summary criteria screen is selected by default.
3. Enter the additional information requested for the specific report in the appropriate fields:
§ Inventory Summary: Use the From and To fields to enter a date range for the report, use the options in the Show field to specify whether to view a Summary report or a Detailed report, and specify how to sort the report using the Sort By options. You can sort by item Name or Code.
§ Cost of Goods Sold and Transactions Reports: Enter a date range for the report using the From and To fields.
§ Profitability: Enter a date range for the report using the From and To fields, and specify how to sort the report using the options in the Sort By field. You can sort the report by Item, by Sales, or by Profit Percentage.
4. Click the PDF, Excel, or Word button to indicate the output you want to generate.
Depending on the output format you choose, the file opens as a separate tab on your browser (PDF) or as a separate file (Word and Excel), from which you can save or print the report.
5. Click Archive to save the requested data to Cloud Cabinet.