J
John Paul Angala Pigao
Here is an idea hoping from some help from you guys.
This is regarding my Inventory Database that i would like to implement in
our small office. Now i have a table for the Main Stock with Item ID, Item
Description, Beginning Balance, Qty on Hand. I also has another table called
Issue Voucher where qty will be deducted to the main stock. I also has
another table called Purchase Received where qty will be added to the main
stock.
Before i try to input a code in the Main Stock form On Current (Event
Procedure)
Me.QtyonHand = Nz(Me.Begbal, 0) + Nz(DSum("QtyIssued",
"tbl_PurchasedReceivedTransaction_Details", "ItemID = " & Me.ItemID & ""), 0)
- Nz(DSum("QtyIssued", "tbl_Transaction_Details", "ItemID = " & Me.ItemID &
""), 0)
But the problem is qty on hand will just be updated if i go to the main
stock form and look for the specific item. But if i make a transaction in the
Issue Voucher and go directly to the report qty on hand will not be updated.
Now i came up in this idea. Would it be possible to input the code above in
the Issue Voucher Form so that every time i make transaction qty on hand will
immediately be updated without going to the main stock form.
Please help me....
Thanks in advance.
John Paul Angala Pigao
This is regarding my Inventory Database that i would like to implement in
our small office. Now i have a table for the Main Stock with Item ID, Item
Description, Beginning Balance, Qty on Hand. I also has another table called
Issue Voucher where qty will be deducted to the main stock. I also has
another table called Purchase Received where qty will be added to the main
stock.
Before i try to input a code in the Main Stock form On Current (Event
Procedure)
Me.QtyonHand = Nz(Me.Begbal, 0) + Nz(DSum("QtyIssued",
"tbl_PurchasedReceivedTransaction_Details", "ItemID = " & Me.ItemID & ""), 0)
- Nz(DSum("QtyIssued", "tbl_Transaction_Details", "ItemID = " & Me.ItemID &
""), 0)
But the problem is qty on hand will just be updated if i go to the main
stock form and look for the specific item. But if i make a transaction in the
Issue Voucher and go directly to the report qty on hand will not be updated.
Now i came up in this idea. Would it be possible to input the code above in
the Issue Voucher Form so that every time i make transaction qty on hand will
immediately be updated without going to the main stock form.
Please help me....
Thanks in advance.
John Paul Angala Pigao