Report 6031 Update Contract Prices

Base Application, Microsoft.Service.Contract

src/Layers/W1/BaseApp/Service/Contract/UpdateContractPrices.Report.al227 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.Service.Contract;using Microsoft.Finance.Currency;using Microsoft.Service.Reports;using Microsoft.Service.Setup;using System.Utilities;report 6031 "Update Contract Prices"{    ApplicationArea = Service;    Caption = 'Update Service Contract Prices';    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem("Service Contract Header"; "Service Contract Header")        {            CalcFields = Name, "Calcd. Annual Amount";            DataItemTableView = sorting("Next Price Update Date") where("Contract Type" = const(Contract), Status = const(Signed), "Change Status" = const(Locked));            RequestFilterFields = "Contract No.", "Item Filter";            trigger OnAfterGetRecord()            var                NumberOfPeriods: Integer;                IsHandled: Boolean;            begin                ServContract.Get("Contract Type", "Contract No.");                ServContract.SuspendStatusCheck(true);                UpdateServContract := true;                OldAnnualAmount := "Annual Amount";                "Last Price Update %" := PriceUpdPct;                CalcFields("Calcd. Annual Amount");                if Format("Price Update Period") = '' then                    UpdateServContract := false;                TotOldAnnualAmount := TotOldAnnualAmount + OldAnnualAmount;                TotSignedAmount := TotSignedAmount + "Calcd. Annual Amount";                TotContractLinesAmount := 0;                ServContractLine.Reset();                ServContractLine.SetRange("Contract Type", ServContractLine."Contract Type"::Contract);                ServContractLine.SetRange("Contract No.", "Contract No.");                if GetFilter("Item Filter") <> '' then                    ServContractLine.SetFilter("Item No.", GetFilter("Item Filter"));                if ServContractLine.Find('-') then                    repeat                        ServContractLine2 := ServContractLine;                        ServContractLine.SuspendStatusCheck(true);                        if UpdateServContract then begin                            ServContractLine.Validate(                              "Line Value",                              Round(                                ServContractLine."Line Value" + (ServContractLine."Line Value" * PriceUpdPct / 100),                                Currency."Amount Rounding Precision"));                            OnBeforeServiceContractLineModify(                              ServContractLine, "Service Contract Header", UpdateToDate, PriceUpdPct);                            if ServMgtSetup."Register Contract Changes" then                                ServContractLine.LogContractLineChanges(ServContractLine2);                            ServContractLine.Modify(true);                        end;                        TotContractLinesAmount := TotContractLinesAmount + ServContractLine."Line Amount";                    until ServContractLine.Next() = 0;                if UpdateServContract then begin                    ServContract."Last Price Update Date" := WorkDate();                    ServContract."Next Price Update Date" := CalcDate(ServContract."Price Update Period", ServContract."Next Price Update Date");                    ServContract."Last Price Update %" := PriceUpdPct;                    ContractGainLossEntry.CreateEntry(                      "Service Contract Change Type"::"Price Update",                      ServContract."Contract Type", ServContract."Contract No.",                      TotContractLinesAmount - ServContract."Annual Amount", '');                    ServContract."Annual Amount" := TotContractLinesAmount;                    IsHandled := false;                    OnBeforeCalcAnnualAmt(ServContract, IsHandled);                    if not IsHandled then begin                        NumberOfPeriods := ReturnNoOfPer(ServContract."Invoice Period");                        if NumberOfPeriods = 0 then                            ServContract."Amount per Period" := 0                        else                            ServContract."Amount per Period" :=                                Round(ServContract."Annual Amount" / NumberOfPeriods, Currency."Amount Rounding Precision");                    end;                    if OldAnnualAmount <> ServContract."Annual Amount" then                        ServContract."Print Increase Text" := true;                    ServContract.Modify();                    if ServMgtSetup."Register Contract Changes" then                        ServContract.UpdContractChangeLog("Service Contract Header");                    TotNewAmount := TotNewAmount + ServContract."Annual Amount";                end;            end;            trigger OnPreDataItem()            var                ConfirmManagement: Codeunit "Confirm Management";            begin                if PerformUpd = PerformUpd::"Print Only" then begin                    Clear(ContractPriceUpdateTest);                    ContractPriceUpdateTest.InitVariables(PriceUpdPct, UpdateToDate);                    ContractPriceUpdateTest.SetTableView("Service Contract Header");                    ContractPriceUpdateTest.RunModal();                    CurrReport.Break();                end;                TotOldAnnualAmount := 0;                TotNewAmount := 0;                TotSignedAmount := 0;                if PriceUpdPct = 0 then                    Error(Text000);                if PriceUpdPct > 10 then                    if not ConfirmManagement.GetResponseOrDefault(Text001, true) then                        Error(Text002);                if UpdateToDate = 0D then                    Error(Text003);                SetFilter("Next Price Update Date", '<>%1&<=%2', 0D, UpdateToDate);                Currency.InitRoundingPrecision();                ServMgtSetup.Get();            end;        }    }    requestpage    {        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(UpdateToDate; UpdateToDate)                    {                        ApplicationArea = Service;                        Caption = 'Update to Date';                        ToolTip = 'Specifies the date up to which you want to update prices. The batch job includes contracts with next price update dates on or before this date.';                    }                    field("Price Update %"; PriceUpdPct)                    {                        ApplicationArea = Service;                        AutoFormatType = 0;                        Caption = 'Price Update %';                        DecimalPlaces = 0 : 5;                        ToolTip = 'Specifies the price update for the service item contract values in percentages.';                    }                    field(PerformUpd; PerformUpd)                    {                        ApplicationArea = Service;                        Caption = 'Action';                        OptionCaption = 'Update Contract Prices,Print Only';                        ToolTip = 'Specifies the desired action relating to updating service contract prices.';                    }                }            }        }        actions        {        }    }    labels    {    }    trigger OnInitReport()    begin        UpdateToDate := WorkDate();    end;    var        ServContract: Record "Service Contract Header";        ServContractLine: Record "Service Contract Line";        ContractGainLossEntry: Record "Contract Gain/Loss Entry";        ServContractLine2: Record "Service Contract Line";        Currency: Record Currency;        ServMgtSetup: Record "Service Mgt. Setup";        ContractPriceUpdateTest: Report "Contract Price Update - Test";        OldAnnualAmount: Decimal;        TotOldAnnualAmount: Decimal;        TotNewAmount: Decimal;        TotSignedAmount: Decimal;        TotContractLinesAmount: Decimal;        PriceUpdPct: Decimal;        UpdateToDate: Date;        PerformUpd: Option "Update Contract Prices","Print Only";        UpdateServContract: Boolean;#pragma warning disable AA0074        Text000: Label 'You must fill in the Price Update % field.';        Text001: Label 'The price update % is unusually large.\\Confirm that this is the correct percentage.';        Text002: Label 'The program has stopped the batch job at your request.';        Text003: Label 'You must fill in the Update to Date field.';#pragma warning restore AA0074    procedure InitializeRequest(UpdateToDateFrom: Date; PricePercentage: Decimal; PerformUpdate: Option)    begin        UpdateToDate := UpdateToDateFrom;        PriceUpdPct := PricePercentage;        PerformUpd := PerformUpdate;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeServiceContractLineModify(var ServiceContractLine: Record "Service Contract Line"; ServiceContractHeader: Record "Service Contract Header"; UpdateToDate: Date; PriceUpdPct: Decimal)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalcAnnualAmt(var ServiceContractHeader: Record "Service Contract Header"; var IsHandled: Boolean)    begin    end;}