Rahan, are you referring to the American Sage 100?  In the American version, Sage actually recalculates and stores the average cost of product in stock in the CI_Item table in the field AverageUnitCost…

If you are from France and using the French version of Sage 100, you may want to ask your question there as this particular forum is for the US version of Sage 100, which is a different product.

Here is…

Hopefully the results are good enough.  Most of the time this data is real time however, and the process to calculate it historically is unduly complicated.  But it should be relatively valid for pricing…