Printing the I/C Aged Inventory Report

The I/C Aged Inventory report prints the net changes in item quantities and costs for each of four aging periods.

The report can be printed in either a:

• Detailed version, which prints all individual transactions affecting item quantities and costs.
• Summary version, which prints only the totals of the net changes for each aging period.

Note: The cost of the items received in the inventory is the actual cost of the item. The calculation of the cost of the items shipped from inventory depends on the costing methods used.

To print the I/C Aged Inventory report

1. Open Inventory Control > I/C Stock Control Reports > Aged Inventory.

2. In the I/C Aged Inventory Report screen for Age Transactions As Of, specify the date on which to report the inventory. Initially this is the current date, but you can change it.
3. The report includes only those transactions that have a document date or a fiscal period before or on the cutoff date you specify. Specify the cutoff date or period:
   • To include all transactions up to a specific date, select Document Date for Cutoff By, and then enter a date for Cutoff Date. If you enter zeros for the month, day, and year, the report includes all transactions, regardless of date.
   • To include all transactions up to the end of a fiscal period, select Year/Period for Cutoff By, and then enter the Cutoff Year/Period.
4. Select whether to print separate or consolidated location information. 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).
5. For Print Transactions in , select whether to print a summary (prints only one line per item) or detailed report (includes all transactions). If you select Detail, also enter the Start Date (the date of the oldest transactions that you want to have printed on a detail report).
6. Include Quantities and Include Costs, select which types of quantities and costs to include: all net totals—or only positive, negative, zero, or non-zero net changes in costs and in quantities.
7. If you only want to include a range of account sets, locations, or item numbers, enter the range in the From and To columns in the table.
8. If you want to sort the report by item category, item segment, or an optional field value, select the sort order for Sort By. If you also want to limit the report to a range of values for the sort field, enter the range for From and To.
9. The screen shows the aging periods from the Documents tab of the I/C Options screen, but you can change these aging periods for this report if you want.
10. Click Print.

    The report appears in a new window. You can print the report or export it to a file.

Last published: 4/8/2016