Projects:Price Inclusive of Taxes/Technical Documentation

Contents 1 Project Progress Report - Technical Documentation 1.1 Overview 1.2 Technical design 1.2.1 Database Changes 1.2.1.1 Table m_productprice 1.2.1.2 Table m_productschemaline 1.2.1.3 Table c_orderline & Table c_invoiceline 1.2.2 Java Classes 1.2.3 Stored Procedures 1.3 Window changes 1.3.1 Sales Order Window 1.3.2 Order Document 1.3.3 Changes List

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

Changes List