This article will focus primarily on understanding the Inventory tab of the Stock screen.
Note: Read more about Stock adjustments, Stock transfers, and Batch tracking.
The Inventory tab is Katana's main view for managing your business's stock levels. Stock movements in Katana are entirely automated in real-time based on purchasing, making, and selling activities (also called perpetual inventory).
The Inventory tab shows stock levels for all products and materials at a variant level. You can conveniently see the total Value of stock and Average cost per unit.
The list also displays the quantities you have In stock or Committed to Sales and Manufacturing orders, Expected from suppliers or manufacturing, and whether you have too much or too little inventory considering your Reorder points.
If you added more than one Location to your account, you can select the Location on the Stock screen to see the inventory status at different Locations.
Detailed Inventory Intel
Clicking on the In stock, Committed, or Expected quantities to bring up a more detailed Inventory Intel window that shows stock movements, related orders, and other relevant info.
If you added more than one Location, it will show the intel for the selected Location.
Note: The Unit of Measure for each product, material, and variant is set on item cards.
Inventory tab quantities
If you have more than one Location on your account, quantities are shown for the selected Location.
In stock - the amount of stock you currently have on hand (i.e. physically in your warehouse).
For products, this level increases if you complete a Manufacturing order (MO) or create a positive Stock adjustment. It decreases if you pack or deliver a Sales order (SO) or create a negative Stock Adjustment. It also decreases for a product used as a subassembly in the Product recipe when a MO is completed.
For materials, this level increases when you receive a Purchase order (PO) or create a positive Stock adjustment. It decreases for materials included in the Product recipe if you complete a MO or if you create a negative Stock adjustment.
Expected - the amount of stock that is expected to arrive in the warehouse from open Purchase or Manufacturing orders (MO).
For products, this is increased if you create a MO and the items included in the order remain expected until the MO is partially or fully completed. The Expected amount of products is always based on the Planned quantity for a product on a MO or the Remaining quantity for a product on MO if the MO is partially complete.
The In stock quantity of the product will increase only when:
The MO is partially complete - by the Completed quantity of the product
The MO is completed - by the Actual quantity of the product on the MO.
For materials, this is increased when you create a PO and the items included in the order remain Expected until the PO is Received.
Committed - the amount of stock that is committed to open Sales and Manufacturing orders. A few things you should know:
Products are committed to an open Sales order (SO) or as a subassembly to an open Manufacturing order (MO).
Materials are committed to products on both an open SO and MO based on the Product Recipes of those products.
In the case of Sales orders, materials are only committed to those products on a SO where the Sales items availability status is Not available. With this, you can see the total requirements for a material in the Stock screen based on your production schedule (i.e. Manufacturing orders) and your sales needs (i.e. Sales orders), regardless of whether production has been already scheduled or not.
If Product Sales Items are already In stock no further production is required (i.e. no materials are required). The Product Availability status Expected indicates that an open MO is already making the required product for the customer order, and no materials are committed directly to this SO to avoid double-bookings.
The Committed amount of materials is based on the Planned quantity of ingredients on a MO or the Remaining quantity in case the MO is partially complete.
The In stock quantity for the material will decrease only when:
The MO is partially complete; by the Consumed quantity of the ingredients
The MO is complete; by the Actual quantity of ingredients.
For products, the Committed amount is increased when you create a SO and the items included in the SO will remain committed until the order is Packed or Delivered. It also increases when the product is included in another product's Product Recipe (as a subassembly), and a MO is created for the other product.
For materials (or products used in other Product recipes), this is increased when you create a MO or SO and the products included in the order require the material. Materials will remain committed until the MO is complete or the SO is delivered. Click on the quantity to see all related orders and more info.
Reorder point - the level of inventory for a product or a material that indicates a need to replenish that particular item's stock. The Reorder point can be set and edited directly in the Stock screen for each product and material variant. Read more about how to set a Reorder point and how to determine the appropriate level for a Reorder Point.
Missing / Excess = In stock - Committed + Expected - Reorder Point.
Indicates whether your stock level is above or below an optimal level, based on your stock in hand, expected, committed, and a Reorder Point you have set for your items. Negative values mean you should create a MO for a product or a PO for a material. This number helps to ensure you always have enough items in your warehouse to satisfy the expected demand from customers or manufacturing. Keep in mind that too much excess inventory is not preferable as it comes at a cost (cash is tied up, need to rent additional warehouse space and pay salary for people handling the stock, etc.).
Quick-add Purchase and Manufacturing orders
To quickly create a PO for a material or a MO for a product, click on the "+" button at the end of the row for a specific item. This is a quick way to create a MO or PO for products or materials to re-establish optimal stock levels.
To enter more details or edit a newly created PO or MO, navigate to the PO or MO card in the Buy or Make screens.
If you added more than one Location to your account, the quick-add buttons are visible only for Locations where the Buy and Make functions are enabled.