Table 5480 Tax Group Buffer

Base Application, Microsoft.Integration.Entity

src/Layers/W1/BaseApp/Integration/Entity/TaxGroupBuffer.Table.al214 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.Integration.Entity;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Finance.SalesTax;using Microsoft.Finance.VAT.Setup;table 5480 "Tax Group Buffer"{    Caption = 'Tax Group Buffer';    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Code"; Code[20])        {            Caption = 'Code';            DataClassification = SystemMetadata;            NotBlank = true;        }        field(2; Description; Text[100])        {            Caption = 'Description';            DataClassification = SystemMetadata;        }        field(8000; Id; Guid)        {            Caption = 'Id';            DataClassification = SystemMetadata;        }        field(8005; "Last Modified DateTime"; DateTime)        {            Caption = 'Last Modified DateTime';            DataClassification = SystemMetadata;        }        field(9600; Type; Enum "Tax Buffer Type")        {            Caption = 'Type';            DataClassification = SystemMetadata;        }    }    keys    {        key(Key1; Id)        {            Clustered = true;        }    }    fieldgroups    {    }    trigger OnRename()    begin        Error(CannotChangeIDErr);    end;    var        CannotChangeIDErr: Label 'The id cannot be changed.', Locked = true;        RecordMustBeTemporaryErr: Label 'Tax Group Entity must be used as a temporary record.';    procedure PropagateInsert()    begin        PropagateUpdate(true);    end;    procedure PropagateModify()    begin        PropagateUpdate(false);    end;    local procedure PropagateUpdate(InsertRec: Boolean)    var        GeneralLedgerSetup: Record "General Ledger Setup";        VATProductPostingGroup: Record "VAT Product Posting Group";        TaxGroup: Record "Tax Group";    begin        if not IsTemporary then            Error(RecordMustBeTemporaryErr);        if GeneralLedgerSetup.UseVat() then begin            if InsertRec then begin                VATProductPostingGroup.TransferFields(Rec, true);                VATProductPostingGroup.Insert(true)            end else begin                if xRec.Code <> Code then begin                    VATProductPostingGroup.Get(xRec.Code);                    VATProductPostingGroup.Rename(Code);                end;                VATProductPostingGroup.TransferFields(Rec, true);                VATProductPostingGroup.Modify(true);            end;            UpdateFromVATProductPostingGroup(VATProductPostingGroup);        end else begin            if InsertRec then begin                TaxGroup.TransferFields(Rec, true);                TaxGroup.Insert(true)            end else begin                if xRec.Code <> Code then begin                    TaxGroup.Get(xRec.Code);                    TaxGroup.Rename(true)                end;                TaxGroup.TransferFields(Rec, true);                TaxGroup.Modify(true);            end;            UpdateFromTaxGroup(TaxGroup);        end;    end;    procedure PropagateDelete()    var        GeneralLedgerSetup: Record "General Ledger Setup";        VATProductPostingGroup: Record "VAT Product Posting Group";        TaxGroup: Record "Tax Group";    begin        if GeneralLedgerSetup.UseVat() then begin            VATProductPostingGroup.Get(Code);            VATProductPostingGroup.Delete(true);        end else begin            TaxGroup.Get(Code);            TaxGroup.Delete(true);        end;    end;    procedure LoadRecords(): Boolean    var        GeneralLedgerSetup: Record "General Ledger Setup";    begin        if not IsTemporary then            Error(RecordMustBeTemporaryErr);        if GeneralLedgerSetup.UseVat() then            LoadFromVATProductPostingGroup()        else            LoadFromTaxGroup();        exit(FindFirst());    end;    local procedure LoadFromTaxGroup()    var        TaxGroup: Record "Tax Group";    begin        if not TaxGroup.FindSet() then            exit;        repeat            UpdateFromTaxGroup(TaxGroup);            Insert();        until TaxGroup.Next() = 0;    end;    local procedure LoadFromVATProductPostingGroup()    var        VATProductPostingGroup: Record "VAT Product Posting Group";    begin        if not VATProductPostingGroup.FindSet() then            exit;        repeat            UpdateFromVATProductPostingGroup(VATProductPostingGroup);            Insert();        until VATProductPostingGroup.Next() = 0;    end;    procedure GetCodesFromTaxGroupId(TaxGroupID: Guid; var SalesTaxGroupCode: Code[20]; var VATProductPostingGroupCode: Code[20])    var        GeneralLedgerSetup: Record "General Ledger Setup";        VATProductPostingGroup: Record "VAT Product Posting Group";        TaxGroup: Record "Tax Group";    begin        Clear(SalesTaxGroupCode);        Clear(VATProductPostingGroupCode);        if IsNullGuid(TaxGroupID) then            exit;        if GeneralLedgerSetup.UseVat() then begin            if VATProductPostingGroup.GetBySystemId(TaxGroupID) then                VATProductPostingGroupCode := VATProductPostingGroup.Code;            exit;        end;        if TaxGroup.GetBySystemId(TaxGroupID) then            SalesTaxGroupCode := TaxGroup.Code;    end;    local procedure UpdateFromVATProductPostingGroup(var VATProductPostingGroup: Record "VAT Product Posting Group")    begin        TransferFields(VATProductPostingGroup, true);        Id := VATProductPostingGroup.SystemId;        Type := Type::VAT;    end;    local procedure UpdateFromTaxGroup(var TaxGroup: Record "Tax Group")    begin        TransferFields(TaxGroup, true);        Id := TaxGroup.SystemId;        Type := Type::"Sales Tax";    end;}