how to claculate openig and closing stock in inventory

[ferha_jafri]

Hello everyone,

I am facing an issue in calculating opening and closing stock for inventory application.The issue is i want to calculate stock in hand at the end of the date as suppose i want to calculate SIH for 10/oct/2013 that will be the transcation happend on 10/oct/2013 + SIH for 9/oct/2013.This is very urgent.

Please suggest what needs to be done

With regards

Ferha Jafri

[spividori]

HI.

I have an application in which the calculation of the inventory performed day by day.

This way I can know the inventory of each item to the date I want. If it helps you could upload a sample data and and I will try to show you How to do it.

Regards.

[ferha_jafri]

if possible could you plz forward that application.

[spividori]

Hi.

Here is my application.

You can ask me for help whenever you want.

Regards.

[ferha_jafri]

Hello Sandro,

Thank you so much for your help , i need your help and it is very very urgent , the issue is that we have to divide Forecast stock with SIH summation for different items ,the problem here is that when we are performing WTD is is didviding it wit complete summation of stock in hand although it should be like SIH for one item + SIH for another item and so on... plz help it is very urgent

[vikasmahajan]

PFA  OF SAMPLES I HAVE  IF IT COULD HELP YOU.

GOOD LUCK

VIKAS