Sales Management

Back to User Guide

Introduction

Sales Management deals with all activities related to the customer sales process and corresponding reporting.

This application area of Openbravo covers Order to Shipment and Invoicing parts of Order to Cash business flow and Customer Returns business process. For Payments Management of Order to Cash see the Financial Management application area.

Order to Cash Business Flow

Order to Cash workflow manages the life-cycle of a sales process.

Due to its complexity and different roles involved it is convenient to split Order to Cash down into two main sub-processes:

1. Order to Shipment process starts when a customer requests a quotation or orders goods to the moment the warehouse staff ships the merchandise.

2. Customer Invoice to Cash continues previous sub-process by invoicing customer´s deliveries and closes it by receiving payments from buyers.

Configuration The following setup needs to be done before performing the process:

• Sales Products.
• Prices configuration.
• Business Partners (Customers).
• Sales Quotation document type configuration.

Sales products need to be configured prior any sale in the application. Each product that is being sold needs to have a price in the sales price list in order to be selectable in any transactional document like a sales order or a sales invoice. Same way each product that is being sold needs to be defined in a unit of measure ("UOM"), and in alternative unit of measure (AUM) if required. Please refer to Product Setup, Product and Pricing for more information. Please refer to Pricing, Product Setup and Product for more information.

Business Partners (customers) need to be configured prior any sales can automatically turns into a sales quotation or sales order. Please refer to Business Partner Setup and Business Partner for more information.

Above configuration is one part of the overall Business setup flow within the "Master Data Management" setup.

Finally, the "Quotation" document type requires a sales order document type (i.e. Standard Order) to be defined as "Document Type for Order" to allow the conversion of a sales quotation into a sales order.

Note: It is not required to perform any additional setup for the Sales Management application area if Food & Beverage (F&B) sample client shipped with Openbravo by default is going to be used to explore it. The sample data set already contains the roles, warehouses, business partners, products and prices pre-configured.

Execution

In Sales Management the Order to Cash business process is executed as follows.

Customer can ask directly for a Sales Order or request a Quotation. If the Business Partner asks for a Quotation Sales staff:

• Creates new document in the Sales Quotation window and looks up the customer name in the Business Partner field. If the Business Partner doesn't exist, it is entered in the application with the Business Partner window.
• Then Sales staff fills the Sales Quotation window. The transaction document is set to "Quotation" by default. And continues by adding for each product a line with the product, quantity and if needed its attribute (size and/or color and/or serial number, etc.).
• Once the quotation is ready, it is booked. The Document Status of the quotation changes to Under Evaluation. The Quotation can be printed and sent to the Business Partner by fax, mail or email.
• When the Quotation is accepted by the Business Partner a sales order can be created based on this quotation. When this is done the status of the quotation changes to "Closed - Order created" and the Sales Order can be printed and sent to the Business Partner by fax, mail or email as a confirmation.

If the Business Partner places an order directly Sales staff:

• Creates it with the same Sales Order window setting the the Transaction Document to the desired type of Order (Standard Order, POS Order, Warehouse Order). Lines are filled as in the case of the Quotation. Once the Sales Order is ready, it is processed pressing on the Book button.
• When the Sales Order is processed, it reserves the material for its shipment.
• To review past sales of the Business Partner Sales staff uses Sales Dimensional Report.

Warehouse staff:

• Looks for orders pending for preparation in the Create Shipments from Orders window or with the help of Orders Awaiting Delivery Report.
• The Warehouse staff can create a Shipment in 2 ways:
  • With the Create Shipments from Orders window. It creates a shipment completed for the selected Sales Orders.
  • With the Goods Shipment window in which the Warehouse staff creates the shipment in a manual way.
• Completed shipment updates stock information (product levels go down) and can be posted to create the accounting entries of the shipment.
• Shipments Dimensional Report is used to review past shipments to the Business Partner.

Finance staff can generate invoices in different ways:

• With the Generate Invoices window, in which it generates invoices in bulk for all pending to be invoiced (based on their invoicing rules) Sales Orders.
• With the Create Invoices from Orders window. It shows Orders pending to be invoiced and creates invoices for the selected Sales Orders.
• With the Sales Invoice window in which the Finance staff creates the invoice in a manual way.
• Processed Sales Invoice creates the Payment Plan of the invoice, the Tax of the invoice and can be posted to create the accounting entries of the invoice. Afterwards, the payment plan can be modified.
• Orders Awaiting Invoice Report helps Finance staff to plan and verify invoicing of the Business Partners.
• Finance staff is able to review past customer invoicing information in the Sales Invoice Dimensional Report.

Sales revenues expenses can be recognized in different ways:

