This article will focus mostly on understanding the Inventory tab of the Stock screen.
The Inventory tab is the main view in Katana for managing the stock levels of your business. Stock movements in Katana are completely automated in real-time based on purchasing, making, and selling activities (also called perpetual inventory).
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.
For products, this is increased if you create a MO and the items included in the order remain expected until the MO is completed. The Expected amount of products is always based on the Planned quantity for a product on a MO. Only if the MO is completed, will the Actual quantity of the product on the MO be added to stock.
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 there is already an open MO 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. Only when the MO is complete will the In stock quantity for the material decrease 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 the Product Recipe (as a subassembly) of another product 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 Sales Order 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 for each product and material variant directly in the Stock screen. 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.