BM-D  Print BOM Availability

Purpose of Program

This program lists up to date information on how much inventory is available for each of the components within a bill of material.  This is useful for expediting orders, for it allows a quick survey of all materials required to produce a particular assembly.

You can run the report for a single level in the bill of material or for multiple levels (which will show you the status of the entire product structure).

The report includes the parent item number, description, type, and quantity on hand at the selected location.  It then calculates the quantity to be pulled from stock and the quantity to assemble, based on the quantity you requested.

For each component it lists the item number, quantity needed, quantity on hand, the combined quantity on sales order and backorder, the quantity allocated (required) for existing work orders, and the quantity on work order or purchase order.

If there is not enough of a component part on hand to build the quantity requested, an asterisk (*) is printed to highlight the shortage.

At the end of the report is a calculation of the maximum number of units which can be built based on current inventory availability at the selected location.

General Program Operation

When running this program you are first asked for the parent item number to be included.  You can type in the item numbers or select item numbers from a pop-up window by pressing the F2 key (or clicking on the Lookup button).

Next you can indicate whether you want to view multiple levels or a single level structure.

Then enter the inventory Location.  If you are using multiple inventory Locations, use the F2 key (or click on the Lookup button) to display the available Locations in a pop-up window and make a selection.

Quantity to Project is used in conjunction with the "print shortages only?" option.  For example, if you want to quickly find out if you have enough inventory to build 10 units of a particular item, then enter 10 in the quantity to project field.  If you want the report to list only those components which do not have enough inventory, enter Y at the Print shortages only? field.