Report extension 99000965 Mfg. Document Entries, source in 29

Source29

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';
}