Does anyone know of a way to to be able to update the base price of a rate sheet based on average cost.  I realize that I can achieve this at the time I add the IC item to the price list if the price list is set to markup on average cost.   But as the average cost changes due to buying more product throughout the year I can not see a method within Sage 300 to be able to have it update that price based on the current average cost - at least not through the update item pricing utility.

Does anyone know of a third party application, or even a SQL query that is available that may allow a client to periodically update their price lists based ona % markup from the average cost without visiting each item one at a time.