Report extension 99000965 Mfg. Document Entries

Base Application, Microsoft.Foundation.Navigate

src/Layers/W1/BaseApp/Manufacturing/Foundation/Navigate/MfgDocumentEntries.ReportExt.al106 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Foundation.Navigate;using Microsoft.Manufacturing.Capacity;using Microsoft.Manufacturing.Document;reportextension 99000965 "Mfg. Document Entries" extends "Document Entries"{    dataset    {        addafter("Ins. Coverage Ledger Entry")        {            dataitem("Capacity Ledger Entry"; "Capacity Ledger Entry")            {                DataItemTableView = sorting("Document No.", "Posting Date");                column(EntryNo_CapLedgEntry; "Entry No.")                {                    IncludeCaption = true;                }                column(PstDate_CapLedgEntry; Format("Posting Date"))                {                }                column(DocNo_CapLedgEntry; "Document No.")                {                    IncludeCaption = true;                }                column(Desc_CapLedgEntry; Description)                {                    IncludeCaption = true;                }                column(Qty_CapLedgEntry; Quantity)                {                    IncludeCaption = true;                }                column(CapLedgEntryPostDtCaption; CapLedgEntryPostDtCaptionLbl)                {                }                trigger OnPreDataItem()                begin                    if TempDocumentEntry."Table ID" <> DATABASE::"Capacity Ledger Entry" then                        CurrReport.Break();                    SetCurrentKey("Document No.", "Posting Date");                    SetFilter("Document No.", DocNoFilter);                    SetFilter("Posting Date", PostingDateFilter);                end;            }        }        addafter("Purch. Cr. Memo Hdr.")        {            dataitem("Production Order"; "Production Order")            {                DataItemTableView = sorting(Status, "No.");                column(No_ProdOrder; "No.")                {                    IncludeCaption = true;                }                column(Status_ProdOrder; Status)                {                    IncludeCaption = true;                }                column(StatusCaption_ProdOrder; FieldCaption(Status))                {                }                column(Desc_ProdOrder; Description)                {                    IncludeCaption = true;                }                column(SourceType_ProdOrder; "Source Type")                {                    IncludeCaption = true;                }                column(SourceNo_ProdOrder; "Source No.")                {                    IncludeCaption = true;                }                column(UnitCost_ProdOrder; "Unit Cost")                {                    IncludeCaption = true;                }                column(CostAmt_ProdOrder; "Cost Amount")                {                    IncludeCaption = true;                }                trigger OnPreDataItem()                begin                    if TempDocumentEntry."Table ID" <> DATABASE::"Production Order" then                        CurrReport.Break();                    SetCurrentKey(Status, "No.");                    SetRange(Status, Status::Released, Status::Finished);                    SetFilter("No.", DocNoFilter);                end;            }        }    }    var        CapLedgEntryPostDtCaptionLbl: Label 'Posting Date';}