Customer Order Details
After receiving a request for a quotation or an order, create a new customer order in MRPeasy to track its progress.
In a Customer Order, it is possible to
- calculate the quotation,
- estimate delivery,
- check items’ availability in stock,
- schedule multiple delivery dates,
- reserve items for this particular order,
- see the current status of each line item,
- enter delivery terms,
- manage invoices and shipments.
Jump to a topic:
- Example video: How to use the Customer Order?
- How to estimate costs and lead time for the quotation?
- How to send a Quotation, an Order Confirmation, or an Invoice?
- How to check stock and book the products for the order?
- How to ship the products?
- How are the cost and profit calculated?
- How to enter a bespoke make-to-order product?
- How to import a Customer Order?
- What does the product statuses mean?
To estimate the cost of products and the dates when they could be ready:
- Create and Save the Customer Order.
- Click the Estimate costs and dates button inside the Customer Order.
- Choose whether to consider the available stock levels (using FIFO; or FEFO, for perishable goods) or if all materials should be purchased ignoring the current inventory (the costs and lead times are taken from the purchase terms).
- Enter the desired Margin to calculate the sales price.
- Click Estimate costs and dates button, the sales price and estimated earliest production finish date is calculated for each item.
- Click Show details to see the detailed cost breakdown for every product by materials, manufacturing overhead, and labor cost.
The margin of any product can be updated and the discount can be added.
Please note that the estimated cost and actual cost may differ once all products are booked.
When the costs or dates cannot be calculated, then some associated Purchase Terms and/or BOMs and Routings are missing or need updating (e.g. when an article has been deleted, but it is still listed in a BOM).
To send or print a quotation or an invoice with your company logo and details:
- Create and Save the Customer Order
- Scroll down to the Invoices table.
- Click Create to add a document.
- Choose the document type (Quotation, Order confirmation, Invoice, etc.) and fill in other details.
- Click PDF for customer for the PDF,
or click Send e-mail to open your e-mail client.
Demo video: How to work with Quotations.
- Open the Customer Order, scroll down to the Shipments table.
- Click Create an Invoice Create an invoice button on Shipment's line.
Demo video: How to invoice a Shipment.
Before you can ship products to a customer, you need to reserve the products for this particular order, either from stock (if you make-to-stock) or from future production (if you make-to-order).
To see availability and book products:
- Open the Customer Order at CRM -> Customer Orders.
Or Create a new CO and Save.
- Click the Check stock and book items button under the table of ordered products.
- You will see the inventory status of all items in the order.
- There are two options for reserving goods:
- Button Book manually, which allows to manually create bookings from available stock lots.
- Button Book all items, which will automatically try to book available goods (default by FIFO; or by FEFO, for perishable goods).
If products are not available, then on this page you have the following options:
- Automatically create Manufacturing Orders, and if you wish, also Purchase Orders, by ticking the respective options and clicking Book all items.
The Manufacturing Orders will be scheduled according to material availability and available production resources.
- Create demand for these products by clicking the Book all items button. Then the Available quantity of these items will become negative.
You can schedule the Manufacturing Orders from Stock -> Critical on-hand page. Or if these are purchasable items, you can raise the Purchase Orders from Procurement -> Critical on-hand.
The items from these MOs or POs will be automatically booked to the Customer Order(s).
- Create the manufacturing orders manually by clicking Book manually -> Create a manufacturing order.
Then you need to move back to the bookings page to connect the just planned lot (batch) of products to the Customer Order.
Demo video: How to book Products for a Customer Order.
If a booking is unsuccessful and MOs are not created automatically
Sometimes the software cannot create Manufacturing Orders automatically. This could mean one of two things:
- There could be plenty of available products in the stock already. The software has successfully reserved these, and there is no need to create a new MO. (All is well!)
- Some information needed for creating MO’s is missing:
1) Most commonly, a Purchase Term indicating the material lead time is missing for a purchasable material.
2) The BOM or the Routing is missing from the product.
3) The BOM needs updating since some articles have been deleted.
4) The Routing needs updating since a workstation type has been deleted.
5) There are no workstations in a workstation type. (A workstation needs to be added, or the Routing changed.)
Shipping documents can be created, and shipping reported, directly from inside the Customer Order or from the Stock section.
To create shipping documents (Waybill, Picking list):
- Open the Customer Order and scroll down to the Shipments section.
Or go to Stock -> Shipments.
- Click Add to create a new Shipment.
- Fill in the details and Save.
NB! The products must be booked for the Customer Order.
- Print the Waybill and Picking list.
To ship products:
- Open the Customer Order and scroll down to the Shipments section.
Or go to Stock -> Shipments.
- Open the Shipment.
- Report picking of the items from stock:
a) for reporting line-by-line, click the Pick Consume button on each line to report picking.
b) if reporting all-at-once, click the Pick all items button.
Demo video: How to ship a Customer Order.
The Delivery Note has the name Waybill in MRPeasy.
If you need to send delivery notes, change it:
- Open Settings -> System settings -> PDF Editor
- Click button Edit at the bottom of the page
- Fill/change description field of "Waybill" to "Delivery Note".
- Click button Save.
The profit is calculated as the difference between the sales price on the Customer Order and the actual cost of the product.
When products have not yet been booked:
- The cost and profit can be estimated with the Estimate costs and dates functionality. Otherwise, if that functionality is not used, cost and profit will not be shown until products are booked.
Once bookings for products have been made:
- The software knows the actual cost of the product by using stock lot tracking.
- For example:
* The cost of a purchased item is the actual purchase price, plus any additional PO fees and/or transfer fees, which have been applied to it.
* You can manually create a stock lot (and define its cost), which also happens when you manually update inventory levels.
* From a Manufacturing Order, the cost of a manufactured product is calculated by adding up the following costs
1) the sum total of materials costs of the Manufacturing order (i.e. Materials cost);
2) the sum total of operation costs (i.e. Manufacturing Overhead cost);
3) the sum total of labor costs for performing the manufacturing operations (i.e. Labor cost).
If capacity planning is required, then a new item with BOM and a Routing needs to be created for every bespoke project. This can be done very easily from within the Customer Order:
- Open the Customer Order, or create new.
- When choosing the Product, choose to Add a new product from the drop-down menu.
- Enter the product details.
Read: How to add a manufactured item?
Read: How to duplicate an existing item to create a new custom one-off product?
- Once the product is entered, click Back to return to the Customer Order.
- Continue filling the Customer Order.
If capacity scheduling is not required, read: How to create a make-to-order bespoke manufacturing order?
When creating a new customer order, it is possible to import a list of sold items from a CSV file. The file must be no longer than 100 lines and can contain the following columns:
- Part number - a part number of the stock item that is sold. This column is required.
- Quantity - a total quantity of the item.
- Price - a price per one item.
- Discount - a discount of the item.
- Free text - a free text that is displayed below the stock item.
Other CO information should be added manually before the import.
Product status shows the situation with that particular product.
The software can assign one of the following statuses:
- Not booked - the product is not booked or not the whole quantity is booked.
- Expected on time - all products are booked and are expected on time.
- Possibly delayed - warning that there is a good chance that delivery of products will be late. This can happen if:
- MO finish date is same as CO delivery date;
- Expected date of PO is same as CO delivery date;
- CO delivery date is today and products are not received;
- MO is not started at the planned time.
- Delayed - warning that delivery of products will definitely be late. This can happen if:
- MO finish date is after CO delivery date;
- Expected date of PO is after CO delivery date;
- CO delivery date is in the past and products are not received.
- Ready for shipment - all products are received and can be shipped to the customer.
- Delivered - all products have been shipped to the customer.
Statuses Possibly delayed and Delayed are assigned whether along with other manual actions (for example, when CO, MO or PO is updated) or automatically once per day between 1 a.m. and 3 a.m.