Printing the Inventory Reconciliation Report

The Inventory Reconciliation report lets you compare actual physical inventory totals with the totals in your Sage 300 Inventory Control system. The report identifies discrepancies between item quantities and costs, and shows what will be posted by the Post Inventory Reconciliation screen.

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

Run Day End Processing if you want to include the latest costing information in the report.

To print the Inventory Reconciliation report:

  1. Open Inventory Control > I/C Physical Inventory > Inventory Reconciliation.

  2. Make your selections in the following fields:

    From Location [ ] To [ ]. Specify the range of locations to include in the report.

    Show Only Items with Quantity Variance. Select this option to list only those items that show a variation between the quantity on hand recorded in Inventory Control and the physical count you entered in the Physical Inventory Quantities screen. The report then excludes items for which the totals are the same in Inventory Control as in your physical count.

    Show Only Items with Serial/Lot Quantity Variance. Select this option to show only those items that have a variance between the quantity counted and the serial/lot numbers assigned. The report will exclude items for which the quantity counted equals the numbers assigned.

    Include Comment for Each Item. Select this option to print a blank comment line for each item listed in the report.

    Include Inactive Items. Select this option to include inactive items. This option is selected by default. If you have many inactive items, you can reduce the length of the worksheet by not selecting this option.

    Include [ ]. Select from two types of report.

    • All Units of Measure. The report lists quantities counted for each unit of measure.
    • Stocking Unit Only. The report lists total quantities counted in the stocking unit of measure only.

  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.