Order Fulfillment Worksheet handles make to order assembly items by exploding the bill of materials behind the assembly and checking availability for each required component, rather than looking at the finished item’s own inventory, since a make to order finished good typically has no stock of its own until it is assembled.
Why Component Availability Is the Right Approach
For a make to assembly order item, stock of the finished good generally does not exist until the assembly is actually executed, since it is built to order rather than kept on the shelf as a completed item. Because of this, evaluating whether that finished good can ship requires looking at whether the individual components that make it up are available, rather than checking finished good inventory that does not meaningfully exist yet. The worksheet performs exactly this evaluation, exploding the bill of materials for the assembly and checking availability for each component against current inventory.
Determining Partial Availability
If a sales line requests a quantity of an assembled item and there are only enough components on hand to assemble a portion of that quantity, the worksheet will reflect that partial availability accordingly. For example, if three units of an assembled item are requested but only enough components exist to assemble two, the worksheet shows an availability of two for that line, giving an accurate picture of what can genuinely be supplied given current component stock, rather than simply showing the line as fully available or fully unavailable.
This Applies Specifically to Make to Order Items
This component level evaluation applies specifically to items configured as make to order assembly items. For items handled as make to stock, meaning finished good inventory is kept on hand and assembled ahead of demand rather than triggered by the sales order itself, the worksheet treats availability the same as it would for any other standard inventory item, checking the finished good’s own on hand quantity rather than exploding a bill of materials.
Why This Distinction Matters for Manufacturers and Assemblers
Businesses that sell a mix of make to stock and make to order assembled items benefit from the worksheet automatically applying the correct evaluation method for each, without requiring manual intervention to check component availability separately for the make to order items. This keeps the fulfillment view consistent across an order that might include both standard stock items and make to order assemblies on different lines.
Related Tools
Order Fulfillment Worksheet automatically explodes bills of materials for make to order assembly items on sales lines and evaluates component availability to determine fulfillable quantity, alongside its standard handling of make to stock items.
In summary, the worksheet checks component availability through the bill of materials for make to order assembly items, giving an accurate picture of how much of the finished good can actually be supplied based on what is available to assemble.