J
John Paul Angala Pigao
Please help me calculate quantity inside two separate forms to go to the Main
Stock Form. First, i have a form name Issue Voucher and inside it is a
subform name IVTransactionDetails. Second, i have form name Received Voucher
and inside it is a subform name PRTransactionDetails. Third, I have a Main
Stock Form and we there item id, description, beginning balance and on Hand.
I want to deduct the qty issued in the Issue Voucher Form and add quantity in
the Received Voucher form. Now what i have done is that in the Main Stock
Form i input this command in the On Current (Event Procedure).
Me.QtyonHand = Me.Begbal + DSum("QtyIssued", "PRTransactionDetails", "ItemID
= " & Me.ItemID & "") - DSum("QtyIssued", "IVTransactionDetails", "ItemID = "
& Me.ItemID & "")
But the problem is that when you add qty in the Purchase Received form and
didn't input any quantity in the Issue Voucher for that particular Item ID
will not display anything just a blank field. But if you input qty in the
Issue Voucher and ReceivedVoucher both at the same time qty will be
calculated in the on Hand field of the Main Stock Form.
How can i fix this problem? Can i calculate the on Hand both ways? I mean if
i input data in the Purchased Received Voucher and didn't in the Issue
Voucher it will still calculate and/or vice versa.
Also one more thing would it be possible to make this qtyonhand updated even
if you run a report? Because what is happening right now i need to open the
Main Stock form and update from there the quantity on hand before you will
see the updated on hand in the report. If you run the report without updating
in the Main STock form the qty on hand will never change.
Please help...Thanks in advance.
Stock Form. First, i have a form name Issue Voucher and inside it is a
subform name IVTransactionDetails. Second, i have form name Received Voucher
and inside it is a subform name PRTransactionDetails. Third, I have a Main
Stock Form and we there item id, description, beginning balance and on Hand.
I want to deduct the qty issued in the Issue Voucher Form and add quantity in
the Received Voucher form. Now what i have done is that in the Main Stock
Form i input this command in the On Current (Event Procedure).
Me.QtyonHand = Me.Begbal + DSum("QtyIssued", "PRTransactionDetails", "ItemID
= " & Me.ItemID & "") - DSum("QtyIssued", "IVTransactionDetails", "ItemID = "
& Me.ItemID & "")
But the problem is that when you add qty in the Purchase Received form and
didn't input any quantity in the Issue Voucher for that particular Item ID
will not display anything just a blank field. But if you input qty in the
Issue Voucher and ReceivedVoucher both at the same time qty will be
calculated in the on Hand field of the Main Stock Form.
How can i fix this problem? Can i calculate the on Hand both ways? I mean if
i input data in the Purchased Received Voucher and didn't in the Issue
Voucher it will still calculate and/or vice versa.
Also one more thing would it be possible to make this qtyonhand updated even
if you run a report? Because what is happening right now i need to open the
Main Stock form and update from there the quantity on hand before you will
see the updated on hand in the report. If you run the report without updating
in the Main STock form the qty on hand will never change.
Please help...Thanks in advance.