Table "G/L Entry - VAT Entry Link"
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.
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.
Properties
| Name | Value |
|---|---|
| Caption | G/L Entry - VAT Entry Link |
| Permissions | TableData "G/L Entry - VAT Entry Link" = rimd |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "G/L Entry No." | Integer | General ledger entry number linking to the corresponding G/L transaction record. |
| "VAT Entry No." | Integer | VAT entry number linking to the corresponding VAT transaction record. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
InsertLink
Creates a link between a general ledger entry and a VAT entry for audit trail purposes.
procedure InsertLink(GLEntryNo: Integer; VATEntryNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| GLEntryNo | Integer |
General ledger entry number to link |
| VATEntryNo | Integer |
VAT entry number to link |
InsertLinkSelf
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.
procedure InsertLinkSelf(GLEntryNo: Integer; VATEntryNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| GLEntryNo | Integer |
General ledger entry number to link |
| VATEntryNo | Integer |
VAT entry number to link |
InsertLinkWithGLAccountSelf
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.
procedure InsertLinkWithGLAccountSelf(GLEntryNo: Integer; VATEntryNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| GLEntryNo | Integer |
General ledger entry number to link |
| VATEntryNo | Integer |
VAT entry number to link and update |
AdjustGLAccountNoOnVATEntry
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.
procedure AdjustGLAccountNoOnVATEntry()Events
OnInsertLink
Integration event raised after creating a link between G/L and VAT entries. Enables custom processing or validation after the link establishment.
[IntegrationEvent(False,False)]
local procedure OnInsertLink(var GLEntryVATEntryLink: Record "G/L Entry - VAT Entry Link")Parameters
| Name | Type | Description |
|---|---|---|
| GLEntryVATEntryLink | Table Microsoft.Finance.VAT.Ledger."G/L Entry - VAT Entry Link" |
Link record that was created |
OnBeforeAdjustGLAccountNoOnVATEntryOnInsertLink
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.
[IntegrationEvent(False,False)]
local procedure OnBeforeAdjustGLAccountNoOnVATEntryOnInsertLink(var GLEntryVATEntryLink: Record "G/L Entry - VAT Entry Link"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| GLEntryVATEntryLink | Table Microsoft.Finance.VAT.Ledger."G/L Entry - VAT Entry Link" |
Link record being processed |
| IsHandled | Boolean |
Set to true to skip standard G/L account adjustment |