Table "Detailed CV Ledg. Entry Buffer"
Buffer table for detailed customer and vendor ledger entry data including applications, payments, and adjustments. Stores temporary copies of detailed entry information for analysis, reporting, and batch processing operations.
Remarks
Mirrors the structure of detailed customer and vendor ledger entries for processing scenarios requiring data manipulation. Supports application tracking, currency amounts, VAT processing, and tax calculations. Used by reports and processes analyzing payment applications, discounts, and detailed transaction history.
Properties
| Name | Value |
|---|---|
| Caption | Detailed CV Ledg. Entry Buffer |
| DrillDownPageID | Page Microsoft.Sales.Receivables."Detailed Cust. Ledg. Entries" |
| LookupPageID | Page Microsoft.Sales.Receivables."Detailed Cust. Ledg. Entries" |
| ReplicateData | False |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Entry No." | Integer | Unique entry number identifying the detailed ledger entry record. |
| "CV Ledger Entry No." | Integer | Reference to the parent customer or vendor ledger entry. |
| "Entry Type" | Enum Microsoft.Finance.ReceivablesPayables."Detailed CV Ledger Entry Type" | Type of detailed entry indicating the specific transaction purpose. |
| "Posting Date" | Date | Date when the detailed entry was posted to the ledger. |
| "Document Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Document type associated with the detailed entry transaction. |
| "Document No." | Code[20] | Document number for the detailed entry transaction. |
| Amount | Decimal | Transaction amount in the original currency for the detailed entry. |
| "Amount (LCY)" | Decimal | Amount in local currency (LCY) for the detailed entry transaction. |
| "CV No." | Code[20] | Customer or vendor number associated with this detailed entry. |
| "Currency Code" | Code[10] | Currency code for foreign currency amounts, blank for LCY. |
| "User ID" | Code[50] | User ID who created or modified this detailed entry record. |
| "Source Code" | Code[10] | Source code identifying the origin of this detailed entry transaction. |
| "Transaction No." | Integer | Transaction number linking related detailed entries and postings. |
| "Journal Batch Name" | Code[10] | Journal batch name from which this detailed entry was created. |
| "Reason Code" | Code[10] | Reason code explaining the business purpose of this detailed entry. |
| "Debit Amount" | Decimal | Debit amount for the detailed entry in original currency. |
| "Credit Amount" | Decimal | Credit amount for the detailed entry in original currency. |
| "Debit Amount (LCY)" | Decimal | Debit amount for the detailed entry in local currency. |
| "Credit Amount (LCY)" | Decimal | Credit amount for the detailed entry in local currency. |
| "Initial Entry Due Date" | Date | Due date from the initial entry before any applications or adjustments. |
| "Initial Entry Global Dim. 1" | Code[20] | Global dimension 1 code from the initial entry for reporting and analysis. |
| "Initial Entry Global Dim. 2" | Code[20] | Global dimension 2 code from the initial entry for cost center and project analysis. |
| "Gen. Posting Type" | Enum Microsoft.Foundation.Enums."General Posting Type" | General posting type for G/L account determination and posting setup. |
| "Gen. Bus. Posting Group" | Code[20] | General business posting group for G/L account determination and posting setup. |
| "Gen. Prod. Posting Group" | Code[20] | General product posting group for G/L account determination and posting setup. |
| "Tax Area Code" | Code[20] | Tax area code for sales tax calculation and reporting by geographical location. |
| "Tax Liable" | Boolean | Indicates whether the entry is subject to sales tax calculation. |
| "Tax Group Code" | Code[20] | Tax group code defining the type of items subject to specific tax rates. |
| "Use Tax" | Boolean | Indicates whether use tax applies instead of regular sales tax. |
| "VAT Bus. Posting Group" | Code[20] | VAT business posting group for VAT calculation and posting setup. |
| "VAT Prod. Posting Group" | Code[20] | VAT product posting group for VAT calculation and posting setup. |
| "Additional-Currency Amount" | Decimal | Additional reporting currency amount for detailed entry. |
| "VAT Amount (LCY)" | Decimal | VAT amount in local currency for the detailed entry. |
| "Use Additional-Currency Amount" | Boolean | Indicates whether to use additional reporting currency amount calculations. |
| "Initial Document Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Document type from the initial entry before applications or adjustments. |
| "Applied CV Ledger Entry No." | Integer | Entry number of the CV ledger entry that this detailed entry was applied to. |
| "Remaining Pmt. Disc. Possible" | Decimal | Remaining payment discount amount that can still be taken. |
| "Max. Payment Tolerance" | Decimal | Maximum payment tolerance amount allowed for this detailed entry. |
| "Tax Jurisdiction Code" | Code[10] | Tax jurisdiction code for sales tax calculation and reporting requirements. |
| "Exch. Rate Adjmt. Reg. No." | Integer | Exchange rate adjustment register number for currency revaluation tracking. |
| "Non-Deductible VAT Amount LCY" | Decimal | Non-deductible VAT amount in local currency for partial VAT deduction scenarios. |
| "Non-Deductible VAT Amount ACY" | Decimal | Non-deductible VAT amount in additional reporting currency for partial VAT deduction scenarios. |
| 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
InsertDtldCVLedgEntry
Inserts or updates a detailed CV ledger entry buffer record with consolidation logic. Combines entries with matching key fields to avoid duplicate buffer records.
procedure InsertDtldCVLedgEntry(var DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; var CVLedgEntryBuf: Record "CV Ledger Entry Buffer"; InsertZeroAmout: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| DtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer record to insert |
| CVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer record |
| InsertZeroAmout | Boolean |
Whether to insert entries with zero amounts |
CopyPostingGroupsFromVATEntry
Copies posting group fields from a VAT entry to the detailed CV ledger entry buffer. Used for VAT-related detailed entries to maintain proper posting setup references.
procedure CopyPostingGroupsFromVATEntry(VATEntry: Record "VAT Entry")Parameters
| Name | Type | Description |
|---|---|---|
| VATEntry | Table Microsoft.Finance.VAT.Ledger."VAT Entry" |
VAT entry containing posting group information to copy |
CopyFromGenJnlLine
Copies relevant fields from a general journal line to create an initial detailed CV ledger entry. Sets up the buffer with transaction amounts, dimensions, and basic posting information.
procedure CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")Parameters
| Name | Type | Description |
|---|---|---|
| GenJnlLine | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line" |
General journal line containing source transaction data |
InitFromGenJnlLine
Initializes the detailed CV ledger entry buffer with basic posting information from a general journal line. Sets up document and user identification fields without amounts or detailed data.
procedure InitFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")Parameters
| Name | Type | Description |
|---|---|---|
| GenJnlLine | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line" |
General journal line containing basic posting information |
CopyFromCVLedgEntryBuf
Copies key reference fields from a CV ledger entry buffer to establish parent-child relationship. Links the detailed entry to its parent ledger entry with currency and dimension information.
procedure CopyFromCVLedgEntryBuf(CVLedgEntryBuf: Record "CV Ledger Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer containing reference data |
InitDetailedCVLedgEntryBuf
Initializes and inserts a complete detailed CV ledger entry buffer with specified amounts and application data. Creates fully populated detailed entry for payment applications, discounts, and tolerance scenarios.
procedure InitDetailedCVLedgEntryBuf(GenJnlLine: Record "Gen. Journal Line"; var CVLedgEntryBuf: Record "CV Ledger Entry Buffer"; var DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; EntryType: Enum "Detailed CV Ledger Entry Type"; AmountFCY: Decimal; AmountLCY: Decimal; AmountAddCurr: Decimal; AppliedEntryNo: Integer; RemainingPmtDiscPossible: Decimal; MaxPaymentTolerance: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| GenJnlLine | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line" |
Source general journal line |
| CVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer |
| DtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer to initialize |
| EntryType | Enum Microsoft.Finance.ReceivablesPayables."Detailed CV Ledger Entry Type" |
Type of detailed entry to create |
| AmountFCY | Decimal |
Amount in foreign currency |
| AmountLCY | Decimal |
Amount in local currency |
| AmountAddCurr | Decimal |
Amount in additional reporting currency |
| AppliedEntryNo | Integer |
Entry number of applied ledger entry |
| RemainingPmtDiscPossible | Decimal |
Remaining payment discount available |
| MaxPaymentTolerance | Decimal |
Maximum payment tolerance amount |
FindVATEntry
Finds the corresponding VAT entry for the detailed CV ledger entry using transaction number and posting groups. Used to link detailed entries with their related VAT transactions for reporting and analysis.
procedure FindVATEntry(var VATEntry: Record "VAT Entry"; TransactionNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| VATEntry | Table Microsoft.Finance.VAT.Ledger."VAT Entry" |
VAT entry record to populate with found entry |
| TransactionNo | Integer |
Transaction number to search for |
Events
OnAfterCopyFromGenJnlLine
Integration event raised after copying fields from a general journal line to the detailed CV ledger entry buffer. Enables customization of field mapping and additional data population from journal lines.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromGenJnlLine(var DtldCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; GenJnlLine: Record "Gen. Journal Line")Parameters
| Name | Type | Description |
|---|---|---|
| DtldCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer being populated |
| GenJnlLine | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line" |
Source general journal line |
OnAfterCopyFromCVLedgEntryBuf
Integration event raised after copying reference fields from a CV ledger entry buffer. Enables customization of field mapping and additional data population from parent ledger entries.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromCVLedgEntryBuf(var DetailedCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer being populated |
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Source CV ledger entry buffer |
OnAfterCopyPostingGroupsFromVATEntry
Integration event raised after copying posting groups from a VAT entry. Enables customization of VAT-related posting group assignments and validation.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyPostingGroupsFromVATEntry(var DetailedCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; VATEntry: Record "VAT Entry")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer being updated |
| VATEntry | Table Microsoft.Finance.VAT.Ledger."VAT Entry" |
Source VAT entry with posting group information |
OnAfterInitFromGenJnlLine
Integration event raised after initializing basic fields from a general journal line. Enables customization of initialization logic and additional field setup.
[IntegrationEvent(False,False)]
local procedure OnAfterInitFromGenJnlLine(var DetailedCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; GenJournalLine: Record "Gen. Journal Line")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer being initialized |
| GenJournalLine | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line" |
Source general journal line |
OnAfterInsertDtldCVLedgEntry
Integration event raised after inserting a detailed CV ledger entry buffer record. Enables post-processing of inserted detailed entries and related buffer updates.
[IntegrationEvent(False,False)]
local procedure OnAfterInsertDtldCVLedgEntry(var DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; var CVLedgEntryBuf: Record "CV Ledger Entry Buffer"; var NewDtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; var NextDtldBufferEntryNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| DtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Current detailed CV ledger entry buffer |
| CVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer |
| NewDtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Newly inserted detailed entry |
| NextDtldBufferEntryNo | Integer |
Next available entry number for sequencing |
OnBeforeInsertDtldCVLedgEntry
Integration event raised before inserting a detailed CV ledger entry buffer in the initialization process. Enables custom validation and processing before detailed entry creation.
[IntegrationEvent(False,False)]
local procedure OnBeforeInsertDtldCVLedgEntry(var DetailedCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; GenJournalLine: Record "Gen. Journal Line"; var IsHanled: Boolean; var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer to be inserted |
| GenJournalLine | Table Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Line" |
Source general journal line |
| IsHanled | Boolean |
Set to true to skip standard insertion logic |
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer |
OnBeforeCreateDtldCVLedgEntryBuf
Integration event raised before creating a detailed CV ledger entry buffer during consolidation. Enables custom logic for entry consolidation and duplicate detection.
[IntegrationEvent(False,False)]
local procedure OnBeforeCreateDtldCVLedgEntryBuf(var DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; var NewDtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; var NextDtldBufferEntryNo: Integer; var IsHandled: Boolean; var CVLedgEntryBuf: Record "CV Ledger Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| DtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Current detailed CV ledger entry buffer for comparison |
| NewDtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
New detailed entry being processed |
| NextDtldBufferEntryNo | Integer |
Next available entry number |
| IsHandled | Boolean |
Set to true to skip standard consolidation logic |
| CVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer |
OnInsertDtldCVLedgEntryOnBeforeInsert
Integration event raised before inserting a new detailed CV ledger entry buffer record. Enables final validation and field modifications before database insertion.
[IntegrationEvent(False,False)]
local procedure OnInsertDtldCVLedgEntryOnBeforeInsert(var DetailedCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Detailed CV ledger entry buffer about to be inserted |
OnInsertDtldCVLedgEntryOnBeforeModify
Integration event raised before modifying an existing detailed CV ledger entry buffer during consolidation. Enables custom logic for amount aggregation and field updates in consolidated entries.
[IntegrationEvent(False,False)]
local procedure OnInsertDtldCVLedgEntryOnBeforeModify(var DetailedCVLedgEntryBuffer: Record "Detailed CV Ledg. Entry Buffer"; NewDtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| DetailedCVLedgEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Existing detailed CV ledger entry buffer being modified |
| NewDtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
New detailed entry being consolidated |
OnInsertDtldCVLedgEntryOnBeforeNewDtldCVLedgEntryBufInit
Integration event raised before initializing a new detailed CV ledger entry buffer during the insertion process. Enables custom setup and field population before detailed entry processing begins.
[IntegrationEvent(False,False)]
local procedure OnInsertDtldCVLedgEntryOnBeforeNewDtldCVLedgEntryBufInit(var DtldCVLedgEntryBuf: Record "Detailed CV Ledg. Entry Buffer"; CVLedgEntryBuf: Record "CV Ledger Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| DtldCVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."Detailed CV Ledg. Entry Buffer" |
Source detailed CV ledger entry buffer |
| CVLedgEntryBuf | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Parent CV ledger entry buffer |