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)