Discounts

Visual Catpro

Different Discounts :

You may apply different discounts in an invoice. You may apply discount on total amount as well as item wise discount.

Discount on Total amount:

To apply discount on total amount add 'DISCOUNT' column in Doc Totals You may apply discount in % or in rupees. 'DiscountAmt' field is for printing discount amount and 'DiscountRate' is for printing % of discount.

You may also add CASH_DISCOUNT in Doc Totals for giving more discounts on total amount

Item Wise Discount:

Some times it is required to give different discounts on different items in an invoice. In such case you may add desired columns in Doc Columns. Here is the list of columns and their significance which may be used to give item wise discounts.

Column	Description	Field
DISCOUNT	This column may be added if you want to give discount in %. It reduce the amount in given %.	VDiscount (r99)
DISCOUNT_PERPC	This column may be added if you want to give discount on per unit in rupees. It reduce the amount to (RATE - DISCOUNT_PERPC) * QUANTITY	VDiscountPer (r99)
DISCOUNT_AMT	You may add this column to see the discount amount if you are giving discount in %.	DiscountAmt (r99)
ABSOLUTE_DISCOUNT	This column may be added if you want to give discount in rupees. It reduce the amount to AMOUNT - ABSOLUTE_DISCOUNT.	VDiscountAmt (r99)

Sometimes we want to give different discounts on different items but we want that sum of discount amount should appear in the totals. In such a case you have to add BOTTOM_DISCOUNT in Doc Columns and in Doc Totals.

Database Field: "BottomDiscountAmt"(r1)

Same way you may also use BOTTOM_DISCOUNT2 in DocColumn & DocTotals to give more discount.

Database Field: "BottomDiscount2Amt"(r1)

Other Discounts:

Sometimes we want to give discounts where we want decrease the rate according to discount %. In such case you may add 'txpAdjDiscount', 'txpAdjExtraDiscount', 'txpAdjSplDiscount' fields in Doc Inputs. You may also have to add 'REVISED_RATE' column in Doc Columns. Visual Catpro reduce the rate to specified discounts and fill the rate after discount in REVISED_RATE column. If REVISED_RATE column exists then amount will be calculated on revised rate instead of rate.