item cost

[former_member522789]

Hello

I am confused with last evaluated price and last evaluated price

It seems that item cost is the real item valuation which is correct, could you tell me which table or tansaction can I see the list per items of item costs to compare with last evaluated price and purchase price....

Besides why sales gross margin calculation can not be based on item costs

Thank you

Guillaume

[Former Member · Accepted solution]

Hai!

Item cost is stored in OINM Table as CalcPrice . This depends on Valuation method.

Gross Margin can be set based on Item cost, this is a setting left to users.

Go to Modules>Sys Initialization>Document settings.

You will a check book Gross Profit Margin that should be enabeled and in Base Orgin you have to map Item Cost instead Last evaluate price.

*Close the thread if problem solved

Regards,

Thanga Raj.K

[Former Member · Accepted solution]

Table OITM and OITW holds Item Cost for Moving Average items only i belive. For FIFO it won't hold.

Regards,

Thanga Raj.K

[former_member187989]

Thanks Thangraj,Really useful inputs.

Delone, Check Inventory Reports --> Item lists for price comparisons.

[former_member187989]

Clarify this statement

I am confused with last evaluated price and last evaluated price

Table is OITM with OITW.

Query to compare item cost with last evaluated & last purchase price.

SELECT DISTINCT T0.ItemCode, T0.ItemName, T0.DfltWH, T1.AvgPrice, T0.LstEvlPric, T0.LastPurPrc FROM OITM T0  INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode and
T0.DfltWH = T1.WhsCode

Edited by: Jeyakanthan A on Jun 17, 2009 10:56 AM

Edited by: Jeyakanthan A on Jun 17, 2009 10:57 AM