Small and medium business | Business Central, N...

Values from Different Table to Report

(0) Share

Report

Posted on by LearnBC

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

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);
            {
            }
        }

    }

}

All responses (3)

Answers (0)

LearnBC 190 on at

Like (0)

Report
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 21,452 Moderator on at

Like (0)

Report

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 999 Moderator on at

Like (0)

Report

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.