By using this website, you agree to our Terms of Use (click here)
So our company has deals with some of our vendors where purchasing a set amount causes the price per unit to change. We are wanting to make it so we don't have to manually change the cost per unit any time we make a purchase to these vendors. Is there a way to have the price per unit/item to change based on how much is being purchased?
Example: If less than 20 items it costs $6.25 per item, 20 or more is $5.75 per item, and if total cost exceeds $3000 it costs 5.25 per item.
We are hoping that the Unit Cost field will auto update based on the Order Qty. field when we are adding the item to the PO.
Screen ID AP202000 using break qty's will take care of item price under / over qty 20. The total cost is that a line total cost? if so you could use the same method.
Thanks @carl-brooks Break qty solves the by amount problem, but we are trying to find a solution where if we purchased 4 Stock items from the vendor at same time and the total cost exceeds it will trigger the 3rd, cheaper, price.
Example: Stock item 1 we buy $700 of product, item 2 we buy 900$ of product, item 3 we buy $800 of product and item 4 we buy $1000 of product. So we have a total of $3400 of total product in one purchase. If this should happen the total cost of the PO will trigger the prices to switch to option 3 on cost for our vendor.
Is there a way to make a Break Cost on the PO or does it only work on stock for vendors on AP20.20.00?
I can't think of a way to do this unfortunately. On the customer side, you could accomplish something like this with Discounts. But I can't think of a way to do it on the Vendor side.