Description |
UPDATE CC
SET CC.dblActualAmount = tblBilled.dblTotal
FROM tblCTContractCost CC
JOIN (
SELECT intContractCostId,SUM(dblTotal) dblTotal
FROM tblAPBillDetail
WHERE intContractCostId > 0
GROUP BY intContractCostId
) tblBilled ON tblBilled.intContractCostId = CC.intContractCostId
STEPS:
# Create One Contract with Cost.Initially the Actual Amount of the Cost line will be blank.
# Create a voucher by clicking Add Payables button.
# Post the Voucher.
# Open contract
ISSUE: Actual Amount of Other Cost is blank
ACCEPTANCE: The Actual Amount Should Populate in the Contract Cost Grid as per below Screen Shot
|