This report gives you an overview of the current age composition of selected items in your inventory. The list shows the number of units of the selected item that were added to or removed from inventory and at which point in time. Items can be added to or removed from inventory as a result of purchases, sales and positive and negative adjustments.
For each of the items that you specify when setting up the report, the printed document shows the number of units added to or removed from inventory before the specified start date, during each of three periods of equal length, and the total inventory quantity of the selected item.
You can specify what is included in the report by setting filters. If you do not set any filters, the report will include all your records. You can also determine what is shown in the report by filling in the fields on the Options tab.
On the Item tab, you can fill in the standard field filters, or you can select additional filters. To do this, press F3, click the AssistButton and then select the relevant filter(s).
To print the report, click Print. To see the report on the screen before printing it, click Preview.
To set filters in the report, fill in the fields as follows:
No.: In the Filter field, you can specify the numbers of the items that you want to include in the report.
Inventory Posting Group: In the Filter field, you can specify the inventory posting groups that you want to include in the report.
Statistics Group: In the Filter field, you can specify the statistics groups that you want to include in the report. The field can only be used if the corresponding field on the item card is filled in.
Location Filter: In the Filter field, you can specify the locations that you want to include in the report. The field can only be used if the corresponding field on the item card is filled in.
Click the up-arrow in the lower left-hand corner of the window to see the results of the filters you have defined for the table.
To see the sorting keys and determine the order in which the information will be displayed in the report, click Sort.
End Date: In this field, you can specify the end date of the report. The report calculates backwards from this date and sets up three periods of the length specified in the Period Length field. This way you can, for example, compare this month to the two previous months.
Period Length: In this field, you can specify the length of the three periods in the report.