Dear All,
we have one issue.
x item as of march 31st inventory closing qty :850,486 amount : 3,727,632.23 avg price : 4.38
X item consumption posted in April qty : 709,943 Amount : 2,716,591.81 avg price : 3.82 why it took 3.82 it should be 4.38
at the time of posting it took 4.38 only but in April closing it settle with 3.82 .
So after closing April qty: 140,543 amount : 1,011,040.42 avg price : 7.21 showing.
why it was settle like this even did not receive any qty in April.
Item model group : FIFO Closing method : Weighted avg
please help us to solve this.
Thanks
Ashok