while select sum does not work it

Hello Guys,

I have code blog down blog: I am trying to show sum amount off payback.amountcurInterest   and Amountcur of payback table.

For Amountcur I should group by payback.CrdtShortLong(long or short)

 

if CrdtLinePayback).CrdtShortLong=short then it should sum  up the related lines'  

I should Write something like this on this code blog

LedgerTransJournal.AmountCurCredit +=paybackk.AmontcurInterest;it should sum up the Interest of payback's table

if(payback.CrdtShortLong =CrdtShortLong:short) then

LedgerTransJournal.AmountCutcredit  +=payback.amountcur it should sum up the amountcur of paybackk

aLso there is a case that ,in sametime  I can have journal lines like short term and log term , I should show separetly their amount too

 

this is the code blog:

while select sum(AmountCur) from payback where payback.CrdtId == crdttable.CrdtId
{
ledgerJournalTrans.clear();
ledgerJournalTrans.Voucher = voucher;

ledgerJournalTrans = setLedgerJournalTransCommonField( voucher,
ledgerJournalTable.JournalNum,
currencyCode,
ledgerJournalName.TransactionTxtType
);
AmountCurDebit += Currency::amount(payback.BSMVInterest());
if(payback.BuzCrdtShortLong == CrdtShortLong::ShortTerm)
{

I wrote in here  the both code but it did not work it.


AmountLongInterest += payback.BSMVInterest();
AmountLong += Currency::amount(payback.AmountCur + payback.BSMVInterest());

}
else
{
AmountShortInterest += payback.BSMVInterest();
AmountShort += Currency::amount(payback.AmountCur + payback.BSMVInterest());

}

ledgerJournalTrans.AmountCurDebit = Currency::amount(payback.BSMVInterest());
ledgerJournalTrans.AccountType = LedgerJournalACType::Ledger;
ledgerJournalTrans.CurrencyCode = CrdtTable.currencyCode;
ledgerJournalTrans.ExchRate = CrdtTable.ExchRate;


ledgerJournalTrans.insert();
}

Related
Recommended