How to apply Fifo method?

[mahaveersomani]

i had a problem regarding fifo method.......can anyone help me on this.....i have attached my file here........and had write my problem in the same file......

i had tried so much but i did not get any solution on this......any one can help me.....

any help would be much appreciated......

Thank in Advance.......


Regards
CA Mahaveer Somani

[:) Sixthsense :)]

The data structure is so bad it can be done easily with the help of pivot table if you keep the data in proper way. just one question how C12 should need to have 10?

[mahaveersomani]

in my example i issue 25 units .......as per fifo method there would be issued first =10 then second =5 and then third = 10 so that total issued qty should be equal to the user issued qty = 25.

and if it is so easy in pivot table then can you tell me how........please?

Regards
CA Mahaveer Somani

[:) Sixthsense :)]

I have restructured the data and automated the process with the help of Worksheet Functions and Pivot Table

Please refer the attached file for details.

[mahaveersomani]

actually i am unable to understand how to use this table therefore...........now i make it as follows: check the attached file........


and really thanks @sixthsense but actually i dont know how to use.........it?

now you can compare which file is most useful for me..........tell........?

Regards
CA Mahaveer Somani

[:) Sixthsense :)]

Oh if that is the case then sorry I cannot assist you further since I given my best

[mahaveersomani]

my friend it is totally solved file which i have uploaded here..............by the way..........


many many thanks for your valuable time.........but what you send me i dont know......how to use that file.........even i was thinking from where i should start..... ha ha ha .....how i m duffer.......!!!

Thanks bro.......
Regards
CA Mahaveer Somani

[:) Sixthsense :)]

Change the A2 Or B2 cell value of Pivot Sheet and check what's happening.

I just included a simple code to refresh the pivot whenever any change happens in A2 or B2 cell value of Pivot Sheet.

I have given my last best output for you

[mahaveersomani]

thanks but still there is so much pendency my friend.............if i write pen then it shows pen only if i write book then its shows books only.........but i need commuted data.........

thanks leave this topic..........
file which is given u last time was solved file..........

Regards
CA Mahaveer Somani