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 in MS Excel
Stock Employee ITEM TOTAL QTY NAME DEPARTMENT Date QTY REQUESTING BALANCE Qty REMARK Sheet 20 Ream Mark Account March 1, 2015 2 Ream 18