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

Projects:CostBasedPricelist/Technical Documentation

Contents

Cost Based Price List - Technical Documentation

Overview

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 "http://wiki.openbravo.com/wiki/Projects:CostBasedPricelist/Technical_Documentation"

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.