### Title

How to keep track of Purchase Order Inventory Price Changes?

### Post

Hi,

Is there a way to have filemaker automatically change the cost of the product if the Purchase Order Cost is higher or lower when purchasing more stock?

For example, if you purchase 20 same items with the cost of $5.00 per item and in the sales/order layout you sell them for $10 per item, than you re-order when the stock quantity reaches 2 and the cost of the item now costs $6.25, which would mean that we would have to change the cost and price of the item via sales/order layout starting after quantity of 2.

I hope that is clear.

Thanks.

I'm not sure that I am understanding that. I can read it two ways. a) you want to be able to automatically adjust your selling price for an item when the purchase cost changes. b) you want the cost of the item to be controlled by the quantity purchased (different quantities = different unit costs).

My best guess is b).

Two methods are possible in theory, but you'll have to study your actual situation to see which works best for your particular business:

a) a formula (calculation) is used that takes the base unit price for a quantity of 1 and the actual quantity ordered and computes the adjusted unit cost.

b) a Table with multiple records is set up where you have multiple records for each product. Each record records a product ID, a unit cost, and the smallest qty that can be used to get that cost.

With a) you look up either the unit cost and apply the formula, or you look up both the unit cost and the formula to be applied (to have more than one formula for different classes of products) and compute the cost.

with b) you just look up the unit cost by matching the actual qty ordered against the table of products and minimum quantities. There are at least two different ways to set up auto-enter options to look up the price from such a table.