Table 6084 Service Line Price Adjmt.

Base Application, Microsoft.Service.Pricing

src/Layers/W1/BaseApp/Service/Pricing/ServiceLinePriceAdjmt.Table.al284 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.Pricing;using Microsoft.Finance.Currency;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;using Microsoft.Service.Document;using Microsoft.Service.Item;table 6084 "Service Line Price Adjmt."{    Caption = 'Service Line Price Adjmt.';    DataClassification = CustomerContent;    fields    {        field(1; "Document Type"; Enum "Service Document Type")        {            Caption = 'Document Type';        }        field(2; "Document No."; Code[20])        {            Caption = 'Document No.';        }        field(3; "Service Line No."; Integer)        {            Caption = 'Service Line No.';        }        field(4; "Service Item Line No."; Integer)        {            Caption = 'Service Item Line No.';        }        field(5; "Service Item No."; Code[20])        {            Caption = 'Service Item No.';            ToolTip = 'Specifies the number of the service item that is registered in the Service Item table.';            TableRelation = "Service Item";        }        field(6; "Serv. Price Adjmt. Gr. Code"; Code[10])        {            Caption = 'Serv. Price Adjmt. Gr. Code';            ToolTip = 'Specifies the code of the service price adjustment group that applies to the posted service line.';            TableRelation = "Service Price Adjustment Group";        }        field(7; Type; Enum "Service Line Type")        {            Caption = 'Type';            ToolTip = 'Specifies the type of this line, which can be item, resource, cost, or general ledger Account.';            Editable = false;        }        field(8; "No."; Code[20])        {            Caption = 'No.';            ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.';            Editable = false;            TableRelation = if (Type = const(Item)) Item            else            if (Type = const(Resource)) Resource            else            if (Type = const(Cost)) "Service Cost";        }        field(9; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies the service item, resource, or service cost, of which the price is going to be adjusted.';            Editable = false;        }        field(10; Quantity; Decimal)        {            AutoFormatType = 0;            Caption = 'Quantity';            ToolTip = 'Specifies the value of the service line that will be adjusted.';            Editable = false;        }        field(14; Amount; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 1;            Caption = 'Amount';            ToolTip = 'Specifies the total net amount on the service line.';            Editable = false;        }        field(15; "New Amount"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 1;            Caption = 'New Amount';            ToolTip = 'Specifies the amount to invoice.';            trigger OnValidate()            var                IsHandled: Boolean;            begin                GetServHeader();                IsHandled := false;                OnValidateNewAmountOnAfterGetServHeader(Rec, Currency, ServHeader, IsHandled);                if IsHandled then                    exit;                "New Unit Price" :=                  Round(("New Amount" * 100 / (100 - "Discount %")) / Quantity, Currency."Unit-Amount Rounding Precision");                if ServHeader."Prices Including VAT" then                    "New Amount incl. VAT" := "New Amount"                else                    "New Amount incl. VAT" := Round("New Amount" + "New Amount" * "Vat %" / 100, Currency."Amount Rounding Precision");                "Discount Amount" :=                  Round("New Unit Price" * Quantity * "Discount %" / 100, Currency."Amount Rounding Precision");                "New Amount Excl. VAT" := Round("New Amount incl. VAT" / (1 + "Vat %" / 100), Currency."Amount Rounding Precision");            end;        }        field(16; "Unit Price"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 2;            Caption = 'Unit Price';            ToolTip = 'Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card.';            Editable = false;        }        field(17; "New Unit Price"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 2;            Caption = 'New Unit Price';            ToolTip = 'Specifies the unit price of the item, resource, or cost specified on the service line.';            trigger OnValidate()            begin                GetServHeader();                "Discount Amount" :=                  Round("New Unit Price" * Quantity * "Discount %" / 100, Currency."Amount Rounding Precision");                "New Amount" := Round("New Unit Price" * Quantity - "Discount Amount", Currency."Amount Rounding Precision");                if ServHeader."Prices Including VAT" then                    "New Amount incl. VAT" := "New Amount"                else                    "New Amount incl. VAT" := Round("New Amount" + "New Amount" * "Vat %" / 100, Currency."Amount Rounding Precision");                "New Amount Excl. VAT" := Round("New Amount incl. VAT" / (1 + "Vat %" / 100), Currency."Amount Rounding Precision");            end;        }        field(18; "Unit Cost"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 2;            Caption = 'Unit Cost';            Editable = false;        }        field(19; "Discount %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Discount %';            ToolTip = 'Specifies the discount percentage you want to provide on the amount on the corresponding service line.';            Editable = false;        }        field(20; "Discount Amount"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 1;            Caption = 'Discount Amount';            ToolTip = 'Specifies the discount you want to provide on the amount on this service line.';            Editable = false;        }        field(21; "Amount incl. VAT"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 1;            Caption = 'Amount incl. VAT';            ToolTip = 'Specifies the total amount that the service line is going to be adjusted, including VAT.';            Editable = false;        }        field(22; "New Amount incl. VAT"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 1;            Caption = 'New Amount incl. VAT';            ToolTip = 'Specifies a new amount, including VAT.';            trigger OnValidate()            begin                GetServHeader();                if ServHeader."Prices Including VAT" then                    "New Amount" := "New Amount incl. VAT"                else                    "New Amount" := Round("New Amount incl. VAT" / (1 + "Vat %" / 100), Currency."Amount Rounding Precision");                "New Unit Price" :=                  Round(("New Amount" * 100 / (100 - "Discount %")) / Quantity, Currency."Unit-Amount Rounding Precision");                "Discount Amount" :=                  Round("New Unit Price" * Quantity * "Discount %" / 100, Currency."Amount Rounding Precision");                "New Amount Excl. VAT" := Round("New Amount incl. VAT" / (1 + "Vat %" / 100), Currency."Amount Rounding Precision");            end;        }        field(24; Weight; Decimal)        {            AutoFormatType = 0;            Caption = 'Weight';            Editable = false;        }        field(25; "Adjustment Type"; Option)        {            Caption = 'Adjustment Type';            ToolTip = 'Specifies the adjustment type for this line.';            Editable = false;            OptionCaption = 'Fixed,Maximum,Minimum';            OptionMembers = "Fixed",Maximum,Minimum;        }        field(26; "Service Price Group Code"; Code[10])        {            Caption = 'Service Price Group Code';            ToolTip = 'Specifies the code of the service price adjustment group associated with the service item on this line.';            Editable = false;            TableRelation = "Service Price Group";        }        field(27; "Manually Adjusted"; Boolean)        {            Caption = 'Manually Adjusted';            Editable = false;        }        field(28; "Vat %"; Decimal)        {            AutoFormatType = 0;            Caption = 'Vat %';            Editable = false;        }        field(29; "New Amount Excl. VAT"; Decimal)        {            AutoFormatExpression = GetCurrency();            AutoFormatType = 1;            Caption = 'New Amount Excl. VAT';            Editable = false;        }    }    keys    {        key(Key1; "Document Type", "Document No.", "Service Item Line No.", "Service Line No.")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnModify()    begin        "Manually Adjusted" := true;    end;    var        ServHeader: Record "Service Header";        Currency: Record Currency;    local procedure GetServHeader()    begin        if ("Document Type" <> ServHeader."Document Type") or           ("Document No." <> ServHeader."No.")        then begin            ServHeader.Get(Rec."Document Type", Rec."Document No.");            if ServHeader."Currency Code" = '' then                Currency.InitRoundingPrecision()            else begin                ServHeader.TestField("Currency Factor");                Currency.Get(ServHeader."Currency Code");                Currency.TestField("Amount Rounding Precision");            end;        end;    end;    procedure GetCurrency(): Code[10]    begin        GetServHeader();        exit(ServHeader."Currency Code");    end;    [IntegrationEvent(false, false)]    local procedure OnValidateNewAmountOnAfterGetServHeader(var ServiceLinePriceAdjmt: Record "Service Line Price Adjmt."; Currency: Record Currency; ServHeader: Record "Service Header"; var IsHandled: Boolean)    begin    end;}