How-toKatana Cloud InventoryManufacturing Orders / Inventory

Katana Manufacturing Order Ingredients Not Available: How to Resolve

Question
Katana manufacturing order ingredients not available

Also searched as

  • Katana ingredient shortage manufacturing order
  • Katana can't start manufacturing order not enough stock
  • Katana ingredients expected not in stock
  • Katana make to order shortage purchase order

Short answer

A Katana manufacturing order flags an ingredient as not available when free stock at the order's location is less than the recipe quantity and no incoming purchase or manufacturing order covers the gap. Resolve it by checking the ingredient's stock by location, creating or expediting a purchase order, fixing a wrong location or recipe, or correcting stock with an adjustment or stocktake.

Applies to: Katana Cloud Inventory manufacturing orders and make-to-order or make-to-stock workflows. Exact status labels may differ slightly between app versions.

How to clear an ingredient shortage

  1. 1Open the manufacturing order and read the ingredient rows. Note which are in stock, expected (covered by an incoming order) and not available.
  2. 2Open the short ingredient and check stock by location. A common cause is that stock exists, but in another location than the order's production location.
  3. 3Check what is already committed. Stock allocated to other manufacturing orders or sales orders is not free for this one.
  4. 4If the item is genuinely short, create a purchase order from the sales or manufacturing order shortage view, or from the item, and set a realistic expected arrival date.
  5. 5If the item is made in-house, make sure it has its own recipe and create a manufacturing order for the sub-assembly.
  6. 6If the physical stock exists but the system says zero, fix it with a stock adjustment or a stocktake, and find out why receipts were not recorded.
  7. 7Check the recipe quantity and unit of measure. A recipe in the wrong unit can make the demand look far larger than reality.
  8. 8Re-open the order and confirm the status moved to in stock or expected before scheduling production.

How Katana decides availability

Katana compares the recipe demand of each manufacturing order with free inventory at the production location, then looks at open supply: purchase orders with expected dates and other manufacturing orders that will produce the item. Stock that covers the need is shown as in stock, supply that is coming is shown as expected, and anything left over is not available.

Because allocation follows order priority and dates, adding a new urgent order can quietly flip an older order from in stock to short. That surprises planners who assume the stock was reserved forever. Treat the status as a live calculation, not a promise.

The usual root causes

Wrong location is the top cause: raw material received into a general warehouse while the order produces at a workshop location. A transfer or a corrected receipt location fixes it in minutes. Second is unrecorded receipts: goods arrived but the purchase order was never marked received, so the system believes the shelf is empty.

Third is recipe error: an extra ingredient left on a recipe after a design change, a wrong quantity per unit, or a batch recipe built for ten units used as if it were for one. Fourth is real shortage with no purchase order, which is the system working as designed and telling you to buy.

Choosing between purchase, make and adjust

Buy when the item is a purchased part and lead time fits the order date. Set the supplier lead time on the item so future shortages show a sensible expected date instead of nothing. Make when the item has a recipe and you have capacity and materials for the sub-assembly.

Adjust only when you have evidence the physical count differs, for example after counting the bin. Adjusting stock to make a warning disappear hides the real process gap and will return as a negative or missing-cost problem later.

Preventing repeat shortages

Set reorder points and minimums for the parts that stop production most often, use the shortage views regularly rather than only when an order is stuck, and keep supplier lead times honest. Receive purchase orders the day goods arrive, in the correct location, so availability reflects reality.

For make-to-order businesses, confirm sales orders only after checking the promised date against component availability, not just finished goods. The shortage view on a sales order exists for exactly this decision.

Common pitfalls

  • !Looking at total stock instead of stock at the manufacturing order's location.
  • !Ignoring stock committed to other orders and then wondering why free stock is lower than on hand.
  • !Adjusting stock to clear a warning instead of fixing the missing receipt.
  • !Leaving purchase orders without expected dates, so the order shows no coverage at all.
  • !Using a recipe unit that differs from the stock unit of measure.
  • !Not creating a manufacturing order for sub-assemblies, so the parent order can never become available.

