As your business is growing and evolving all the time, your requirements as to the use of Open ERP are likely to change. To sustain your growth, you can easily extend your Logistics & Manufacturing Management with other Open ERP business applications, such as HR or CRM, to name some. Open ERP offers this flexibility; you can start with one business application and gradually complete Open ERP to suit your ever changing needs!
In this chapter, we will show you a complete Sales / Purchase / Manufacturing / Warehouse flow. We will explain how to create a product, create a sales order, have an automatic purchase proposal and / or production order, produce and receive the goods, deliver to the customer, and get sales and purchase invoices in a step-by-step scenario.
First you will get an explanation about the scenario (what Thomas or one of his colleagues is supposed to do). Then the Notes will learn you how Thomas (or a colleague of his) enters the information in Open ERP. For the simplicity of the use case, we will do all of the steps under the Admin user. Please note that we will not discuss all elements in detail in this chapter. Later in the book, you will find all required information (apart from the advanced sales features).
Your company will have a stand at the House & Design Fair to promote a series of products. Thomas, the salesman, shows the new products to the visiting prospects and customers.
John Smith from the company Clarkson Ltd. visits your stand and decides to order the brand new Desk and Chair you are promoting. Thomas will have to create this new customer in Open ERP.
To create a new customer, Thomas clicks the Sales button in Open ERP’s main screen. Then he goes to Sales > Address Book > Customers and clicks the New button. The name of a customer is in blue, because it is a mandatory field, so Thomas enters Clarkson in that field. He notices that the Customer check box is already checked. Thomas enters John Smith in the Contact Name, he selects the Default address type. In the Street field, Thomas enters London Street 40; he also enters the City London and the Country United Kingdom as shown in the screenshot below. He takes a look at the other three tabs and decides to keep the default values. Thomas then clicks the Save button to store the new customer.
Figure 2.1: New Customer
Because the desk and the chair from the new Office Secrets series do not yet exist in Open ERP, Mitchell, the Product Manager, will create this brand-new desk as a Make to Order product that will be bought directly from the supplier concerned. He will have to create a new product category for the Office Secrets series too.
Product categories do have an effect on the products assigned to them, and a product may belong to only one category. To create a new product category, Mitchell goes to Warehouse, selects the menu Configuration > Product > Products Categories and clicks New to get an empty form for defining a product category. Mitchell enters Office Secrets in the Name field and adds it to the parent category All products / Sellable. He leaves the other fields as such, and clicks Save.
Then Mitchell will create three new products. Note that he could also have created the new product category directly from the Product form.
To create a new product, Mitchell goes to Warehouse > Product > Products and clicks the New button. The name of a product is in blue, because it is a mandatory field, so he enters 1600 Desk Wave Right-hand W1600x D1200x H725mm Maple in that field. He notices that the Can be Sold and Can be Purchased check boxes are already checked by default. Mitchell selects the Stockable Product product type, because he wants to keep track of the stock movements of the desks. In the Procurement Method field, Mitchell selects Make to Order, because the company decided to only buy the product at the supplier when there is a sales order for it. The Supply Method will be Buy. He sets the Cost Price to 300 and the Sales Price to 541.25, as shown in the screenshot Product (page 11). Mitchell selects the product category Office Secrets. Now he just has to add the supplier from whom he will buy the desks. He clicks the Suppliers tab, then clicks New. He clicks the Magnifying glass to get a list of suppliers, from which he selects Wood y Wood Pecker. He sets the minimal quantity to 1 and clicks the Save & Close button. He takes a look at the other tabs and decides to keep the default values. He then clicks the Save button to store the new product.
To create the component to be included in the Bill of Material, Mitchell clicks the Duplicate button to duplicate the Desk (available when a product is not in Edit mode). He changes the name to Leather for Chair in that field. He unchecks the Can be Sold checkbox. Mitchell changes the Procurement Method to Make to Stock, because the company needs a permanent stock of leather to be able to fulfil the customer’s demands. He sets the Cost Price to 20 and the Sales Price to 0. Mitchell then clicks the Save button to store the new product.
To create another component to be included in the Bill of Material, Mitchell clicks the Duplicate button to duplicate the Leather for Chair. He changes the name to Chair Frame in that field. He sets the Cost Price to 100. Mitchell then clicks the Save button to store the new product.
To create the finished product, Mitchell goes to the list of products, opens the Desk product and clicks the Duplicate button to duplicate the Desk (available when a product is not in Edit mode). He changes the name to Leather Operator Chair in that field. In the Procurement Method field, Mitchell selects Make to Order, then he changes the Supply Method to Produce. He sets the Cost Price to 200 and the Sales Price to 325.50. From the supplier tab, Mitchell deletes the supplier by clicking the black cross. He then clicks the Save button to store the new product.
To make sure the leather and the frame is always in stock, Mitchell has to define minimum stock rules, telling Open ERP how many goods have to be ordered to keep a good stock level.
Figure 2.2: Product
Minimum Stock Rules
To enter minimum stock rules for the Leather for Chair product, he clicks the Minimum Stock Rules action, and clicks the New button. Mitchell notices that the product is already preset in the form. He selects the Open ERP S.A. warehouse and notices that the Stock location is automatically set. As a minimum quantity, he adds 10 and the maximum quantity will be 40. He then clicks the Save button to store the minimum stock rules, as shown in the screenshot Minimum Stock Rules. Do the same for the frame.
Figure 2.3: Minimum Stock Rules
To produce the chair from the frame and the leather seat, Mitchell has to create a Bill of Material for the finished product (the Chair). This way, he will tell Open ERP which components are required to produce the Chair.
Mitchell opens the Chair product, clicks the Bill of Materials action, then clicks the New button. Mitchell notices that the Chair is already preset in the form. He clicks the New button next to Components to add the Leather for Chair. He clicks the disk in front of the line to save his changes. Then he adds a new line (which is displayed automatically) for the Chair Frame and clicks the disk to save. Finally, Mitchell clicks the Save button at the top.
Now Thomas will have a look at how the warehouse and the locations have been organized.
Warehouse and Location Structure
Open ERP has three predefined top-level location types: Physical Locations which define where your stock is physically stored, Partner Locations for the customer and supplier stock and Virtual Locations representing counterparts for procurement, production and inventory. Thomas clicks Warehouse > Configuration > Warehouse Management > Locations to display a list view of the locations.
The customer Clarkson asked to receive a quotation for two Office Desks and two chairs from the Office Secrets series. Thomas enters the sales quotation.
Figure 2.4: Location Structure
Sales Quotation / Order
Thomas goes to Sales > Sales > Sales Orders. He clicks the New button, to make a quotation. He enters Clarkson in the Customer field. Now he can enter the products he will be selling. Next to Sales Order Lines, Thomas clicks the New button to enter sales order lines. He selects the Desk product and changes the quantity to 2 as specified in the screenshot Sales Order. Thomas clicks the Save & New button to add a second line. He adds 2 chairs and notices that a message is displayed saying that there is no stock. Thomas clicks the Save & Close button. Then he clicks Compute to see the total price of the quotation. He opens the Other Information tab, because he wants the sales invoice to be created from the picking. So, he changes the Shipping Policy to Invoice from the Picking. To print the quotation, he clicks Quotation / Order in the Reports section at the right side of the screen.
Figure 2.4: Sales Order
John Smith calls Thomas to tell him that he agrees with the quotation. Thomas now confirms the sales order.
Sales Quotation / Order
Thomas goes to Sales > Sales > Sales Orders. He enters Clarkson in the Customer field and then clicks Search. Thomas clicks the sales order to open it. He clicks the Confirm Order button to make a sales order from the quotation. To print the sales order, he clicks Quotation / Order in the Reports section at the right side of the screen.
The goods have to be produced and delivered to the customer, but Thomas notices that the desks and chairs are not available in stock. Because the Desk was defined as a Make to order & Buy product, Open ERP will automatically create a procurement order on confirmation of a sales order, allowing you to directly generate a purchase order. The same will be done for the Leather.
Open ERP has a scheduler that will run by default every day. In this case, Jason, your company’s Purchaser, will run the scheduler manually.
Jason goes to Warehouse > Schedulers. He clicks Compute Schedulers because he needs to purchase material and wants to check whether anything needs to be added. In the Wizard, Jason clicks Compute Schedulers to start the computation.
Now Open ERP will have created procurements (in this example purchase requests) for the products that need to be supplied.
Jason goes to Purchases > Purchase Management > Request for Quotation. He notices three purchase requests for Wood y Wood Pecker. He selects these three purchase requests by clicking the checkbox in front of them, then clicks the Merge Purchase Orders action at the right to order all products in one go. He clicks the yellow pencil to open the merged purchase request in Edit mode. Now he decides to purchase some extra desks, because Luke, the Sales Manager, told him he expects more sales. To do this, he clicks the yellow pencil in front of the order line and changes the quantity to 10. He clicks the Save & Close button, then he clicks Compute to see the total price of the quotation. From the Delivery & Invoicing tab, he specifies that the invoice has to be created from the picking (Invoicing Control from Picking). To confirm the purchase order, he just has to click the Convert to Purchase Order button.
The supplier Wood y Wood Pecker sends the goods to your company. Jason receives the goods and enters this receipt in Open ERP.
Jason goes to Warehouse > Warehouse Management > Incoming Shipments. He notices the incoming shipment for Wood y Wood Pecker, and clicks the green arrow to start receiving the products. He clicks the Validate button to confirm that all products have been received from the supplier. From the Incoming Shipments list view, he notices that the Delivery order for the customer is now ready to process (red text at the top of the screen), at least for the desks. He wants to check the stock of Desks and goes to Warehouse > Product > Products. In the Name field, Jason types desk, then clicks Search. The real stock is 10, the virtual stock is 8, because of the confirmed sales order for two desks.
Because the purchase order was set to be invoiced from the picking, Jason can now create the draft invoice, which allows for easy invoicing control.
Draft Purchase Invoice
Jason returns to Warehouse > Warehouse Management > Incoming Shipments and clicks Clear. He opens the extended filters and clicks the To Invoice button. He ticks the check box in front of the incoming shipment to be invoiced and then clicks the Create Invoice action in the Reports section at the right side of the screen. He selects the Purchase Journal and clicks Create to generate the draft invoice. The screen with the supplier invoice will open. We will get back to this later.
Figure 2.5: Create Invoice from Incoming Shipments
To tell the system that the procurements have been received and that the raw materials are now in stock, so that the production order can be generated, Jason has to run the scheduler again.
Jason goes to Warehouse > Schedulers. He clicks Compute Schedulers. In the Wizard, Jason clicks Compute Schedulers to start the computation.
Jason checks his list of manufacturing orders which are ready to produce. He notices the leather operator chair and decides to start manufacturing it.
Manufacturing or Production Orders
Jason goes to Manufacturing > Manufacturing > Manufacturing Orders and selects the order to start producing the chairs. He opens it by clicking the yellow pencil, then clicks the Start Production button. He notices the products to be consumed. He assembles the frame and the leather for both chairs. When he has finished, he clicks the Produce button. He keeps the default settings and clicks Confirm, then Cancel to close the window. He clicks the Save button to see the changes.
The Chairs are now also available in stock and the complete order can be delivered to the customer. In the warehouse, they check the open delivery orders.
Randy from the warehouse goes to Warehouse > Warehouse Management > Delivery Orders to check the goods ready for delivery. He clicks the yellow pencil to open the delivery order. He clicks the Process button to deliver the 2 desks and chairs, then he clicks Validate.
Thomas now checks whether the goods have been delivered to his customer. He can check this from the sales order, or he can tell from the status of the delivery order.
Creating a Sales Invoice
To create the draft sales invoice, Thomas has several possibilities.
He opens Sales > Invoicing > Deliveries to Invoice and selects the corresponding delivery for invoicing by ticking the check box and clicking the Create Invoice action in the Reports section at the right of the screen.
He goes to Warehouse > Warehouse Management > Delivery Orders, and clicks the Create Invoice button.
He goes to the list of sales orders, and opens the sales order concerned. Thomas clicks the History tab, clicks the picking list and then the Create Invoice button. He selects the Sales Journal and clicks the Create button.
The draft invoice is now displayed in list view. Thomas opens the invoice and clicks the Validate button. To print the invoice, he clicks the Print Invoice button, or the Invoices action in the Reports section at the right of the screen. The printed invoice will automatically be added as pdf document to Attachments.
Robin, the accountant, now receives the invoice from his supplier. He can do the invoicing control according to the picking directly from the Purchase Invoices screen.
Robin goes to Accounting > Suppliers > Supplier Invoices and opens the Wood y Wood Pecker invoice. Robin verifies whether the invoice from the supplier matches this draft invoice created from the picking order. The invoice indeed matches and he clicks the Approve button to confirm the invoice and assign a document number to it.
Below you find a graphical representation of the sales flow we explained before; the part from quotation to invoice. This view is available in Open ERP. You can open this Process view by clicking the question mark next to the Sales Order title.
Figure 2.6: From Quotation to Invoice
(End of Chapter 2)
The example above demonstrates the power of Odoo Open ERP for manufacturing logistics. Companies now have the flexibility necessary to streamline operational efficiency with scalable solutions derived from Odoo ERP best practices and customized technology
Odoo Open Source ERP solutions from USA Odoo are scalable to streamline a company’s contract, custom, and real-time manufacturing, along with international outsourcing, and get what’s needed, when it’s needed, in the simplest way. Through Open Source Integrators, USA Odoo creates more efficient planning and forecasting leads to better ordering, which in turn equals better logistics for your manufacturing business.
USA Odoo is critical for both processes and performance, delivering the logistics integration that helps companies deploy and drive new insights, profitability, and flexibility to reach a company’s full destiny as a market leader.
Advanced Manufacturing with ERP includes accurate inventory valuations at each step, deep product and materials traceability, product lifecycle management and managed contract and outsourced manufacturing, including make-to-order or highly customized creation of products in real-time. With logistics expertise, Open Source Integrators synchronizes all of these coveted capabilities into one highly reliable and insightful planning and forecasting system.
Top 10 benefits to USA Odoo for Logistics:
As a top Odoo open source software integrator in the US, USA Odoo provides enterprise Odoo integration customers with a unique combination of open source business process consulting and turnkey implementation. As an Odoo Gold partner, we help your enterprise synchronize and integrate manufacturing as well as e-commerce, including the aggregation of processes and decentralized and/or independent systems. Our veteran team of Odoo ERP consultants works hands on with your team to help drive your ability to connect your organization end to end with accounting, customer, and big-data-driven centricity.
USA Odoo was created to provide Odoo-powered open source accounting, CRM, e-commerce platform, and logistic integration including real-time big data and business process improvements leading the way. Our Odoo open source software consultants work personally with each of our clients to analyze the challenges facing their operations, unleash the power of their data, and achieve their specific competitive advantage and ROI business goals.
For greater insight into the power of Open ERP, read the entirety of “StreamIine your Manufacturing Processes with Open ERP: A Simple Approach to Manage the Manufacturing and Supply Chain Complexity.”
Fabien Pickaers is CEO and Founder of Odoo SA, the world’s #1 business apps suite.
Els Van Vossel is the owner of Foxy Consulting bvba and works as a functional ERP consultant and a technical communicator.
See how our experience across the accounting discipline helps rightsize the recommendations and solutions for your company.