• In most cases companies would want to recognize revenues as soon as an invoice is completed. For instance a food and beverage distributor selling beverages would want to recognize the revenue as soon as the goods leaves the warehouse.

In Openbravo, in this situation, revenue is generated as part of the accounting of the sales invoice corresponding to the transaction.

• Under some circumstances, however, it is required to defer the revenue recognition. For instance a food and beverage distributor selling and invoices a product that they will only be able to deliver to their customers in 3 months needs to defer revenue recognition till the delivery.

In Openbravo, in this situation, the revenue can be deferred until a given starting period and within within a given number of periods by entering a revenue deferred plan in the sales invoice lines.

For a full description of this functionality please review the How to manage deferred revenue and expenses article.

Credit limit for business partner

• Each Business Partner can be set up with a Credit Line Limit. When customer balance (amount that is outstanding for payment for the customer) is higher than the credit line limit a corresponding information message is shown when business partner is selected during the creation of a sales order, sales invoice or goods shipment. This way Openbravo assists in risk analysis while placing customer orders or executing other steps in the Order to Cash business flow.

This message is just an input to consider and the documents creation process can be continued.

Finally, the finance staff is in charge of recording and managing the customer payments:

• When a payment is received against an invoice it can be recorded in the Sales Invoice window by using the Add Payment button. It is also possible to receive a prepayment for the Sales Order. Detailed payment management documentation is available in the Financial Management//Receivables&Payables application area and in the How to manage prepaid invoices in receivables.

Customer Returns Business Flow

Customer Returns workflow manages the business processes for returning items back from customers either for credit

or for replacement.

Configuration The following configuration options are available in this process:

• Return reasons
• Condition of the goods
• Accounts for Cost of Goods Sold (COGS) for returns and Revenue for returns

Execution In Sales Management the Customer Returns business process is executed as follows. Customer can request a return material for whatever reason.

Sales staff:

• Creates a new document in the Return from Customer window and looks for the customer name in the Business Partner field.
• And continues by adding lines clicking the button Pick/Edit lines.
  • Picks Goods shipment lines and edits the quantity the customer wants to return, price and return reasons.
• Once the Return Material document is accepted processes it by clicking the button Book. The status of the document changes from Draft to Booked

Warehouse staff:

• Creates a new document in the Return Material Receipt window and looks for the vendor name in the Business Partner field.
• And continues by adding lines clicking the button Pick/Edit lines.
  • Picks lines created in the Return from Customer window.
  • If needed edits the quantity received and its location (storage bin).
• Once the document is ready processes it by clicking the button Complete. The status of the document changes from Draft to Completed
• Completed receipt updates stock information (product levels go up).

Finance staff: To invoice these documents can do it from several windows / processes:

• With Return from Customer window where a new button Create Credit might appear or not based on the original sales order. If the order is already invoiced then it will be present, if not - it won't. Using this button it is possible to invoice the return order following the standard process, that is, depending on the invoice terms.
• With the same Create Credit button it is also possible to create an invoice and leave it as credit to be used later.
• Using Generate Invoices process: if the invoice terms is Customer Schedule After Delivery and both sales orders and RMAs exist the process groups all of them in one standard Sales Invoice (not in a Return Material Sales Invoice).
• With the Sales Invoice window by picking lines and either grouping them from standard sales orders and return orders or by creating individual Return Material Sales Invoices only from return orders.
• With the Sales Invoice window creating a Return Material Sales Invoice making sure that the amount of the Invoice is negative.

Relationship with other application areas

Sales Management has a connection with other application areas:

• Warehouse Management as shipment changes stock quantity and its value.
• Financial Management in terms of managing payments.
• Material Requirement Planning (MRP) because pending sales orders are one of the inputs for the prodReversal Sales Invoiceuction process.

Application Menu

Please find below detailed description of all windows and reports of the Sales Management application area.

Transactions

• Sales Quotation
• Sales Order
• Goods Shipment
• Return from Customer
• Return Material Receipt
• Create Shipments from Orders
• Sales Invoice
• Create Invoices from Orders
• Generate Invoices

Analysis Tools

• Sales Dimensional Report
• Shipments Dimensional Report
• Stock for Open Orders
• Orders Awaiting Invoice Report
• Orders Awaiting Delivery Report
• Sales Invoice Dimensional Report Legacy
• Sales Invoice Dimensional Report

Setup

• Condition of the goods
• Reject Reason

Advanced

• Commission Payment
• Discount Invoice Report
• Sales Order Report
• Invoiced Sales Order Report
• Delivered Sales Order Report
• Shipment Report
• Invoice Detail
• Customer Invoice Report
• Sales Region
• Commission
• Sales Channel
• Sales Campaign
• External Point of Sales

Back to User Guide