Aged Inventory Report � Printing

Sage ERP Accpac Inventory Control 6.0

Printing the Aged Inventory Report

The report prints the net changes in item quantities and costs for a set of four aging periods specified by the user at print time.

Depending on the options chosen at print time, the report can be printed in a detailed or summary version. The detailed version prints all individual transactions affecting item quantities and costs. The summary version prints only the totals of the net changes for each period.

For information on the contents of this report, see Aged Inventory Report � Features.

To print the report

  1. Choose the Aged Inventory Report icon from the Stock Control Reports folder.

  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 form appear here, but you can assign different periods for the report, if you wish.

  1. Click Print.

    If printing to a printer, Accounts Receivable displays the print destination form to let you confirm your printer selection and change the number of copies to print. Choose OK if the settings are correct; otherwise, choose Cancel or Setup.

    If printing to a file, Inventory Control displays the name of the file, so you can change it or cancel printing.

    If printing to the screen (preview), Inventory Control displays the report. If you want, you can then export it to a file or send it to the printer.

    If printing to e-mail, Inventory Control displays an e-mail message form for you to fill in, and inserts the report as an attachment when you choose Send.

See also