Handling Order Cancellations Without Losing Cost and Inventory Control

Nov 27 2023

Winning an order is only the start. Once you release the job, schedule production, buy material, and start booking labor, a cancellation can create real downstream work across production, inventory, purchasing, and accounting.

Cancellations also show up as internal problems, like a late quality issue, wrong revision, or a failure at final inspection. In Cetec ERP, the best path depends on where the job is in the process and whether you can recover material, capture cost cleanly, and remove demand from open purchase orders.

Start With the Decision: Salvage as Finished Goods or Shut It Down

Before you click anything, decide which outcome you need. If the build is far enough along that you should finish it and carry it as stock, treat it like a production completion problem. If the job needs to be deleted or closed without producing a finished good, treat it like an inventory disposition and cleanup problem. That decision drives the rest of the steps.

Convert a Customer Build Order to an Internal Order When the Build Is Recoverable

If the order is canceled but the job is already mostly built and past the point of practical disassembly, converting the order to an internal build-to-stock order is usually the cleanest option. This keeps the labor and raw material consumption tied to a completed production outcome, instead of leaving WIP in an unfinished state.

From there, complete production and receive the finished item into inventory. That closes the loop operationally: material is backflushed or consumed as expected, labor posts, and you now have a finished good you can scrap, rework later, or hold in stock for a future shipment. For a walkthrough of the conversion workflow, reference: https://cetecerp.com/support/how-to/how-to-convert-a-build-order-to-an-internal-order.html

converttointernal.jpg

Close or Delete an Order Based on Whether Material Is Picked

If you do not want to finish the job into finished goods, the next question is whether material has been picked. This is the point where cancellations can quietly turn into inventory errors if the workflow is rushed.

  • If no parts are picked, you can close the order.
  • If parts are picked, decide whether they can go back to stock or need to be scrapped.
  • If parts are picked and are going back to stock, dekit the order before closing so inventory is returned correctly.
  • If parts are picked and you are scrapping them, close the order using the cancellation flow that records the scrap through an inventory adjustment code.
scrapline.jpg

Clean Up Open Purchase Orders With Reverse MRP

After the order is closed or converted, the last step is handling any purchase orders that were created to support the demand. A practical way to stay on top of this is for purchasing to routinely run what we call Reverse MRP to find PO lines that no longer have an order driving their need date.

In Cetec ERP, run the Purchase Orders report with the “View by” filter set to “PO Line”. Then open “More Options” and use the “Days Early” filter. Choose the “(No Need Date)” option to list PO lines without any orders driving demand. This gives your team a clear list to cancel, reschedule, or repurpose. For more detail, see: https://cetecerp.com/blog/reverse-mrp.html

Key Takeaways

  • If the build is recoverable, convert the customer build order to an internal order and finish production into stock.
  • If you are canceling without finishing the build, base the workflow on whether material is picked and whether it returns to stock or must be scrapped.
  • Deking before closing is the clean path when picked parts are returning to inventory.
  • When scrapping picked parts, use the cancellation flow that records scrap via an inventory adjustment code.
  • Use Reverse MRP to find PO lines that no longer have demand after the cancellation.

Conclusion

Order cancellations are common, but the follow-through determines whether inventory, WIP, and purchasing stay accurate. When your team chooses the right path, convert to internal stock when appropriate, dekit or scrap picked material intentionally, and clear orphaned PO demand, you can close a canceled job in Cetec ERP without leaving accounting and inventory cleanup for later.