Openbravo ERP - Consignment Sales Management

Consignment sales management is a native Openbravo module that allows you to easily manage inventory at customer locations, invoicing your customer only when product is actually sold. In this type of streamlined trading arrangement between partners, you retain ownership of the stock until the final sale, and payment is not made until there is a sale. Unsold stock is returned back to you, without any money changing hands.

Consignment Sales is suitable for new product, used goods and new marketplace sellers. The module fully supports all standard consignment business process flows--directly inside of Openbravo!

 

 

A consignment sales process is used when you (the consignor) send goods to a selling agent (the consignee), and retain ownership until the final sale. The business process flow in Consignment Sales consist of four major parts:

• Consignment Fill-up
• Consignment Issue
• Consignment Returns
• Consignment Pick-up
• Consignment Loss

Consignment Fill-up

Consignment Fill-up covers the replenishment of your stock at the customer site. The two steps up:

• Consignment Fill-up Order
  The order is a request from your customer (typically through a sales representative of your company), based on the demand of the product in market. This order does not involve any pricing (only quantities), and will not result in invoicing.
• Consignment Fill-up Delivery
  The delivery records the movement of the goods out of current stock, to the customer site. Even after the goods have been delivered, you will retain the ownership until the goods are sold.

Consignment Issue

Consignment issue records the sale, enabling the customer to sell the product from the stock available in their warehouse. This business transaction is relevant for billing (your customer now owes you money), because the customer has sold the goods.

Consignment Returns

The Consignment returns process enables the customer to return the goods into the consignment stock that were already taken out of it. After consignment Issue, if the end customer finds any defects or any discrepancies, they can return the product to consignment stock. This transaction is relevant for billing since your customer receives a credit for the returned goods.

Consignment Pick-up

If not all of the consignment inventory has been sold, the remaining products may be returned back to your warehouse. The two steps involved in this Consignment Pick-up process are:

• Consignment Pick-up Order
  Based on products not utilized at the customer location, your Sales representative or some other in-charge person will place a pickup order.
• Consignment Pick-up Delivery
  Based on a pickup order, the person in charge from your company takes the remaining products from the customer location and stores them in your warehouse.

Screenshots

 

 

 

 

Please contact me,if you are interested in this module.

 

thirumalai@qualian.in

 

 

Fifth year in Qualian with Openbravo:Travel in the Marines

I successfully completed my fourth year in Qualian with Openbravo.Now I entered into Fifth year and I'm very happy with my progress.

Thanks to Senthil and company for giving lot of responsibilities.WOW !!!,What a surprise growth in my career along with Openbravo.

ERP is a Ocean and just I learnt to swim,waving boats.Now,The ship is built and I need to travel in the marines :)

My Ship name is MetR,A solution for construction Industry in Openbravo ERP.

Consignment Sales Management

Qualiantech developed an extension module named Consignment Sales Management for handling Consignment Sales process.

This module is registered in Openbravo forge and Qualian have a plan to release it in Openbravo Exchange,probably by next week.


http://forge.openbravo.com/projects/consignmentsales



Functional Specification Document
Contents

1 Functional Specification: Consignment Sales Management
1.1 Section 1: Overview & Justification
1.1.1 Purpose:
1.2 Section 2: Users & Business process description
1.2.1 User goals
1.2.1.1 Consignment Fill-up
1.2.1.1.1 Consignment Fill-up Order
1.2.1.1.2 Consignment Fill-up Delivery
1.2.1.2 Consignment Issue
1.2.1.3 Consignment Returns
1.2.1.4 Consignment Pick-up
1.2.1.4.1 Consignment Pick-up Order
1.2.1.4.2 Consignment Pick-up Delivery

Functional Specification: Consignment Sales Management
Section 1: Overview & Justification
Purpose:

Consignment sales is a form of business in which, as a service to the customer (Eg. A Retail Store), the company or vendor maintains a stock of their materials at a customer’s location. The company or vendor retains ownership of the materials until they are withdrawn from the consignment stores. The customer is only charged for product once it is reported as used.

Module Name = “Consignment Sales Management”
Module language = English and Spanish translation
Module url = [1]
Module author = Qualian Technologies
Module License=OB Commercial License

Section 2: Users & Business process description
User goals

In trading arrangement, Consignment sales play a vital role in placing any material in the hand of another. Business process flow in Consignment Sales consists of four major parts. They are

Consignment Fill-up
Consignment Issue
Consignment Returns
Consignment Pick-up


Consignment Fill-up

The core functionality of Consignment Fillup explains that the stocks can be replenished at the customer site is not accounted for neither invoicing nor pricing because the goods remain the property of your company. The two steps involved in consignment Fill up are

Consignment Fill-up Order
Consignment Fill-up Delivery

Consignment Fill-up Order

It’s a request from the customer through the sales representative of your company based on the demand of the product in market. So it doesn’t involve any invoicing or pricing of the product.

Consignment Fill-up Delivery

After the company has received a fill up order either from customer or through sales representative, the company shall deliver the goods at the customer site based on current stock. Even after the goods have been delivered, the company will retain the ownership until the goods are sold.


Consignment Issue

Consignment issue involves & explains the significant process of selling the goods. It enables the customer to sell the product from the stock available in their warehouse. This business transaction is relevant for billing from company to customer because the customer has sold the goods.

Consignment Returns

