while select LedgerJournalTrans where LedgerJournalTrans.JournalNum == ledgerJournalId && LedgerJournalTrans.Voucher == voucher { if(ledgerJournalTrans.AmountCurCredit == 0) { Ex_InvoiceJournalTmp.VendAmountLCY = ((Ledgerjournaltrans.AmountCurDebit + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate)/100; Ex_InvoiceJournalTmp.VendAmountCurr = Ledgerjournaltrans.AmountCurDebit + abs(Ex_InvoiceJournalTmp.Ex_VATAmount) ; } else if(ledgerJournalTrans.AmountCurDebit == 0) { Ex_InvoiceJournalTmp.VendAmountLCY = abs(((Ledgerjournaltrans.AmountCurCredit + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate)/100) *-1; Ex_InvoiceJournalTmp.VendAmountCurr = abs(Ledgerjournaltrans.AmountCurCredit + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * -1; } }
if(ledgerJournalTrans.AmountCurCredit == 0) { Ex_InvoiceJournalTmp.Amount = taxTrans.SourceBaseAmountCur; Ex_InvoiceJournalTmp.VendAmountCurr = ((abs(Ex_InvoiceJournalTmp.Amount) + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate)*-1/100; Ex_InvoiceJournalTmp.AmountMST = ((abs(Ex_InvoiceJournalTmp.Amount) + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate)*-1/100; Ex_InvoiceJournalTmp.VendAmountLCY = ((abs(Ex_InvoiceJournalTmp.Amount) + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate)*-1/100; x = x + Ex_InvoiceJournalTmp.AmountMST; Ex_InvoiceJournalTmp.ConversionAmount = numeralsToTxt(abs(x)); } else if(ledgerJournalTrans.AmountCurDebit == 0) { Ex_InvoiceJournalTmp.Amount = taxTrans.SourceBaseAmountCur; Ex_InvoiceJournalTmp.VendAmountLCY = ((abs(Ex_InvoiceJournalTmp.Amount) + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate)*-1/100; Ex_InvoiceJournalTmp.AmountMST = ((abs(Ex_InvoiceJournalTmp.Amount) + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * Ledgerjournaltrans.ExchRate) /100; Ex_InvoiceJournalTmp.VendAmountCurr = abs(Ledgerjournaltrans.AmountCurCredit + abs(Ex_InvoiceJournalTmp.Ex_VATAmount)) * -1;
while select ledgerJournalTrans
where ledgerJournalTrans.JournalNum == ledgerJournalId
&& ledgerJournalTrans.Voucher == voucher
{
if (ledgerJournalTrans.AmountCurCredit == 0)
{
ex_InvoiceJournalTmp.VendAmountLCY = ((ledgerJournalTrans.AmountCurDebit + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate) / 100;
ex_InvoiceJournalTmp.VendAmountCurr = ledgerJournalTrans.AmountCurDebit + abs(ex_InvoiceJournalTmp.Ex_VATAmount) ;
}
else if (ledgerJournalTrans.AmountCurDebit == 0)
{
ex_InvoiceJournalTmp.VendAmountLCY = -abs(((ledgerJournalTrans.AmountCurCredit + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate)/100);
ex_InvoiceJournalTmp.VendAmountCurr = -abs(ledgerJournalTrans.AmountCurCredit + abs(ex_InvoiceJournalTmp.Ex_VATAmount));
}
}
// --- Second snippet ---
if (ledgerJournalTrans.AmountCurCredit == 0)
{
ex_InvoiceJournalTmp.Amount = taxTrans.SourceBaseAmountCur;
ex_InvoiceJournalTmp.VendAmountCurr = -((abs(ex_InvoiceJournalTmp.Amount) + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate) / 100;
ex_InvoiceJournalTmp.AmountMST = -((abs(ex_InvoiceJournalTmp.Amount) + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate) / 100;
ex_InvoiceJournalTmp.VendAmountLCY = -((abs(ex_InvoiceJournalTmp.Amount) + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate) / 100;
x += ex_InvoiceJournalTmp.AmountMST;
ex_InvoiceJournalTmp.ConversionAmount = numeralsToTxt(abs(x));
}
else if(ledgerJournalTrans.AmountCurDebit == 0)
{
ex_InvoiceJournalTmp.Amount = taxTrans.SourceBaseAmountCur;
ex_InvoiceJournalTmp.VendAmountLCY = -((abs(ex_InvoiceJournalTmp.Amount) + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate) / 100;
ex_InvoiceJournalTmp.AmountMST = ((abs(ex_InvoiceJournalTmp.Amount) + abs(ex_InvoiceJournalTmp.Ex_VATAmount)) * ledgerJournalTrans.ExchRate) / 100;
ex_InvoiceJournalTmp.VendAmountCurr = -abs(ledgerJournalTrans.AmountCurCredit + abs(ex_InvoiceJournalTmp.Ex_VATAmount));
}
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156