Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Mar 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    inventory system using asp.net

    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?

  • #2
    New Coder
    Join Date
    Feb 2006
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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...


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •