Table 173 Standard Purchase Code

Base Application, Microsoft.Purchases.Document

src/Layers/W1/BaseApp/Purchases/Document/StandardPurchaseCode.Table.al115 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.Purchases.Document;using Microsoft.Finance.Currency;using System.Utilities;table 173 "Standard Purchase Code"{    Caption = 'Standard Purchase Code';    DataCaptionFields = "Code", Description;    LookupPageID = "Standard Purchase Codes";    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[10])        {            Caption = 'Code';            ToolTip = 'Specifies a code which identifies this standard purchase code.';            NotBlank = true;        }        field(2; Description; Text[100])        {            Caption = 'Description';            ToolTip = 'Specifies a description of the standard purchase code.';        }        field(3; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            ToolTip = 'Specifies the currency code of the amounts on the standard purchase lines.';            TableRelation = Currency;            trigger OnValidate()            var                Currency: Record Currency;                Currency2: Record Currency;                StandardVendorPurchaseCode: Record "Standard Vendor Purchase Code";                ConfirmManagement: Codeunit "Confirm Management";            begin                if not Currency.Get("Currency Code") then                    Currency.InitRoundingPrecision();                if not Currency2.Get(xRec."Currency Code") then                    Currency2.InitRoundingPrecision();                if Currency."Amount Rounding Precision" <> Currency2."Amount Rounding Precision" then begin                    StdPurchLine.Reset();                    StdPurchLine.SetRange("Standard Purchase Code", Code);                    StdPurchLine.SetRange(Type, StdPurchLine.Type::"G/L Account");                    StdPurchLine.SetFilter("Amount Excl. VAT", '<>%1', 0);                    if StdPurchLine.Find('-') then begin                        if not ConfirmManagement.GetResponseOrDefault(                             StrSubstNo(                               Text001, FieldCaption("Currency Code"), StdPurchLine.FieldCaption("Amount Excl. VAT"),                               FieldCaption("Currency Code")), true)                        then                            Error(Text002);                        repeat                            StdPurchLine."Amount Excl. VAT" :=                              Round(StdPurchLine."Amount Excl. VAT", Currency."Amount Rounding Precision");                            StdPurchLine.Modify();                        until StdPurchLine.Next() = 0;                    end;                end;                StandardVendorPurchaseCode.SetRange(Code, Code);                StandardVendorPurchaseCode.ModifyAll("Currency Code", "Currency Code");            end;        }    }    keys    {        key(Key1; "Code")        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnDelete()    var        ConfirmManagement: Codeunit "Confirm Management";    begin        StdVendorPurchCode.Reset();        StdVendorPurchCode.SetRange(Code, Code);        if not StdVendorPurchCode.IsEmpty() then            if not ConfirmManagement.GetResponseOrDefault(                StrSubstNo(StdPurchCodeDeletionQst, rec.Code, StdVendorPurchCode.TableCaption()), true) then                Error('');        StdPurchLine.Reset();        StdPurchLine.SetRange("Standard Purchase Code", Code);        StdPurchLine.DeleteAll(true);        StdVendorPurchCode.DeleteAll(true);    end;    var        StdPurchLine: Record "Standard Purchase Line";        StdVendorPurchCode: Record "Standard Vendor Purchase Code";#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'If you change the %1, the %2 will be rounded according to the new %3.';#pragma warning restore AA0470        Text002: Label 'The update has been interrupted to respect the warning.';#pragma warning restore AA0074        StdPurchCodeDeletionQst: Label 'If you delete the code %1, the related records in the %2 table will also be deleted. Do you want to continue?', Comment = '%1=Standard Purchase Code, %3=Table Caption';}