BimpBlog

Reserving Materials for a Customer Order: Keep the Board From Another Product

How reserving materials for a customer order works: two orders for one board with a stock / reserve / free table, the steps in Bimp and the limits of a reserve.

DO
Dmytro ObukhovCo-Founder & CEO
Table of contents
In short
  • Reserving materials assigns raw materials to a specific order: they cannot be written off, moved or used for another product by accident. A reserve reduces the free balance and leaves the warehouse stock unchanged.
  • In the example the warehouse holds 60 m² of board and two orders need 81 m². The reserve for the first order takes 45 m² and leaves 15 m² free for the second, the 21 m² shortage is visible at once, and the purchase can be ordered before cutting starts.
  • In Bimp, materials are reserved with the Stock reservation (materials) document from a customer order, or with the "Reserve" column in the production order. A reserve is possible only within the available balance.
  • Bimp does not rank order priorities by itself: the reserve goes to whoever placed it first, and redistribution is done by a person.

Reserving materials for a customer order assigns the raw materials and components that are already in the warehouse to a specific production order. A reserved material leaves the free balance: it will not be shipped to another customer, moved or used for another product, and if there is not enough material, the shortage is visible before the shop starts.

Two managers sell products made from the same board on the same day. Each looks at the warehouse and sees 60 m². Both promise their customers a deadline. On Thursday the shop cuts the board for the first order, and on Friday it turns out that 15 m² is left for the second. The rest of the article works through this case with arithmetic and a stock / reserve / free table. The company is hypothetical.

Why reserve materials for a customer order?

A reserve is needed when there is one material and several orders for it. Without a reserve, the warehouse balance shows the same number to every manager, and each treats it as theirs. With a reserve the number is split: how much there is, how much is already assigned to orders and how much is free.

A reserve gives three things. It protects the material from an accidental write-off or a sale to another customer. It shows the shortage separately for each order. And it gives the buyer a date by which the material must be purchased.

In practice this action goes by different names: raw material reserve, booking materials, setting the board aside. The meaning is the same, but Bimp distinguishes the terms, as explained below.

What happens when two orders claim the same board?

A hypothetical manufacturer makes office pedestal units from 16 mm chipboard. One unit needs 1.8 m² of board. The warehouse holds 60 m². Two orders arrive.

OrderCustomerUnits, pcsBoard for the order, m²
Adealer2525 × 1.8 = 45
Boffice center2020 × 1.8 = 36
Total4581

The need is 81 m² against a stock of 60 m²: 81 - 60 = 21 m² is missing. The only question is which order the shortage falls on. Without a reserve, the answer is set by the order in which the shop takes the board. If the foreman started with B, B takes 36 m² and A gets 24 m² of the 45 it needs. With a reserve the answer is known in advance.

Below is how the stock, the reserve and the free quantity of board change step by step.

StepEventStock, m²Reserve, m²Free, m²
1Starting state60060
2Reserve for order A (45 m²)604515
3Reserve for order B within the free quantity (15 m²)60600
4Receipt of 21 m² of purchased board816021
5Reserve for order B for another 21 m²81810

Checking the steps. Free equals stock minus reserve: 60 - 45 = 15, then 60 - 60 = 0, then 81 - 60 = 21, then 81 - 81 = 0. The reserve for B is 15 + 21 = 36 m², which matches the need of 36 m², and together with 45 m² for A it makes 81 m².

The result of step 3 matters most: order B knows its shortage of 36 - 15 = 21 m² at the moment it is entered. The buyer does not wait for the shop to stop, and manager B quotes the customer a deadline that includes the board delivery.

How do you reserve materials in Bimp?

There are two ways. The first is from a customer order. In the order, on the “Goods, services” tab, the product has a specification. In the header open the “Create based on” menu and choose “Stock reservation (materials)”. Bimp calculates the materials by the specification for the quantity of products in the order, you check the composition, quantity and batches, and save the document. For batch-tracked materials there is a “Fill by batches” button. The steps are described in the help article Reserving materials.

The second way is from the production order. On the “Materials” tab fill in the “Reserve” column by hand. If you turn on the “Product reservation (Production order)” switch in the accounting settings, the reserve is placed automatically. Creating the order itself is covered in the article about the production order.

In the example, manager A opens the dealer’s customer order, creates “Stock reservation (materials)”, sees 45 m² of board, which matches the need, and saves the document. Manager B does the same for the office center and sees that only 15 m² is free. The document shows the available quantity and the shortage, so the decision to purchase or use an analogue is made at this moment.

