I'm facing a serious problem now in my vb.net(VS 2005) project.
The problem is that I want to update automatically my stock when I enter the purchase voucher and keep the purchase voucher detail as well.
I can do everything except the automatic stock update.
YOUR VALUABLE HELP WILL APPRECIATED. "THANKS IN ADVANCE".
Jump to Post
We'll probably need more info on your project before we can offer any assistance, like what is your db, what have you done already (either in the purchase voucher details or the stock update) and what your tables look like.
Usually we prefer to keep 2 seperate stocks, the on-hand …
Jump to Post…
update stock set quantity = s.quantity + po.quantity from stock s inner join PurOrder po on s.items = po.items where po.POID = '2' update stock set quantity = s.quantity - so.quantity from stock s inner join SalesOrder so on s.items = so.items where so.SOID = '5'
All 8 RepliesReply to this topic
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.