topic Re: how to claculate openig and closing stock in inventory in QlikView

how to claculate openig and closing stock in inventory

ferha_jafri — Mon, 18 Nov 2013 10:34:23 GMT

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

Re: how to claculate openig and closing stock in inventory

spividori — Mon, 18 Nov 2013 13:19:04 GMT

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.

Re: how to claculate openig and closing stock in inventory

ferha_jafri — Tue, 19 Nov 2013 06:20:38 GMT

if possible could you plz forward that application.

Re: Re: how to claculate openig and closing stock in inventory

spividori — Tue, 19 Nov 2013 13:40:27 GMT

Hi.

Here is my application.

You can ask me for help whenever you want.

Regards.

Re: how to claculate openig and closing stock in inventory

ferha_jafri — Fri, 22 Nov 2013 10:06:36 GMT

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

Re: how to claculate openig and closing stock in inventory

vikasmahajan — Fri, 22 Nov 2013 10:24:42 GMT

PFA OF SAMPLES I HAVE IF IT COULD HELP YOU.

GOOD LUCK

VIKAS