Available in Sage 50 Quantum Accounting.
Example of Rounding When Quantity Discounts and Multi-Packs Are Used
Together
How Do I...
Let's look at an example of how a Quantity Discount is calculated and
rounded when an inventory item is sold as a Multi-Pack unit. The example
below incorporates the following three conditions:
- You are selling an inventory item that has a Quantity
Discount applied to it.
- When you created the Quantity Discount, you selected
to round the final unit price.
- You are selling this inventory item in Multi-Pack
units.
In this example, let’s say that you’re selling an item that has an original
sales price of $10.00 per unit. Let’s also say that you’ve applied a Quantity
Discount to this item that gives customers a 5.55% discount if they order
six or more of the item, and that you’ve chosen to round the discounted
unit price to .50. You've also created a Multi-Pack unit for this item,
so that you can sell them in six-packs.
Here's how Sage 50 calculates and rounds the unit price:
- Sage 50 starts with the original price of the
item. In this case, $10.00.
- Next, the Quantity Discount is calculated. In
this example, the customer ordered a six-pack of the item, so they receive
the 5.55% discount. Now the unit price drops from $10.00 per unit to $9.445
per unit.
- Once the Quantity Discount is calculated, the
unit price is rounded. In this case, $9.445 is rounded to $9.50 since
the specific cent value of .50 was entered in the Maintain Quantity Discounts
window.
- Now the unit price of $9.50 is multiplied by the
number of units sold (in this case, six) which equals a total price of
$57.00.
As you can see in this example, the rounding occurs directly after the
Quantity Discount is calculated. It is the unit
price that gets rounded—not the total price.
What do you want to do next?