help with Control stock database

[Nelson Barros]

hi to all, i'm trying to build a database with the balance of products in my lab, (ex: i have 50 bikers and i buyed 10 more and 2 are broken, so i have 58 bikers, but i buyed 5 more and now i have 58 + 5) I tryed to do this, but always i put another value i loose the older one, so i never got the total of produts, How can i do that database?

Thanks for your help in advance!

[transpower]

What's a biker? A beaker? There are lots of ways to do this. One would be to have these fields: original_stock, new_stock, broken_stock, total_stock. Total_stock = original_stock + new_stock - broken_stock. Here you would manually update new_stock and broken_stock; total_stock would be a calculation field. Of course, this could be made vastly more sophisticated.

[Nelson Barros]

Thanks transpower, you are right, thats a beaker, not a biker! But that was i tryed to do at the beggining, but, allways i put a new value in the new stock or the broken stock, the total stock updated without the oldests values from the new and broken stocks (like: original =250; New (1) = 10; broken (1)= 5, total= 255, but whwn i put a new value, new = 20, there is total=265 and must be 275) I'm clear now?

Thanks again for your help, and sorry for my english!

[mushroom]

Hi,

I have a stock control system with Invoices, Line items and products. I have a total in the Products file of how many I have in stock.(nowstk) I can see in the Invs. and line Items the amount taken away after someone has ordered (currentstock) i.e nowstk-LineItems::quantity.

Any ideas how to get that to show (and be current) in the Products file so I can make a list for end of year stock take?

The Invoices and Line Items records are in portal rows

Thanks in advance