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
-
Open Inventory Control > I/C Stock Control Reports > Aged Inventory.
- 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.
- 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.
- 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).
- 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).
- 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.
- 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.
- 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.
- 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.
- Click Print.
The report appears in a new window. You can print the report or export it to a file.