Inventory Reports
There are twelve Inventory reports available. They are accessed on the Inventory Reports Menu.
1. Item Master Listing
2. Bill of Materials
3. Complete Item Price File Listing
4. Price by Sales Level
5. Purchase Information Listing
6. Inventory Location Listing
7. Inventory Stock Status Listing
8. Inventory Valuation
9. Inventory Profitability
10. Inventory Count Worksheet
11. Item Reorder Report
12. Inventory History
13. Pick Ticket History
14. Serial Number Tracking Report
15. Inventory Ranking Report
This option is only available if the Inventory module is purchased. This program is used to list information on each of the items in Inventory. The report contains the following information: quantity on hand, quantity on order, minimum reorder point, latest cost and average cost. The report can contain one, many or all items in Inventory.
The Bill of Materials report is specifically designed to itemize the Component Parts of one or more Bundle type inventory items. An Item entered through the Inventory Item Price file program can be designated as a "Bundle" item. This means the item is made up of multiple associated Component Parts. This report makes it easy to see all the pieces that need to be pulled together to fill an order that is comprised of Bundle items.
Complete Item Price File Listing
This program is used to list the information in the Item Price File. A report of purchase order information, sales information or all information may be obtained.
This program is used to list the items by sales level prices. A Report of Price by Sales Level is generated. The price and the sales level for each item is listed.
This report is a complete listing of all open Purchase Orders. The item number,description and vendors are also listed.
This option is only available if the inventory module is purchased. This report is used to list the items at each location. The areas may also be included, if desired.
This option is only available if the inventory module is purchased. This program is used to list the status of each item in inventory. The information available in the report includes the item ID, location, area, description, unit of measure, quantity on hand, quantity on order and total quantity.
This option is only available if the inventory module is purchased. This report calculates the total value of Inventory. The value of individual items or all items may be reported.
This option is only available if the inventory module is purchased. The report shows the price per unit, total price, cost per unit, total cost, and margin for each listed item.
This option is only available if the inventory module is purchased. This program is used to verify that the inventory count is accurate. The worksheet is usually used to do physical counts of Inventory. The quantities on order and on hand may be listed for each item. Items may be sorted by Location or by Item ID. The Locations and Items may be chosen for reporting.
This option is only available if the inventory module is purchased. This program is used to list the items that are currently being reordered.
This option is only available if the inventory module is purchased. This program lists all transactions to the General Ledger for a particular item. Multiple items and fiscal periods may be selected.
This option is only available if the inventory module is purchased. This program is used to list all Inventory Pick Tickets.
This option is only available if the inventory module is purchased. This program is used to print the tracking history of a specific serial number. Information includes the purchase transaction, any movement using pick tickets or adjustments, and the sale of the serialized item through accounts receivable.
This option is only available if the inventory module is purchased. The report compares selected items and ranks them according to different profitability measurements.