Report 6521 Item Tracking Appendix

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/ItemTrackingAppendix.Report.al537 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.Inventory.Reports;using Microsoft.Foundation.Address;using Microsoft.Inventory.Tracking;using Microsoft.Purchases.Document;using Microsoft.Sales.Document;using Microsoft.Sales.History;using System.Utilities;report 6521 "Item Tracking Appendix"{    Caption = 'Item Tracking Appendix';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(MainRecord; "Integer")        {            DataItemTableView = sorting(Number);            PrintOnlyIfDetail = false;            dataitem(PageLoop; "Integer")            {                DataItemTableView = sorting(Number) where(Number = const(1));                column(Addr1; Addr[1])                {                }                column(Addr2; Addr[2])                {                }                column(SourceCaption; SourceCaption)                {                }                column(Addr3; Addr[3])                {                }                column(Addr4; Addr[4])                {                }                column(TodayFormatted; Format(Today, 0, 4))                {                }                column(Addr5; Addr[5])                {                }                column(Addr6; Addr[6])                {                }                column(DocumentDate; Format(DocumentDate))                {                }                column(Addr7; Addr[7])                {                }                column(Addr8; Addr[8])                {                }                column(Addr2Caption; Addr2Caption)                {                }                column(Addr21; Addr2[1])                {                }                column(Addr22; Addr2[2])                {                }                column(Addr23; Addr2[3])                {                }                column(Addr24; Addr2[4])                {                }                column(Addr25; Addr2[5])                {                }                column(Addr26; Addr2[6])                {                }                column(Addr27; Addr2[7])                {                }                column(Addr28; Addr2[8])                {                }                column(ShowAddr2; ShowAddr2)                {                }                column(ItemTrackingAppendixCaption; ItemTrackingAppendixCaptionLbl)                {                }                column(DocumentDateCaption; DocumentDateCaptionLbl)                {                }                column(PageCaption; PageCaptionLbl)                {                }                dataitem(ItemTrackingLine; "Integer")                {                    DataItemTableView = sorting(Number);                    PrintOnlyIfDetail = false;                    column(SerialNo_ItemTrackingLine; TempTrackingSpecBuffer."Serial No.")                    {                    }                    column(No_ItemTrackingLine; TempTrackingSpecBuffer."Item No.")                    {                    }                    column(Desc_ItemTrackingLine; TempTrackingSpecBuffer.Description)                    {                    }                    column(Qty_ItemTrackingLine; TempTrackingSpecBuffer."Quantity (Base)")                    {                    }                    column(LotNo; TempTrackingSpecBuffer."Lot No.")                    {                    }                    column(ShowGroup; ShowGroup)                    {                    }                    column(NoCaption; NoCaptionLbl)                    {                    }                    column(DescriptionCaption; DescriptionCaptionLbl)                    {                    }                    column(QuantityCaption; QuantityCaptionLbl)                    {                    }                    column(LotNoCaption; LotNoCaptionLbl)                    {                    }                    column(SerialNoCaption; SerialNoCaptionLbl)                    {                    }                    dataitem(Total; "Integer")                    {                        DataItemTableView = sorting(Number) where(Number = const(1));                        column(TotalQuantity; TotalQty)                        {                        }                        column(ShowTotal; ShowTotal)                        {                        }                    }                    trigger OnAfterGetRecord()                    begin                        if Number = 1 then                            TempTrackingSpecBuffer.FindSet()                        else                            TempTrackingSpecBuffer.Next();                        if TempTrackingSpecBuffer.Correction then                            TempTrackingSpecBuffer."Quantity (Base)" := -TempTrackingSpecBuffer."Quantity (Base)";                        ShowTotal := false;                        if IsStartNewGroup(TempTrackingSpecBuffer) then                            ShowTotal := true;                        ShowGroup := false;                        if (TempTrackingSpecBuffer."Source Ref. No." <> OldRefNo) or                           (TempTrackingSpecBuffer."Item No." <> OldNo)                        then begin                            OldRefNo := TempTrackingSpecBuffer."Source Ref. No.";                            OldNo := TempTrackingSpecBuffer."Item No.";                            TotalQty := 0;                        end else                            ShowGroup := true;                        TotalQty += TempTrackingSpecBuffer."Quantity (Base)";                    end;                    trigger OnPreDataItem()                    begin                        if TrackingSpecCount = 0 then                            CurrReport.Break();                        SetRange(Number, 1, TrackingSpecCount);                        TempTrackingSpecBuffer.SetCurrentKey("Source ID", "Source Type", "Source Subtype", "Source Batch Name",                          "Source Prod. Order Line", "Source Ref. No.");                    end;                }                trigger OnAfterGetRecord()                begin                    // exclude documents without Item Tracking                    if TrackingSpecCount = 0 then                        CurrReport.Break();                    OldRefNo := 0;                    ShowGroup := false;                end;            }            trigger OnAfterGetRecord()            begin                HandleRec(Number);            end;            trigger OnPreDataItem()            begin                if MainRecCount = 0 then                    CurrReport.Break();                SetRange(Number, 1, MainRecCount);            end;        }    }    requestpage    {        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(Document; DocType)                    {                        ApplicationArea = ItemTracking;                        Caption = 'Document';                        Lookup = false;                        OptionCaption = 'Sales Quote,Sales Order,Sales Invoice,Sales Credit Memo,Sales Return Order,Sales Post. Shipment,Sales Post. Invoice,Purch. Quote,Purch. Order,Purch. Invoice,Purch. Credit Memo,Purch. Return Order';                        ToolTip = 'Specifies the type of document for which you would like to print the item tracking numbers.';                    }                    field(DocumentNo; DocNo)                    {                        ApplicationArea = ItemTracking;                        Caption = 'Document No.';                        ToolTip = 'Specifies the number of the document for which you would like to print the item tracking numbers.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Reports/ItemTrackingAppendix.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        SetRecordFilter();    end;    var        SalesHeader: Record "Sales Header";        PurchaseHeader: Record "Purchase Header";        SalesShipmentHdr: Record "Sales Shipment Header";        SalesInvoiceHdr: Record "Sales Invoice Header";        ItemTrackingDocMgt: Codeunit "Item Tracking Doc. Management";        FormatAddr: Codeunit "Format Address";        DocNo: Code[20];        DocType: Option "Sales Quote","Sales Order","Sales Invoice","Sales Credit Memo","Sales Return Order","Sales Post. Shipment","Sales Post. Invoice","Purch. Quote","Purch. Order","Purch. Invoice","Purch. Credit Memo","Purch. Return Order";        Addr: array[8] of Text[100];        Addr2: array[8] of Text[100];        SourceCaption: Text;        Addr2Caption: Text;        ShowAddr2: Boolean;        ShowGroup: Boolean;        ShowTotal: Boolean;        DocumentDate: Date;        MainRecCount: Integer;#pragma warning disable AA0074        Text002: Label 'Pay-to Address';        Text003: Label 'Bill-to Address';#pragma warning restore AA0074        TrackingSpecCount: Integer;#pragma warning disable AA0074        Text004: Label 'Sales - Shipment';#pragma warning restore AA0074        OldRefNo: Integer;        OldNo: Code[20];        TotalQty: Decimal;#pragma warning disable AA0074        Text005: Label 'Sales - Invoice';        Text006: Label 'Sales';        Text007: Label 'Purchase';#pragma warning restore AA0074        ItemTrackingAppendixCaptionLbl: Label 'Item Tracking - Appendix';        DocumentDateCaptionLbl: Label 'Document Date';        PageCaptionLbl: Label 'Page';        NoCaptionLbl: Label 'No.';        DescriptionCaptionLbl: Label 'Description';        QuantityCaptionLbl: Label 'Quantity';        LotNoCaptionLbl: Label 'Lot No.';        SerialNoCaptionLbl: Label 'Serial No.';    protected var        TempTrackingSpecBuffer: Record "Tracking Specification" temporary;    local procedure SetRecordFilter()    begin        case DocType of            DocType::"Sales Quote", DocType::"Sales Order", DocType::"Sales Invoice",          DocType::"Sales Credit Memo", DocType::"Sales Return Order":                FilterSalesHdr();            DocType::"Purch. Quote", DocType::"Purch. Order", DocType::"Purch. Invoice",          DocType::"Purch. Credit Memo", DocType::"Purch. Return Order":                FilterPurchHdr();            DocType::"Sales Post. Shipment":                FilterSalesShip();            DocType::"Sales Post. Invoice":                FilterSalesInv();        end;    end;    local procedure HandleRec(Nr: Integer)    begin        case DocType of            DocType::"Sales Quote", DocType::"Sales Order", DocType::"Sales Invoice",            DocType::"Sales Credit Memo", DocType::"Sales Return Order":                begin                    if Nr = 1 then                        SalesHeader.FindSet()                    else                        SalesHeader.Next();                    HandleSales();                end;            DocType::"Purch. Quote", DocType::"Purch. Order", DocType::"Purch. Invoice",            DocType::"Purch. Credit Memo", DocType::"Purch. Return Order":                begin                    if Nr = 1 then                        PurchaseHeader.FindSet()                    else                        PurchaseHeader.Next();                    HandlePurchase();                end;            DocType::"Sales Post. Shipment":                begin                    if Nr = 1 then                        SalesShipmentHdr.FindSet()                    else                        SalesShipmentHdr.Next();                    HandleShipment();                end;            DocType::"Sales Post. Invoice":                begin                    if Nr = 1 then                        SalesInvoiceHdr.FindSet()                    else                        SalesInvoiceHdr.Next();                    HandleInvoice();                end;        end;    end;    local procedure HandleSales()    begin        AddressSalesHdr(SalesHeader);        TrackingSpecCount :=          ItemTrackingDocMgt.RetrieveDocumentItemTracking(TempTrackingSpecBuffer, SalesHeader."No.",            DATABASE::"Sales Header", SalesHeader."Document Type".AsInteger());    end;    local procedure HandlePurchase()    begin        AddressPurchaseHdr(PurchaseHeader);        TrackingSpecCount :=          ItemTrackingDocMgt.RetrieveDocumentItemTracking(TempTrackingSpecBuffer, PurchaseHeader."No.",            DATABASE::"Purchase Header", PurchaseHeader."Document Type".AsInteger());    end;    local procedure HandleShipment()    begin        AddressShipmentHdr(SalesShipmentHdr);        TrackingSpecCount :=          ItemTrackingDocMgt.RetrieveDocumentItemTracking(TempTrackingSpecBuffer, SalesShipmentHdr."No.",            DATABASE::"Sales Shipment Header", 0);    end;    local procedure HandleInvoice()    begin        AddressInvoiceHdr(SalesInvoiceHdr);        TrackingSpecCount :=          ItemTrackingDocMgt.RetrieveDocumentItemTracking(TempTrackingSpecBuffer, SalesInvoiceHdr."No.",            DATABASE::"Sales Invoice Header", 0);    end;    local procedure AddressSalesHdr(SalesHdr: Record "Sales Header")    begin        ShowAddr2 := false;        case SalesHdr."Document Type" of            SalesHdr."Document Type"::Invoice, SalesHdr."Document Type"::"Credit Memo":                begin                    FormatAddr.SalesHeaderSellTo(Addr, SalesHdr);                    if SalesHdr."Bill-to Customer No." <> SalesHdr."Sell-to Customer No." then begin                        FormatAddr.SalesHeaderBillTo(Addr2, SalesHdr);                        ShowAddr2 := true;                    end;                end            else                FormatAddr.SalesHeaderBillTo(Addr, SalesHdr);        end;        DocumentDate := SalesHdr."Document Date";        SourceCaption := StrSubstNo('%1 %2 %3', Text006, SalesHdr."Document Type", SalesHdr."No.");        Addr2Caption := Text003;    end;    local procedure AddressPurchaseHdr(PurchaseHdr: Record "Purchase Header")    begin        ShowAddr2 := false;        case PurchaseHdr."Document Type" of            PurchaseHdr."Document Type"::Quote, PurchaseHdr."Document Type"::"Blanket Order":                FormatAddr.PurchHeaderPayTo(Addr, PurchaseHdr);            PurchaseHdr."Document Type"::Order, PurchaseHdr."Document Type"::"Return Order":                begin                    FormatAddr.PurchHeaderBuyFrom(Addr, PurchaseHdr);                    if PurchaseHdr."Buy-from Vendor No." <> PurchaseHdr."Pay-to Vendor No." then begin                        FormatAddr.PurchHeaderPayTo(Addr2, PurchaseHdr);                        ShowAddr2 := true;                    end;                end;            PurchaseHdr."Document Type"::Invoice, PurchaseHdr."Document Type"::"Credit Memo":                begin                    FormatAddr.PurchHeaderPayTo(Addr, PurchaseHdr);                    if not (PurchaseHdr."Pay-to Vendor No." in ['', PurchaseHdr."Buy-from Vendor No."]) then begin                        FormatAddr.PurchHeaderBuyFrom(Addr2, PurchaseHdr);                        ShowAddr2 := true;                    end;                end;        end;        DocumentDate := PurchaseHdr."Document Date";        SourceCaption := StrSubstNo('%1 %2 %3', Text007, PurchaseHdr."Document Type", PurchaseHdr."No.");        Addr2Caption := Text002;    end;    local procedure AddressShipmentHdr(SalesShipHdr: Record "Sales Shipment Header")    begin        ShowAddr2 := false;        FormatAddr.SalesShptShipTo(Addr, SalesShipHdr);        if SalesShipHdr."Bill-to Customer No." <> SalesShipHdr."Sell-to Customer No." then begin            FormatAddr.SalesShptBillTo(Addr2, Addr2, SalesShipHdr);            ShowAddr2 := true;        end;        DocumentDate := SalesShipHdr."Document Date";        SourceCaption := StrSubstNo('%1 %2', Text004, SalesShipHdr."No.");        Addr2Caption := Text003;    end;    local procedure AddressInvoiceHdr(SalesInvHdr: Record "Sales Invoice Header")    begin        ShowAddr2 := false;        FormatAddr.SalesInvBillTo(Addr, SalesInvHdr);        DocumentDate := SalesInvHdr."Document Date";        SourceCaption := StrSubstNo('%1 %2', Text005, SalesInvHdr."No.");        Addr2Caption := Text002;    end;    procedure IsStartNewGroup(var TempTrackingSpecification: Record "Tracking Specification" temporary): Boolean    var        TempTrackingSpecification2: Record "Tracking Specification" temporary;        SourceRef: Integer;    begin        TempTrackingSpecification2 := TempTrackingSpecification;        SourceRef := TempTrackingSpecification2."Source Ref. No.";        if TempTrackingSpecBuffer.Next() = 0 then begin            TempTrackingSpecification := TempTrackingSpecification2;            exit(true);        end;        if SourceRef <> TempTrackingSpecBuffer."Source Ref. No." then begin            TempTrackingSpecification := TempTrackingSpecification2;            exit(true);        end;        TempTrackingSpecification := TempTrackingSpecification2;        exit(false);    end;    local procedure FilterSalesHdr()    begin        case DocType of            DocType::"Sales Quote":                SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Quote);            DocType::"Sales Order":                SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Order);            DocType::"Sales Invoice":                SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::Invoice);            DocType::"Sales Credit Memo":                SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::"Credit Memo");            DocType::"Sales Return Order":                SalesHeader.SetRange("Document Type", SalesHeader."Document Type"::"Return Order");        end;        if DocNo <> '' then            SalesHeader.SetFilter("No.", DocNo);        MainRecCount := SalesHeader.Count();    end;    local procedure FilterSalesShip()    begin        if DocNo <> '' then            SalesShipmentHdr.SetRange("No.", DocNo);        MainRecCount := SalesShipmentHdr.Count();    end;    local procedure FilterSalesInv()    begin        if DocNo <> '' then            SalesInvoiceHdr.SetRange("No.", DocNo);        MainRecCount := SalesInvoiceHdr.Count();    end;    local procedure FilterPurchHdr()    begin        case DocType of            DocType::"Purch. Quote":                PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::Quote);            DocType::"Purch. Order":                PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::Order);            DocType::"Purch. Invoice":                PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::Invoice);            DocType::"Purch. Credit Memo":                PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::"Credit Memo");            DocType::"Purch. Return Order":                PurchaseHeader.SetRange("Document Type", PurchaseHeader."Document Type"::"Return Order");        end;        if DocNo <> '' then            PurchaseHeader.SetFilter("No.", DocNo);        MainRecCount := PurchaseHeader.Count();    end;}