Scenario
A user needs to know when and how to apply the Discount Items.
Solution
In applying a discount, here is what users should know and remember:
I. Know where to apply the discount:
a.) Is it to the entire Sales Order?
b.) Is it to specific item/s only?
II. Remember to:
a.) Populate the Discount Item Field if you want to apply the discount to the entire order
b.) Insert the discount item directly below the item you want to apply the discount to if you want to apply a line level discount (apply discount to specific items only)
See how it works by comparing the Summary of the Sales Orders or the GL Impact of the Invoices.
Discount Item for this demo:
I. APPLIED TO ENTIRE SALES ORDER
1.) On the Sales Order, look for the DISCOUNT ITEM FIELD under Items tab and populate the Discount Item. Here is how it looks like after saving:
2.) Generate the Bill/Invoice. Here is the GL Impact:
5% of the total amount of 60.00 (which is 3.00) can be seen in the Summary and shows as a single line in the GL Impact.
II. APPLIED TO SPECIFIC ITEMS
1.) On the Sales Order, enter the discount after each item. Notice that the discount rate is applied to the preceding item.
2.) Generate the Bill/Invoice. Here is the GL Impact:
The summary does not show the discount of 3.00 (sum of the 5% of each line item amount) as the discount was applied individually to each line item and not to the entire Sales Order amount. In the GL Impact, it shows 3 lines for each discount applied to the line items.
So if for example we intend to apply the discount to the second item only, here is the behavior:
Here is the GL Impact of the Invoice:
Some users get confused with how line level discount works and, at times, assume that the discount will apply to all items above the discount item. But we have to take note that it will only apply to the item preceding the discount line item as mentioned above.
If users want to apply the discount to a group of items, but not to all items, then we can use the Subtotal.
Insert the subtotal after the items you want to group.
I added another Subtotal after the third item simply to demonstrate that it will not consider the items before the first subtotal anymore.
I hope this helps! Any ideas you want to add related to this? Feel free to comment below.