Search
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
First of all elaborate well what you want. Kse pag sinabi mong Inventory, ndi kasama ung sales at ung supplier.
At pag sinabing inventory, Available stocks, Receive stocks and Release stocks. Inventory ay Stock in and Stock out un lng.
Hi thanks for the reply.
The inventory system that I created involves sales transactions.The sales transaction is where Stock-out comes in and Stock-in when you create a PO and then receiving the item. The supplier there is just an additional information or a feature for the report just for tracking purposes.Now, I just want to ask some ideas on how to subtract quantity available from quantity to be sold.
In my database the quantity/item added is stored at tblpo. Cuz it as added during the PO entry and receving the item. And the to be subtracted at quantity in tblstocks. So there are 2 tables involved. I really need help on how to subtract from tblpo to tblstocks.
Thanks
Kim
Hi Kim! Did u already find a solution to ur problem?
If not, u can try this one.
=== this is a query to get the total received during PO, total sold during sales and the remaining qty - the link for the two tables is the "ITEM" ===
SELECT a.item_code, sum(a.receive_qty) as total_quantity, sum(b.sold_qty) as total_sold, (sum(a.receive_qty) - sum(a.sold_qty)) as remaining_qty
FROM TBLPO a left join TBLSTOCKS b ON a.item_code = b.item_code
GROUP BY a.item_code
=== don't be confuse on "item_code, receive_qty and sold_qty", I juz made it up hoping that was the fieldname on ur tables.
If you have question/clarrifications, you can send me a mcgs.
Hope this help!
I tried to reply yesterday night but I didn't make it.
Here are some photos of my very first Inventory system. This is not a POS of Sales Inventory.
This system Includes the Inventory (current stocks), Receive and Release. As you can see the Receive and Release are similar to each other, but it is different ^_^
Hi thanks for the reply.
The inventory system that I created involves sales transactions.The sales transaction is where Stock-out comes in and Stock-in when you create a PO and then receiving the item. The supplier there is just an additional information or a feature for the report just for tracking purposes.Now, I just want to ask some ideas on how to subtract quantity available from quantity to be sold.
In my database the quantity/item added is stored at tblpo. Cuz it as added during the PO entry and receving the item. And the to be subtracted at quantity in tblstocks. So there are 2 tables involved. I really need help on how to subtract from tblpo to tblstocks.
Thanks
Kim