Loading

Add new comment

Thu, 03/11/2010 - 11:14
Kim
Offline
Joined: 03/08/2010
Reply

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

More information about text formats

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.