Report extension 6485 Serv. Suggest Worksheet Lines

Base Application, Microsoft.CashFlow.Worksheet

src/Layers/W1/BaseApp/Service/CashFlow/ServSuggestWorksheetLines.ReportExt.al145 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.CashFlow.Worksheet;using Microsoft.CashFlow.Forecast;using Microsoft.CashFlow.Setup;using Microsoft.Service.Document;reportextension 6485 "Serv. Suggest Worksheet Lines" extends "Suggest Worksheet Lines"{    dataset    {        addafter("Sales Line")        {            dataitem("Service Line"; "Service Line")            {                DataItemTableView = sorting("Document Type", "Document No.", "Line No.") where("Document Type" = const(Order));                trigger OnAfterGetRecord()                begin                    Window.Update(2, ServiceOrderTxt);                    Window.Update(3, "Document No.");                    ServiceHeader.Get("Document Type", "Document No.");                    if ServiceHeader."Bill-to Customer No." <> '' then                        Customer.Get(ServiceHeader."Bill-to Customer No.")                    else                        Customer.Init();                    InsertCFLineForServiceLine();                end;                trigger OnPreDataItem()                begin                    if not ConsiderSource["Cash Flow Source Type"::"Service Orders".AsInteger()] then                        CurrReport.Break();                    if not ReadPermission then                        CurrReport.Break();                end;            }        }    }    requestpage    {        layout        {            addafter("ConsiderSource[SourceType::""Sales Order""]")            {#pragma warning disable AA0100                field("ConsiderSource[SourceType::""Service Orders""]"; ConsiderSource["Cash Flow Source Type"::"Service Orders".AsInteger()])#pragma warning restore AA0100                {                    ApplicationArea = Service;                    Caption = 'Service Orders';                    ToolTip = 'Specifies if you want to include service orders in the cash flow forecast.';                }            }        }        trigger OnOpenPage()        begin            if ConsiderSource["Cash Flow Source Type"::"Service Orders".AsInteger()] then                ConsiderSource["Cash Flow Source Type"::"Service Orders".AsInteger()] := "Service Line".ReadPermission;        end;    }    var        ServiceOrderTxt: Label 'Service Orders';        ServiceDocumentDescriptionTxt: Label 'Service %1 - %2 %3', Comment = '%1 = Source Document Type (e.g. Invoice), %2 = Due Date, %3 = Source Name (e.g. Customer Name). Example: Service Invoice - 04-05-18 The Cannon Group PLC';    protected var        ServiceHeader: Record "Service Header";    local procedure InsertCFLineForServiceLine()    var        ServiceLine2: Record "Service Line";        SkipInsert: Boolean;    begin        ServiceLine2 := "Service Line";        if Summarized and (ServiceLine2.Next() <> 0) and (ServiceLine2."Customer No." <> '') and           (ServiceLine2."Document No." = "Service Line"."Document No.")        then begin            TotalAmt += CalculateLineAmountForServiceLine("Service Line");            MultiSalesLines := true;        end else begin            CFWorksheetLine2.Init();            CFWorksheetLine2."Source Type" := CFWorksheetLine2."Source Type"::"Service Orders";            CFWorksheetLine2."Source No." := "Service Line"."Document No.";            CFWorksheetLine2."Source Line No." := "Service Line"."Line No.";            CFWorksheetLine2."Document Type" := CFWorksheetLine2."Document Type"::Invoice;            CFWorksheetLine2."Document Date" := ServiceHeader."Document Date";            CFWorksheetLine2."Shortcut Dimension 1 Code" := ServiceHeader."Shortcut Dimension 1 Code";            CFWorksheetLine2."Shortcut Dimension 2 Code" := ServiceHeader."Shortcut Dimension 2 Code";            CFWorksheetLine2."Dimension Set ID" := ServiceHeader."Dimension Set ID";            CFWorksheetLine2."Cash Flow Account No." := CFSetup."Service CF Account No.";            CFWorksheetLine2.Description :=              CopyStr(                StrSubstNo(                  ServiceDocumentDescriptionTxt,                  ServiceHeader."Document Type",                  ServiceHeader.Name,                  Format(ServiceHeader."Order Date")),                1, MaxStrLen(CFWorksheetLine2.Description));            SetCashFlowDate(CFWorksheetLine2, ServiceHeader."Due Date");            CFWorksheetLine2."Document No." := "Service Line"."Document No.";            CFWorksheetLine2."Amount (LCY)" := CalculateLineAmountForServiceLine("Service Line");            if Summarized and MultiSalesLines then begin                CFWorksheetLine2."Amount (LCY)" := CFWorksheetLine2."Amount (LCY)" + TotalAmt;                MultiSalesLines := false;                TotalAmt := 0;            end;            if "Cash Flow Forecast"."Consider CF Payment Terms" and (Customer."Cash Flow Payment Terms Code" <> '') then                CFWorksheetLine2."Payment Terms Code" := Customer."Cash Flow Payment Terms Code"            else                CFWorksheetLine2."Payment Terms Code" := ServiceHeader."Payment Terms Code";            SkipInsert := false;            OnInsertCFLineForServiceLineOnBeforeInsertTempCFWorksheetLine(CFWorksheetLine2, "Cash Flow Forecast", "Service Line", SkipInsert);            if not SkipInsert then                InsertTempCFWorksheetLine(CFWorksheetLine2, 0);        end;    end;    local procedure CalculateLineAmountForServiceLine(ServiceLine: Record "Service Line"): Decimal    begin        exit(GetServiceAmountForCFLine(ServiceLine));    end;    local procedure GetServiceAmountForCFLine(ServiceLine: Record "Service Line"): Decimal    begin        exit(ServiceLine."Outstanding Amount (LCY)" + ServiceLine."Shipped Not Invoiced (LCY)");    end;    [IntegrationEvent(false, false)]    local procedure OnInsertCFLineForServiceLineOnBeforeInsertTempCFWorksheetLine(var CashFlowWorksheetLine: Record "Cash Flow Worksheet Line"; CashFlowForecast: Record "Cash Flow Forecast"; ServiceLine: Record "Service Line"; var SkipInsert: Boolean)    begin    end;}