getting closing stock

[manoj9849967222]

Hi All

I require a urgent help. I have three tables

1. Inward
2. Outward
3. Product

I have different products around 30 nos.

Now when ever there is purchase i enter in the Purchase Table & when ever there is sales i enter in the sales table. Now at month end i want stock report
which is closing stock = purchase - sales. I want this Item wise.

For example

product a = 20nos
product b = 10 nos

Is there any way to do this.


Please help.

Regards
Manoj

[nico5038]

The general approach for this is to store the StockQuantity in the Product table.
This will allow for consolidating the real-stock with the administrative stock e.g. once a year and will prevent your database from flooding with Sales and Purchases records. (Also a common practise to do a warehouse stock count :-)

To get your report just create a GroupBy query linking the product (with the stock qty) with the Sales and Purchases and sum the sales amount and the purchase amount using Year(datefield) and Month(datefield ) function to be able to calculate the monthly flow.

Getting the idea ?

Nic;o)

[manoj9849967222]

Thanks for your help

Let me check how it workes

Regards
Manoj

[nico5038]

Keep me posted and don't hesitate to ask more :-)

Nic;o)