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

Projects:Price Inclusive of Taxes/Technical Documentation

Contents

Project Progress Report - Technical Documentation

Overview

This document will explain the approach to implement a solution to support pricelists that are inclusive of taxes.

Technical design

Database Changes

Table m_productprice

Additional Columns

Column Data Type Description
pricegross Numeric, Default(0) Corresponding to Gross Unit Price

Table m_productschemaline

Column Data Type Description
gross_base Numeric, Default(0) Corresponding to Base Price in calculating new Gross Price
gross_addamt Numeric, Default(0) Corresponding to Increment in calculating new Gross Price
gross_discount Numeric, Default(0) Corresponding to Discount in calculating new Gross Price
gross_rounding Numeric, Default(0) Corresponding to Rounding in calculating new Gross Price
gross_minamt Numeric, Default(0) Corresponding to min amount in calculating new Gross Price
gross_maxamt Numeric, Default(0) Corresponding to max amount in calculating new Gross Price
gross_fixed Numeric, Default(0) Corresponding to new Gross Price


Table c_orderline & Table c_invoiceline

Column Data Type Description
gross_unit_price Numeric, Default(0) Corresponding to pricegross in m_productprice for the product
line_gross_amount Numeric, Default(0) Corresponding to the gross amount for the quantity ordered

Java Classes

Stored Procedures

Window changes

Sales Order Window

- to also calculate the tax inclusive unit price when unit price changes - to calculate gross amount and net unit price when tax inclusive unit price changes


Same approach can be extended to the Purchase order window, Purchase invoice and Sales Invoice

Order Document

Same approach can be extended to the Purchase order window, Purchase invoice and Sales Invoice

Changes List

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Price_Inclusive_of_Taxes/Technical_Documentation"

This page has been accessed 3,770 times. This page was last modified on 8 June 2012, at 05:29. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.