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.  This is global, for all warehouses.  The AverageCost is stored also in the IM_ItemWarehouse, for each warehouse location.  These fields roughly approximate the "Coût Unitaire Moyen Pondéré"   which in English is known as the Weighted Average Cost. 

In my experience, it is quite likely that if you are using the European Version that a similar convention will exist in those databases with similar field names. 

If you are using other methods like PEPS/FIFO, DEPS/LIFO or lots, there will be a child table (for example, IM_LotSerialTransactionHistory) indicating the activity of these lots and you will have to find the open lots, but average cost is typically calculated by the system and is reported at the time the query is run, in relative real time.

I hope this helps

thank you very much for your answer!
i am using a french version of the software and did in the end found a WAC..... the result are slightly surprising though and I am looking into it....

appreciate your help and time!

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.  I just find there is too much volatility to drive pricing so I tend to use static pricing that I recalculate regularly so that pricing can be more consistent to the customer.

again thank you...
the static solution might be a solution although the number of items is quite important

Hello Rahan, we are also using a french version of SAGE and would like to know where did you find them ?

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 the link to the Sage 100 France Support Group:

https://www.sagecity.com/fr/sage-100cloud-france/f 

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 the link to the Sage 100 France Support Group:

https://www.sagecity.com/fr/sage-100cloud-france/f