How to print the Aged Inventory report on Sage 300 Inventory Control


  1. Open Inventory Control > I/C Stock Control Reports > Aged Inventory.
  2. Make your selections in the following fields:
    • Age Transactions As Of. Specify the date on which to report the inventory. The program uses this date to assign transactions to aging periods. For example, if you print the report by due date, the program assigns each transaction to an aging period by calculating the number of days between its due date and the Age As Of date.
    • Cutoff By. The report includes only those transactions that have a document date or a fiscal period before or on the cutoff date you specify. There are two methods for selecting a cutoff date.
      • Document Date. Use this method if you want to include all transactions up to a specific date that is not the fiscal period end date. Enter a date in the Cutoff Date field. If you enter zeros for the month, day, and year, the report includes all transactions, regardless of date.
      • Year/Period. Use this method if you want to include all transactions up to the end of a fiscal period. Make your selections in the Year and Period fields.
    • Print Separate or Consolidated Locations. If you select Separate Locations, the report prints each location on a new page. If you select Consolidated Locations, the report prints a single total for each item for all locations (within the range you specify).
    • Print Transactions In. Indicate whether to print a Summary or detailed report (one that prints only one line per item, or one that includes all transactions).
    • Start Date. Specify the date of the oldest transactions that you want to have printed on a detail report.
    • Include. Specify whether you want all net totals to be printed, or print only positive, negative, zero, or non-zero net changes in costs and in quantities.
    • From/To. Indicate the ranges of account sets, locations, and item numbers that you want to include in the report. You can also select a range of values for the field that you use to sort the report.
    • Sort By. You can choose to sort the report by item category, item segment, or by optional field value. You can also choose a range of values for the sort field.
    • Use Aging Periods. The aging periods entered in the I/C Options screen appear here, but you can assign different periods for the report, if you wish.
  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.


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