Nobody/Anonymous - 2003-09-29

the main thing I'm looking for is a MySQL and php based on-line system that gives user acces to view a certain stock-situation of a specific item.
In other words: users with differten abbilities should see what item is in stock and for what reason.

eg.
a user sees that there's 100 x art.8890 in stock and wants to reserve 20 pcs. He then does so by giving in a reservation for these 20 pcs. maybe together with some other reservations. A second visitor now must only see the 80 pcs. available left.

when we sent out these 20 pcs. they really will be gone.

but!
with every reservation or order or shipment or edit or whatsoever that is being made, there allways must be a reference or ordernumber given that also (if that isn't enough) must display the last 4 or 5 'historical' changes which may not be edited anymore

so in the end the screenview must say
1. art.nr 8890    100 pcs
2. art.nr 8890      80 pcs     last ref. 77492877748
3. art.nr 8890      15 pcs     last ref. 88098435t56
4. art.nr 8890     120 pcs     last ref. 78u9378744

so... you also must be able to add stock.

all of this is needed to show several customers online what a specific stock cotains at that moment.
when stock is tkaen back, or bought back, the it must be very easy to add again.
for that reason it would be great to just say... + 20
or -10

I hope this rather complex idea is clear to everybody and has ideas on what to use, or where to seek...