Historical Log For Inventory?
Example of work:
# of current supplies we have as of October 12, 2004
10 toners
12 boxes of legal papers
11 transfer belt
I will set up web-based form to let employee to reduce the quantity when they took it out from the supply room. It is kinda easy to update the information. But how can I have the historical log so that we can see how much was used in the last event such as few days, weeks, months, etc.. as a whole or individually.
View Replies
I 'm collecting some data based on users that logged in.
Table:
userid
last_logon_date
amount_of_login (increment + 1)
At the moment i only collect the data as it is nothing more. but i need to now be able to keep the data on a monthly basis. What would be the best approach. If i inserted the data into another table and timestamped it as the current month/year. Then once the data has been inserted reset the current logons count to 0. Would this work or i'm just wasting time trying to be adventurous.
View Replies
View Related
I have written a script to take inventory of PCs on my
network in an excel spreadsheet. I want it to be available whenever
wherever needed by my managers and other accounts/purchase people. Is
there any way possible that I can put it on my intranet website using
ASP...???? Code:
View Replies
View Related
our cart is comersus system db is ms sql.I am sure I will have to create a new page. I am BRAND new to asp. I have been doing vb for desktop. Please help or refer me to a link for details.
View Replies
View Related
I am currently printing out order details for products that our warehouse are shipping. I have just started adding barcodes to these forms for each product.
How difficult is it going to be allow people working in the warehouse to scan the bar code for the products. This in turn should update the database and send an email to the customer to tell them that the product is being shipped?
Hope you can help with some ideas - are there any commercial products possibly?
View Replies
View Related
Below is the function which is called when user clicks add to cart. I need to check inventory to make sure it is in stock when added. Is Javascript the right thing to use or should I write something in ASP? I'm not sure I'm up to the challenge and may need to pay someone to write it, explain it to me, and then help me implement it. Sounds simple enough.
View Replies
View Related