Hi
I need your help. I want to build a stock management inventory for the office. It is not a sale inventory, non-cash transactions. I want to have the total quantity of stock and employee can request stock via requisition slip; and as they request supply, it should be deducted from the total stock and shows the balances. Can someone help me get stable, cuz the database will be on a server
Example 1 in MS Excel
Stock Employee ITEM TOTAL QTY NAME DEPARTMENT Date QTY REQUESTING QTY BALANCE REMARK Sheet 20 Ream Mark Account Dept. March 1, 2015 2 Ream 18
How to deduct the Stock from Stock Order and get the balance each time employee request stock
Example 2
Please help with the Design
Office Stock
StockID
Stock Name
Stock Description
Stock Quantity
Stock Balance
RequisitionSlip (Employee)
ID
EmployeeName
Department
StockName
Quantity Requesting
Date of Request