Page 5984 Service Item Trend Lines

Base Application, Microsoft.Service.Item

src/Layers/W1/BaseApp/Service/Item/ServiceItemTrendLines.Page.al232 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.Item;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Service.Ledger;using System.Utilities;page 5984 "Service Item Trend Lines"{    Caption = 'Lines';    LinksAllowed = false;    PageType = ListPart;    SourceTable = "Service Item Trend Buffer";    SourceTableTemporary = true;    layout    {        area(content)        {            repeater(Control1)            {                Editable = false;                ShowCaption = false;                field("Period Start"; Rec."Period Start")                {                    ApplicationArea = Service;                    Caption = 'Period Start';                }                field("Period Name"; Rec."Period Name")                {                    ApplicationArea = Service;                    Caption = 'Period Name';                }#pragma warning disable AA0100                field("ServItem.""Prepaid Amount"""; Rec."Prepaid Income")#pragma warning restore AA0100                {                    ApplicationArea = Prepayments;                    Caption = 'Prepaid Income';                    ToolTip = 'Specifies the total income (in LCY) that has been posted to the prepaid account with regard to the service item in the periods specified in the Period Start field.';                    trigger OnDrillDown()                    begin                        ShowServLedgEntries(false);                    end;                }#pragma warning disable AA0100                field("ServItem.""Invoiced Amount"""; Rec."Posted Income")#pragma warning restore AA0100                {                    ApplicationArea = Service;                    Caption = 'Posted Income';                    DrillDown = true;                    ToolTip = 'Specifies the total income (in LCY) that has been posted to the general ledger for the service item in the periods specified in the Period Start field.';                    trigger OnDrillDown()                    begin                        ShowServLedgEntries(true);                    end;                }#pragma warning disable AA0100                field("ServItem.""Parts Used"""; Rec."Parts Used")#pragma warning restore AA0100                {                    ApplicationArea = Service;                    Caption = 'Parts Used';                    DrillDown = true;                    ToolTip = 'Specifies the cost of resources used in the specified period.';                    trigger OnDrillDown()                    begin                        ShowServLedgEntriesByType(ServLedgEntry.Type::Item);                    end;                }#pragma warning disable AA0100                field("ServItem.""Resources Used"""; Rec."Resources Used")#pragma warning restore AA0100                {                    ApplicationArea = Service;                    Caption = 'Resources Used';                    DrillDown = true;                    ToolTip = 'Specifies the cost of spare parts used in the period shown in the Period Start field.';                    trigger OnDrillDown()                    begin                        ShowServLedgEntriesByType(ServLedgEntry.Type::Resource);                    end;                }#pragma warning disable AA0100                field("ServItem.""Cost Used"""; Rec."Cost Used")#pragma warning restore AA0100                {                    ApplicationArea = Service;                    Caption = 'Cost Used';                    ToolTip = 'Specifies the amount of service usage based on service cost for this service item.';                    trigger OnDrillDown()                    begin                        ShowServLedgEntriesByType(ServLedgEntry.Type::"Service Cost");                    end;                }                field(Profit; Rec.Profit)                {                    ApplicationArea = Service;                    AutoFormatType = 1;                    Caption = 'Profit';                }                field(ProfitPct; Rec."Profit %")                {                    ApplicationArea = Service;                    Caption = 'Profit %';                }            }        }    }    actions    {    }    trigger OnAfterGetRecord()    begin        if DateRec.Get(Rec."Period Type", Rec."Period Start") then;        CalcLine();    end;    trigger OnFindRecord(Which: Text) FoundDate: Boolean    var        VariantRec: Variant;    begin        VariantRec := Rec;        FoundDate := PeriodFormLinesMgt.FindDate(VariantRec, DateRec, Which, PeriodType.AsInteger());        Rec := VariantRec;    end;    trigger OnNextRecord(Steps: Integer) ResultSteps: Integer    var        VariantRec: Variant;    begin        VariantRec := Rec;        ResultSteps := PeriodFormLinesMgt.NextDate(VariantRec, DateRec, Steps, PeriodType.AsInteger());        Rec := VariantRec;    end;    trigger OnOpenPage()    begin        Rec.Reset();    end;    var        ServLedgEntry: Record "Service Ledger Entry";        DateRec: Record Date;        PeriodFormLinesMgt: Codeunit "Period Form Lines Mgt.";        PeriodType: Enum "Analysis Period Type";        AmountType: Enum "Analysis Amount Type";    protected var        ServItem: Record "Service Item";    procedure SetLines(var ServItem1: Record "Service Item"; NewPeriodType: Enum "Analysis Period Type"; NewAmountType: Enum "Analysis Amount Type")    begin        ServItem.Copy(ServItem1);        Rec.DeleteAll();        PeriodType := NewPeriodType;        AmountType := NewAmountType;        CurrPage.Update(false);    end;    local procedure SetDateFilter()    begin        if AmountType = AmountType::"Net Change" then            ServItem.SetRange("Date Filter", Rec."Period Start", Rec."Period End")        else            ServItem.SetRange("Date Filter", 0D, Rec."Period End");    end;    local procedure ShowServLedgEntries(Prepaid: Boolean)    begin        SetDateFilter();        ServLedgEntry.Reset();        ServLedgEntry.SetCurrentKey("Service Item No. (Serviced)", "Entry Type", "Moved from Prepaid Acc.", Type, "Posting Date");        ServLedgEntry.SetRange("Service Item No. (Serviced)", ServItem."No.");        ServLedgEntry.SetRange("Entry Type", ServLedgEntry."Entry Type"::Sale);        ServLedgEntry.SetRange("Moved from Prepaid Acc.", Prepaid);        ServLedgEntry.SetRange(Open, false);        ServLedgEntry.SetFilter("Posting Date", ServItem.GetFilter("Date Filter"));        PAGE.Run(0, ServLedgEntry);    end;    local procedure ShowServLedgEntriesByType(Type: Enum "Service Ledger Entry Type")    begin        SetDateFilter();        ServLedgEntry.Reset();        ServLedgEntry.SetCurrentKey("Service Item No. (Serviced)", "Entry Type", "Moved from Prepaid Acc.", Type, "Posting Date");        ServLedgEntry.SetRange("Service Item No. (Serviced)", ServItem."No.");        ServLedgEntry.SetRange("Entry Type", ServLedgEntry."Entry Type"::Sale);        ServLedgEntry.SetRange(Type, Type);        ServLedgEntry.SetFilter("Posting Date", ServItem.GetFilter("Date Filter"));        PAGE.Run(0, ServLedgEntry);    end;    local procedure CalcLine()    begin        SetDateFilter();        ServItem.CalcFields("Invoiced Amount", "Resources Used", "Parts Used", "Cost Used", "Prepaid Amount");        Rec.Profit := ServItem."Invoiced Amount" - ServItem."Resources Used" - ServItem."Parts Used" - ServItem."Cost Used";        if ServItem."Invoiced Amount" <> 0 then            Rec."Profit %" := Round((Rec.Profit / ServItem."Invoiced Amount") * 100, 0.01)        else            Rec."Profit %" := 0;        Rec."Prepaid Income" := ServItem."Prepaid Amount";        Rec."Posted Income" := ServItem."Invoiced Amount";        Rec."Parts Used" := ServItem."Parts Used";        Rec."Resources Used" := ServItem."Resources Used";        Rec."Cost Used" := ServItem."Cost Used";        OnAfterCalcLine(ServItem, Rec);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalcLine(var ServItem: Record "Service Item"; var ServiceItemTrendBuffer: Record "Service Item Trend Buffer")    begin    end;}