Processing

Clicking on a Process button will generate the following report:

The columns in the grid are:

•      ID: The item ID for the selected assemblies.

•      Purch Desc: The purchasing description for the item.

•      On Hand: The quantity on hand.

•      On PO: The quantity on purchase orders.

•      On Sales Order: The quantity on open sales orders.

•      On Pend Build: The quantity of this assembly on pending build transactions (as a subassembly or component).

•      Can Build: The quantity of this assembly that you can build with the current inventory status, ASSUMING that only this assembly would be built.

•      To Build: The quantity of this assembly to be built with existing pending build transactions (as the assembly to be built).

•      Net Avail: A calculated column, “On Hand” – “On Sales Order” – “On Pend Build” + “On PO” + “To Build” + “Required”. Essentially this is the quantity you would have as “available” if all of your supply and demand transactions were to complete. Add the supply (quantity on hand, items to be built on pending builds, items you are purchasing, items you say you want to build now) and subtract the demand (items on sales orders, items to be used in pending builds). Note that this is not a hard figure, and it does NOT include any “time phasing”. It assumes all sales orders will be invoiced and all PO’s will be received, immediately. Note also that this does not include supply/demand from subassemblies in multiple level BOM’s – it can only look (as QuickBooks does) at a single level of the BOM for this item.

•      Required: This is the quantity that you would LIKE to build. It is the only column you can edit. Enter the quantity that you want to build. Note that the “Net Available” column adjusts to include this figure.

You could, for example, review the “Net Avail” column to find any items with a negative quantity. Enter that quantity as a positive number in the “Required” column to represent the quantity of the items you want to build to fulfill current demand.

There are three buttons available:

1.  Clear: This will clear any values from the Required column, if you wish to start over.

2.  Requirements: This will generate a report that will show you how many component items you will require to build your “required” list. We recommend that you always run this before doing a “build” to be sure that you have enough items on hand.

3.  Build: This will build the items in your “required” list.

You should always run the Requirements reports prior to building. This will generate reports that will show you how many component items that you will need to build the list of “required” items.

If you find that you have enough to build all of the required assemblies you can return to this screen and click the “build” button to build the items.

•      The Explosion Level option will select if you want to use a single level explosion (subassembly items are treated as components, just as QuickBooks does for a “build”) or a multiple level explosion (where subassembly items will in turn have a “build” issued).

•      If you select a “full level” explosion then you can check the Use SubAssembly Balances box. If it is not checked then the program will not use available balances of subassembly items.

•      Allow Pending Builds – if this is not checked then the program will not issue “pending” builds if you have a shortage of items for an assembly. If it is checked, then if you have a shortage the program will generate a pending build.

Note that the program will always use the current date for the build, and the current date when determining what the quantities are in the grid.

The Requirements reports are identical to what you will see with the Order option, and are described earlier in this chapter.

If you do not check Allow Pending Builds and you have a shortage for one of the assemblies to be built, the program will warn you that some builds did not complete and will list those that failed.

Any builds that are successful will be listed.