In the example image below, I’m a bit confused. Based on my understanding, the total outgoing value should be the sum of the Raw Materials in the document. However, while the total Raw Materials is 15,476, the total outgoing value shows 27,635.42. I’m trying to understand why there is such a difference.
You’re seeing this difference because ERPNext does not use the Basic Rate shown in the Stock Entry table to calculate the outgoing value.
That Basic Rate is only for display.
ERPNext actually uses the valuation rate from your stock ledger, which is based on:
-
previous purchase prices,
-
FIFO or moving average,
-
landed cost charges,
-
old stock adjustments,
-
and any earlier repack/manufacture entries.
So even though the raw materials listed total around ₱15,476, ERPNext is calculating the outgoing stock based on actual historical cost, which comes out to ₱27,635.42.
3 Likes
Thank you @shaileshsaini!
1 Like