...

View Full Version : inventory system using asp.net



fadodz
04-17-2007, 04:44 PM
hey everyone...
did anyone know about an actual line cost calculation use in inventory system. i am developing an inventory system that use to calculate the stock age, alert the admin when the stock come to certain amount and to calculate the stock cost. the actial line cost is when we buy the certain product in certain amount, then the price is keep change every month. for example:

Before order
Product Code Description Qty
12345 Paracetamol 200
12347 Lactulose 3

Order
Product Code Description Qty
12345 Paracetamol 10
12347 Lactulose 1

After order
Product Code Description Qty
12345 Paracetamol 210
12347 Lactulose 4

Supposed to be
Product Code Date Arrived Description Qty
12345 31/01/2006 Paracetamol 200
12347 31/02/2006 Lactulose 3
12345 3/08/2006 Paracetamol 10
12347 3/08/2006 Lactulose 1


did anyone know about this type of calculation?

rosehabib
04-19-2007, 02:42 AM
Before order
Product Code Description Qty
12345 Paracetamol 200
12347 Lactulose 3

Order
Product Code Description Qty
12345 Paracetamol 10
12347 Lactulose 1

After order
Product Code Description Qty
12345 Paracetamol 210
12347 Lactulose 4

Supposed to be
Product Code Date Arrived Description Qty
12345 31/01/2006 Paracetamol 200
12347 31/02/2006 Lactulose 3
12345 3/08/2006 Paracetamol 10
12347 3/08/2006 Lactulose 1

---------------------------------------------------------------------

so, the result supposed to be the last one rite?

what u need to do is when u order the new item, u just need to insert the detail without sum up the total item.
then, to retrieve the item back, just call from database and sort it based on date arrived.

i think that's all to do...
may be u can try this solution...



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum