How to Update field in other table based on the first field ?!

(0) Share

Report

Posted on by Sanfour

Hello Experts

I have a problem concerning the update method as i have made a new customized form and im trying to show the sum of the Credit and Debit in my form

first i made a new fields in my table and i put them in my form

All i need is to update the credit and debit in my form based on the posted sum of GL Lines credit & debit

here is the code that im using after the super in the update method in the LedgerJournalTrans update

select sum(AmountCurDebit), sum(AmountCurCredit) from _LedgerJournalTrans where this.LoanNo == _Sega_BankLoan.LoanNo && this.VoucherPosted == 1;
_Sega_BankLoan.Credit = this.AmountCurCredit;
_Sega_BankLoan.Debit = this.AmountCurDebit;
// _Sega_BankLoan.update();
}

please advise me if the logic of where to put my code and how to reach the right solution

the fields in my table is not getting updated