Katana calculates ingredient availability dynamically to help manage production and inventory efficiently. This guide explains how ingredients are tracked against sales, manufacturing, and outsourced purchase orders based on priority and stock levels.
Ingredients availability shows the stock status for ingredients required to make products on an order. Ingredient requirements for products are based on the Product recipe / BOM, which can include both materials and subassemblies.
Ingredients availability status can either show In stock, Expected, Not available, or No recipe. Based on the status, you should understand which actions to take next.
Ingredients availability is automatically calculated based on stock position and priority of orders and cannot be manually adjusted.
Ingredients availability areas
Products on a sales order (in the Sell screen or on a Sales order card). This is especially relevant for businesses that are Make-to-Order as it provides immediate information about ingredient availability for making ordered products.
Products on a manufacturing order (in the Schedule tab or on a Manufacturing Order card). Provides information about the ingredient availability for making products in the production schedule.
Products on an Outsourced purchase order. Provides information about the ingredient availability at the contractor's location for making the ordered products.
The Sell, Make and Buy screens that list Sales, Manufacturing, and Outsourced purchase orders display Ingredients availability at the order level. The status will show Not available or Expected when at least one ingredient for a product on the order has a similar status. Expected is only shown if no ingredients have a Not available status for the order. Click on any order to see more detailed information.
How availability is calculated
The Ingredients availability status indicates whether ingredients are available for products on a specific sales order (SO), manufacturing order (MO) or outsourced purchase order (OPO). Ingredients availability status takes into account the order priority, which can be changed for SOs and MOs by moving the positions of orders in either the Sell screen or Schedule tab. To change the priority of the OPOs change the Expected arrival date.
If you have the required ingredients in stock, the Ingredients availability for an order may still show Not available if another higher priority order has already reserved the same ingredient. Changing the order priority can also affect the Ingredients availability statuses.
Pre-committed components may also influence the availability status of ingredients, as these components might already be allocated to higher-priority orders, resulting in potential discrepancies.
The calculation
To determine the status of an ingredient, Katana will First check whether there is enough In stock of the ingredient. If not, Katana will look for any open purchase orders containing the materials, manufacturing orders, or outsourced purchase orders for subassemblies (i.e. the ingredient is in an Expected status). If not, Ingredients availability shows Not available.
Katana's handling of kits or bundles differs from standard BOMs, as only the primary sales item benefits from auto-assembly, which may lead to calculation discrepancies if subassemblies are included as kits.
In Katana, you can report the actual quantity of products made or ingredients used in production. The Ingredients availability is calculated based on the planned quantity. Only when an order is completed are the stock movements recorded based on actual quantities. Before completion, stock calculations are done based on planned quantities.
Materials aren't permanently linked to any orders. Ingredients availability is always calculated based on the priority of order.
Read more about how order priorities affect Ingredients availability.
Note: This approach is different from the link between a SO and Make-to-Order MO (Types of manufacturing orders). Sales items availability for a SO only works in a similar way to Ingredients availability for a Make-to-Stock MO (i.e. booking products is based on priority). Read more about a typical Make-to-Stock flow.
Availability status for specific ingredients
Click on a MO to see the product's list of ingredients based on the Product recipe / BOM. Ingredients availability is displayed for each ingredient.
On a SO card, Ingredients availability displays the ingredient status for the product on the order line - it doesn't display availability at the ingredient level. If any ingredients required to make the product are Not available or Expected, you can click on the Ingredients availability status on a SO card to open a list of missing or expected ingredients.
On an OPO card you can see Ingredient availability both for the product (Purchase items tab) and on ingredient level (Track ingredients tab).
Clicking the "i icon" next to the quantity will open more detailed information about the stock status of the ingredient.
For missing ingredients, click on + Buy to create a new purchase order (PO) for the required items (or + Make for required subassemblies).
For expected ingredients, click on the related PO number in the Expected from column to navigate to the order.
Detailed Inventory Intel
Clicking the "i icon" in the missing materials list or on the Ingredients availability status for a specific ingredient on a MO or an OPO opens the Inventory Intel window, which shows additional info about the inventory level of a specific ingredient.
You can check the In stock, Expected, and Committed quantities of the ingredient and see all the orders to which the material is committed. In this window, orders are listed by priority, and the current order is highlighted in bold. The priority can be changed either in the Sell screen, Schedule tab, or by changing OPO Expected arrival date.
Ingredient availability statuses
-- "Not available" --
This means there aren't enough materials or subassemblies available in the inventory to make a required product and that you aren't expecting the materials from a supplier (i.e. you have not created a PO for the material in the required amount for this product). It also means you're not expecting subassemblies from manufacturing or a contractor (i.e. there is no MO or OPO for the subassembly in the required amount for this product).
Recommended option 1: Create a PO for material, or an MO / OPO for a subassembly. If you want to keep enough ingredients in stock to satisfy requirements in the future, we recommend adjusting the safety stock level for this ingredient.
Additionally, verify the Bill of Materials (BOM) configuration to ensure none of the components are set up as kits or bundles, which can affect Katana's auto-assembly and potential stock mechanisms.
Recommended option 2: If you need to complete this order quickly, but the order has a low priority, you can try bringing it to a higher position to give it a higher priority for booking ingredients in stock or expected from suppliers (or subassemblies expected from manufacturing or contractor).
-- "Expected" --
You'll see this status when there aren't enough ingredients available in inventory for the order, but you have an open PO for the material, an open MO or OPO for the subassembly in the required amount, and the ingredient is expected to arrive.
The date below the Expected status indicates the arrival date of a connected (O)PO for materials and sub-assemblies and the Production Deadline of a related MO for subassemblies.
Recommended option 1: No action is required, but if you want to keep enough ingredients in stock to satisfy the requirements in the future, you could adjust your Reorder Point for this ingredient.
Recommended option 2: If you need to fulfill the order quickly, but the order has a low priority, you can try giving it a higher priority for reserving ingredients in stock or expected from suppliers (or subassemblies expected from manufacturing or contractor).
-- "In stock" --
This status means you have enough materials and subassemblies available in inventory for this order.
Recommended action: No action is required, proceed with production.
-- "Processed" --
This status is used on the Sell screen. When the Sales items availability is In stock, the Ingredients are shown as Processed. This status is also used when MO or OPO is done.
-- "Not applicable" --
This Ingredients availability status only appears on a SO and OPO, not a MO.
You'll see Not applicable on a SO if:
You added more than one location to your account, selected a Ship from a location with no Make possibilities (i.e., it's a sales location, not a production site), and no OPO is providing products for that location. You can change the location functions from Settings → Locations.
You disabled the I make this product option for the product on the product card. In this case, you have chosen to purchase the product from suppliers (not make it) and the Ingredients availability status is not relevant.
You'll see Not applicable on an OPO if:
You added a material to OPO, and the Ingredients availability status is not relevant.
You added only "I buy this" product to OPO. In this case, you have chosen not to track ingredients and the Ingredients availability status is not relevant.
Further details on how ingredient availability is calculated
If you wish to understand exactly how Katana calculates Ingredients availability, here are the calculations:
Not available:
Quantity required by the product on the order > (In stock + Expected - Committed in the inventory), where Committed only includes the quantity committed to higher priority orders.Expected:
[Quantity required by the product on the order < (In stock + Expected - Committed in the inventory)] AND ["Quantity" required by the product on the order > (In stock - Committed in the inventory)], where Committed only includes the quantity committed to higher priority orders.In stock:
Quantity required by the product on the order < (In stock - Committed in the inventory), where Committed only includes the quantity committed to higher priority orders.
Note: Quantities used in availability calculations are always the planned quantities of products and ingredients on an open MO, not the actual quantities. Stock movements when completing an MO will be based on actual quantities, but stock bookings before MO completion are based on the planned quantities.
Troubleshooting Potential Stock Calculation Issues
Potential stock calculation issues in Katana can disrupt inventory management and production planning. Here's a comprehensive look at common causes of miscalculations and how to address them effectively.
Common Causes of Potential Stock Miscalculations
1. Insufficient Stock of Components
A product's potential stock depends on the availability of all individual components listed in its Bill of Materials (BOM):
If one or more components aren't available, potential stock may not calculate correctly.
2. Pre-Committed Components
Components listed in a BOM might already be allocated to existing sales or production orders, causing discrepancies in potential stock calculations.
3. Configuration as Kits/Bundles
When a BOM ingredient is set up as a kit or bundle instead of individual components, it poses limitations. Katana's auto-assembly and potential stock mechanisms function only for the primary sales item, not its subassemblies. This misconfiguration can result in incorrect calculations.
How to Correct Potential Stock Calculation Issues
To ensure accurate potential stock calculations, follow these steps:
1. Verify Stock Availability
Check that all components necessary for the item's BOM have sufficient quantities available.
Confirm that no components have been pre-committed to other orders.
2. Adjust Sales Order Priority
In the SELL > Open list, drag and drop affected sales orders to the top. This prioritization ensures that stock is allocated accurately to the most critical orders.
3. Review BOM Configuration
If any component is configured as a kit or bundle, consider splitting it into individual items to ensure proper handling by Katana's auto-assembly mechanism.
Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]