Table 253 G/L Entry - VAT Entry Link

Base Application, Microsoft.Finance.VAT.Ledger

src/Layers/W1/BaseApp/Finance/VAT/Ledger/GLEntryVATEntryLink.Table.al148 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.Ledger;using Microsoft.Finance.GeneralLedger.Ledger;/// <summary>/// Link table connecting general ledger entries with their corresponding VAT entries for audit trail and reconciliation./// Maintains referential integrity between G/L and VAT posting for accurate financial reporting and compliance tracking./// </summary>/// <remarks>/// Core integration table for VAT ledger functionality. Supports automatic G/L account number adjustment on VAT entries./// Extensible through insertion and adjustment events for custom VAT/G/L integration scenarios./// </remarks>table 253 "G/L Entry - VAT Entry Link"{    Caption = 'G/L Entry - VAT Entry Link';    Permissions = TableData "G/L Entry - VAT Entry Link" = rimd;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// General ledger entry number linking to the corresponding G/L transaction record.        /// </summary>        field(1; "G/L Entry No."; Integer)        {            Caption = 'G/L Entry No.';            TableRelation = "G/L Entry"."Entry No.";        }        /// <summary>        /// VAT entry number linking to the corresponding VAT transaction record.        /// </summary>        field(2; "VAT Entry No."; Integer)        {            Caption = 'VAT Entry No.';            TableRelation = "VAT Entry"."Entry No.";        }    }    keys    {        key(Key1; "G/L Entry No.", "VAT Entry No.")        {            Clustered = true;        }        key(Key2; "VAT Entry No.")        {        }    }    fieldgroups    {    }    /// <summary>    /// Creates a link between a general ledger entry and a VAT entry for audit trail purposes.    /// </summary>    /// <param name="GLEntryNo">General ledger entry number to link</param>    /// <param name="VATEntryNo">VAT entry number to link</param>    procedure InsertLink(GLEntryNo: Integer; VATEntryNo: Integer)    var        GLEntryVatEntryLink: Record "G/L Entry - VAT Entry Link";    begin        GLEntryVatEntryLink.InsertLinkSelf(GLEntryNo, VATEntryNo);    end;    /// <summary>    /// Creates a link record in the current instance between a G/L entry and VAT entry.    /// Raises integration event to notify subscribers of the new link creation.    /// </summary>    /// <param name="GLEntryNo">General ledger entry number to link</param>    /// <param name="VATEntryNo">VAT entry number to link</param>    procedure InsertLinkSelf(GLEntryNo: Integer; VATEntryNo: Integer)    begin        Init();        "G/L Entry No." := GLEntryNo;        "VAT Entry No." := VATEntryNo;        Insert();        OnInsertLink(Rec);    end;    /// <summary>    /// Creates a link between G/L and VAT entries and automatically adjusts the G/L account number on the VAT entry.    /// Combines link creation with G/L account synchronization for data consistency.    /// </summary>    /// <param name="GLEntryNo">General ledger entry number to link</param>    /// <param name="VATEntryNo">VAT entry number to link and update</param>    procedure InsertLinkWithGLAccountSelf(GLEntryNo: Integer; VATEntryNo: Integer)    var        IsHandled: Boolean;    begin        InsertLinkSelf(GLEntryNo, VATEntryNo);        IsHandled := false;        OnBeforeAdjustGLAccountNoOnVATEntryOnInsertLink(Rec, IsHandled);        if IsHandled then            exit;        Rec.AdjustGLAccountNoOnVATEntry();    end;    /// <summary>    /// Updates the G/L account number on the linked VAT entry to match the G/L entry's account.    /// Ensures consistency between VAT entries and their corresponding G/L account assignments.    /// </summary>    procedure AdjustGLAccountNoOnVATEntry()    var        GLEntry: Record "G/L Entry";        VATEntryEdit: Codeunit "VAT Entry - Edit";    begin        if Rec.IsTemporary() then            exit;        if Rec."G/L Entry No." = 0 then            exit;        GLEntry.SetLoadFields("G/L Account No.");        GLEntry.Get(Rec."G/L Entry No.");        VATEntryEdit.SetGLAccountNo(Rec."VAT Entry No.", GLEntry."G/L Account No.");    end;    /// <summary>    /// Integration event raised after creating a link between G/L and VAT entries.    /// Enables custom processing or validation after the link establishment.    /// </summary>    /// <param name="GLEntryVATEntryLink">Link record that was created</param>    [IntegrationEvent(false, false)]    local procedure OnInsertLink(var GLEntryVATEntryLink: Record "G/L Entry - VAT Entry Link")    begin    end;    /// <summary>    /// Integration event raised before adjusting G/L account number on VAT entry during link insertion.    /// Allows custom logic to handle or skip the automatic G/L account adjustment process.    /// </summary>    /// <param name="GLEntryVATEntryLink">Link record being processed</param>    /// <param name="IsHandled">Set to true to skip standard G/L account adjustment</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeAdjustGLAccountNoOnVATEntryOnInsertLink(var GLEntryVATEntryLink: Record "G/L Entry - VAT Entry Link"; var IsHandled: Boolean)    begin    end;}