You use the Inventory - Availability Plan report to display a list of the quantity of each item in customer, purchase and transfer orders and the quantity available in inventory. The list is divided into columns that cover six periods with starting and ending dates as well as the periods before and after those periods. The report is useful when you are planning your inventory purchases.
Several fields have already been entered in the Field field on the Item tab. If you want to include more information, you can select additional fields to be included in the report. To do this, in the Field field, press F3, click the AssistButton, and then select the relevant field(s). You can set filters on any of the fields entered in the Field field. If you do not set any filters, the report will include all the records related to the Field fields. In the fields on the Options tab, you define the six periods you want to look at, and whether the report should show data by stockkeeping unit.
To print the report, click the Print button. To see the report on screen, click Preview. If you want to save your report and print it later, click Cancel, and the program automatically saves the report.
You can fill in the fields already entered on the tabs as follows:
No.: Here you specify the numbers of the items to be included in the report. To see the item numbers, click the Filter field and then click the AssistButton that appears to the right.
Location Filter: Here you can set a filter on the locations to be included in the report.
Search Description: Here you can set a filter on the Search Description field.
Bill of Materials: If the items you have specified to be included in the report are BOMs, you must insert a check mark in this field.
Inventory Posting Group: Here you can specify the inventory posting groups to be included in the report. To see the existing inventory posting groups, click the Filter field and then click the AssistButton that appears to the right.
Vendor No.: Here you can specify the numbers of the vendors to be included in the report. To see the existing vendors, click the Filter field and then click the AssistButton that appears to the right.
Click the up-arrow at the lower left-hand corner of the window to see the result of the filters you have defined for the report.
To see the sorting keys and determine the order in which the information will be displayed in the report, click Sort....
Starting Date: Enter a date to specify the beginning of the first specified period to be calculated by the report.
Period Length: Enter a code to indicate how long each period will be, for example, 1M = 1 month, 1Q = 1 quarter, and so on.
Use Stockkeeping Unit: Enter a checkmark if you want the report to display the availability plan by stockkeeping unit.
To see the table with the results of the filters you have set for the report, click the up-arrow in the lower left-hand corner of the window.
To sort your records in descending or ascending order (for example, numerically or alphabetically) on one of the fields in your report, click Sort. In the Sort window, under Key, select the relevant field and under Order select Ascending or Descending and then click OK.