FIFO Inventory Valuation

ERPNext User Forum
1

Hello,

I am unable to understand the FIFO valuation of the stock in my inventory    

I used Stock Entry to receive 2 product batches on 1-1-2014 @ 08.00 AM

Batch 001 – 324 bottles @ $5.36 (valuation rate $5.36)

Batch 002 – 625 bottles @ $6.15 (valuation rate $5.88)

The valuation rate mentioned in the bracket comes from the Stock Ledger. My product is set at FIFO Inventory valuation.

I am wondering, why my second inventory batch is valued at $5.88 rather than $6.15? Am I missing something here?

Thanks in advance

Sarang

–

You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1526292d-650b-411a-8550-2040746535be%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

2
Valuation rate at Stock Ledger report shows average valuation rate for all available stock. It does not show for that batch. Calculation is like: ((324*5.34)+(625*6.15)) / (324 + 625). But in the backend it maintains a [[qty1, rate1], [qty2, rate2]] queue for fifo valuation.


On Aug 19, 2014, at 6:18 PM, Sarang <sa...@gmail.com> wrote:

Hello,

I am unable to understand the FIFO valuation of the stock in

my inventory    

<o:p></o:p>

I used Stock Entry to receive 2 product batches on 1-1-2014
@ 08.00 AM

Batch 001 – 324 bottles @ $5.36 (valuation rate $5.36)<o:p></o:p>

Batch 002 – 625 bottles @ $6.15 (valuation rate $5.88)

The valuation rate mentioned in the bracket comes from the
Stock Ledger. My product is set at FIFO Inventory valuation.

I am wondering, why my second inventory batch is valued at $5.88
rather than $6.15? Am I missing something here?

Thanks in advance

Sarang<o:p></o:p>


–

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1526292d-650b-411a-8550-2040746535be%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


–

You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CD825787-34F2-4A76-8FCB-ECCA37281254%40iwebnotes.com.

For more options, visit https://groups.google.com/d/optout.

3
That makes lots of sense.  I really like that.

Le mercredi 20 août 2014 12:51:18 UTC+2, Nabin Hait a écrit :
Valuation rate at Stock Ledger report shows average valuation rate for all available stock. It does not show for that batch. Calculation is like: ((324*5.34)+(625*6.15)) / (324 + 625). But in the backend it maintains a [[qty1, rate1], [qty2, rate2]] queue for fifo valuation.


On Aug 19, 2014, at 6:18 PM, Sarang <sa...@gmail.com> wrote:

Hello,

I am unable to understand the FIFO valuation of the stock in my inventory    

I used Stock Entry to receive 2 product batches on 1-1-2014 @ 08.00 AM

Batch 001 – 324 bottles @ $5.36 (valuation rate $5.36)

Batch 002 – 625 bottles @ $6.15 (valuation rate $5.88)

The valuation rate mentioned in the bracket comes from the Stock Ledger. My product is set at FIFO Inventory valuation.

I am wondering, why my second inventory batch is valued at $5.88 rather than $6.15? Am I missing something here?

Thanks in advance

Sarang


–

You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/1526292d-650b-411a-8550-2040746535be%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


–

You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/a14b3f9d-e633-45c3-928c-de64433d839c%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.