How an ERP-grounded AI assistant handles this

An ERPray-style assistant on a small ERP can answer which manufacturing orders are blocked, which ingredient is short, where stock for it actually sits, and which open purchase orders cover it, in one question, and it shows the query it ran. It reads by default and any purchase order or adjustment it suggests stays pending human approval. For a handful of orders, Katana's own shortage views are usually enough.

Frequently asked questions

What is the difference between expected and not available in Katana?

Expected means there is no free stock now, but an incoming purchase order or manufacturing order is scheduled to cover the need. Not available means neither free stock nor scheduled supply covers it, so you need to buy, make or correct stock.

Why does an ingredient show short when I can see it on the shelf?

Usually the receipt was not recorded, the stock sits in a different location than the order's production location, or it is committed to another order. Check stock by location and the committed quantity before adjusting anything.

Can I start a Katana manufacturing order with a shortage?

Katana lets you plan around shortages, but you cannot consume material that does not exist in stock without creating a negative or an adjustment. Resolve the shortage first so costs and stock stay accurate.

Does the order of manufacturing orders change what is available?

Yes. Availability is allocated against demand by priority and date, so a new urgent order can take stock from an older one. Review shortages after adding or rescheduling orders rather than assuming earlier status still holds.

Related

Error fix

Fix Katana API 429 Too Many Requests

HTTP 429 from the Katana public API means your integration exceeded the per-key request allowance for the current time window. Fix it by honoring the retry headers, backing off with jitter, paging with the largest allowed page size, caching reference data such as products and variants, and replacing polling loops with scheduled incremental syncs.

How-to

MRPeasy Materials Shortage: Plan Purchases Correctly

MRPeasy compares the demand from customer orders and manufacturing orders with available stock, booked stock and open purchase orders, and flags what is short. To act on it, review the shortages, confirm item lead times and minimum stock levels, then create purchase or manufacturing orders and re-check planned dates.

How-to

Fishbowl SQL Query for Inventory by Location

Fishbowl stores physical inventory as rows in the tag table, one per part per location per tracking combination. Join tag to part and location, group by part and location, and sum quantity to get on hand by location. Run it read-only through Fishbowl's reporting module or a read-only MySQL user, and verify column names against your version.

How-to

How to Create a Generic Inquiry in Acumatica

Generic Inquiries (GI) are Acumatica's no-code query builder for joining tables, adding filters, and exposing the result as an inquiry screen, dashboard data source, or API endpoint. Open System > Customization > Generic Inquiry, add your base table, define joins and conditions, then run and save. No SQL or customization project is required.

Error fix

Fix Odoo AccessError: You Are Not Allowed to Access Records

Odoo raises AccessError when a user's security groups do not grant a CRUD right on a model through ir.model.access.csv, or when an ir.rule record rule filters the specific record out for that user or company. Fix it by adding the user to the group named in the error, editing the model's access rights, or reviewing the record rule's domain under Settings > Technical > Security.

How-to

How to Void a Check in Sage 100

Sage 100 voids checks through Accounts Payable > Main > Check and Payment Voiding. Select the bank code, choose the check number, and Sage reverses the Cash Disbursements Journal entry and reopens the invoice it paid. A check that already cleared in Bank Reconciliation or falls in a closed period needs an extra step before it can be voided cleanly.

AI for ERP

AI Demand Forecasting for Manufacturers: Better Numbers and an Explanation Planners Can Trust

AI demand forecasting explains ERP forecast changes in plain language, flags exceptions for planners, and handles short-history SKUs without Excel overrides.

AI for ERP

AI for quote-to-cash in manufacturing and job shop ERPs

AI reads incoming RFQs, drafts quotes from your ERP's own cost and pricing history, and flags parts your shop has never quoted before, keeping the estimator in control.

Stuck on Katana Cloud Inventory?

Talk to engineers who work inside Katana Cloud Inventory every week, and who build private AI that answers these questions from your own ERP data.