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
- The new fields ( tax inclusive unit price , gross amount) are to be shown in the order line and will be editable if the pricelist is inclusive of taxes.
- The call-out that is called on changing the unit price will have to be changed
- 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
- A new call-out to calculate unit price from tax inclusive when tax rate changes and vice-versa.
Same approach can be extended to the Purchase order window, Purchase invoice and Sales Invoice
Order Document
- Change the iReport Order document to show the inclusive of tax price if the price list is inclusive of tax. Also do not show the tax details before the gross price of the order is calculated
Same approach can be extended to the Purchase order window, Purchase invoice and Sales Invoice