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.

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 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
Lama 30 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?
Suggested answer

YUN ZHU 74,115 Super User 2024 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
Lama 30 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;

}

}

}
Lama 30 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.
Community Member Microsoft Employee 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.