Skip to main content
C
Cetal
July 8, 2021
Question

Shortage Report does not calculate properly

  • July 8, 2021
  • 1 reply
  • 0 views

For a simple example let's say I'm trying to do an assembly build for one sandwich containing these items:

Bread x 2 (sub assembly - flour, water, salt, yeast)

Ham x 1 (inventory item)

Lettuce x 1 (inventory item)

 

The bread was already put in stock with an assembly build. So I have the bread and lettuce in stock, but I'm missing ham. If I run the shortage report on the asssembly build, it would spit out something like this: 

 

Needed:

Ham x 1

Flour x 2

Water x 2

 

The problem is that I don't need flour and water if I have the bread in stock. The shortage report doesn't consider the sub assemblies in stock, it just looks at the inventory items as a whole. Is this a bug? We have assemblies with 20 or more sub assemblies, so it makes it very difficult to find what I actually need to order. Thanks

    1 reply

    Rustler
    Rustler
    July 8, 2021

    In QB a sub assembly it an item all by itself
    so if the assembly BOM shows a sub assembly - it is required

     

    If you make your own bread, then do that with an assembly, that stocks the item bread.  Since you make bread by the loaf and then slice it - the loaf needs to be moved to a separate item as sliced bread

    C
    CetalAuthor
    July 8, 2021

    Yes the (hypothetical) bread is a sub assembly, and it is stocked when we do an assembly build. The bread doesn't show up on the shortage report, but it's children (flour, water) do show up. But they shouldn't be on there if we have bread already built. In short, we don't need flour to make a sandwich if we already have the bread in stock.

      Adrian_A
      Adrian_A
      July 8, 2021

      I appreciate you for getting back to us, Cetal.

       

      As Rustler shared above, you'll have to create a separate assembly for the bread. Here's how you can do that:

       

      1. From the Lists menu, select Item List.
      2. Select New in the Item drop-down.
      3. Select Inventory Assembly.
      4. Enter an Item Name/Number.
      5. Enter the ITEM.
      6. Click OK.

       

      You can also check this article to keep track on what you sell: Keep track of each sale in two ways.

       

      Please let me know if you have any additional questions or concerns in the comment section below. I'm always here to help you.

      Terms & ConditionsAccessibility statement