How to Print the Inventory Reconciliation Report on Sage 300 Inventory Control


  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.
    • 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
    • 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.


If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.