Inventory Goods Receipt on moving average

[Former Member]

Dear all,

I would like to know what should be done to always receive items on the current moving average price on the transaction Inventory Goods Receipt

Currently, the system let the user choose a price list, but none of them is the average price.

I tried the Last evaluated price, but the value is not always the same than the moving average.

Logistic people will use this transaction, and they should not have any choice, and moreover, I don't want them to see his information.

Any idea ?

thank you

Sébastien

[former_member197621 · Accepted solution]

Hi,

By default no option, but you can achieve through below FMS,

If you have not enable "Manage Item Cost per Warehouse" in Company details then try this query

SELECT T0.[AvgPrice] FROM OITM T0

where T0.[ItemCode]  = (select $[IGN1.Itemcode])

If you enable "Manage Item Cost per Warehouse" in Company details then try this query

SELECT T0.[AvgPrice] FROM OITW T0

where T0.[ItemCode]  = (select $[IGN1.Itemcode])

and t0.WhsCode = ((select $[IGN1.whscode]))