Consignment returns enables the customer to return the goods into the consignment stock that were already taken out of it. After consignment Issue, if customer finds any defects or any discrepancies they can return the product to consignment stock. This transaction is relevant for billing since the customer receives a credit for the returned goods.


Consignment Pick-up

After the products have been sold, the remaining consignment goods have to return back to the warehouse of your company.The two steps involved in consignment Pick-up are

Consignment Pick-up order
Consignment Pick-up delivery

Consignment Pick-up Order

Based on products not utilized at customer location, Sales representative or some other in-charge person will place a pickup order.

Consignment Pick-up Delivery

Based on pickup order,the person in charge from company takes the remaining products from customer location and stored it in the warehouse of the company.


http://forge.openbravo.com/plugins/mwiki/index.php/ConsignmentSales/Functional_Specification_Document

http://forge.openbravo.com/plugins/mwiki/index.php/ConsignmentSales/User_Manual

208 reasons to choose Openbravo

Wednesday, October 13, 2010

Source:
http://paolojuvara.blogspot.com/2010/10/208-reasons-to-choose-openbravo.html


Two key reasons to choose an open source solution over another is the vibrancy of its ecosystem of developers and the amount of contributions that project receives from its community. Projects with more contributors evolve faster deliver more value to its users.

Architecture is a key factor in stimulating contributions and projects with a modular architecture have proven to generate a livelier ecosystem than monolithic ones. This is primarily because modular systems allow decoupled and independent development lowering the barrier to contribution.

Openbravo launched its modular architecture in April 2009, when it introduced release 2.50; in less than 18 months the population of available modules passed the symbolic threshold of 200 units.


Today, Openbravo's ecosystem sports 208 generally available modules with a growth rate of 104% in the first 9 months of the year. More importantly, more than 47% of these modules are developed by third party with no or little support by the core Openbravo development team, proving the efficiency of the ecosystem.


While these are impressive numbers, one has to look at the details to understand the value of these contributions for Openbravo end users:

* 108 modules related to localization in 20 countries; these are not only translations but also accounting rules, tax configurations, tax reports, etc.
* 45 are functional extensions that expand the footprint of Openbravo to support other business processes
* 25 are reports that allow to better leverage the information existing within the ERP
* 7 are tools to simplify the life of System Administrators
* 6 are vertical features or solutions that address needs specific of sectors such as hospitality, apparel, healthcare, or higher education
* 4 are connectors to other applications or services
* 4 are alert rules informing users of anomalies in the data patterns in their business
* 3 are skins

Another interesting dimension of analysis is the usage, measured in terms of downloads, which illustrated by the three charts below.




Finally, a key value of the Openbravo ecosystem is its continuity: it is very easy to port modules from one version to the next. This is illustrated by the chart below showing that 25% of the modules are already compatible with both 2.50 and the newly launched 3.0.


The next time you are evaluating an open source solution, consider its ecosystem as well. In the case of Openbravo, you will find 208 additional reasons to choose it as your ERP.

The Family Grid – part II

by Rob Goris

Simple, real-time business intelligence by manipulating grids

Reporting is an essential part of everyday business and therefore an essential part of an ERP. Today´s businesses need relevant, up-to-date, accurate and consumable metrics that help them make the right decisions. Traditionally, reports are generated once in a while (month, quarter) and are exported to PDF for printing & annotating or Excel for further manipulation. Reports are used in presentations and meetings to look at past performance, understand the status quo and project future performance. The danger lies in the choice of dimensions and the interpretation of the data. Reports are static and generated as a one-off document with a set of dimensions, normally defined by a ready-made SQL query or via a visual query builder. Openbravo´s Sales Dimensional Reports allow the user to choose a number of filters and dimensions and even the sorting order can be set. This works well if the user knows in advance what metrics she is looking for and what data set she wants to look at. The drawback is that it does not allow analyzing the data in realtime by changing the filters and dimensions and looking at the impact on the results while doing so.

A while ago, in the Family Grid, I have presented a fairly abstract idea for basic business intelligence functionality by combining parent and child data in one grid, joining grids and filtering and aggregating columns. Now, I´d like to show you a more simplified version of this idea.

The Family Grid II scenario (download it here) lets the user view sales orders in one grid and a set of order lines for all of these in the other. Both the sales order grid and the order lines grid can be filtered on any attribute using column filters. Columns containing numerical values can be aggregated (sum, count, average, median). The grids can be joined (inner or outer join) with the click of a button which, for example, lets the user find all sales order that contain a certain product (or all sales that do not contain that certain product). Final result sets can be exported to Excel or PDF and the view (which is in fact a query rather than a report) can be saved for reuse.

It should be noted that this approach does not intend to replace traditional reporting because many SQL queries just cannot be build using the Family Grid. However, I believe that this way of manipulating grids is very powerful and can lead to insights that can be hard to discover using traditional one-way reporting. Playing with a data set in real time using parent and child grids, filters, aggregations and joins with an easy-to-use GUI lets non-expert users unlock the power of data in an ERP without having to invest in hi-end business intelligent software.

Are you as convinced as I am about the business value of this feature? Discuss it here.

By the way, we´re not happy with the name of this functionality. Family Grid does not cover it really. What about RapidGrid, GridSift, PowerGrid, Data Distiller, Metrix, EasyAnswer, RapidAnswer, IntelliGrid, "Openbravo RapidEdge Edition – the fastest way to start a competitive edge", "PerfectGrid - the fast & simple way to your information"?




source:
http://planet.openbravo.com/