News & Publications
Insights and thought leadership in Open ERP

Evolving Manufacturing Logistics Require Odoo Open ERP flexibility

Chapter 2

Complete Example: Sell, Check the Stock, Manufacture and Purchase

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.

Create a New Customer

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.

New Customer

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

Create a New Product Category and Product

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.

Product

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.

Add Minimum Stock Rules

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

Create a Bill of Material

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.

BoM

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.

Warehouse and Locations

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.

Create a Sales Quotation

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

Confirm the 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.

Run the Scheduler

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.

Scheduler

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.

Change the Purchase Request and Confirm It

Now Open ERP will have created procurements (in this example purchase requests) for the products that need to be supplied.

Purchase Requests

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.

Receive the Products

The supplier Wood y Wood Pecker sends the goods to your company. Jason receives the goods and enters this receipt in Open ERP.

Incoming Shipments

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.

Create the Draft Purchase Invoice

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

Run the Scheduler Again

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.

Scheduler

Jason goes to Warehouse > Schedulers. He clicks Compute Schedulers. In the Wizard, Jason clicks Compute Schedulers to start the computation.

Start Manufacturing

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.

Deliver the Goods to the Customer and Create Draft Sales Invoice

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.

Delivery

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.

Create the Sales Invoice

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.

Confirm the Purchase Invoice

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.

Invoice Control

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)

Odoo ERP Scalability

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:

  1. Enables lean supply chain management via pull systems
  2. Provides advanced visibility across the entire chain for profitability and sustainability
  3. Includes build-in inventory management, transportation management, as well as communication with end-customer
  4. Allows management and monitoring of the various processes and stages
  5. Tightly integrated procurement integration with purchasing, sales orders, accounting, manufacturing, and warehousing
  6. Management of serial number and lot tracing throughout the entire system
  7. Supports the manufacturing module based on lean principles (work order and work centers and Kanban system)
  8. Enables visibility and management of detailed stock moves from purchasing through delivery
  9. Provides transportation-related metrics including average inbound and outbound transportation cost and cost per shipment
  10. Build-in sales analysis tools for forecasting and revenue projections as well as variance detection

About USA Odoo

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.”

We invite you to continue exploring the pages of USA Odoo and Open Source Integrators to see what we mean about “Open Source Done Right” and how we can help your company scale with harmony.

About the Authors

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.

Leave a Comment

Name*
Email*
Comments

Get to Know Us

Take the next step to connect with us and discover the power of Open ERP. Please select your preferred way to engage.

Financial Accounting with Odoo.
We literally wrote a book about it.

Enhance your Odoo experience with our exclusive open source modules and resources.

Open Source ERP Takes Many Forms

See how our experience across the accounting discipline helps rightsize the recommendations and solutions for your company.

Open Source ERPs can be the smartest move for your company, but it takes finding the top integrator to provide expert ERP consulting, optimized software, and quality support. Look no further.

ERP customers can enjoy all the robust capabilities of real-time data sets to inform their ERP solutions, operations and leadership teams. If you are looking for Hadoop done right, you’re in the right place.

There are websites and then there are e-commerce sites. E-commerce at the next level starts with a robust CMS solution. Find out why Open Source Integrators look first to Magento for the heavy lifting.

Schedule a Call
Readiness Assessment
Attend a Webinar
Contact Us