Table 8068 Sales Subscription Line

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Sales Service Commitments/Tables/SalesSubscriptionLine.Table.al895 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Finance.Currency;using Microsoft.Finance.SalesTax;using Microsoft.Inventory.Item;using Microsoft.Sales.Document;using Microsoft.Sales.Pricing;table 8068 "Sales Subscription Line"{    DataClassification = CustomerContent;    Caption = 'Sales Subscription Line';    DrillDownPageId = "Sales Service Commitments";    LookupPageId = "Sales Service Commitments";    fields    {        field(1; "Document Type"; Enum "Sales Document Type")        {            Caption = 'Document Type';        }        field(2; "Document No."; Code[20])        {            Caption = 'Document No.';            TableRelation = "Sales Header"."No." where("Document Type" = field("Document Type"));        }        field(3; "Document Line No."; Integer)        {            Caption = 'Document Line No.';        }        field(4; "Line No."; Integer)        {            Caption = 'Line No.';            AutoIncrement = true;        }        field(10; "Item No."; Code[20])        {            Caption = 'Item No.';            TableRelation = Item;            Editable = false;            trigger OnValidate()            begin                if Rec."Invoicing via" = Rec."Invoicing via"::Contract then                    TestField("Item No.");            end;        }        field(11; "Item Description"; Text[100])        {            Caption = 'Item Description';            FieldClass = FlowField;            CalcFormula = lookup("Sales Line".Description where("Document Type" = field("Document Type"), "Document No." = field("Document No."), "Line No." = field("Document Line No.")));            Editable = false;        }        field(12; Partner; Enum "Service Partner")        {            Caption = 'Partner';            Editable = false;        }        field(13; Description; Text[100])        {            Caption = 'Description';            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();            end;        }        field(14; "Calculation Base Type"; Enum "Calculation Base Type")        {            Caption = 'Calculation Base Type';            Editable = false;            trigger OnValidate()            var                ServiceCommPackageLine: Record "Subscription Package Line";            begin                ServiceCommPackageLine.CheckCalculationBaseTypeAgainstVendorError(Partner, "Calculation Base Type");            end;        }        field(15; "Calculation Base Amount"; Decimal)        {            Caption = 'Calculation Base Amount';            MinValue = 0;            BlankZero = true;            AutoFormatType = 2;            AutoFormatExpression = Rec."Currency Code";            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                CalculatePrice();            end;        }        field(16; "Calculation Base %"; Decimal)        {            Caption = 'Calculation Base %';            MinValue = 0;            BlankZero = true;            DecimalPlaces = 0 : 5;            AutoFormatType = 0;            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                CalculatePrice();            end;        }        field(17; "Price"; Decimal)        {            Caption = 'Price';            Editable = false;            BlankZero = true;            AutoFormatType = 2;            AutoFormatExpression = Rec."Currency Code";            trigger OnValidate()            var                SalesHeader: Record "Sales Header";            begin                GetSalesHeader(SalesHeader);                Currency.Initialize(SalesHeader."Currency Code");                "Price" := Round("Price", Currency."Unit-Amount Rounding Precision");                TestIfSalesOrderIsReleased();                Validate("Discount %");            end;        }        field(18; "Discount %"; Decimal)        {            Caption = 'Discount %';            MinValue = 0;            MaxValue = 100;            BlankZero = true;            DecimalPlaces = 0 : 5;            AutoFormatType = 0;            trigger OnValidate()            begin                CalculateServiceAmount(FieldNo("Discount %"));            end;        }        field(19; "Discount Amount"; Decimal)        {            Caption = 'Discount Amount';            MinValue = 0;            BlankZero = true;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";            trigger OnValidate()            begin                CalculateServiceAmount(FieldNo("Discount Amount"));            end;        }        field(20; Amount; Decimal)        {            Caption = 'Amount';            BlankZero = true;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";            trigger OnValidate()            begin                CalculateServiceAmount(FieldNo(Amount));            end;        }        field(21; "Sub. Line Start Formula"; DateFormula)        {            Caption = 'Subscription Line Start Formula';            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();            end;        }        field(22; "Agreed Sub. Line Start Date"; Date)        {            Caption = 'Agreed Subscription Line Start Date';        }        field(23; "Initial Term"; DateFormula)        {            Caption = 'Initial Term';            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                DateFormulaManagement.ErrorIfDateFormulaNegative("Initial Term");            end;        }        field(24; "Notice Period"; DateFormula)        {            Caption = 'Notice Period';            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                DateFormulaManagement.ErrorIfDateFormulaNegative("Notice Period");            end;        }        field(25; "Extension Term"; DateFormula)        {            Caption = 'Subsequent Term';            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                if Format("Extension Term") = '' then                    TestField("Notice Period", "Extension Term");                DateFormulaManagement.ErrorIfDateFormulaNegative("Extension Term");            end;        }        field(26; "Billing Base Period"; DateFormula)        {            Caption = 'Billing Base Period';            Editable = false;            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                DateFormulaManagement.ErrorIfDateFormulaEmpty("Billing Base Period", FieldCaption("Billing Base Period"));                DateFormulaManagement.ErrorIfDateFormulaNegative("Billing Base Period");                CheckRatioBetweenBillingBasePeriodAndRhythm();            end;        }        field(27; "Billing Rhythm"; DateFormula)        {            Caption = 'Billing Rhythm';            Editable = false;            trigger OnValidate()            begin                TestIfSalesOrderIsReleased();                DateFormulaManagement.ErrorIfDateFormulaEmpty("Billing Rhythm", FieldCaption("Billing Rhythm"));                DateFormulaManagement.ErrorIfDateFormulaNegative("Billing Rhythm");                CheckRatioBetweenBillingBasePeriodAndRhythm();            end;        }        field(28; "Invoicing via"; Enum "Invoicing Via")        {            Caption = 'Invoicing via';            Editable = false;        }        field(30; Template; Code[20])        {            Caption = 'Template';            TableRelation = "Sub. Package Line Template";            ValidateTableRelation = false;            Editable = false;        }        field(31; "Subscription Package Code"; Code[20])        {            Caption = 'Subscription Package Code';            TableRelation = "Subscription Package";            Editable = false;            trigger OnValidate()            var                ServiceCommitmentTemplate: Record "Sub. Package Line Template";            begin                if ServiceCommitmentTemplate.Get(Template) then begin                    Rec."Usage Based Billing" := ServiceCommitmentTemplate."Usage Based Billing";                    Rec."Usage Based Pricing" := ServiceCommitmentTemplate."Usage Based Pricing";                    Rec."Pricing Unit Cost Surcharge %" := ServiceCommitmentTemplate."Pricing Unit Cost Surcharge %";                    Rec.Modify(false);                end;            end;        }        field(32; "Customer Price Group"; Code[10])        {            Caption = 'Customer Price Group';            Editable = false;            TableRelation = "Customer Price Group";        }        field(33; Discount; Boolean)        {            Caption = 'Discount';            Editable = false;        }        field(40; "Create Contract Deferrals"; Enum "Create Contract Deferrals")        {            Caption = 'Create Contract Deferrals';        }        field(50; "Subscription Header No."; Code[20])        {            Caption = 'Subscription No.';            Editable = false;            TableRelation = "Subscription Header";        }        field(51; "Subscription Line Entry No."; Integer)        {            Caption = 'Subscription Line Entry No.';            Editable = false;            TableRelation = "Subscription Line"."Entry No.";        }        field(54; "Price Binding Period"; DateFormula)        {            Caption = 'Price Binding Period';        }        field(59; "Period Calculation"; enum "Period Calculation")        {            Caption = 'Period Calculation';        }        field(60; "Linked to No."; Code[20])        {            Caption = 'Linked to No.';            Editable = false;        }        field(61; "Linked to Line No."; Integer)        {            Caption = 'Linked to Line No.';            Editable = false;        }        field(62; Process; Enum Process)        {            Caption = 'Process';            Editable = false;            trigger OnValidate()            begin                UpdateHeaderFromContractRenewal();            end;        }        field(100; "Unit Cost"; Decimal)        {            Caption = 'Unit Cost';            Editable = false;            AutoFormatType = 2;            AutoFormatExpression = Rec."Currency Code";        }        field(101; "Unit Cost (LCY)"; Decimal)        {            AutoFormatType = 2;            AutoFormatExpression = '';            Caption = 'Unit Cost (LCY)';            trigger OnValidate()            var                SalesHeader: Record "Sales Header";            begin                GetSalesHeader(SalesHeader);                if SalesHeader."Currency Code" <> '' then                    "Unit Cost" := Round(CurrExchRate.ExchangeAmtLCYToFCY(GetDate(), SalesHeader."Currency Code", "Unit Cost (LCY)", SalesHeader."Currency Factor"), Currency."Unit-Amount Rounding Precision")                else                    "Unit Cost" := "Unit Cost (LCY)";            end;        }        field(102; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            Editable = false;            FieldClass = FlowField;            CalcFormula = lookup("Sales Header"."Currency Code" where("Document Type" = field("Document Type"), "No." = field("Document No.")));        }        field(8000; "Usage Based Billing"; Boolean)        {            Caption = 'Usage Based Billing';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Usage Based Billing" then begin                    Rec.TestField("Invoicing via", Enum::"Invoicing Via"::Contract);                    Rec.TestField(Discount, false);                    if Rec."Usage Based Pricing" = "Usage Based Pricing"::None then                        Rec.Validate("Usage Based Pricing", "Usage Based Pricing"::"Usage Quantity");                end else                    Validate("Usage Based Pricing", "Usage Based Pricing"::None);            end;        }        field(8001; "Usage Based Pricing"; Enum "Usage Based Pricing")        {            Caption = 'Usage Based Pricing';            DataClassification = CustomerContent;            trigger OnValidate()            begin                if Rec."Usage Based Pricing" <> Enum::"Usage Based Pricing"::None then begin                    Rec.TestField("Invoicing via", Enum::"Invoicing Via"::Contract);                    Validate("Usage Based Billing", true);                    if Rec."Usage Based Pricing" <> Enum::"Usage Based Pricing"::"Unit Cost Surcharge" then                        Validate("Pricing Unit Cost Surcharge %", 0);                end                else begin                    "Usage Based Billing" := false;                    "Pricing Unit Cost Surcharge %" := 0;                end;            end;        }        field(8002; "Pricing Unit Cost Surcharge %"; Decimal)        {            Caption = 'Pricing Unit Cost Surcharge %';            DataClassification = CustomerContent;            AutoFormatType = 0;            DecimalPlaces = 0 : 5;        }    }    keys    {        key(PK; "Line No.")        {            Clustered = true;        }        key(SK1; "Document Type", "Document No.", "Document Line No.", "Subscription Package Code")        {        }    }    trigger OnModify()    begin        TestIfSalesOrderIsReleased();    end;    trigger OnDelete()    var        SalesServiceCommitmentCannotBeDeletedErr: Label 'The Sales Subscription Line cannot be deleted, because it is the last line with Process Contract Renewal. Please delete the Sales line in order to delete the Sales Subscription Line.';    begin        TestIfSalesOrderIsReleased();        if Rec.IsOnlyRemainingLineForContractRenewalInDocument() then            Error(SalesServiceCommitmentCannotBeDeletedErr);    end;    local procedure TestIfSalesOrderIsReleased()    var        SalesHeader: Record "Sales Header";    begin        GetSalesHeader(SalesHeader);        if not SalesHeader.TestStatusIsNotReleased() then            Error(ReleasedSalesOrderExistsErr);    end;    procedure FilterOnSalesLine(SourceSalesLine: Record "Sales Line")    begin        Rec.FilterOnDocument(SourceSalesLine."Document Type", SourceSalesLine."Document No.");        Rec.SetRange("Document Line No.", SourceSalesLine."Line No.");    end;    internal procedure FilterOnDocument(SalesDocumentType: Enum "Sales Document Type"; DocumentNo: Code[20])    begin        Rec.SetRange("Document Type", SalesDocumentType);        Rec.SetRange("Document No.", DocumentNo);    end;    internal procedure InitRecord(SourceSalesLine: Record "Sales Line")    begin        Rec.Init();        SetDocumentFields(SourceSalesLine."Document Type", SourceSalesLine."Document No.", SourceSalesLine."Line No.");        SalesLine := SourceSalesLine;        Rec."Line No." := 0;    end;    internal procedure SetDocumentFields(DocType: Enum "Sales Document Type"; DocNo: Code[20];                                                      DocLineNo: Integer)    begin        Rec."Document Type" := DocType;        Rec."Document No." := DocNo;        Rec."Document Line No." := DocLineNo;    end;    local procedure CalculateServiceAmount(CalledByFieldNo: Integer)    var        SalesHeader: Record "Sales Header";        MaxServiceAmount: Decimal;    begin        TestIfSalesOrderIsReleased();        GetSalesHeader(SalesHeader);        GetSalesLine(SalesLine);        MaxServiceAmount := Round((Price * SalesLine.Quantity), Currency."Amount Rounding Precision");        if CalledByFieldNo = FieldNo(Amount) then begin            Amount := Round(Amount, Currency."Amount Rounding Precision");            if Amount > MaxServiceAmount then                Error(ServiceAmountIncreaseErr, FieldCaption(Amount), Format(MaxServiceAmount));            "Discount Amount" := Round(MaxServiceAmount - Amount, Currency."Amount Rounding Precision");            if MaxServiceAmount <> 0 then                "Discount %" := Round(100 - (Amount / MaxServiceAmount * 100), 0.00001);        end else begin            Amount := Round((Price * SalesLine.Quantity), Currency."Amount Rounding Precision");            if CalledByFieldNo = FieldNo("Discount %") then                "Discount Amount" := Round(Amount * "Discount %" / 100, Currency."Amount Rounding Precision");            if CalledByFieldNo = FieldNo("Discount Amount") then                if Amount <> 0 then                    "Discount %" := Round("Discount Amount" / Amount * 100, 0.00001)                else                    "Discount %" := 0;            Amount := Round((Price * SalesLine.Quantity) - "Discount Amount", Currency."Amount Rounding Precision");            if Amount > MaxServiceAmount then                Error(ServiceAmountIncreaseErr, FieldCaption(Amount), Format(MaxServiceAmount));        end;    end;    procedure CalculateCalculationBaseAmount()    var        IsHandled: Boolean;    begin        GetSalesLine(SalesLine);        OnBeforeCalculateCalculationBaseAmount(SalesLine, Rec, IsHandled);        if IsHandled then            exit;        if SalesLine.Type <> Enum::"Sales Line Type"::Item then            exit;        case Partner of            Partner::Customer:                CalculateCalculationBaseAmountCustomer();            Partner::Vendor:                CalculateCalculationBaseAmountVendor();        end;        OnAfterCalculateCalculationBaseAmount(SalesLine, Rec);    end;    local procedure CalculateCalculationBaseAmountCustomer()    var        TempSalesLine: Record "Sales Line" temporary;        CalculatedBaseAmount: Decimal;        IsHandled: Boolean;    begin        case "Calculation Base Type" of            "Calculation Base Type"::"Item Price":                begin                    TempSalesLine := SalesLine;                    TempSalesLine.UpdateUnitPrice(TempSalesLine.FieldNo("No."));                    CalculatedBaseAmount := TempSalesLine."Unit Price";                end;            "Calculation Base Type"::"Document Price",            "Calculation Base Type"::"Document Price And Discount":                CalculatedBaseAmount := SalesLine."Unit Price";            else begin                IsHandled := false;                OnCalculateBaseTypeElseCaseOnCalculateCalculationBaseAmountCustomer(Rec, SalesLine, CalculatedBaseAmount, IsHandled);                if not IsHandled then                    Error(CalculateBaseTypeOptionNotImplementedErr, Format("Calculation Base Type"), FieldCaption("Calculation Base Type"),                                         Rec.TableCaption, CalculateCalculationBaseAmountCustomerProcedureNameLbl);            end;        end;        Validate("Calculation Base Amount", CalculatedBaseAmount);        if "Calculation Base Type" = "Calculation Base Type"::"Document Price And Discount" then            Validate("Discount %", SalesLine."Line Discount %");        if (Partner = Partner::Customer) and           ("Calculation Base Type" in [Enum::"Calculation Base Type"::"Document Price", Enum::"Calculation Base Type"::"Document Price And Discount"])       then            CalculateUnitCost();        Modify();    end;    local procedure CalculateCalculationBaseAmountVendor()    var        SalesHeader: Record "Sales Header";        ContractsItemManagement: Codeunit "Sub. Contracts Item Management";        CurrencyDate: Date;        CalculatedBaseAmount: Decimal;        IsHandled: Boolean;    begin        case "Calculation Base Type" of            "Calculation Base Type"::"Item Price":                begin                    SalesLine.TestField(Type, SalesLine.Type::Item);                    CalculatedBaseAmount := ContractsItemManagement.CalculateUnitCost(SalesLine."No.");                    if SalesLine."Currency Code" <> '' then begin                        SalesHeader := SalesLine.GetSalesHeader();                        CurrencyDate := SalesLine.GetDate();                        CalculatedBaseAmount :=                            Round(                                CurrExchRate.ExchangeAmtLCYToFCY(                                    CurrencyDate, SalesHeader."Currency Code",                                    CalculatedBaseAmount, SalesHeader."Currency Factor"),                                Currency."Unit-Amount Rounding Precision");                    end;                end;            "Calculation Base Type"::"Document Price":                CalculatedBaseAmount := SalesLine."Unit Cost";            else begin                IsHandled := false;                OnCalculateBaseTypeElseCaseOnCalculateCalculationBaseAmountVendor(Rec, SalesLine, CalculatedBaseAmount, IsHandled);                if not IsHandled then                    Error(CalculateBaseTypeOptionNotImplementedErr, Format("Calculation Base Type"), FieldCaption("Calculation Base Type"),                                                                    Rec.TableCaption, CalculateCalculationBaseAmountVendorProcedureNameLbl);            end;        end;        Validate("Calculation Base Amount", CalculatedBaseAmount);        Modify();    end;    local procedure CalculatePrice()    begin        if "Calculation Base Amount" <> 0 then begin            if Discount then                "Calculation Base Amount" := Abs("Calculation Base Amount") * -1;            Validate(Price, "Calculation Base Amount" * "Calculation Base %" / 100);        end else            Validate(Price, 0);        if Partner = Partner::Vendor then            CalculateUnitCost();    end;    local procedure GetSalesHeader(var OutSalesHeader: Record "Sales Header")    var        SalesHeader: Record "Sales Header";    begin        TestField("Document No.");        if ("Document Type" <> SalesHeader."Document Type") or ("Document No." <> SalesHeader."No.") then            if SalesHeader.Get("Document Type", "Document No.") then                if SalesHeader."Currency Code" = '' then                    Currency.InitRoundingPrecision()                else begin                    SalesHeader.TestField("Currency Factor");                    Currency.Get(SalesHeader."Currency Code");                    Currency.TestField("Unit-Amount Rounding Precision");                    Currency.TestField("Amount Rounding Precision");                end            else                Clear(SalesHeader);        OutSalesHeader := SalesHeader;    end;    internal procedure CalcVATAmountLines(var SalesHeader: Record "Sales Header"; var TempSalesServiceCommitmentBuff: Record "Sales Service Commitment Buff." temporary; var UniqueRhythmDictionary: Dictionary of [Code[20], Text])    var        SalesServiceCommitment: Record "Sales Subscription Line";        SalesTaxCalculate: Codeunit "Sales Tax Calculate";        BasePeriodCount: Integer;        RhythmPeriodCount: Integer;    begin        BasePeriodCount := 1;        RhythmPeriodCount := 1;        if SalesHeader."Currency Code" = '' then            Currency.InitRoundingPrecision()        else            Currency.Get(SalesHeader."Currency Code");        TempSalesServiceCommitmentBuff.DeleteAll(false);        SalesServiceCommitment.FilterOnDocument(SalesHeader."Document Type", SalesHeader."No.");        SalesServiceCommitment.SetRange(Partner, Enum::"Service Partner"::Customer);        SalesServiceCommitment.SetRange("Invoicing via", SalesServiceCommitment."Invoicing via"::Contract);        if SalesServiceCommitment.FindSet() then            repeat                CreateTempSalesServiceCommitmentBuffForSalesServiceCommitment(SalesServiceCommitment, TempSalesServiceCommitmentBuff, UniqueRhythmDictionary, BasePeriodCount, RhythmPeriodCount);            until SalesServiceCommitment.Next() = 0;        if TempSalesServiceCommitmentBuff.Find('-') then            repeat                case TempSalesServiceCommitmentBuff."VAT Calculation Type" of                    TempSalesServiceCommitmentBuff."VAT Calculation Type"::"Normal VAT",                    TempSalesServiceCommitmentBuff."VAT Calculation Type"::"Reverse Charge VAT":                        if SalesHeader."Prices Including VAT" then begin                            TempSalesServiceCommitmentBuff."VAT Base" :=                                Round(TempSalesServiceCommitmentBuff."Line Amount" / (1 + TempSalesServiceCommitmentBuff."VAT %" / 100), Currency."Amount Rounding Precision");                            TempSalesServiceCommitmentBuff."VAT Amount" :=                                Round(                                    TempSalesServiceCommitmentBuff."Line Amount" - TempSalesServiceCommitmentBuff."VAT Base",                                    Currency."Amount Rounding Precision", Currency.VATRoundingDirection());                            TempSalesServiceCommitmentBuff."Amount Including VAT" := TempSalesServiceCommitmentBuff."VAT Base" + TempSalesServiceCommitmentBuff."VAT Amount";                        end else begin                            TempSalesServiceCommitmentBuff."VAT Base" := TempSalesServiceCommitmentBuff."Line Amount";                            TempSalesServiceCommitmentBuff."VAT Amount" :=                                Round(                                    TempSalesServiceCommitmentBuff."VAT Base" * TempSalesServiceCommitmentBuff."VAT %" / 100,                                    Currency."Amount Rounding Precision", Currency.VATRoundingDirection());                            TempSalesServiceCommitmentBuff."Amount Including VAT" := TempSalesServiceCommitmentBuff."Line Amount" + TempSalesServiceCommitmentBuff."VAT Amount";                        end;                    TempSalesServiceCommitmentBuff."VAT Calculation Type"::"Full VAT":                        begin                            TempSalesServiceCommitmentBuff."VAT Base" := 0;                            TempSalesServiceCommitmentBuff."VAT Amount" := TempSalesServiceCommitmentBuff."Line Amount";                            TempSalesServiceCommitmentBuff."Amount Including VAT" := TempSalesServiceCommitmentBuff."VAT Amount";                        end;                    TempSalesServiceCommitmentBuff."VAT Calculation Type"::"Sales Tax":                        begin                            if SalesHeader."Prices Including VAT" then begin                                TempSalesServiceCommitmentBuff."Amount Including VAT" := TempSalesServiceCommitmentBuff."Line Amount";                                TempSalesServiceCommitmentBuff."VAT Base" :=                                    Round(                                        SalesTaxCalculate.ReverseCalculateTax(                                            SalesHeader."Tax Area Code", TempSalesServiceCommitmentBuff."Tax Group Code", SalesHeader."Tax Liable",                                            SalesHeader."Posting Date", TempSalesServiceCommitmentBuff."Amount Including VAT", TempSalesServiceCommitmentBuff.Quantity, SalesHeader."Currency Factor"),                                    Currency."Amount Rounding Precision");                                TempSalesServiceCommitmentBuff."VAT Amount" := TempSalesServiceCommitmentBuff."Amount Including VAT" - TempSalesServiceCommitmentBuff."VAT Base";                            end else begin                                TempSalesServiceCommitmentBuff."VAT Base" := TempSalesServiceCommitmentBuff."Line Amount";                                TempSalesServiceCommitmentBuff."VAT Amount" :=                                    SalesTaxCalculate.CalculateTax(                                        SalesHeader."Tax Area Code", TempSalesServiceCommitmentBuff."Tax Group Code", SalesHeader."Tax Liable",                                        SalesHeader."Posting Date", TempSalesServiceCommitmentBuff."VAT Base", TempSalesServiceCommitmentBuff.Quantity, SalesHeader."Currency Factor");                                TempSalesServiceCommitmentBuff."VAT Amount" :=                                    Round(TempSalesServiceCommitmentBuff."VAT Amount", Currency."Amount Rounding Precision", Currency.VATRoundingDirection());                                TempSalesServiceCommitmentBuff."Amount Including VAT" := TempSalesServiceCommitmentBuff."VAT Base" + TempSalesServiceCommitmentBuff."VAT Amount";                            end;                            if TempSalesServiceCommitmentBuff."VAT Base" = 0 then                                TempSalesServiceCommitmentBuff."VAT %" := 0                            else                                TempSalesServiceCommitmentBuff."VAT %" := Round(100 * TempSalesServiceCommitmentBuff."VAT Amount" / TempSalesServiceCommitmentBuff."VAT Base", 0.00001);                        end;                end;                TempSalesServiceCommitmentBuff.Modify(false);            until TempSalesServiceCommitmentBuff.Next() = 0;    end;    local procedure CreateTempSalesServiceCommitmentBuffForSalesServiceCommitment(SalesServiceCommitment: Record "Sales Subscription Line";                                                                 var TempSalesServiceCommitmentBuff: Record "Sales Service Commitment Buff." temporary;                                                                 var UniqueRhythmDictionary: Dictionary of [Code[20], Text];                                                                 var BasePeriodCount: Integer;                                                                 var RhythmPeriodCount: Integer)    var        SalesLineVAT: Record "Sales Line";        ContractRenewalMgt: Codeunit "Sub. Contract Renewal Mgt.";        IsHandled: Boolean;        RhythmIdentifier: Code[20];        ContractRenewalPriceCalculationRatio: Decimal;        VatPercent: Decimal;        DateFormulaType: Enum "Date Formula Type";        ContractRenewalLbl: Label 'Contract Renewal';        RhythmTextLbl: Label '%1 %2', Comment = '%1 = Billing Rhythm Period Count,%2 = Billing Rhythm Text';        RhythmText: Text;    begin        OnBeforeCreateVATAmountLineForSalesSubscriptionLine(SalesServiceCommitment, IsHandled);        if IsHandled then            exit;        GetSalesLine(SalesServiceCommitment, SalesLineVAT);        // Get Rhythm and Base period count        if SalesLineVAT.IsContractRenewal() then begin            ContractRenewalPriceCalculationRatio := DateFormulaManagement.CalculateRenewalTermRatioByBillingRhythm(SalesServiceCommitment."Agreed Sub. Line Start Date", SalesServiceCommitment."Initial Term", SalesServiceCommitment."Billing Rhythm");            RhythmIdentifier := ContractRenewalMgt.GetContractRenewalIdentifierLabel();            RhythmText := ContractRenewalLbl;        end else begin            DateFormulaType := DateFormulaManagement.FindDateFormulaTypeForComparison(SalesServiceCommitment."Billing Rhythm", RhythmPeriodCount);            DateFormulaManagement.FindDateFormulaTypeForComparison(SalesServiceCommitment."Billing Base Period", BasePeriodCount);            if (DateFormulaType = DateFormulaType::Quarter) or (DateFormulaType = DateFormulaType::Year) then                DateFormulaType := DateFormulaType::Month;            RhythmIdentifier := Format(RhythmPeriodCount) + Format(DateFormulaType);        end;        if not UniqueRhythmDictionary.ContainsKey(RhythmIdentifier) then begin            if not SalesLineVAT.IsContractRenewal() then                if ((RhythmPeriodCount > 1) and (DateFormulaType.AsInteger() <= Enum::"Date Formula Type"::Year.AsInteger())) then                    // Use plural for more then 1                    RhythmText := StrSubstNo(RhythmTextLbl, RhythmPeriodCount, Enum::"Date Formula Type".FromInteger((DateFormulaType.AsInteger() + 100)))                else                    RhythmText := Format(DateFormulaType);            UniqueRhythmDictionary.Add(RhythmIdentifier, RhythmText);        end;        if (SalesLineVAT.Type <> Enum::"Sales Line Type"::" ") and (SalesLineVAT.Quantity <> 0) then begin            if SalesLineVAT."VAT Calculation Type" in               [SalesLineVAT."VAT Calculation Type"::"Reverse Charge VAT", SalesLineVAT."VAT Calculation Type"::"Sales Tax"]            then                VatPercent := 0            else                VatPercent := SalesLineVAT."VAT %";            TempSalesServiceCommitmentBuff.Reset();            TempSalesServiceCommitmentBuff.SetRange("Rhythm Identifier", RhythmIdentifier);            TempSalesServiceCommitmentBuff.SetRange("VAT Calculation Type", SalesLineVAT."VAT Calculation Type");            TempSalesServiceCommitmentBuff.SetRange("VAT %", VatPercent);            TempSalesServiceCommitmentBuff.SetRange("Tax Group Code", SalesLineVAT."Tax Group Code");            if not TempSalesServiceCommitmentBuff.FindLast() then begin                TempSalesServiceCommitmentBuff."Entry No." := TempSalesServiceCommitmentBuff.GetNextEntryNo();                TempSalesServiceCommitmentBuff.Init();                TempSalesServiceCommitmentBuff."Rhythm Identifier" := RhythmIdentifier;                TempSalesServiceCommitmentBuff."VAT Calculation Type" := SalesLineVAT."VAT Calculation Type";                TempSalesServiceCommitmentBuff."Tax Group Code" := SalesLineVAT."Tax Group Code";                TempSalesServiceCommitmentBuff."VAT %" := VatPercent;                TempSalesServiceCommitmentBuff."Currency Code" := SalesLineVAT."Currency Code";                TempSalesServiceCommitmentBuff.Insert(false);            end;            TempSalesServiceCommitmentBuff.Reset();            TempSalesServiceCommitmentBuff.Quantity += SalesLineVAT."Quantity (Base)";            if SalesLineVAT.IsContractRenewal() then                TempSalesServiceCommitmentBuff."Line Amount" += SalesServiceCommitment.Amount * ContractRenewalPriceCalculationRatio            else                TempSalesServiceCommitmentBuff."Line Amount" += SalesServiceCommitment.Amount / BasePeriodCount * RhythmPeriodCount;            TempSalesServiceCommitmentBuff.Modify(false);        end;    end;    internal procedure IsOnlyRemainingLineForContractRenewalInDocument(): Boolean    var        SalesServiceCommitment: Record "Sales Subscription Line";    begin        if Process <> Process::"Contract Renewal" then            exit(false);        SalesServiceCommitment.SetRange("Document Type", Rec."Document Type");        SalesServiceCommitment.SetRange("Document No.", Rec."Document No.");        SalesServiceCommitment.SetRange(Process, Process::"Contract Renewal");        SalesServiceCommitment.SetFilter("Line No.", '<>%1', Rec."Line No.");        exit(SalesServiceCommitment.IsEmpty());    end;    local procedure UpdateHeaderFromContractRenewal()    begin        if not (Rec."Document Type" in [Rec."Document Type"::Quote, Rec."Document Type"::Order]) then            FieldError(Rec."Document Type");        SalesLine.Get(Rec."Document Type", Rec."Document No.", Rec."Document Line No.");        SalesLine.SetExcludeFromDocTotal();        SalesLine.UpdateUnitPrice(FieldNo(Rec.Process));    end;    internal procedure CalculateUnitCost()    var        SalesHeader: Record "Sales Header";        CurrencyDate: Date;    begin        GetSalesLine(SalesLine);        case Rec.Partner of            Partner::Customer:                Rec.Validate("Unit Cost (LCY)", SalesLine."Unit Cost (LCY)" * Rec."Calculation Base %" / 100);            Partner::Vendor:                if SalesLine."Currency Code" <> '' then begin                    SalesHeader := SalesLine.GetSalesHeader();                    CurrencyDate := SalesLine.GetDate();                    Rec.Validate("Unit Cost (LCY)",                                 Round(                                    CurrExchRate.ExchangeAmtFCYToLCY(                                        CurrencyDate, SalesHeader."Currency Code",                                        Rec.Price, SalesHeader."Currency Factor"),                                    Currency."Unit-Amount Rounding Precision"));                end else                    Rec.Validate("Unit Cost (LCY)", Rec.Price);        end;    end;    local procedure GetDate(): Date    begin        GetSalesLine(SalesLine);        exit(SalesLine.GetDate());    end;    local procedure GetSalesLine(var SalesLine2: Record "Sales Line")    begin        GetSalesLine(Rec, SalesLine2);    end;    local procedure GetSalesLine(SalesSubscriptionLine: Record "Sales Subscription Line"; var SalesLine2: Record "Sales Line")    begin        if (SalesLine."Document Type" <> SalesSubscriptionLine."Document Type")            or (SalesLine."Document No." <> SalesSubscriptionLine."Document No.")            or (SalesLine."Line No." <> SalesSubscriptionLine."Document Line No.")        then            SalesLine2.Get(SalesSubscriptionLine."Document Type", SalesSubscriptionLine."Document No.", SalesSubscriptionLine."Document Line No.")        else            SalesLine2 := SalesLine;        OnAfterGetSalesLine(Rec, SalesLine2);    end;    procedure SetSalesLine(var NewSalesLine: Record "Sales Line")    begin        SalesLine := NewSalesLine;    end;    local procedure CheckRatioBetweenBillingBasePeriodAndRhythm()    var    begin        if (Format("Billing Base Period") <> '') and (Format("Billing Rhythm") <> '') then            DateFormulaManagement.CheckIntegerRatioForDateFormulas("Billing Base Period", FieldCaption("Billing Base Period"), "Billing Rhythm", FieldCaption("Billing Rhythm"));    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateBaseTypeElseCaseOnCalculateCalculationBaseAmountCustomer(SalesSubscriptionLine: Record "Sales Subscription Line"; SalesLine: Record "Sales Line"; var CalculatedBaseAmount: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateBaseTypeElseCaseOnCalculateCalculationBaseAmountVendor(SalesSubscriptionLine: Record "Sales Subscription Line"; SalesLine: Record "Sales Line"; var CalculatedBaseAmount: Decimal; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCreateVATAmountLineForSalesSubscriptionLine(SalesSubscriptionLine: Record "Sales Subscription Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetSalesLine(var SalesSubscriptionLine: Record "Sales Subscription Line"; var SalesLine: Record "Sales Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeCalculateCalculationBaseAmount(var SalesLine: Record "Sales Line"; var SalesSubscriptionLine: Record "Sales Subscription Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCalculateCalculationBaseAmount(var SalesLine: Record "Sales Line"; var SalesSubscriptionLine: Record "Sales Subscription Line")    begin    end;    var        Currency: Record Currency;        CurrExchRate: Record "Currency Exchange Rate";        SalesLine: Record "Sales Line";        DateFormulaManagement: Codeunit "Date Formula Management";        ServiceAmountIncreaseErr: Label '%1 cannot be greater than %2.', Comment = '%1 and %2 are numbers';        ReleasedSalesOrderExistsErr: Label 'Subscription Lines cannot be edited on orders with status = Released.';        CalculateBaseTypeOptionNotImplementedErr: Label 'Unknown option %1 for %2.\\ Object Name: %3, Procedure: %4', Comment = '%1=Format("Calculation Base Type"), %2 = Fieldcaption for "Calculation Base Type", %3 = Current object name, %4 = Current procedure name';        CalculateCalculationBaseAmountVendorProcedureNameLbl: Label 'CalculateCalculationBaseAmountVendor', Locked = true;        CalculateCalculationBaseAmountCustomerProcedureNameLbl: Label 'CalculateCalculationBaseAmountCustomer', Locked = true;}