Table 6084 Service Line Price Adjmt.
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;}