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

How I can External Document Number in Standard Stantment Report get data?

(0) Share

Report

Posted on by Lama

Hello all,

We have created a customized "Customer Statement report" in Business central for our Customers. The customer wanted to add a column "External doc no" in the report.

we have added a column "External doc no" in the data item "Sales Invoice Header" under the "DtldCustLedgEntries" data item. but when we want to modify the "word layout" of the report the table has the repeat data in one section under DtldCustLedgEntries, so when we added the column "External doc no" in this table that will give empty data under this column!

Is there any way we can get data in the column External doc no?

Does any help, please?

Thanks.

I have the same question (0)

All responses (6)

Answers (0)

Community Member on at

Like (1)

Report

RE: How I can External Document Number in Standard Stantment Report get data?

I think you can create a global variable and on after get record you can assign the external document number to the the new variable created, make the new variable as the new column in the report.

Was this reply helpful? Yes No
Lama 37 on at

Like (0)

Report

RE: How I can External Document Number in Standard Stantment Report get data?

Thanks For your response

I will try it now.

Was this reply helpful? Yes No
Lama 37 on at

Like (0)

Report

RE: How I can External Document Number in Standard Stantment Report get data?

I need more help from you, please!

I wrote this code, this is what you meant?

okay, but now, how I can use the variable in the word layout? I didn't find it in the word layout after the built?!!

reportextension 50112 CustomerSR extends "Standard Statement"

{

dataset

{

modify(DtldCustLedgEntries)

{

trigger OnAfterAfterGetRecord()

var

ExternalDocNumLL: Record "Sales Invoice Header";

begin

ExternalDocNumLL.SetRange("External Document No.");

end;

}

}

}

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (1)

Report

RE: How I can External Document Number in Standard Stantment Report get data?

Hi, I'm sorry I haven't done a detailed test, but I think the following should work.

Standard Code:

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Lama 37 on at

Like (0)

Report

RE: How I can External Document Number in Standard Stantment Report get data?

Thanks, ZHU

But I need to add External Document No. on the DtldCustLedgEntries data item.

can you help me with that?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,307 Super User 2025 Season 2 on at

Like (0)

Report

RE: How I can External Document Number in Standard Stantment Report get data?

Hi, how about adding a flowfield field to "Detailed Cust. Ledg. Entry" table first? In this way, the processing in the report will be simpler.

For example,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No