inventory management problem
From: prabuinet <prabuinet_at_gmail.com>
Date: 14 Oct 2006 05:27:36 -0700
Message-ID: <1160828856.673553.282000_at_i3g2000cwc.googlegroups.com>
I have two tables:
Date: 14 Oct 2006 05:27:36 -0700
Message-ID: <1160828856.673553.282000_at_i3g2000cwc.googlegroups.com>
I have two tables:
purchase (ItemId, PurchQuantity, PurchaseDate); sales (ItemId, SalesQuantity, SalesDate);
With these two table could I able to find:
- Quantity in Stock at any given date of any item.
- Purchase and Sales and their OpeningStock and ClosingStock Report
If i could not do it, can I maintain a table like this
StockLevel (ItemId, OpeningStock, ClosingStock, AdjustedQuantity, TransactionType);
where transaction type = purchase/sales.
- the problem i'm facing with this table is i want to update this table each and every time the purchase or sales table is updated.
- purchase or sales transaction can be inserted, deleted or updated for any date, this makes this table more complex. forex:
please give me any suggestions or better solutions,
Is there any smart way to handle these kinds of transactions.
thanks in advance Received on Sat Oct 14 2006 - 14:27:36 CEST