Table 213 Alt. Cust. VAT Reg.

Base Application, Microsoft.Finance.VAT.Registration

src/Layers/W1/BaseApp/Finance/VAT/Registration/AltCustVATReg.Table.al203 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.Finance.VAT.Registration;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.VAT.Setup;using Microsoft.Foundation.Address;using Microsoft.Sales.Customer;using System.Telemetry;/// <summary>/// Stores alternative VAT registration numbers for customers operating in multiple countries./// Enables country-specific VAT configurations with associated posting groups and validation rules./// </summary>table 213 "Alt. Cust. VAT Reg."{    Caption = 'Alternative Customer VAT Registration';    LookupPageId = "Alt. Cust. VAT Reg.";    DrillDownPageId = "Alt. Cust. VAT Reg.";    fields    {        /// <summary>        /// Unique identifier for the alternative VAT registration record.        /// </summary>        field(1; ID; Integer)        {            DataClassification = SystemMetadata;            AutoIncrement = true;        }        /// <summary>        /// Customer number associated with this alternative VAT registration.        /// </summary>        field(2; "Customer No."; Code[20])        {            DataClassification = CustomerContent;            TableRelation = Customer;            NotBlank = true;            ToolTip = 'Specifies the customer number.';        }        /// <summary>        /// Country or region code for which this alternative VAT registration applies.        /// </summary>        field(3; "VAT Country/Region Code"; Code[10])        {            DataClassification = CustomerContent;            TableRelation = "Country/Region";            ToolTip = 'Specifies the country or region code for the VAT';            NotBlank = true;            trigger OnLookup()            var                Customer: Record Customer;                CountryRegion: Record "Country/Region";                CountriesRegionsPage: Page "Countries/Regions";            begin                if "Customer No." <> '' then begin                    Customer.Get("Customer No.");                    if Customer."Country/Region Code" <> '' then                        CountryRegion.SetFilter(Code, '<>%1', Customer."Country/Region Code");                end;                CountriesRegionsPage.SetTableView(CountryRegion);                CountriesRegionsPage.LookupMode(true);                if CountriesRegionsPage.RunModal() = Action::LookupOK then begin                    CountriesRegionsPage.GetRecord(CountryRegion);                    Validate("VAT Country/Region Code", CountryRegion.Code);                end;            end;            trigger OnValidate()            begin                if "VAT Country/Region Code" <> xRec."VAT Country/Region Code" then                    VATRegistrationValidation();            end;        }        /// <summary>        /// VAT registration number for the specified country or region.        /// </summary>        field(4; "VAT Registration No."; Text[20])        {            Caption = 'VAT Registration No.';            DataClassification = CustomerContent;            ToolTip = 'Specifies the VAT registration number.';            trigger OnValidate()            begin                "VAT Registration No." := UpperCase("VAT Registration No.");                if "VAT Registration No." <> xRec."VAT Registration No." then                    VATRegistrationValidation();            end;        }        /// <summary>        /// General business posting group for transactions in this VAT jurisdiction.        /// </summary>        field(5; "Gen. Bus. Posting Group"; Code[20])        {            Caption = 'Gen. Bus. Posting Group';            DataClassification = CustomerContent;            TableRelation = "Gen. Business Posting Group";            ToolTip = 'Specifies the customer''s trade type to link transactions made for this customer with the appropriate general ledger account according to the general posting setup.';            trigger OnValidate()            var                GenBusPostingGrp: Record "Gen. Business Posting Group";            begin                if xRec."Gen. Bus. Posting Group" <> "Gen. Bus. Posting Group" then                    if GenBusPostingGrp.ValidateVatBusPostingGroup(GenBusPostingGrp, "Gen. Bus. Posting Group") then                        Validate("VAT Bus. Posting Group", GenBusPostingGrp."Def. VAT Bus. Posting Group");            end;        }        /// <summary>        /// VAT business posting group for transactions in this VAT jurisdiction.        /// </summary>        field(6; "VAT Bus. Posting Group"; Code[20])        {            Caption = 'VAT Bus. Posting Group';            DataClassification = CustomerContent;            TableRelation = "VAT Business Posting Group";            ToolTip = 'Specifies the customer''s VAT specification to link transactions made for this customer to.';        }    }    keys    {        key(PK; ID)        {            Clustered = true;        }        key(CustomerVATCountryKey; "Customer No.", "VAT Country/Region Code")        {        }    }    var        AltCustVATRegFacade: Codeunit "Alt. Cust. VAT. Reg. Facade";        FeatureTelemetry: Codeunit "Feature Telemetry";        FeatureNameTxt: Label 'Alternative Customer VAT Registration', Locked = true;    trigger OnInsert()    begin        AltCustVATRegFacade.CheckAltCustVATRegConsistent(Rec);        FeatureTelemetry.LogUptake('0000NFH', FeatureNameTxt, Enum::"Feature Uptake Status"::"Set up");    end;    trigger OnModify()    begin        AltCustVATRegFacade.CheckAltCustVATRegConsistent(Rec);    end;    /// <summary>    /// Validates VAT registration number against format rules and VIES service when enabled.    /// </summary>    procedure VATRegistrationValidation()    var        VATRegistrationNoFormat: Record "VAT Registration No. Format";        VATRegistrationLog: Record "VAT Registration Log";        VATRegNoSrvConfig: Record "VAT Reg. No. Srv Config";        Customer: Record Customer;        VATRegistrationLogMgt: Codeunit "VAT Registration Log Mgt.";        ResultRecordRef: RecordRef;        ApplicableCountryCode: Code[10];        IsHandled: Boolean;        LogNotVerified: Boolean;    begin        IsHandled := false;        OnBeforeVATRegistrationValidation(Rec, IsHandled);        if IsHandled then            exit;        if not VATRegistrationNoFormat.Test("VAT Registration No.", "VAT Country/Region Code", "Customer No.", DATABASE::Customer) then            exit;        LogNotVerified := true;        if ("VAT Country/Region Code" <> '') or (VATRegistrationNoFormat."Country/Region Code" <> '') then begin            ApplicableCountryCode := "VAT Country/Region Code";            if ApplicableCountryCode = '' then                ApplicableCountryCode := VATRegistrationNoFormat."Country/Region Code";            if VATRegNoSrvConfig.VATRegNoSrvIsEnabled() then begin                LogNotVerified := false;                VATRegistrationLogMgt.ValidateVATRegNoWithVIES(                    ResultRecordRef, Rec, "Customer No.", VATRegistrationLog."Account Type"::Customer.AsInteger(), ApplicableCountryCode);                ResultRecordRef.SetTable(Rec);            end;        end;        if LogNotVerified then begin            Customer.Get(Rec."Customer No.");            VATRegistrationLogMgt.LogCustomer(Customer);        end;    end;    /// <summary>    /// Integration event raised before starting VAT registration validation process.    /// </summary>    /// <param name="AltCustVATReg">Alternative customer VAT registration record being validated</param>    /// <param name="IsHandled">Set to true to skip standard validation processing</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeVATRegistrationValidation(var AltCustVATReg: Record "Alt. Cust. VAT Reg."; var IsHandled: Boolean)    begin    end;}