Table 5950 Service Order Allocation

Base Application, Microsoft.Service.Document

src/Layers/W1/BaseApp/Service/Document/ServiceOrderAllocation.Table.al640 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.Document;using Microsoft.Foundation.AuditCodes;using Microsoft.Projects.Resources.Resource;using Microsoft.Service.Item;using Microsoft.Service.Maintenance;using Microsoft.Service.Resources;using Microsoft.Service.Setup;using System.Utilities;table 5950 "Service Order Allocation"{    Caption = 'Service Order Allocation';    DrillDownPageID = "Service Order Allocations";    LookupPageID = "Service Order Allocations";    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.';        }        field(2; Status; Option)        {            Caption = 'Status';            ToolTip = 'Specifies the status of the entry, such as active, non-active, or cancelled.';            Editable = false;            OptionCaption = 'Nonactive,Active,Finished,Canceled,Reallocation Needed';            OptionMembers = Nonactive,Active,Finished,Canceled,"Reallocation Needed";            trigger OnValidate()            begin                case Status of                    Status::Canceled:                        begin                            Clear(ServLogMgt);                            ServLogMgt.ServHeaderCancelAllocation("Resource No.", "Document Type".AsInteger(), "Document No.", "Service Item Line No.");                        end;                    Status::Active:                        begin                            Clear(ServLogMgt);                            ServLogMgt.ServHeaderAllocation("Resource No.", "Document Type".AsInteger(), "Document No.", "Service Item Line No.");                        end;                    Status::"Reallocation Needed":                        begin                            Clear(ServLogMgt);                            ServLogMgt.ServHeaderReallocationNeeded("Resource No.", "Document Type".AsInteger(), "Document No.", "Service Item Line No.");                        end;                end;            end;        }        field(3; "Document No."; Code[20])        {            Caption = 'Document No.';            ToolTip = 'Specifies the number of the service order associated with this entry.';            Editable = false;            trigger OnLookup()            var                ServOrderNo: Code[20];            begin                ServOrderNo := "Document No.";                Clear(ServOrderMgt);                ServOrderMgt.ServHeaderLookup("Document Type".AsInteger(), ServOrderNo);            end;        }        field(4; "Allocation Date"; Date)        {            Caption = 'Allocation Date';            ToolTip = 'Specifies the date when the resource allocation should start.';            trigger OnValidate()            begin                if "Allocation Date" = 0D then                    if Status <> Status::Nonactive then                        Error(Text001, FieldCaption("Allocation Date"), FieldCaption(Status), Status);                if "Allocation Date" < WorkDate() then                    Message(Text002, FieldCaption("Allocation Date"), "Allocation Date");            end;        }        field(5; "Resource No."; Code[20])        {            Caption = 'Resource No.';            ToolTip = 'Specifies the number of the resource allocated to the service task in this entry.';            TableRelation = Resource;            trigger OnValidate()            var                ConfirmManagement: Codeunit "Confirm Management";            begin                if "Resource No." <> '' then begin                    ServmgtSetup.Get();                    Res.Get("Resource No.");                    "Resource Group No." := Res."Resource Group No.";                    if ServmgtSetup."Resource Skills Option" = ServmgtSetup."Resource Skills Option"::"Warning Displayed"                    then                        if "Service Item Line No." <> 0 then begin                            ServItemLine.Get("Document Type", "Document No.", "Service Item Line No.");                            if not                               ServOrderAllocMgt.QualifiedForServiceItemLine(ServItemLine, "Resource No.")                            then                                Error(Text003, FieldCaption("Resource No."), "Resource No.");                        end;                    if ServmgtSetup."Service Zones Option" = ServmgtSetup."Service Zones Option"::"Warning Displayed"                    then begin                        ServHeader.Get(Rec."Document Type", Rec."Document No.");                        Res."Service Zone Filter" := ServHeader."Service Zone Code";                        Res.CalcFields("In Customer Zone");                        if not Res."In Customer Zone" then                            if not ConfirmManagement.GetResponseOrDefault(                                 StrSubstNo(                                   Text004,                                   FieldCaption("Resource No."),                                   "Resource No.",                                   ServHeader.FieldCaption("Service Zone Code"),                                   ServHeader."Service Zone Code"), true)                            then                                Error('');                    end;                    if (Status = Status::"Reallocation Needed") or (Status = Status::Active) then                        CreateReallocationEntry();                end;            end;        }        field(6; "Resource Group No."; Code[20])        {            Caption = 'Resource Group No.';            ToolTip = 'Specifies the number of the resource group allocated to the service task in this entry.';            TableRelation = "Resource Group";            trigger OnValidate()            begin                if ("Resource Group No." <> '') and                   ("Resource Group No." <> xRec."Resource Group No.")                then begin                    if Res.Get("Resource No.") then                        if "Resource Group No." <> Res."Resource Group No." then                            "Resource No." := '';                    if (Status = Status::"Reallocation Needed") or (Status = Status::Active) then                        CreateReallocationEntry();                end;            end;        }        field(7; "Service Item Line No."; Integer)        {            Caption = 'Service Item Line No.';            ToolTip = 'Specifies the number of the service item line linked to this entry.';            TableRelation = "Service Item Line"."Line No." where("Document Type" = field("Document Type"),                                                                  "Document No." = field("Document No."));            trigger OnValidate()            var                ServOrderManagement: Codeunit ServOrderManagement;            begin                if not HideDialog and ServHeader.Get("Document Type", "Document No.") then                    ServOrderAllocMgt.CheckServiceItemLineFinished(ServHeader, "Service Item Line No.");                if ServItemLine.Get("Document Type", "Document No.", "Service Item Line No.") then begin                    ServOrderManagement.CheckServiceItemBlockedForAll(ServItemLine);                    "Service Item No." := ServItemLine."Service Item No.";                    "Service Item Serial No." := ServItemLine."Serial No.";                end else begin                    "Service Item No." := '';                    "Service Item Serial No." := '';                end;                CalcFields("Service Item Description");            end;        }        field(8; "Allocated Hours"; Decimal)        {            AutoFormatType = 0;            Caption = 'Allocated Hours';            ToolTip = 'Specifies the hours allocated to the resource or resource group for the service task in this entry.';            DecimalPlaces = 0 : 5;            trigger OnValidate()            begin                if "Allocated Hours" = 0 then                    if Status <> Status::Nonactive then                        Error(                          Text005,                          FieldCaption("Allocated Hours"), FieldCaption(Status), Status);            end;        }        field(9; "Starting Time"; Time)        {            Caption = 'Starting Time';            ToolTip = 'Specifies the time when you want the allocation to start.';            trigger OnValidate()            begin                ValidateStartEndTime();            end;        }        field(10; "Finishing Time"; Time)        {            Caption = 'Finishing Time';            ToolTip = 'Specifies the time when you want the allocation to finish.';            trigger OnValidate()            begin                ValidateStartEndTime();            end;        }        field(11; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description for the service order allocation.';        }        field(12; "Reason Code"; Code[10])        {            Caption = 'Reason Code';            ToolTip = 'Specifies the reason code, a supplementary source code that enables you to trace the entry.';            TableRelation = "Reason Code";        }        field(13; "Service Item No."; Code[20])        {            Caption = 'Service Item No.';            ToolTip = 'Specifies the number of the service item.';            TableRelation = if ("Document Type" = filter(<> "Credit Memo")) "Service Item"."No." where(Blocked = filter(<> All))            else            if ("Document Type" = filter("Credit Memo")) "Service Item"."No.";            trigger OnLookup()            begin                ServItemLine.Reset();                ServItemLine.SetRange("Document Type", "Document Type");                ServItemLine.SetRange("Document No.", "Document No.");                ServItemLine."Service Item No." := "Service Item No.";                if PAGE.RunModal(0, ServItemLine) = ACTION::LookupOK then                    Validate("Service Item Line No.", ServItemLine."Line No.");            end;            trigger OnValidate()            begin                if "Service Item No." <> '' then begin                    ServItemLine.Reset();                    ServItemLine.SetRange("Document Type", "Document Type");                    ServItemLine.SetRange("Document No.", "Document No.");                    ServItemLine.SetRange("Service Item No.", "Service Item No.");                    ServItemLine.FindFirst();                    Validate("Service Item Line No.", ServItemLine."Line No.");                end;            end;        }        field(14; Posted; Boolean)        {            Caption = 'Posted';        }        field(15; "Service Item Description"; Text[100])        {            CalcFormula = lookup("Service Item Line".Description where("Document Type" = field("Document Type"),                                                                        "Document No." = field("Document No."),                                                                        "Line No." = field("Service Item Line No.")));            Caption = 'Service Item Description';            ToolTip = 'Specifies a description of the service item in this entry.';            Editable = false;            FieldClass = FlowField;        }        field(16; "Service Item Serial No."; Code[50])        {            Caption = 'Service Item Serial No.';            ToolTip = 'Specifies the serial number of the service item in this entry.';            trigger OnLookup()            begin                ServItemLine.Reset();                ServItemLine.SetRange("Document Type", "Document Type");                ServItemLine.SetRange("Document No.", "Document No.");                ServItemLine."Serial No." := "Service Item Serial No.";                if PAGE.RunModal(0, ServItemLine) = ACTION::LookupOK then                    Validate("Service Item Line No.", ServItemLine."Line No.");            end;            trigger OnValidate()            begin                if "Service Item Serial No." <> '' then begin                    ServItemLine.Reset();                    ServItemLine.SetRange("Document Type", "Document Type");                    ServItemLine.SetRange("Document No.", "Document No.");                    ServItemLine.SetRange("Serial No.", "Service Item Serial No.");                    ServItemLine.FindFirst();                    Validate("Service Item Line No.", ServItemLine."Line No.");                end;            end;        }        field(17; "Repair Status"; Code[20])        {            CalcFormula = lookup("Service Item Line"."Repair Status Code" where("Document Type" = field("Document Type"),                                                                                 "Document No." = field("Document No."),                                                                                 "Line No." = field("Service Item Line No.")));            Caption = 'Repair Status';            Editable = false;            FieldClass = FlowField;        }        field(18; "Service Started"; Boolean)        {            Caption = 'Service Started';        }        field(19; "Document Type"; Enum "Service Document Type")        {            Caption = 'Document Type';            ToolTip = 'Specifies the type of the document (Order or Quote) from which the allocation entry was created.';            Editable = false;        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; Status, "Document Type", "Document No.", "Service Item Line No.", "Allocation Date", "Starting Time", Posted)        {            SumIndexFields = "Allocated Hours";        }        key(Key3; "Document Type", "Document No.", Status, "Resource Group No.", "Allocation Date", "Starting Time", Posted)        {            SumIndexFields = "Allocated Hours";        }        key(Key4; Status, "Document Type", "Document No.", "Service Item Line No.", "Resource No.", "Allocation Date", "Starting Time", Posted)        {            SumIndexFields = "Allocated Hours";        }        key(Key5; "Document Type", "Document No.", "Service Item Line No.", "Allocation Date", "Starting Time", Posted)        {            SumIndexFields = "Allocated Hours";        }        key(Key6; "Resource No.", "Document Type", "Allocation Date", Status, Posted)        {        }    }    fieldgroups    {    }    trigger OnDelete()    begin        if not HideDialog and ServHeader.Get("Document Type", "Document No.") then            ServOrderAllocMgt.CheckServiceItemLineFinished(ServHeader, "Service Item Line No.");    end;    trigger OnInsert()    begin        ServOrderAlloc.Reset();        if ServOrderAlloc.Find('+') then            "Entry No." := ServOrderAlloc."Entry No." + 1        else            "Entry No." := 1;        TestField("Document No.");        if ("Service Item Line No." <> 0) and           ("Resource No." <> '')        then begin            CheckAllocationEntry();            if not HideDialog and ServHeader.Get("Document Type", "Document No.") then                ServOrderAllocMgt.CheckServiceItemLineFinished(ServHeader, "Service Item Line No.");        end;        if Status = Status::Nonactive then begin            if ("Resource No." <> '') or               ("Resource Group No." <> '')            then                CheckAllocationEntry();            if ("Allocation Date" <> 0D) and               (("Resource No." <> '') or ("Resource Group No." <> ''))            then                Validate(Status, Status::Active);        end;    end;    trigger OnModify()    begin        TestField("Service Item Line No.");        if not HideDialog and ServHeader.Get("Document Type", "Document No.") then begin            ServOrderAllocMgt.CheckServiceItemLineFinished(ServHeader, xRec."Service Item Line No.");            ServOrderAllocMgt.CheckServiceItemLineFinished(ServHeader, "Service Item Line No.");        end;        if Status = Status::Active then            if ("Resource No." = '') and               ("Resource Group No." = '')            then                Error(Text008, FieldCaption("Resource No."), FieldCaption("Resource Group No."));        CheckAllocationEntry();        if Status = Status::Nonactive then            if ("Allocation Date" <> 0D) and               (("Resource No." <> '') or ("Resource Group No." <> ''))            then                Validate(Status, Status::Active);    end;    var        ServHeader: Record "Service Header";        ServItemLine: Record "Service Item Line";        ServmgtSetup: Record "Service Mgt. Setup";        ServOrderAlloc: Record "Service Order Allocation";        ServOrderAlloc2: Record "Service Order Allocation";        Res: Record Resource;        ResGr: Record "Resource Group";        RepairStatus: Record "Repair Status";        RepairStatus2: Record "Repair Status";        ServOrderMgt: Codeunit ServOrderManagement;        ServOrderAllocMgt: Codeunit ServAllocationManagement;        ServLogMgt: Codeunit ServLogManagement;        ReallocEntryReasons: Page "Reallocation Entry Reasons";        ChangeServItemLine: Boolean;        HideDialog: Boolean;        RepairStatusCode: Code[10];        Flag: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text000: Label 'Only one %1 can be allocated to a %2.';        Text001: Label '%1 must be filled in when the %2 is %3.';        Text002: Label 'The %1 %2 has expired.';        Text003: Label '%1 %2 is not qualified to carry out the service.';        Text004: Label '%1 %2 is not working in %3 %4.';        Text005: Label '%1 must be greater than 0 when the %2 is %3.';        Text006: Label '%1 cannot be greater than %2.';        Text007: Label '%1 with the field %2 selected cannot be found.';        Text008: Label '%1 and %2 cannot be blank at the same time.';#pragma warning restore AA0470#pragma warning restore AA0074    local procedure ValidateStartEndTime()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeValidateStartEndTime(Rec, IsHandled);        if IsHandled then            exit;        if "Starting Time" = 0T then            exit;        if "Finishing Time" = 0T then            exit;        if "Starting Time" > "Finishing Time" then            Error(Text006, FieldCaption("Starting Time"), FieldCaption("Finishing Time"));    end;    local procedure CreateReallocationEntry()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCreateReallocationEntry(Rec, IsHandled);        if IsHandled then            exit;        RepairStatus2.Reset();        RepairStatus2.SetRange(Initial, true);        if RepairStatus2.FindFirst() then            RepairStatusCode := RepairStatus2.Code;        ChangeServItemLine := false;        Clear(ReallocEntryReasons);        ReallocEntryReasons.SetRecord(Rec);        ReallocEntryReasons.SetTableView(Rec);        ReallocEntryReasons.SetNewResource("Resource No.", "Resource Group No.");        Flag := false;        if not HideDialog then            Flag := ReallocEntryReasons.RunModal() = ACTION::Yes        else            Flag := true;        if Flag then begin            "Reason Code" := ReallocEntryReasons.ReturnReasonCode();            ServOrderAlloc2 := Rec;            ServOrderAlloc.Reset();            if ServOrderAlloc.Find('+') then                ServOrderAlloc2."Entry No." := ServOrderAlloc."Entry No." + 1;            CalcFields("Repair Status");            RepairStatus.Get("Repair Status");            if Status = Status::Active then begin                OnCreateReallocationEntryOnBeforeResetRepairStatus(Rec);                if RepairStatus.Initial then begin                    RepairStatus2.Reset();                    RepairStatus2.SetRange(Referred, true);                    if RepairStatus2.FindFirst() then begin                        ChangeServItemLine := true;                        RepairStatusCode := RepairStatus2.Code;                        Validate(Status, Status::Active);                        ServOrderAlloc2."Resource No." := xRec."Resource No.";                        ServOrderAlloc2."Resource Group No." := xRec."Resource Group No.";                        ServOrderAlloc2."Reason Code" := xRec."Reason Code";                        if "Service Started" then                            ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Finished)                        else                            ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Canceled);                        ServOrderAlloc2.Insert();                    end else                        Error(                          Text007,                          RepairStatus.TableCaption(), RepairStatus.FieldCaption(Referred));                end else                    if RepairStatus."In Process" then begin                        RepairStatus2.Reset();                        RepairStatus2.SetRange("Partly Serviced", true);                        if RepairStatus2.FindFirst() then begin                            RepairStatusCode := RepairStatus2.Code;                            ChangeServItemLine := true;                            Validate(Status, Status::Active);                            ServOrderAlloc2."Resource No." := xRec."Resource No.";                            ServOrderAlloc2."Resource Group No." := xRec."Resource Group No.";                            ServOrderAlloc2."Reason Code" := xRec."Reason Code";                            if "Service Started" then                                ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Finished)                            else                                ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Canceled);                            ServOrderAlloc2.Insert();                        end else                            Error(                              Text007,                              RepairStatus.TableCaption(), RepairStatus.FieldCaption("Partly Serviced"));                    end else begin                        Validate(Status, Status::Active);                        ServOrderAlloc2."Resource No." := xRec."Resource No.";                        ServOrderAlloc2."Resource Group No." := xRec."Resource Group No.";                        ServOrderAlloc2."Reason Code" := xRec."Reason Code";                        if "Service Started" then                            ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Finished)                        else                            ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Canceled);                        ServOrderAlloc2.Insert();                    end;            end else begin                Validate(Status, Status::Active);                ServOrderAlloc2."Resource No." := xRec."Resource No.";                ServOrderAlloc2."Resource Group No." := xRec."Resource Group No.";                ServOrderAlloc2."Reason Code" := xRec."Reason Code";                if "Service Started" then                    ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Finished)                else                    ServOrderAlloc2.Validate(Status, ServOrderAlloc2.Status::Canceled);                ServOrderAlloc2.Insert();            end;            if ChangeServItemLine then begin                TestField("Service Item Line No.");                ServItemLine.Get("Document Type", "Document No.", "Service Item Line No.");                ServItemLine."Repair Status Code" := RepairStatusCode;                ServItemLine.Modify(true);            end;        end else begin            "Resource No." := xRec."Resource No.";            "Resource Group No." := xRec."Resource Group No.";            exit;        end;    end;    procedure GetHideDialog(): Boolean    begin        exit(HideDialog);    end;    procedure SetHideDialog(HideDialog1: Boolean)    begin        HideDialog := HideDialog1;    end;    local procedure CheckAllocationEntry()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeCheckAllocationEntry(Rec, IsHandled);        if IsHandled then            exit;        if not HideDialog then begin            ServOrderAlloc.Reset();            ServOrderAlloc.SetCurrentKey("Document Type", "Document No.", "Service Item Line No.");            ServOrderAlloc.SetRange("Document Type", "Document Type");            ServOrderAlloc.SetRange("Document No.", "Document No.");            ServOrderAlloc.SetRange("Service Item Line No.", "Service Item Line No.");            ServOrderAlloc.SetFilter("Entry No.", '<>%1', "Entry No.");            ServOrderAlloc.SetFilter(Status, '%1|%2', ServOrderAlloc.Status::Active, ServOrderAlloc.Status::"Reallocation Needed");            if ServOrderAlloc.Find('-') then                repeat                    if ("Resource No." <> '') and                       (ServOrderAlloc."Resource No." <> '') and                       (ServOrderAlloc."Resource No." <> "Resource No.")                    then                        Error(Text000, Res.TableCaption(), ServItemLine.TableCaption());                    if ("Resource Group No." <> '') and                       (ServOrderAlloc."Resource Group No." <> '') and                       (ServOrderAlloc."Resource Group No." <> "Resource Group No.")                    then                        Error(Text000, ResGr.TableCaption(), ServItemLine.TableCaption());                until ServOrderAlloc.Next() = 0;        end;    end;    procedure SetFilters(ServiceItemLine: Record "Service Item Line")    begin        Reset();        SetCurrentKey("Document Type", "Document No.", "Service Item Line No.");        SetRange("Document Type", ServiceItemLine."Document Type");        SetRange("Document No.", ServiceItemLine."Document No.");        SetRange("Service Item Line No.", ServiceItemLine."Line No.");        SetRange(Status, ServOrderAlloc.Status::Active);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCheckAllocationEntry(var ServiceOrderAllocation: Record "Service Order Allocation"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCreateReallocationEntry(var ServiceOrderAllocation: Record "Service Order Allocation"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeValidateStartEndTime(var ServiceOrderAllocation: Record "Service Order Allocation"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCreateReallocationEntryOnBeforeResetRepairStatus(var ServiceOrderAllocation: Record "Service Order Allocation")    begin    end;}