Skip to main content
Business Central forum
Suggested answer

Values from Different Table to Report

editSubscribe (0) ShareShare
ReportReport
Posted on by 190

Hello All,

i want to extend a report e Vendor - Balance to Date (321, Report Request) , a new field called External Document No from Gen. Journal Line (81).but while am trying, am not getting Gen Journal line in the data set

Extdoc.jpg

reportextension 60005 "Vendor Balance to Date" extends "Vendor - Balance to Date"
{
    RDLCLayout = './ReportLayouts/VendorBalToDate.rdl';
    dataset
    {
     
        // Add changes to dataitems and columns here
        add(Gen. Journal Line )
        {
            column(External Document Number);
            {
            }
        }

    }

}

  • LearnBC Profile Picture
    LearnBC 190 on at
    RE: Values from Different Table to Report

    i tried with vendor ledger entries, then also its not getting those values over there

    reportextension 60005 "Vendor Balance to Date" extends "Vendor - Balance to Date"
    {
        RDLCLayout = './ReportLayouts/VendorBalToDate.rdl';
        dataset
        {
         
            // Add changes to dataitems and columns here
            add(Vendor Ledger Entry )
            {
                Column("External Document No")
                {
                }
            }
    
        }
    
    }

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 20,984 Super User on at
    RE: Values from Different Table to Report

    Hi,

    You can not add Gen. Journal Line data item to this report, as this report made of Vendor and Vendor Ledger entry, you are only allowed to use any of the data item, In that case I would suggest please build a new custom report.

    Thanks.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User on at
    RE: Values from Different Table to Report

    I think the dataitem you will need to add is not the General journal lines. But the general ledger entries

    General journal lines is unposted data and i guess you want to report on posted data.

    But to add the external document number to your report you just have to add that column from the vendor ledger entries. Because the field is also available there. And the vendor ledger entry field is already a dataitem in the report.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,030 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans