Can We Dispatch on Friday? ERPNext Planning for Pump Orders
Sales needs a date for 12 pumps. Stores has three free and the test bench can clear seven more. Here is how to work out a promise the factory can keep.
At a Coimbatore pump factory, a dealer asks for 12 standard pumps by Friday. A second dealer already expects eight on Monday. The sales executive can see five finished units in ERPNext. Before calling the first dealer back, she needs two more facts from the factory: how many of those five can she use, and how many new pumps can pass the test bench before Friday’s truck leaves?
Here is a worked example for a planner, a stores supervisor and a sales executive. The quantities and dates are illustrative.
Start with the two orders and the stock already promised
Both dealers want the same pump variant. Stores confirms that all five finished pumps passed inspection, but two are committed to an older order. That leaves three free pumps for the two dealers. To meet demand of 20, the factory must build 17 more. Counting all five as free would make the first promise two pumps short before assembly even begins.
In ERPNext, check each Sales Order item, quantity, delivery date and quantity already delivered. Compare the finished-goods warehouse balance with existing commitments and any stock reservations your site uses. If the second dealer requires a different motor or seal, split the calculation by item and BOM revision.
Find what limits Friday dispatch
The planner uses a Production Plan to bring the two Sales Orders together. Each new pump needs one seal kit. Stores has 12 usable kits. A Purchase Order covers another five, and the supplier says they will arrive Monday morning. The 12 on hand are enough to assemble the nine additional pumps Dealer A wants. But the test supervisor has only seven free test slots before Friday’s truck. Every pump must pass before dispatch.
| Friday check | Quantity | What sales can promise |
|---|---|---|
| Tested pumps free in stores | 3 | Available for Dealer A |
| Additional pumps the bench can clear | 7 | Available only if all seven pass before loading |
| Maximum Friday shipment | 10 | 2 of Dealer A’s 12 remain open |
This is the point to call the dealer. Offer ten on Friday and two in a later shipment, subject to their agreement. If the dealer needs all 12 together, agree a revised date. Keep the original request and the revised commitment visible to the people scheduling the truck.
Protect Monday’s order
If seven new pumps are completed on Friday, five of the original 12 seal kits remain. Monday now needs ten pumps: two for Dealer A and eight for Dealer B. Five kits in stores plus five due from the supplier make ten on paper. Check the supplier’s arrival time, receiving inspection, assembly labour, ten test slots and the carrier cutoff. A delivery expected at 4 p.m. does little for a truck booked at noon.
Use the Production Plan and linked Work Orders to review planned production and the purchase documents to check incoming parts. Projected quantity helps identify a shortage. The planner still needs to check the dates of the documents behind that figure. A dispatch date derived from the example is a planning decision, not a date ERPNext automatically guarantees.
Close the loop after the truck leaves
If ten pumps actually leave on Friday, create the Delivery Note for ten against Dealer A’s Sales Order. Check that two remain open, and that Dealer B still has eight due. If one pump fails testing, only nine are ready for Friday. Tell the dealer before loading, move the failed unit into the agreed quality workflow, and revisit Monday’s plan.
For a demo, bring two anonymised orders for the same model, one BOM, a stock balance and next week’s test schedule. Ask sales, stores and production to agree on one number they can ship today and one date that still depends on the supplier.
For the wider factory workflow, read pump manufacturing from BOM to dispatch. For system setup, see ERPNext manufacturing and purchase management. Frappe explains the underlying calculations in its Production Plan and Projected Quantity guides.
No comments yet. Login to start a new discussion Start a new discussion