UDF for FIFO Valuation of Inventory

**vandanavai** · 09-22-2007, 02:47 PM

Hello Everybody,

I found this UDF called as FIFO on internet . I tried to use it. This UDF calculates inventory value on FIFO basis. It worked perfectly excet in one instance( marked in yellow colour in attached file.) can anybody help me what is wrong. I understand VB very little. Can record macros but no difficult programming. This UDF will help me a lot if this problem is solved.

Can anybody help me?

**rylo** · 09-22-2007, 11:23 PM

Hi

How are you calculating your value for PQR? To me it should be

=(C6+D6-F6)*E6+D12*E12

which brings back the UDF result. This calculation (adjusted for the row numbers) matches the other calculated results.

rylo

**aromaveda** · 08-17-2009, 11:19 AM

Vandana,

I need a similar function but i need to calculate COGS of sold goods also along with inventory valuation. I am unable to see the FIFO Code, would you please let me know?

Thanks
Sanjay

**royUK** · 08-17-2009, 11:42 AM

aROMAVEDA
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.