How do you check how much material is free?

Open the Stock with Reserve report in the “Reports” section. For each warehouse and product it shows two columns: “Stock” and “Reserve”. The free quantity is the difference: there is no separate “Free” column. For the board after step 3 it is 60 - 60 = 0 m².

If a reserve looks larger than you expect, turn on the “Show as last level: Documents” switch. Under the board row the documents that created the reserve appear, and you can see which order it is assigned to. The report shows the state for the selected date, by default the current one.

One rule to know: Bimp checks availability on the document date. If on that date the board has not been received yet, or is already reserved for another order, the reserve will not be created. So the receipt of the 21 m² in the example must be posted before you reserve it for B.

What do you do when there is not enough material for all orders?

There are four ways, and they can be combined.

  1. Purchase the shortage. In the example it is 21 m², and the delivery time sets the start date for B.
  2. Replace the material with an analogue. If the specification lists an analogue of the board, the “Replace with analogues” action in the production order substitutes it. For a reserve by batches the system warns that the reserve must be released or new batches chosen.
  3. Split order B into two batches. From 15 m² of free board you get 15 / 1.8 = 8 units (8 × 1.8 = 14.4 m²), and the other 12 units start after the board arrives.
  4. Redistribute the reserve. If B is more urgent than A, release part of the reserve from A with a Stock reservation document of the type “Release from reservation” and place it for B. The system does not decide this itself.

After plans change, the reserve should be released at once. A reserved board that is not needed blocks the warehouse: it stays unavailable for new orders even though the customer has refused. The general reserve rules, including the term and automatic release, are in the article Reserving goods.

How do you keep the reserve in order every day?

A reserve works while it is placed on time and released when the order has lost its meaning. For a shop with several orders a week, four habits are enough:

  1. Reserve materials on the day the order is confirmed. The day the shop starts is too late. Then the shortage is visible while there is still time to purchase.
  2. Check the Stock with Reserve report once a week for the main materials: board, hardware, edging. Rows with zero free quantity are candidates for purchase.
  3. Release the reserve right after a customer refuses or a product changes. A reserved board that nobody needs blocks the next orders.
  4. Before starting a batch, compare the “Reserve” column in the production order with the need. If the reserve is smaller, the shop sees the shortage and does not wait for the board to run out in the middle of cutting.

In the example these habits cost a few minutes: two reserves, one report and one purchase of 21 m² of board. Without them the same 21 m² comes to light during cutting, when the shop is already standing idle.

What Bimp does and does not do

Bimp is a Ukrainian cloud ERP for manufacturers. It calculates the need for materials by the specification, reserves them within the available balance from a customer order or a production order, shows stock, reserve and shortage, suggests analogues, releases a reserve with a separate document and provides the Stock with Reserve report with drill-down to documents. For wider inventory control see the Bimp site.

The limits are these. A reserve is possible only for material that has already been received: you cannot reserve a board that is still on its way from the supplier. Automatic booking against a receipt in Bimp works for goods. For production materials it does not exist. The system does not rank priorities between orders by itself: the reserve goes to whoever placed it first, and a person redistributes it. The report has no “Free” column, and the free quantity is calculated as stock minus reserve. A reserve also does not write off the material: the write-off happens when “Assembly” is posted.

In the example the reserve settled the conflict between two orders before the first cut: order A got 45 m², B got 15 m² and a shortage of 21 m², which a purchase covered before the start. The same stock / reserve / free table can be kept for any material that several orders need at the same time.

FAQ

What is reserving materials in manufacturing?

It is assigning the raw materials and components already in stock to a specific order. Reserved materials drop out of the free balance, so another order, a sale or a transfer cannot take them.

How does a raw material reserve differ from booking materials?

A reserve assigns material that is already in the warehouse and works only within the balance. In Bimp, booking is described for goods waiting for a supplier receipt: they are assigned to the customer at the moment of receipt.

Does a reserve write materials off the warehouse?

No. A reserve only assigns materials to the order. The write-off happens when "Assembly" is posted.

How do you remove a reserve if the order was cancelled?

Create a Stock reservation document with the type "Release from reservation" or clear the "Reserve" column. The material then returns to the free balance.

How do you find out how much material is free?

In the Stock with Reserve report, subtract the "Reserve" column from the "Stock" column. The report has no separate "Free" column.

We will show a materials reserve on your order

In a Bimp ERP demo, a specialist reserves materials by your specification from a customer order and shows how much of them stays free for the next orders.

Book a demo
DODmytro ObukhovCo-Founder & CEO