Umi
04/13/2022, 5:20 PMMatt Bernstein
04/13/2022, 6:46 PMSELECT
transaction.id,
transaction.number,
transactionLine.foreignamount,
BUILTIN.DF(transactionLine.subsidiary),
transactionLine.subsidiary,
BUILTIN.DF(transaction.currency) AS currency,
TransactionAccountingLine.amount,
TransactionAccountingLine.debit,
TransactionAccountingLine.credit,
BUILTIN.CONSOLIDATE(TransactionAccountingLine.amount, 'INCOME', 'DEFAULT', 'DEFAULT', 11, transaction.postingperiod, 'DEFAULT')
FROM
transactionLine
INNER JOIN transaction ON transaction.id = transactionLine.transaction
INNER JOIN TransactionAccountingLine ON (
transaction.id = TransactionAccountingLine.transaction
AND TransactionAccountingLine.transactionline = transactionLine.id
)
WHERE
TransactionAccountingLine.posting = 'T'
FETCH NEXT 1000 ROWS ONLY
Selcuk Dogru
04/13/2022, 7:29 PMBUILTIN.CURRENCY_CONVERT(TL.netamount, 4, T.trandate)
to convert to any target currencyUmi
04/14/2022, 11:58 AMSelcuk Dogru
04/14/2022, 3:57 PMSELECT TOP 1 CR.exchangerate
FROM currencyrate CR
WHERE CR.basecurrency = C.id AND
CR.transactioncurrency = 4 AND
CR.effectivedate <= T.trandate
ORDER BY CR.effectivedate DESC