Discounts from vendors on purchase orders

I am using Quickbooks Premier 2004. I purchase inventory from a vendor that offers a 25% discount for certain items if you purchase more than 6 in an order. A typical invoice will list all qualifying items first (at their normal prices) followed by one line listing the total for all above items before the discount is applied. The next line is a negative amount subtracting the 25% discount for all above items. Any items not qualifying for a discount are then listed at normal price on the invoice. I cannot find a way to reflect this discount when receiving items in Quickbooks without manually calculating the discount on each item and overriding the cost from the original purchase order. I tried to create a discount item and use it on the purchase order the way you do on a sales receipt, but it just put the total discount into a discount account, left my COGS at the normal prices and resulted in bad data for COGS and gross margin in the Sales by Item report. Is there a better Quickbooks product that would allow me to enter two costs for an item in inventory or solve this problem without so many manual calculations? Thanks!

Reply to
Nancy
Loading thread data ...

You can look at various add-on products if you wish, but how much is it really worth to you? Unless you're entering many such items every day, the following keystrokes don't seem that onerous:

- Click or tab to the price.

- "End" *0.75 If the items follow each other, "down arrow" to the next price, otherwise click or tab and repeat.

I'm not aware of a better solution.

Reply to
!-!

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.