View source | View content page | Page history | Printable version   

Projects:CostBasedPricelist/Technical Documentation


Cost Based Price List - Technical Documentation


This document will explain the approach to implement a solution to support Cost Based Price List.

Technical design

Database Changes

Table M_PriceList

Column Data Type Description
costbased CHAR(1 byte), Default (N) Corresponding to Cost Based Price List

Table M_ProductPrice

Column Data Type Description
cost NUMBER, Default (0) Corresponding to Product Cost

Table M_DiscountSchemaLine

Column Data Type Description
list_margin NUMBER, Default(0) Corresponding to Base Net List Price
std_margin NUMBER, Default(0) Corresponding to Base Net Unit Price
limit_margin NUMBER, Default(0) Corresponding to Base Net Limit Price

Stored Procedures

Stored Procedure m_pricelist_create

New logic to allow the creation of a price list beginning with the product cost. If you use cost based and do not have a price list base version the process add all products (excluding discounts products) existing in the organization and client.

Stored Procedure m_get_cost

New stored procedure that return the cost converted in the selected currency for the new costing engine and the previous cost in Openbravo ERP.

Window changes

Retrieved from ""

This page has been accessed 1,129 times. This page was last modified on 3 September 2012, at 10:11. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.