The 
Item
Expiration - Quantity report is an overview of the
quantities of selected items in your inventory whose expiration
dates fall within a certain period. The list shows the number of
units of the selected item that will expire in a given time period.
For each of the items that you specify when setting up the report,
the printed document shows the number of units that will expire
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. The quantities in the report reflect only the quantities of the item for which expiration dates have been defined.
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.
Ending 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.