Item cost price - How to accomodate changing cost prices

Item cost price - How to accomodate changing cost prices

I am in urgent need of assistance with how to accommodate changing cost prices for items, not manually.

We import items so their landed cost is always changing. This cost is NOT reflected however in the item cost price. This is going to cause us some very, very serious issues when it comes to bundling items together as that works off the item cost price, not the item inventory value.

I cannot be updating hundreds of item cost prices manually every time a new shipment arrives. Surely there's a way to automate this? If so how?

I'm quote shocked that the system doesn't appear to automatically update the item average cost. This is a very basic requirement of any inventory module. Without accurate costing, how would any business expect to be able to analyse their margins?