Print Discount from SU13/Invoicing
The Print Discount field dictates how Discount is calculated which impacts the Invoice Line Extension as well as how Discount is presented on the printed invoice.
- When the Print Discount check box is selected (i.e. Print Discount is ON), the discount percent is applied (Qty x Price) to get the extended discount amount which then reduces the line extension. On the printed invoice, the regular selling price is printed along with a discount 'code' followed by the discounted line extension. The discount 'code' is cross-referenced in a legend that is printed at the bottom of the invoice that explains the discount percent applied to the invoices lines.
- When the Print Discount check box is not selected (i.e. Print Discount is OFF), the discount percent is applied to the selling price to get the discounted selling price; then (QTY x Discounted Selling Price) to get the line extension. On the printed invoice, the discounted price is printed and extended; there is no discount code or discount legend printed.
The calculations produce slightly different line extension totals. Note: Order value line extension uses Qty Ordered in the calculation; the invoice line extension uses Qty to Ship in the calculation. Here is an example to illustrate the two scenarios:
- Print Discount is selected for our customer:
Product |
Qty order |
B/O |
To Ship |
Price |
Discount |
Extension |
ABC |
27 |
0 |
27 |
259.38 |
12.5 |
6127.85 |
- The Discount 'Amount' is calculated as follows:
[(Qty x Price) x Discount] / 100
[(27 x 259.38) x 12.5] / 100
(7,003.26 x 12.5) / 100 = 875.41
- The Line Extension is calculated as follows:
(Qty x Price) - Discount Amount
7,003.26 - 875.41 = 6,127.85
- Print Discount is NOT selected for our customer:
Product |
Qty order |
B/O |
To Ship |
Price |
Discount |
Extension |
ABC |
27 |
0 |
27 |
259.38 |
12.5 |
6127.92 |
- The Unit Discount 'Amount' is calculated as follows:
(Price x Discount) / 100
(259.38 x 12.5) / 100
3,242 / 100 = 32.42
- The Discounted Price is calculated as:
Price - Unit Discount 'Amount'
259.38 - 32.42 = 226.96
- The Line Extension is calculated as follows:
Discounted Price x Qty
226.96 * 27 = 6,127.92
To recap, when Print Discount is selected, the Discount is calculated on the (Qty x Price) extension. When Print Discount is NOT selected, the Discount is applied to the unit price and then the line is extended.
|