Inventory Availability Report

This report displays a list of the individual items' inventory and much other information about them: quantity on sales order, quantity on purchase order, back orders from vendors, minimum inventory, and whether there is a reorder. The report can be used, for example, as the basis for deciding when to purchase items.

You can define what is included in the report by setting filters. You can set additional fields on the tab by clicking the Field field, then clicking the AssistButton that appears to the right. Fill in the fields as follows:

Item

No.: Here you can specify the numbers of the items to be included in the report. To see the existing item numbers, click the Filter field, 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: Enter Yes if the items that will be included in the report are BOMs.

Inventory Posting Group: Here you can specify the posting groups to be included in the report. To see the existing posting groups, click the Filter field, then click the AssistButton that appears to the right.

Statistics Group: Here you can specify the statistics groups to be included in the report. The field can be used only if the corresponding field on the item card is filled in.

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, then click the AssistButton that appears to the right.

Options

Use Stockkeeping Unit: Here you can enter a checkmark if you want the report to list the availability of item, by stockkeeping unit.

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 table.

To see the sorting keys and determine the order in which the information will be displayed in the report, click Sort....

Click the Print button to print out the report. If you want to see the report on the screen before printing, click the Preview button. If you do not want to print the report now, click Cancel to close the window.



© 2009 Microsoft Corporation. All rights reserved.