Table 5964 Service Contract Line
src/Layers/W1/BaseApp/Service/Contract/ServiceContractLine.Table.al1,299 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.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Sales.Customer;using Microsoft.Service.Comment;using Microsoft.Service.Document;using Microsoft.Service.Item;using Microsoft.Service.Ledger;using Microsoft.Service.Setup;using System.Utilities;table 5964 "Service Contract Line"{ Caption = 'Service Contract Line'; DrillDownPageID = "Serv. Contr. List (Serv. Item)"; LookupPageID = "Serv. Contr. List (Serv. Item)"; DataClassification = CustomerContent; fields { field(1; "Contract Type"; Enum "Service Contract Type") { Caption = 'Contract Type'; ToolTip = 'Specifies the type of the contract.'; } field(2; "Contract No."; Code[20]) { Caption = 'Contract No.'; ToolTip = 'Specifies the number of the service contract or service contract quote associated with the service contract line.'; TableRelation = "Service Contract Header"."Contract No." where("Contract Type" = field("Contract Type")); } field(3; "Line No."; Integer) { Caption = 'Line No.'; } field(4; "Contract Status"; Enum "Service Contract Status") { Caption = 'Contract Status'; ToolTip = 'Specifies the status of the contract.'; } field(5; "Service Item No."; Code[20]) { Caption = 'Service Item No.'; ToolTip = 'Specifies the number of the service item that is subject to the service contract.'; TableRelation = "Service Item" where(Blocked = filter(" ")); trigger OnValidate() var ServiceItemLine: Record "Service Item Line"; ServContractMgt: Codeunit ServContractManagement; ConfirmManagement: Codeunit "Confirm Management"; InvoicePeriod: DateFormula; LastInvoiceDate: Date; NewLastInvoiceDate: Date; ServiceItemNoIsNotEmpty: Boolean; IsHandled: Boolean; begin IsHandled := false; OnValidateServiceItemNoOnBeforeOnValidate(Rec, xRec, IsHandled); if IsHandled then exit; TestStatusOpen(); GetServContractHeader(); if ServContractHeader."Last Invoice Date" <> 0D then begin LastInvoiceDate := ServContractHeader."Last Invoice Date"; Evaluate(InvoicePeriod, ServContractMgt.GetInvoicePeriodText(ServContractHeader."Invoice Period")); NewLastInvoiceDate := CalcDate(InvoicePeriod, LastInvoiceDate); if (ServContractHeader."Expiration Date" <> 0D) and (NewLastInvoiceDate > ServContractHeader."Expiration Date") then Error(Text025, ServiceItemLine.TableCaption(), ServContractHeader.FieldCaption("Expiration Date")); end; IsHandled := false; OnValidateServiceItemNoOnBeforeCheckServContractHeaderStatus(Rec, xRec, IsHandled); if not IsHandled then if (ServContractHeader.Status = ServContractHeader.Status::Signed) and (not "New Line") then Error(Text013, FieldCaption("Service Item No.")); ServiceItemNoIsNotEmpty := "Service Item No." <> ''; OnValidateServiceItemNoOnAfterCalcServiceItemNoIsNotEmpty(Rec, ServiceItemNoIsNotEmpty, xRec, HideDialog); if ServiceItemNoIsNotEmpty then begin GetServItem(); TestField("Customer No."); IsHandled := false; OnValidateServiceItemNoOnBeforeCheckSameCustomer(ServItem, ServContractHeader, IsHandled); if not IsHandled then if ServItem."Customer No." <> ServContractHeader."Customer No." then Error(Text000, "Customer No."); IsHandled := false; OnValidateServiceItemNoOnBeforeCheckSameItemExist(Rec, IsHandled); if not IsHandled then begin ServContractLine.Reset(); ServContractLine.SetRange("Contract No.", "Contract No."); ServContractLine.SetRange("Contract Type", "Contract Type"); ServContractLine.SetRange("Service Item No.", "Service Item No."); ServContractLine.SetFilter("Line No.", '<>%1', "Line No."); if not ServContractLine.IsEmpty() then Error(Text003); end; if not HideDialog then begin ServContractLine.Reset(); ServContractLine.SetCurrentKey("Service Item No.", "Contract Status"); ServContractLine.SetRange("Service Item No.", "Service Item No."); ServContractLine.SetFilter("Contract Status", '<>%1', ServContractLine."Contract Status"::Cancelled); ServContractLine.SetRange("Contract Type", ServContractLine."Contract Type"::Contract); ServContractLine.SetFilter("Contract No.", '<>%1', "Contract No."); OnValidateServiceItemNoOnAfterServContractLineSetFiltersWithContractStatus(Rec, ServContractLine); if not ServContractLine.IsEmpty() then begin if not ConfirmManagement.GetResponseOrDefault( StrSubstNo(Text019, "Service Item No."), true) then begin "Service Item No." := xRec."Service Item No."; exit; end; end else begin ServContractLine.Reset(); ServContractLine.SetCurrentKey("Service Item No."); ServContractLine.SetRange("Service Item No.", "Service Item No."); ServContractLine.SetRange("Contract Type", ServContractLine."Contract Type"::Quote); ServContractLine.SetFilter("Contract No.", '<>%1', "Contract No."); if not ServContractLine.IsEmpty() then if not ConfirmManagement.GetResponseOrDefault( StrSubstNo(Text019, "Service Item No."), true) then begin "Service Item No." := xRec."Service Item No."; exit; end; end; end; if (ServItem."Ship-to Code" <> ServContractHeader."Ship-to Code") and not HideDialog then if not ConfirmManagement.GetResponseOrDefault( StrSubstNo(Text001, "Service Item No."), true) then begin "Service Item No." := xRec."Service Item No."; exit; end; "Ship-to Code" := ServItem."Ship-to Code"; end; ServContractLine := Rec; Init(); OnValidateServiceItemNoOnAfterInit(Rec, ServContractLine); "Starting Date" := ServContractLine."Starting Date"; "Contract Expiration Date" := ServContractLine."Contract Expiration Date"; "Credit Memo Date" := ServContractLine."Credit Memo Date"; "Next Planned Service Date" := ServContractLine."Next Planned Service Date"; "Service Period" := ServContractLine."Service Period"; "Customer No." := ServContractLine."Customer No."; if ServContractLine."Service Item No." <> '' then "Ship-to Code" := ServContractLine."Ship-to Code" else "Ship-to Code" := ServContractHeader."Ship-to Code"; "Contract Status" := ServContractLine."Contract Status"; "Service Item No." := ServContractLine."Service Item No."; if "Service Item No." = '' then exit; Description := ServItem.Description; "Serial No." := ServItem."Serial No."; "Service Item Group Code" := ServItem."Service Item Group Code"; "Item No." := ServItem."Item No."; "Variant Code" := ServItem."Variant Code"; "Unit of Measure Code" := ServItem."Unit of Measure Code"; ServContractMgt.CheckItemServiceBlocked(Rec); if (ServContractHeader."Response Time (Hours)" < ServItem."Response Time (Hours)") and (ServContractHeader."Response Time (Hours)" <> 0) then "Response Time (Hours)" := ServContractHeader."Response Time (Hours)" else if ServItem."Response Time (Hours)" <> 0 then "Response Time (Hours)" := ServItem."Response Time (Hours)" else "Response Time (Hours)" := ServContractHeader."Response Time (Hours)"; ServMgtSetup.Get(); Validate("Line Cost", ServItem."Default Contract Cost"); Validate("Line Value", ServItem."Default Contract Value"); Validate("Line Discount %", ServItem."Default Contract Discount %"); OnValidateServiceItemNoOnBeforeModify(ServItem, ServContractHeader); if ServContractLine.Get("Contract Type", "Contract No.", "Line No.") then begin UseServContractLineAsxRec := true; Modify(true); end; end; } field(6; Description; Text[100]) { Caption = 'Description'; ToolTip = 'Specifies the description of the service item that is subject to the contract.'; trigger OnValidate() begin TestStatusOpen(); end; } field(7; "Serial No."; Code[50]) { Caption = 'Serial No.'; ToolTip = 'Specifies the serial number of the service item that is subject to the contract.'; trigger OnValidate() begin TestStatusOpen(); TestField("Item No."); end; } field(8; "Service Item Group Code"; Code[10]) { Caption = 'Service Item Group Code'; TableRelation = "Service Item Group"; trigger OnValidate() begin TestStatusOpen(); TestField("Service Item No."); end; } field(9; "Customer No."; Code[20]) { Caption = 'Customer No.'; ToolTip = 'Specifies the number of the customer associated with the service contract.'; TableRelation = Customer; } field(10; "Ship-to Code"; Code[10]) { Caption = 'Ship-to Code'; ToolTip = 'Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment.'; Editable = false; TableRelation = "Ship-to Address".Code where("Customer No." = field("Customer No.")); } field(11; "Item No."; Code[20]) { Caption = 'Item No.'; ToolTip = 'Specifies the number of the item linked to the service item in the service contract.'; TableRelation = Item where(Type = const(Inventory), Blocked = const(false), "Service Blocked" = const(false)); trigger OnValidate() begin TestStatusOpen(); if "Item No." <> xRec."Item No." then TestField("Service Item No.", ''); if "Item No." <> '' then begin Item.Get("Item No."); Currency.InitRoundingPrecision(); Description := Item.Description; "Unit of Measure Code" := Item."Sales Unit of Measure"; GetServContractHeader(); "Response Time (Hours)" := ServContractHeader."Response Time (Hours)"; ServMgtSetup.Get(); "Line Cost" := Round(Item."Unit Cost" * ServMgtSetup."Contract Value %" / 100, Currency."Amount Rounding Precision"); "Line Discount %" := 0; case ServMgtSetup."Contract Value Calc. Method" of ServMgtSetup."Contract Value Calc. Method"::"Based on Unit Price": "Line Value" := Round(Item."Unit Price" * ServMgtSetup."Contract Value %" / 100, Currency."Amount Rounding Precision"); ServMgtSetup."Contract Value Calc. Method"::"Based on Unit Cost": "Line Value" := Round(Item."Unit Cost" * ServMgtSetup."Contract Value %" / 100, Currency."Amount Rounding Precision"); end; Validate("Line Value", "Line Value"); end else begin "Unit of Measure Code" := ''; "Variant Code" := ''; "Serial No." := ''; end; end; } field(12; "Unit of Measure Code"; Code[10]) { Caption = 'Unit of Measure Code'; ToolTip = 'Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.'; TableRelation = if ("Item No." = filter(<> '')) "Item Unit of Measure".Code where("Item No." = field("Item No.")) else "Unit of Measure"; trigger OnValidate() begin TestStatusOpen(); if "Unit of Measure Code" <> xRec."Unit of Measure Code" then begin TestField("Service Item No.", ''); TestField("Item No."); end; end; } field(13; "Response Time (Hours)"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Response Time (Hours)'; DecimalPlaces = 0 : 5; MinValue = 0; trigger OnValidate() begin TestStatusOpen(); end; } field(14; "Last Planned Service Date"; Date) { Caption = 'Last Planned Service Date'; ToolTip = 'Specifies the date of the last planned service on this item.'; Editable = false; } field(15; "Next Planned Service Date"; Date) { Caption = 'Next Planned Service Date'; ToolTip = 'Specifies the date of the next planned service on the item included in the contract.'; trigger OnValidate() begin TestStatusOpen(); if ("Next Planned Service Date" <> 0D) and ("Next Planned Service Date" < "Starting Date") then Error(Text009, FieldCaption("Next Planned Service Date"), FieldCaption("Starting Date")); end; } field(16; "Last Service Date"; Date) { Caption = 'Last Service Date'; ToolTip = 'Specifies the date when the service item on the line was last serviced.'; } field(17; "Last Preventive Maint. Date"; Date) { Caption = 'Last Preventive Maint. Date'; ToolTip = 'Specifies the date when the last time preventative service was performed on this item.'; Editable = false; } field(18; "Invoiced to Date"; Date) { Caption = 'Invoiced to Date'; Editable = false; } field(19; "Credit Memo Date"; Date) { Caption = 'Credit Memo Date'; ToolTip = 'Specifies the date when you can create a credit memo for the service item that needs to be removed from the service contract.'; trigger OnValidate() begin TestStatusOpen(); TestField(Credited, false); CheckCreditMemoDate(); end; } field(20; "Contract Expiration Date"; Date) { Caption = 'Contract Expiration Date'; ToolTip = 'Specifies the date when an item should be removed from the contract.'; trigger OnValidate() var IsHandled: Boolean; begin TestStatusOpen(); IsHandled := false; OnBeforeValidateContractExpirationDate(Rec, xRec, CurrFieldNo, IsHandled); if IsHandled then exit; TestField(Credited, false); ServContractHeader.Get("Contract Type", "Contract No."); if (not ServContractHeader.Prepaid) and (xRec."Contract Expiration Date" <= "Invoiced to Date") and (xRec."Contract Expiration Date" <> 0D) then if ("Contract Expiration Date" > "Invoiced to Date") or ("Contract Expiration Date" = 0D) then Error( Text024, FieldCaption("Contract Expiration Date")); if "Contract Expiration Date" = 0D then begin "Credit Memo Date" := 0D; exit; end; if "Contract Expiration Date" < "Starting Date" then Error( Text009, FieldCaption("Contract Expiration Date"), FieldCaption("Starting Date")); if ServContractHeader."Expiration Date" <> 0D then if "Contract Expiration Date" > ServContractHeader."Expiration Date" then Error( Text017, FieldCaption("Contract Expiration Date"), ServContractHeader.FieldCaption("Expiration Date")); if "Contract Expiration Date" < "Credit Memo Date" then Error( Text009, FieldCaption("Contract Expiration Date"), FieldCaption("Credit Memo Date")); if "Credit Memo Date" = 0D then "Credit Memo Date" := "Contract Expiration Date"; if not ServContractHeader."Automatic Credit Memos" then begin ServLedgEntry.Reset(); ServLedgEntry.SetCurrentKey(Type, "No.", "Entry Type", "Moved from Prepaid Acc.", "Posting Date", Open); ServLedgEntry.SetRange(Type, ServLedgEntry.Type::"Service Contract"); ServLedgEntry.SetRange("No.", "Contract No."); ServLedgEntry.SetRange("Moved from Prepaid Acc.", false); ServLedgEntry.SetRange(Open, false); ServLedgEntry.CalcSums("Amount (LCY)"); if ServLedgEntry."Amount (LCY)" <> 0 then Message(Text011, "Contract No."); end; end; } field(21; "Service Period"; DateFormula) { Caption = 'Service Period'; ToolTip = 'Specifies the period of time that must pass between each servicing of an item.'; trigger OnValidate() begin TestStatusOpen(); end; } field(22; "Line Value"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; BlankZero = true; Caption = 'Line Value'; ToolTip = 'Specifies the value of the service item line in the contract or contract quote.'; trigger OnValidate() begin if "Line Value" < 0 then FieldError("Line Value"); Validate("Line Discount %"); end; } field(23; "Line Discount %"; Decimal) { AutoFormatType = 0; BlankZero = true; Caption = 'Line Discount %'; ToolTip = 'Specifies the discount percentage that is granted for the item on the line.'; DecimalPlaces = 0 : 5; MaxValue = 100; MinValue = 0; trigger OnValidate() var IsHandled: Boolean; begin TestStatusOpen(); IsHandled := false; OnBeforeValidateLineDiscountPercent(Rec, xRec, CurrFieldNo, IsHandled); if IsHandled then exit; Currency.InitRoundingPrecision(); "Line Value" := Round("Line Value", Currency."Amount Rounding Precision"); "Line Amount" := Round("Line Value" - "Line Value" * "Line Discount %" / 100, Currency."Amount Rounding Precision"); "Line Discount Amount" := Round("Line Value" - "Line Amount", Currency."Amount Rounding Precision"); Profit := Round("Line Amount" - "Line Cost", Currency."Amount Rounding Precision"); end; } field(24; "Line Amount"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; BlankZero = true; Caption = 'Line Amount'; ToolTip = 'Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.'; trigger OnValidate() var IsHandled: Boolean; begin TestStatusOpen(); IsHandled := false; OnBeforeValidateLineAmount(Rec, xRec, CurrFieldNo, IsHandled); if IsHandled then exit; TestField("Line Value"); Currency.InitRoundingPrecision(); "Line Discount Amount" := Round("Line Value" - "Line Amount", Currency."Amount Rounding Precision"); "Line Discount %" := "Line Discount Amount" / "Line Value" * 100; Profit := Round("Line Amount" - "Line Cost", Currency."Amount Rounding Precision"); end; } field(28; "Variant Code"; Code[10]) { Caption = 'Variant Code'; ToolTip = 'Specifies the variant of the item on the line.'; TableRelation = "Item Variant".Code where("Item No." = field("Item No."), Blocked = const(false), "Service Blocked" = const(false)); trigger OnValidate() begin TestStatusOpen(); end; } field(29; "Starting Date"; Date) { Caption = 'Starting Date'; ToolTip = 'Specifies the starting date of the service contract.'; Editable = false; } field(30; "New Line"; Boolean) { Caption = 'New Line'; ToolTip = 'Specifies whether the service contract line is new or existing.'; Editable = false; InitValue = true; } field(31; Credited; Boolean) { Caption = 'Credited'; ToolTip = 'Specifies if the service contract line has been credited.'; trigger OnValidate() begin TestStatusOpen(); TestField("Contract Expiration Date"); end; } field(32; "Line Cost"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; BlankZero = true; Caption = 'Line Cost'; ToolTip = 'Specifies the calculated cost of the service item line in the service contract or contract quote.'; trigger OnValidate() begin TestStatusOpen(); Currency.InitRoundingPrecision(); Profit := Round("Line Amount" - "Line Cost", Currency."Amount Rounding Precision"); end; } field(33; "Line Discount Amount"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; BlankZero = true; Caption = 'Line Discount Amount'; ToolTip = 'Specifies the discount amount that is granted for the item on the line.'; trigger OnValidate() begin TestStatusOpen(); Currency.InitRoundingPrecision(); if "Line Value" <> 0 then "Line Discount %" := "Line Discount Amount" / "Line Value" * 100 else "Line Discount %" := 0; "Line Amount" := Round("Line Value" - "Line Value" * "Line Discount %" / 100, Currency."Amount Rounding Precision"); Profit := Round("Line Amount" - "Line Cost", Currency."Amount Rounding Precision"); end; } field(34; Profit; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; BlankZero = true; Caption = 'Profit'; ToolTip = 'Specifies the profit, expressed as the difference between the Line Amount and Line Cost fields on the service contract line.'; trigger OnValidate() begin TestStatusOpen(); Currency.InitRoundingPrecision(); "Line Amount" := Round(Profit + "Line Cost", Currency."Amount Rounding Precision"); "Line Discount Amount" := Round("Line Value" - "Line Amount", Currency."Amount Rounding Precision"); if "Line Value" <> 0 then "Line Discount %" := "Line Discount Amount" / "Line Value" * 100; end; } } keys { key(Key1; "Contract Type", "Contract No.", "Line No.") { Clustered = true; } key(Key2; "Contract No.", "Line No.", "Contract Type") { } key(Key3; "Service Item No.", "Contract Status") { } key(Key4; "Contract Type", "Contract No.", Credited, "New Line") { MaintainSIFTIndex = false; MaintainSQLIndex = false; SumIndexFields = "Line Amount", Profit; } key(Key5; "Customer No.", "Ship-to Code") { } } fieldgroups { } trigger OnDelete() var ConfirmManagement: Codeunit "Confirm Management"; begin TestStatusOpen(); if "Contract Type" = "Contract Type"::Contract then begin GetServContractHeader(); if ServContractHeader.Status = ServContractHeader.Status::Cancelled then Error(Text015, ServContractHeader.Status); if (ServContractHeader.Status = ServContractHeader.Status::Signed) and (not "New Line") and ServContractHeader."Automatic Credit Memos" then begin TestField("Contract Expiration Date"); CODEUNIT.Run(CODEUNIT::CreateCreditfromContractLines, Rec); end; if (ServContractHeader.Status = ServContractHeader.Status::Signed) and (not "New Line") and (not ServContractHeader."Automatic Credit Memos") then if CreditMemoBaseExists() and (not StatusCheckSuspended) then if not ConfirmManagement.GetResponseOrDefault(Text022, true) then Error(Text023); ServMgtSetup.Get(); if "Service Item No." <> '' then begin if ServMgtSetup."Register Contract Changes" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Service Item No."), 2, Format("Service Item No."), '', "Service Item No.", "Line No."); ServLogMgt.ServItemRemovedFromContract(Rec); end else if ServMgtSetup."Register Contract Changes" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption(Description), 2, Description, '', '', "Line No."); GetServContractHeader(); if (not ServContractHeader."Allow Unbalanced Amounts") and (ServContractHeader.Status = ServContractHeader.Status::Signed) then ContractGainLossEntry.CreateEntry( "Service Contract Change Type"::"Line Deleted", "Contract Type", "Contract No.", -"Line Amount", ''); end; ServCommentLine.SetRange("Table Name", ServCommentLine."Table Name"::"Service Contract"); ServCommentLine.SetRange("Table Subtype", "Contract Type"); ServCommentLine.SetRange("No.", "Contract No."); ServCommentLine.SetRange(Type, ServCommentLine.Type::General); ServCommentLine.SetRange("Table Line No.", "Line No."); ServCommentLine.DeleteAll(); UpdateContractAnnualAmount(true); end; trigger OnInsert() begin TestField(Description); GetServContractHeader(); CheckServContractHeader(); ServMgtSetup.Get(); UpdateContractAnnualAmount(false); if ("Service Item No." = '') and ("Response Time (Hours)" = 0) then "Response Time (Hours)" := ServContractHeader."Response Time (Hours)"; if "Contract Type" = "Contract Type"::Contract then if "Service Item No." <> '' then begin if ServMgtSetup."Register Contract Changes" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Service Item No."), 1, '', Format("Service Item No."), "Service Item No.", "Line No."); ServLogMgt.ServItemAddToContract(Rec); end else if ServMgtSetup."Register Contract Changes" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption(Description), 1, '', Description, '', "Line No."); end; trigger OnModify() begin if UseServContractLineAsxRec then begin xRec := ServContractLine; UseServContractLineAsxRec := false; end; if ("Service Item No." = '') and ("Item No." = '') and (Description = '') then Error(Text016, FieldCaption(Description)); ServMgtSetup.Get(); if ServMgtSetup."Register Contract Changes" then if "Contract Type" = "Contract Type"::Contract then LogContractLineChanges(xRec); if Rec."Line Amount" <> xRec."Line Amount" then UpdateContractAnnualAmount(false); if "Service Item No." <> xRec."Service Item No." then begin ServLogMgt.ServItemAddToContract(Rec); ServLogMgt.ServItemRemovedFromContract(xRec); end; end; var Currency: Record Currency; Item: Record Item; ServMgtSetup: Record "Service Mgt. Setup"; ServLedgEntry: Record "Service Ledger Entry"; ServContractHeader: Record "Service Contract Header"; ServContractLine: Record "Service Contract Line"; ServItem: Record "Service Item"; ContractChangeLog: Record "Contract Change Log"; ContractGainLossEntry: Record "Contract Gain/Loss Entry"; ServCommentLine: Record "Service Comment Line"; ServLogMgt: Codeunit ServLogManagement; HideDialog: Boolean; StatusCheckSuspended: Boolean; UseServContractLineAsxRec: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'This service item does not belong to customer no. %1.'; Text001: Label 'Service item %1 has a different ship-to code for this customer.\\Do you want to continue?';#pragma warning restore AA0470 Text003: Label 'This service item already exists in this service contract.';#pragma warning disable AA0470 Text008: Label '%1 field value cannot be later than the %2 field value on the contract line.'; Text009: Label 'The %1 cannot be less than the %2.'; Text011: Label 'Service ledger entry exists for service contract line %1.\\You may need to create a credit memo.'; Text013: Label 'You cannot change the %1 field on signed service contracts.'; Text015: Label 'You cannot delete service contract lines on %1 service contracts.'; Text016: Label 'Service contract lines must have at least a %1 filled in.'; Text017: Label 'The %1 cannot be later than the %2.'; Text018: Label 'You cannot reset %1 manually.'; Text019: Label 'Service item %1 already belongs to one or more service contracts/quotes.\\Do you want to continue?'; Text020: Label 'The service period for service item %1 under contract %2 has not yet started.'; Text021: Label 'The service period for service item %1 under contract %2 has expired.';#pragma warning restore AA0470 Text022: Label 'If you delete this contract line while the Automatic Credit Memos check box is not selected, a credit memo will not be created.\Do you want to continue?'; Text023: Label 'The update has been interrupted to respect the warning.';#pragma warning disable AA0470 Text024: Label 'You cannot enter a later date in or clear the %1 field on the contract line that has been invoiced for the period containing that date.'; Text025: Label 'You cannot add a new %1 because the service contract has expired. Renew the %2 on the service contract.', Comment = 'You cannot add a new Service Item Line because the service contract has expired. Renew the Expiration Date on the service contract.';#pragma warning restore AA0470#pragma warning restore AA0074 procedure SetupNewLine() var IsHandled: Boolean; begin IsHandled := false; OnBeforeSetupNewLine(Rec, IsHandled); if IsHandled then exit; if not ServContractHeader.Get("Contract Type", "Contract No.") then exit; "Customer No." := ServContractHeader."Customer No."; "Ship-to Code" := ServContractHeader."Ship-to Code"; "Contract Status" := ServContractHeader.Status; "Contract Expiration Date" := ServContractHeader."Expiration Date"; "Credit Memo Date" := "Contract Expiration Date"; "Service Period" := ServContractHeader."Service Period"; if ("Contract Type" = "Contract Type"::Contract) and ("Contract Status" = "Contract Status"::Signed) then "Starting Date" := WorkDate() else "Starting Date" := ServContractHeader."Starting Date"; if "Starting Date" > ServContractHeader."First Service Date" then "Next Planned Service Date" := "Starting Date" else "Next Planned Service Date" := ServContractHeader."First Service Date"; OnAfterSetupNewLine(Rec, ServContractHeader); end; local procedure GetServItem() var ServContractManagement: Codeunit ServContractManagement; begin TestField("Service Item No."); if "Service Item No." <> ServItem."No." then begin ServItem.Get("Service Item No."); ServContractManagement.CheckServiceItemBlockedForServiceContract(Rec); end; OnAfterGetServiceItem(Rec, ServItem); end; procedure CalculateNextServiceVisit() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCalculateNextServiceVisit(Rec, IsHandled); if IsHandled then exit; ServMgtSetup.Get(); if (Format("Service Period") <> '') and ("Next Planned Service Date" <> 0D) then begin GetServContractHeader(); case ServMgtSetup."Next Service Calc. Method" of ServMgtSetup."Next Service Calc. Method"::Planned: "Next Planned Service Date" := CalcDate("Service Period", "Last Planned Service Date"); ServMgtSetup."Next Service Calc. Method"::Actual: "Next Planned Service Date" := CalcDate("Service Period", "Last Service Date"); end; end else "Next Planned Service Date" := 0D; OnAfterCalculateNextServiceVisit(ServContractHeader, ServMgtSetup); end; procedure UpdateContractAnnualAmount(Deleting: Boolean) var OldServContractHeader: Record "Service Contract Header"; ServContractLine2: Record "Service Contract Line"; LineAmount: Decimal; IsHandled: Boolean; begin GetServContractHeader(); IsHandled := false; OnUpdateContractAnnualAmountOnAfterGetServContractHeader(Rec, ServContractHeader, IsHandled); if IsHandled then exit; if not ServContractHeader."Allow Unbalanced Amounts" then begin LineAmount := CalculateOtherLineAmounts(); OldServContractHeader := ServContractHeader; if Deleting then ServContractHeader."Annual Amount" := LineAmount else begin ServContractHeader."Annual Amount" := LineAmount + "Line Amount"; if not "New Line" then ContractGainLossEntry.CreateEntry( "Service Contract Change Type"::"Manual Update", "Contract Type", "Contract No.", "Line Amount" - xRec."Line Amount", '') else if ServContractHeader.Status = ServContractHeader.Status::Signed then if ServContractLine2.Get("Contract Type", "Contract No.", "Line No.") then ContractGainLossEntry.CreateEntry( "Service Contract Change Type"::"Manual Update", "Contract Type", "Contract No.", "Line Amount" - ServContractLine2."Line Amount", '') else ContractGainLossEntry.CreateEntry( "Service Contract Change Type"::"Line Added", "Contract Type", "Contract No.", "Line Amount", ''); end; ServContractHeader.ValidateNextInvoicePeriod(); ServContractHeader.SuspendStatusCheck(StatusCheckSuspended); ServContractHeader.Modify(true); if ServContractHeader."Contract Type" = ServContractHeader."Contract Type"::Contract then if ServMgtSetup."Register Contract Changes" then ServContractHeader.UpdContractChangeLog(OldServContractHeader); end; end; local procedure CalculateOtherLineAmounts(): Decimal var ServContractLine2: Record "Service Contract Line"; begin ServContractLine2.Reset(); ServContractLine2.SetRange("Contract Type", "Contract Type"); ServContractLine2.SetRange("Contract No.", "Contract No."); ServContractLine2.SetFilter("Line No.", '<>%1', "Line No."); OnCalculateOtherLineAmountsOnAfterSetFilters(ServContractLine2); ServContractLine2.CalcSums("Line Amount"); exit(ServContractLine2."Line Amount"); end; procedure HideDialogBox(Hide: Boolean) begin HideDialog := Hide; end; procedure TestStatusOpen() begin if StatusCheckSuspended then exit; GetServContractHeader(); ServContractHeader.TestField("Change Status", ServContractHeader."Change Status"::Open); OnAfterTestStatusOpen(Rec, CurrFieldNo); end; local procedure CheckServContractHeader() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckServContractHeader(ServContractHeader, IsHandled); if IsHandled then exit; ServContractHeader.TestField("Customer No."); ServContractHeader.TestField("Contract No."); ServContractHeader.TestField("Starting Date"); if "Service Item No." <> '' then begin ServContractHeader.TestField("Service Period"); ServContractHeader.TestField("First Service Date"); end; end; local procedure CheckCreditMemoDate() var IsHandled: Boolean; begin IsHandled := false; OnBeforeCheckCreditMemoDate(Rec, xRec, IsHandled); if IsHandled then exit; if "Credit Memo Date" <> 0D then if "Credit Memo Date" > "Contract Expiration Date" then Error( Text008, FieldCaption("Credit Memo Date"), FieldCaption("Contract Expiration Date")); if "Credit Memo Date" <> xRec."Credit Memo Date" then if "Credit Memo Date" = 0D then Error(Text018, FieldCaption("Credit Memo Date")); end; procedure GetStatusCheckSuspended(): Boolean begin exit(StatusCheckSuspended); end; procedure SuspendStatusCheck(Suspend: Boolean) begin StatusCheckSuspended := Suspend; end; local procedure GetServContractHeader() begin TestField("Contract No."); if ("Contract Type" <> ServContractHeader."Contract Type") or ("Contract No." <> ServContractHeader."Contract No.") then ServContractHeader.Get("Contract Type", "Contract No."); end; procedure ShowComments() begin ServContractHeader.Get("Contract Type", "Contract No."); ServContractHeader.TestField("Customer No."); TestField("Line No."); ServCommentLine.Reset(); ServCommentLine.SetRange("Table Name", ServCommentLine."Table Name"::"Service Contract"); ServCommentLine.SetRange("Table Subtype", "Contract Type"); ServCommentLine.SetRange("No.", "Contract No."); ServCommentLine.SetRange(Type, ServCommentLine.Type::General); ServCommentLine.SetRange("Table Line No.", "Line No."); PAGE.RunModal(PAGE::"Service Comment Sheet", ServCommentLine); end; procedure ValidateServicePeriod(CurrentDate: Date) begin if "Starting Date" > CurrentDate then Error(Text020, "Service Item No.", "Contract No."); if "Contract Expiration Date" = 0D then begin ServContractHeader.Get(ServContractHeader."Contract Type"::Contract, "Contract No."); if (ServContractHeader."Expiration Date" <> 0D) and (ServContractHeader."Expiration Date" <= CurrentDate) then Error(Text021, "Service Item No.", "Contract No."); end else if "Contract Expiration Date" < CurrentDate then Error(Text021, "Service Item No.", "Contract No."); end; procedure CreditMemoBaseExists() Result: Boolean var ServContractMgt: Codeunit ServContractManagement; CreditAmount: Decimal; FirstPrepaidPostingDate: Date; LastIncomePostingDate: Date; IsHandled: Boolean; begin IsHandled := false; OnBeforeCreditMemoBaseExists(Rec, Result, IsHandled); if IsHandled then exit(Result); if "Line Amount" > 0 then begin TestField("Contract Expiration Date"); if "Invoiced to Date" >= "Contract Expiration Date" then begin Currency.InitRoundingPrecision(); if ServContractHeader.Prepaid then FirstPrepaidPostingDate := ServContractMgt.FindFirstPrepaidTransaction("Contract No.") else FirstPrepaidPostingDate := 0D; LastIncomePostingDate := "Invoiced to Date"; if FirstPrepaidPostingDate <> 0D then LastIncomePostingDate := FirstPrepaidPostingDate - 1; CreditAmount := Round( ServContractMgt.CalcContractLineAmount("Line Amount", "Contract Expiration Date", LastIncomePostingDate), Currency."Amount Rounding Precision"); if FirstPrepaidPostingDate <> 0D then if "Contract Expiration Date" < FirstPrepaidPostingDate then CreditAmount := Round( ServContractMgt.CalcContractLineAmount("Line Amount", FirstPrepaidPostingDate, "Invoiced to Date"), Currency."Amount Rounding Precision") else CreditAmount := Round( ServContractMgt.CalcContractLineAmount("Line Amount", "Contract Expiration Date", "Invoiced to Date"), Currency."Amount Rounding Precision"); end; exit((CreditAmount > 0) and (not Credited)); end; exit(false); end; procedure LogContractLineChanges(ServContractLine2: Record "Service Contract Line") begin if "Item No." <> ServContractLine2."Item No." then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Item No."), 0, Format(ServContractLine2."Item No."), Format("Item No."), ServContractLine2."Service Item No.", "Line No."); if "Line Value" <> ServContractLine2."Line Value" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Line Value"), 0, Format(ServContractLine2."Line Value"), Format("Line Value"), ServContractLine2."Service Item No.", "Line No."); if "Line Discount %" <> ServContractLine2."Line Discount %" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Line Discount %"), 0, Format(ServContractLine2."Line Discount %"), Format("Line Discount %"), ServContractLine2."Service Item No.", "Line No."); if "Line Amount" <> ServContractLine2."Line Amount" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Line Amount"), 0, Format(ServContractLine2."Line Amount"), Format("Line Amount"), ServContractLine2."Service Item No.", "Line No."); if "Contract Expiration Date" <> ServContractLine2."Contract Expiration Date" then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Contract Expiration Date"), 0, Format(ServContractLine2."Contract Expiration Date"), Format("Contract Expiration Date"), ServContractLine2."Service Item No.", "Line No."); if "Service Item No." <> ServContractLine2."Service Item No." then ContractChangeLog.LogContractChange( "Contract No.", 1, FieldCaption("Service Item No."), 0, Format(ServContractLine2."Service Item No."), Format("Service Item No."), ServContractLine2."Service Item No.", "Line No."); OnAfterLogContractLineChanges(Rec, ServContractLine2); end; procedure SelectMultipleServiceItems() var ServiceContractHeader: Record "Service Contract Header"; ServiceItemListPage: Page "Service Item List"; SelectionFilter: Text; begin OnBeforeSelectMultipleServiceItems(Rec); GetServContractHeader(); SelectionFilter := ServiceItemListPage.SelectServiceItemsForServiceContract(ServiceContractHeader, Rec); if SelectionFilter <> '' then AddServiceItems(SelectionFilter); OnAfterSelectMultipleServiceItems(Rec); end; local procedure AddServiceItems(SelectionFilter: Text) var ServiceItem: Record "Service Item"; ServiceContractLine: Record "Service Contract Line"; IsHandled: Boolean; begin IsHandled := false; OnBeforeAddServiceItems(Rec, SelectionFilter, IsHandled); if IsHandled then exit; InitNewLine(ServiceContractLine); ServiceContractLine.HideDialogBox(true); ServiceItem.SetLoadFields("No."); ServiceItem.SetFilter("No.", SelectionFilter); if ServiceItem.FindSet() then repeat AddServiceItem(ServiceContractLine, ServiceItem."No."); until ServiceItem.Next() = 0; end; local procedure AddServiceItem(var ServiceContractLine: Record "Service Contract Line"; ServiceItemNo: Code[20]) begin ServiceContractLine."Line No." += 10000; ServiceContractLine.Validate("Service Item No.", ServiceItemNo); ServiceContractLine.Insert(true); end; local procedure InitNewLine(var NewServiceContractLine: Record "Service Contract Line") var ServiceContractLine: Record "Service Contract Line"; begin NewServiceContractLine.Copy(Rec); ServiceContractLine.SetRange("Contract Type", NewServiceContractLine."Contract Type"); ServiceContractLine.SetRange("Contract No.", NewServiceContractLine."Contract No."); if ServiceContractLine.FindLast() then NewServiceContractLine."Line No." := ServiceContractLine."Line No." else NewServiceContractLine."Line No." := 0; end; [IntegrationEvent(true, false)] local procedure OnAfterCalculateNextServiceVisit(ServContractHeader: Record "Service Contract Header"; ServMgtSetup: Record "Service Mgt. Setup") begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetServiceItem(ServiceContractLine: Record "Service Contract Line"; var ServiceItem: Record "Service Item") begin end; [IntegrationEvent(false, false)] local procedure OnAfterLogContractLineChanges(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSetupNewLine(var ServiceContractLine: Record "Service Contract Line"; ServiceContractHeader: Record "Service Contract Header") begin end; [IntegrationEvent(false, false)] local procedure OnAfterTestStatusOpen(ServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeCheckServContractHeader(ServContractHeader: Record "Service Contract Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnBeforeCheckCreditMemoDate(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCreditMemoBaseExists(ServiceContractLine: Record "Service Contract Line"; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateContractExpirationDate(var ServiceContractLine: Record "Service Contract Line"; var xServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateLineAmount(var ServiceContractLine: Record "Service Contract Line"; var xServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeValidateLineDiscountPercent(var ServiceContractLine: Record "Service Contract Line"; var xServiceContractLine: Record "Service Contract Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnCalculateOtherLineAmountsOnAfterSetFilters(var ServiceContractLine: Record "Service Contract Line") begin end; [IntegrationEvent(false, false)] local procedure OnUpdateContractAnnualAmountOnAfterGetServContractHeader(var ServiceContractLine: Record "Service Contract Line"; ServContractHeader: Record "Service Contract Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnValidateServiceItemNoOnAfterCalcServiceItemNoIsNotEmpty(var ServiceContractLine: Record "Service Contract Line"; var ServiceItemNoIsNotEmpty: Boolean; xServiceContractLine: Record "Service Contract Line"; var HideDialog: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnValidateServiceItemNoOnBeforeCheckSameItemExist(var ServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnValidateServiceItemNoOnAfterServContractLineSetFiltersWithContractStatus(var ServiceContractLine: Record "Service Contract Line"; var ServContractLine: Record "Service Contract Line") begin end; [IntegrationEvent(false, false)] local procedure OnValidateServiceItemNoOnBeforeCheckSameCustomer(ServItem: Record "Service Item"; var ServContractHeader: Record "Service Contract Header"; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnValidateServiceItemNoOnBeforeModify(ServItem: Record "Service Item"; ServContractHeader: Record "Service Contract Header") begin end; [IntegrationEvent(true, false)] local procedure OnValidateServiceItemNoOnAfterInit(var ServContractLineRec: Record "Service Contract Line"; ServContractLine: Record "Service Contract Line") begin end; [IntegrationEvent(true, false)] local procedure OnValidateServiceItemNoOnBeforeOnValidate(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(true, false)] local procedure OnValidateServiceItemNoOnBeforeCheckServContractHeaderStatus(var ServiceContractLine: Record "Service Contract Line"; xServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSetupNewLine(var ServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeCalculateNextServiceVisit(var ServiceContractLine: Record "Service Contract Line"; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSelectMultipleServiceItems(var ServiceContractLine: Record "Service Contract Line") begin end; [IntegrationEvent(false, false)] local procedure OnAfterSelectMultipleServiceItems(var ServiceContractLine: Record "Service Contract Line") begin end; [IntegrationEvent(false, false)] local procedure OnBeforeAddServiceItems(var ServiceContractLine: Record "Service Contract Line"; SelectionFilter: Text; var IsHandled: Boolean) begin end;}