First of all I'm using MS Access as my database... I have 4 tables in my database namely tblpo, tblsupplier, tbluser, tblstocks. The flow is the same as other inventory system. Add Stocks/Quantity during PO Entry and minus Stocks/Quantity during sales.
Adding Stocks is simple but my question is how to minus stocks during sales, I'm not really familiar with the coding. Hope somebody will help. Thanks
Kim
- Add new comment
- 12 views