Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Every One,
I have Confusion in calculating Inventory Stock value using FIFO Concept. I have Attached the Excel File about my desired output.
Hi Jayaseelan,
Could u please elaborate more ...
saw attached xl it looks clumsy
Thanks
Hi,
Just by glancing at your XLS file i would assume that we have to precalculate buckets "OUT" for all buckets "IN"
I would do following steps:
This should be all done in script in order to allocate values properly.
regards
Lech
Thank for your reply,
FIFO Concept should be followed. First in comes item unit price should be calculated to first out item unit price.
Consider the following example,
Date ItemCode InQty OutQty unitprice Value
1/11/2016 12GH 5 10 50
2/11/2016 12GH 2 8 16
3/11/2016 12GH 6 10&8 58
From above example totaly i have 5 qty for 10rs as unit price 2 qty 8rs as unnit price. i need to calculate out unit price. 6 qty is out so i need to split the 6qty: 5 * 10 then 1 * 8 so my result is 58.
thanks,