Dynamics Community Forum Thread Details

cross company on Ledger transaction list report

Greeting everyone i'm trying to print that report with cross company

so i see that report using LedgerTransListReportHelper

i see this code

insert_recordset _taxTmp
    (
        LedgerTransactionListStagingTmp,
        GeneralJournalEntryDataArea,
        TaxCode,
        TaxAmountMST
    )
    select RecId, GeneralJournalEntryDataArea
    from _stagingTmp
        group by _stagingTmp.RecId, _stagingTmp.GeneralJournalEntryDataArea, taxTrans.TaxCode
            where _stagingTmp.PostingType == LedgerPostingType::MSTDiff
    join mainAccount
            where _stagingTmp.MainAccount == mainAccount.RecId
                && (mainAccount.Type == DimensionLedgerAccountType::ProfitAndLoss
                    || mainAccount.Type == DimensionLedgerAccountType::Revenue
                    || mainAccount.Type == DimensionLedgerAccountType::Expense)
    join TaxCode, sum(TaxAmount)
        from taxTrans
            where _stagingTmp.TransDate == taxTrans.TransDate
                && _stagingTmp.Voucher == taxTrans.Voucher;

how can i cross company for that query because when i try i got errors

anyway i'm trying to create report for Ledger transactions with cross company

Quick Links

Leaderboard