Table of contents
- Managers saw the total stock of pallets without the available quantity, so on Monday two trucks came for one pallet. The "Available" column subtracts the reserve from the stock, and the second truck is not planned.
- The 1-TN waybill is built from the "Sales of goods and services" document and the "Vehicles" reference book. A notional 20 minutes per waybill shrink to 5, and fourteen trips a week take 70 minutes instead of 280.
- The wholesale warehouse is tied to the "Wholesale" line of business and fills into the order by itself. The status "Completed" releases the reserve, so stale orders do not hold goods.
The company is fictional. Every action in Bimp is a real product feature. The warehouses, trips and minutes in the example are invented, and the arithmetic can be checked on a calculator.
Wholesale order shipment from the warehouse starts with one number: how much product can be promised to a buyer this minute. That is the stock in the warehouse minus what is already tied to other people’s orders. When a manager sees only the total stock, one pallet gets two buyers. The second stage of shipment is documents: the waybill for each truck is built from the sales data with no manual typing.
At “Quartz-Build” (a fictional company) they understood this on Tuesday. On Monday two trucks drove up to the gates of the wholesale warehouse for the same pallet of dry mix. One had to be sent back.
Why did two trucks come for one pallet?
“Quartz-Build” makes dry mixes and has 90 employees. Besides the workshop it has its own wholesale channel for building supply bases and dealers, three warehouses (production, wholesale and a branch) and its own transport. Orders are taken by five managers.
The problem had two sides. Managers saw the total stock across all warehouses in the product card but did not know how much of it was already promised to others. On top of that, some pallets lay in the production warehouse, from which wholesale trucks are not loaded. The second problem lay in the paperwork: the 1-TN waybill was filled in by hand in 20 minutes, and there were fourteen trips a week.
| Indicator | Before (notional) |
|---|---|
| Time per waybill, min | 20 |
| Trips per week | 14 |
| Time on waybills per week, min | 280 |
| The same in hours | 4 h 40 min |
Calculation: 14 × 20 = 280 minutes, that is 280 / 60 = 4.67 hours, almost five hours. A warehouse employee spends these hours in the morning, when trucks are already waiting for loading.
How do you organize wholesale order shipment from the warehouse in Bimp?
The scenario has seven steps. A help link stands next to each.
Step 1. Warehouses and lines of business. In the warehouse reference list create the production warehouse, the wholesale warehouse and the branch (Warehouses). Then in the “Lines of business” reference list tie the wholesale warehouse to the line “Wholesale” and the production warehouse to “Production”. In the company settings turn on the switch for automatic warehouse choice. Now the manager chooses a contract with the line “Wholesale”, and the warehouse in the order appears by itself. If the branch warehouse is needed, it is changed by hand, and the line of business stays intact (Automatic warehouse selection by line of business).
Step 2. A customer order with a reserve. In the order, in the “Reserve” column, enter the quantity tied to the buyer and, if needed, “Reservation days”. In the product list three numbers stand side by side: “Stock in warehouses”, “Reserve” and “Available”. A new order reserves only within “Available” (Reserving goods).
Step 3. Statuses. When the buyer has refused or the shipment is closed, the order gets the status “Completed”. It releases the reserve and removes the order from the plan, so stale orders do not hold pallets (Order statuses).
Step 4. Shipment. The warehouse ships with a “Sales of goods and services” document created from the order. The number of cargo places is entered in the document and goes into the waybill (Shipment).
Step 5. Transport and the waybill. Once, in the “Vehicles” reference list, each vehicle is created: transport type, make, registration number, dimensions. In the “Print” block of the sales document choose the vehicle, the driver, and the loading and unloading points. The “Waybill” print form puts all this into the 1-TN waybill (1-TN waybill).
Step 6. Bulk printing. In the morning the manager opens the “Sales → Sales” journal, ticks all the day’s sales and with one click prints the waybills for all trips (Bulk printing).
Step 7. Reports. The “Stock with Reserve” report shows what is free and what is tied up (report). The analysis of shipments by customers helps to see who is reaching large volumes.
What changes in numbers?
Two trucks came for one pallet because managers saw the total stock. The waybill was filled in by hand in 20 minutes, and fourteen trips a week took 280 minutes.
The wholesale warehouse is tied to the line of business “Wholesale”, orders are reserved within the “Available” column, and the 1-TN waybill is printed from the sales document data and the vehicle reference list.
A waybill takes 5 minutes instead of 20, and fourteen trips take 70 minutes instead of 280. The saving is 210 minutes, which is 3.5 hours a week.
Let us check the calculation by rows.
| Indicator | Before | After | Difference |
|---|---|---|---|
| Minutes per waybill | 20 | 5 | 15 |
| Trips per week | 14 | 14 | 0 |
| Minutes on waybills per week | 280 | 70 | 210 |
| Minutes on waybills over four weeks | 1,120 | 280 | 840 |
14 × 5 = 70 minutes, 280 - 70 = 210 minutes, which is 3.5 hours a week. Over four weeks that is 840 minutes, 14 hours, almost two working days. The five minutes that remain go on checking the consignor and the driver’s signature.
What matters even more is that the manager sees “Available” in the product card. A pallet already promised to the first truck does not appear among the free ones, and the second order for it will not pass reservation. An empty trip costs fuel, the driver’s work and a disrupted loading.
What does the day look like at the wholesale warehouse?
In the morning the sales manager opens the order journal and checks that every order for today has a reserve. The warehouse sees the same orders and prepares pallets. The storekeeper creates “Sales of goods and services” from the order, enters the number of places and chooses the vehicle in the “Print” block. Then the dispatcher selects all sales for the day’s trips in the “Sales” journal and prints the waybills in one file.
This split makes every action obvious. The manager answers for the reserve, the warehouse for shipment, the dispatcher for printing. If there is no reserve, the order shows in the journal without a quantity in the “Reserve” column, and it is not sent to loading.
A separate word on expired reserves. An order the buyer has not confirmed holds pallets and reduces “Available”. So the order gets “Reservation days”: after this period the reserve is released automatically and the pallets return to sale. The value 0 makes the reserve open-ended, and that value is better kept for project deliveries.
What else can be attached to the wholesale warehouse?
Here are three things that are built on this foundation. Delivery by own transport or a hired carrier is charged to the cost of the sale with an “Additional costs” document created from the sale (Additional costs). Then the margin on the order is counted with the trip included.
A related article about price lists, reserves and shipments for a manufacturer with its own wholesale: Wholesale Accounting for Manufacturers. The reserve of raw materials for production, which works by the same principle of “stock minus reserve”, is covered in the material Reserving Materials for a Customer Order.
What does this give?
The wholesale side works in the same database as the workshop. A pallet that has just come off the line appears at once in “Stock in warehouses”, and a few minutes later it can be reserved for a buyer. A separate program for wholesale is not needed, and warehouse stock does not have to be reconciled between two systems.
For the branch the scheme is the same. The branch warehouse is created separately, and the manager creates an order from it by changing the warehouse by hand. The stock of three warehouses stays in one database, so pallets can be moved from the production warehouse to the wholesale one with a transfer document between warehouses, and they appear in “Available” of the wholesale warehouse. The manager needs no extra requests to the workshop for this.
The owner sees three things. First, how much can be sold today. Second, which orders hold a reserve and do not move. Third, how many minutes a week the paperwork takes. Managers stop phoning the warehouse with the question “is it there or not”, because the answer is already in the card.
Bimp is a Ukrainian cloud ERP for manufacturers, and wholesale, the warehouse, the reserve and waybills live in it in one database. For a manufacturer with its own trucks this means the waybill for a trip is printed from the sales data in a few minutes.
Scenario limits
The 1-TN waybill in Bimp is printed from a sales document, but the driver, the vehicle and the route points are filled in by a person. The waybill is not created automatically. Order statuses work by the company settings, and the reserve has to be set by hand in the order column. Some help articles on which the steps rest have a review status, so check the button names against your version. A Nova Poshta waybill for parcels is created in a separate way, through the integration.
Five minutes per waybill, fourteen trips and all the warehouses in the example are invented. How to set up such accounting on your own warehouses and transport is shown on the page Bimp for wholesale trade accounting.
FAQ
How does stock in the warehouse differ from available stock?
Stock shows how much product physically lies in the warehouses. Available equals stock minus the reserve for orders. This is the number you can promise to new customers. A reserve does not move goods, it only reduces the available quantity.
Where does the information for the 1-TN waybill come from?
From the "Print" block of the "Sales of goods and services" document (vehicle, driver, loading and unloading points, consignor and consignee) and from the "Vehicles" reference book, which is filled in once. The "Waybill" print form fills in these data by itself.
Can you print waybills for several shipments at once?
Yes. In the "Sales → Sales" journal tick the documents you need, click the printer icon and choose the form. Bimp assembles one file for all selected sales. It is not recommended to select more than 200 to 300 documents at a time.
How does the 1-TN waybill differ from a Nova Poshta waybill?
The 1-TN accompanies cargo that travels by road and is printed from the sales document. A Nova Poshta waybill is created from the customer order through the integration and is meant for parcels. These are two different documents with different setups.
When is the reserve released?
The reserve is released on shipment, when the order is closed (the status "Completed" or another status with the "Closed order" flag) or with a "Stock reservation" document. With the "Reservation days" field it can be released automatically.
In a Bimp ERP demo a specialist makes an order with a reserve and a 1-TN waybill with you on your own products and vehicles.
Book a demo