Skip to Content
0
Former Member
Jan 19, 2012 at 04:50 AM

STOCK REPORT FIFO wise

62 Views

Hello to ALL

I want stock report FIFO WISE

my Item valuation method is FIFO & Purchase & sale by batch wise,i want report to show that which quantity is remaining & what is the cost for that item

Suppose i purchase I01 qty 2 Price 10 & after i purchase I01 Qty 2 price 15

ie i have stock of I01 is 4 but i want it show bifurcated with coming price ie

ItemCode Qty Price STCK VALUE

I01 2 10 20

2 15 30

If i sale I01 1Qty then i have total stock qty is 3 then report must show that

ItemCode Qty Price STCK VALUE

I01 1 10 10

2 15 30