Add Ext Doc No to Statement

(2) Share

Report

Posted on by MJ-27012000-0

I need to add the External Document number from a Sales Order to the Customer Statement. I think I am close.

Here is what I have...

Any suggestions are appreciated.

Thanks.

reportextension 50100 CustomerStatementReportExt extends "Standard Statement"
{
    dataset
    {
        modify(DtldCustLedgEntries)
        {
            column(SalesOrderExternalNo; SalesOrderExternalNo)
            {
                Caption = 'External Document No.';
            }
            trigger OnAfterGetRecord()
            begin
                SalesOrderExternalNo := '';
                // Only populate for Sales Orders
                if DtldCustLedgEntries."Document Type" = DtldCustLedgEntries."Document Type"::Order then
                    if SalesHeader.Get(DtldCustLedgEntries."Document Type", DtldCustLedgEntries."Document No.") then
                        SalesOrderExternalNo := SalesHeader."External Document No.";
            end;
        }
    }
    var
        SalesHeader: Record "Sales Header";
        SalesOrderExternalNo: Text[100];
}

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU 93,256 Super User 2025 Season 2 on at

Like (0)

Report

Add Ext Doc No to Statement

Hi, There is no Order in the Document Type of Detailed Customer Ledger Entries. . .Your code cannot be used to get the order. I don't understand why there is no error. Did you add Order Type in your environment?

Because this is a posted table, you can use the Invoice No. to get the External Document number on the Posted Sales Invoice. There is no problem.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No