Printing the Item Status Report

Use the Item Status report to print the information entered for each item in the I/C Items screen, as well as the quantities on hand at your inventory locations. If you use the Keep Item Statistics option, the report also shows shipment and receipt statistics for each item.

For more information on the contents of this report, see I/C Item Status Report.

To print the Item Status report:

  1. Open Inventory Control > I/C Stock Control Reports > Item Status.

  2. Make your selections in the following fields:

    From Account Set [ ] to [ ]. Enter a range or use the Finder to select a range of account sets for the report.

    Sort by. Specify the order in which to list item records. You can choose:

    • Item Number. Lists items in order by item numbers.
    • Category. Groups all items by the item categories specified for the report.
    • Item Segment. Lists all items that contain the specified segment in their item numbers, grouped by the specified range of segment codes.
    • Optional Field Entries. Lists all items by the contents of the selected optional field. These choices appear only if you have added optional fields to the I/C Items screen.

    From [ ] To [ ]. Specify the range of item numbers, categories, segments, or optional field entries to include in the report.

    Print. Specify the type of items to include on the report. You can choose all items, only active items, or only inactive items.

    Include. For each item included in the report, print all or a combination of the information entered in the item record (Profile, Unit of Measure, Taxes, Additional Item Information, Optional Fields, Vendors), as well as the quantities on hand at each location, total quantities on hand, item statistics (if you use the option to keep statistics) and FIFO or LIFO costing information. If you have serialized or lotted items in inventory you can choose to include them in the report as well.

  3. Click Print.

    • If you are printing to a physical printer, the Print window appears. Confirm your printer selection and the number of copies to print, and then click OK. Otherwise, click Cancel or Setup.
    • If you are printing to the screen (preview), the report appears in a new window. You can print the report or export it to a file.

      Note: For Web-based clients, the preview screen appears first when you click the Print button.

    • If you are printing to a file, the Export window appears. Specify the file format (for example, PDF, DOC, or XLS). Also, specify a destination for the file:

      • Application. View the report in an application that can open files of the specified format (for example, if you specify PDF as the file format, the report opens in Adobe Acrobat). You can then save the file.
      • Disk file. Save the report to a location you specify.
      • Microsoft Mail. Send the report as an e-mail attachment.

      You can enter the name of a non-existent file or directory to be created by the system when you print. When you print to a file, the report is assigned a unique name, for example, CS1000.TXT.

    • If you are printing to e-mail, an e-mail message appears with the report attached.