Skip to Content
author's profile photo Former Member
Former Member

Inventory Goods Receipt on moving average

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Dec 08, 2013 at 10:56 AM

    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]))

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.