Table "CV Ledger Entry Buffer"
Buffer table for customer and vendor ledger entry data processing and reporting operations. Stores temporary copies of ledger entry information for analysis, aging, and batch processing.
Remarks
Used by various reports and processes that need to manipulate or analyze ledger data without affecting original entries. Supports customer, vendor, and employee ledger entry structures with full field compatibility. Provides integration with dimensions, currencies, and application tracking for comprehensive analysis.
Properties
| Name | Value |
|---|---|
| Caption | CV Ledger Entry Buffer |
| ReplicateData | False |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Entry No." | Integer | Entry number identifying the ledger entry record. |
| "CV No." | Code[20] | Customer, vendor, or employee number associated with the entry. |
| "Posting Date" | Date | Date when the entry was posted to the ledger. |
| "Document Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Document type for the transaction. |
| "Document No." | Code[20] | Document number for the transaction. |
| Description | Text[100] | Description text for the ledger entry. |
| "Your Reference" | Text[35] | Reference number provided by the customer or vendor. |
| "Currency Code" | Code[10] | Currency code for the transaction amount. |
| Amount | Decimal | Transaction amount in the original currency. |
| "Remaining Amount" | Decimal | Remaining amount to be applied in the original currency. |
| "Original Amt. (LCY)" | Decimal | Original transaction amount converted to local currency. |
| "Remaining Amt. (LCY)" | Decimal | Remaining amount to be applied converted to local currency. |
| "Amount (LCY)" | Decimal | Transaction amount converted to local currency. |
| "Sales/Purchase (LCY)" | Decimal | Sales or purchase amount in local currency for statistical purposes. |
| "Profit (LCY)" | Decimal | Profit amount in local currency calculated from sales/purchase transactions. |
| "Inv. Discount (LCY)" | Decimal | Invoice discount amount in local currency applied to the transaction. |
| "Bill-to/Pay-to CV No." | Code[20] | Bill-to customer or pay-to vendor number for the transaction. |
| "CV Posting Group" | Code[20] | Customer or vendor posting group that determines G/L account assignments for posting. |
| "Global Dimension 1 Code" | Code[20] | Global dimension 1 code for financial analysis and reporting segmentation. |
| "Global Dimension 2 Code" | Code[20] | Global dimension 2 code for additional financial analysis and reporting segmentation. |
| "Salesperson Code" | Code[20] | Salesperson code associated with the customer transaction for commission and performance tracking. |
| "User ID" | Code[50] | User ID who created or last modified the entry for audit trail purposes. |
| "Source Code" | Code[10] | Source code indicating the origin of the entry for transaction traceability. |
| "On Hold" | Code[3] | Hold code preventing payment or application of this entry until released. |
| "Applies-to Doc. Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Document Type" | Document type of the target document for payment application. |
| "Applies-to Doc. No." | Code[20] | Document number of the target document for payment application. |
| Open | Boolean | Indicates whether the entry is open for payments or applications. |
| "Due Date" | Date | Due date for payment of the outstanding amount. |
| "Pmt. Discount Date" | Date | Date until which payment discount is available for early payment. |
| "Original Pmt. Disc. Possible" | Decimal | Original payment discount amount available at transaction creation. |
| "Pmt. Disc. Given (LCY)" | Decimal | Payment discount amount actually given in local currency. |
| "Orig. Pmt. Disc. Possible(LCY)" | Decimal | Original payment discount amount possible in local currency. |
| Positive | Boolean | Indicates whether the entry represents a positive transaction amount. |
| "Closed by Entry No." | Integer | Entry number that closed this entry through payment or application. |
| "Closed at Date" | Date | Date when the entry was closed through payment or application. |
| "Closed by Amount" | Decimal | Amount applied when closing this entry through payment or application. |
| "Applies-to ID" | Code[50] | Application ID for grouping entries for batch payment application. |
| "Journal Templ. Name" | Code[10] | Journal template name for entries created through journal posting. |
| "Journal Batch Name" | Code[10] | Journal batch name for entries created through journal posting. |
| "Reason Code" | Code[10] | Reason code providing additional categorization for the transaction. |
| "Bal. Account Type" | Enum Microsoft.Finance.GeneralLedger.Journal."Gen. Journal Account Type" | Type of balancing account for the transaction. |
| "Bal. Account No." | Code[20] | Number of the balancing account for the transaction. |
| "Transaction No." | Integer | Transaction number for grouping related entries posted in the same posting run. |
| "Closed by Amount (LCY)" | Decimal | Amount in local currency that was used to close this entry. |
| "Debit Amount" | Decimal | Debit amount in document currency for the ledger entry. |
| "Credit Amount" | Decimal | Credit amount in document currency for the ledger entry. |
| "Debit Amount (LCY)" | Decimal | Debit amount in local currency for the ledger entry. |
| "Credit Amount (LCY)" | Decimal | Credit amount in local currency for the ledger entry. |
| "Document Date" | Date | Document date from the original transaction. |
| "External Document No." | Code[35] | External document number from the original source document. |
| "Calculate Interest" | Boolean | Indicates whether interest calculation is enabled for this entry. |
| "Closing Interest Calculated" | Boolean | Indicates whether closing interest has been calculated for this entry. |
| "No. Series" | Code[20] | Number series used for automatic numbering of related documents. |
| "Closed by Currency Code" | Code[10] | Currency code for the amount that closed this entry. |
| "Closed by Currency Amount" | Decimal | Amount in foreign currency that was used to close this entry. |
| "Rounding Currency" | Code[10] | Currency code used for rounding adjustments. |
| "Rounding Amount" | Decimal | Rounding adjustment amount in the specified rounding currency. |
| "Rounding Amount (LCY)" | Decimal | Rounding adjustment amount converted to local currency. |
| "Adjusted Currency Factor" | Decimal | Adjusted currency exchange rate factor used for currency conversions. |
| "Original Currency Factor" | Decimal | Original currency exchange rate factor from the time of transaction. |
| "Original Amount" | Decimal | Original transaction amount before any adjustments or applications. |
| "Remaining Pmt. Disc. Possible" | Decimal | Remaining payment discount amount available for this entry. |
| "Pmt. Disc. Tolerance Date" | Date | Last date when payment discount tolerance applies for this entry. |
| "Max. Payment Tolerance" | Decimal | Maximum payment discount tolerance amount allowed for this entry. |
| "Accepted Payment Tolerance" | Decimal | Accepted payment tolerance amount for this entry. |
| "Accepted Pmt. Disc. Tolerance" | Boolean | Indicates whether payment discount tolerance has been accepted for this entry. |
| "Pmt. Tolerance (LCY)" | Decimal | Payment tolerance amount converted to local currency. |
| "Amount to Apply" | Decimal | Amount designated for application against other entries. |
| Prepayment | Boolean | Indicates whether this entry represents a prepayment transaction. |
| "Dimension Set ID" | Integer | Identifier linking to the dimension set for this ledger entry. |
| 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
CopyFromCustLedgEntry
Copies data from a customer ledger entry into the buffer table. Transfers all matching fields and calculates remaining amounts.
procedure CopyFromCustLedgEntry(CustLedgEntry: Record "Cust. Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| CustLedgEntry | Table Microsoft.Sales.Receivables."Cust. Ledger Entry" |
Customer ledger entry to copy from |
CopyFromVendLedgEntry
Copies data from a vendor ledger entry into the buffer table. Maps vendor-specific fields to the corresponding customer/vendor buffer fields.
procedure CopyFromVendLedgEntry(VendLedgEntry: Record "Vendor Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| VendLedgEntry | Table Microsoft.Purchases.Payables."Vendor Ledger Entry" |
Vendor ledger entry to copy from |
CopyFromEmplLedgEntry
Copies data from an employee ledger entry into the buffer table. Maps employee-specific fields to the corresponding customer/vendor buffer fields.
procedure CopyFromEmplLedgEntry(EmplLedgEntry: Record "Employee Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| EmplLedgEntry | Table Microsoft.HumanResources.Payables."Employee Ledger Entry" |
Employee ledger entry to copy from |
RecalculateAmounts
Recalculates amounts when converting between different currencies. Updates all currency-related fields using exchange rates from the specified posting date.
procedure RecalculateAmounts(FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date)Parameters
| Name | Type | Description |
|---|---|---|
| FromCurrencyCode | Code[10] |
Source currency for conversion |
| ToCurrencyCode | Code[10] |
Target currency for conversion |
| PostingDate | Date |
Date to use for exchange rate lookup |
SetClosedFields
Sets the closed fields for a ledger entry buffer with closing information.
procedure SetClosedFields(EntryNo: Integer; PostingDate: Date; NewAmount: Decimal; AmountLCY: Decimal; CurrencyCode: Code[10]; CurrencyAmount: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| EntryNo | Integer |
Entry number that closed this entry |
| PostingDate | Date |
Date when the entry was closed |
| NewAmount | Decimal |
Amount used to close the entry |
| AmountLCY | Decimal |
Amount in local currency used to close the entry |
| CurrencyCode | Code[10] |
Currency code of the closing amount |
| CurrencyAmount | Decimal |
Currency amount used to close the entry |
GetPmtDiscountDate
Gets the payment discount date relative to a reference date.
procedure GetPmtDiscountDate(ReferenceDate: Date): DateParameters
| Name | Type | Description |
|---|---|---|
| ReferenceDate | Date |
Reference date for payment discount calculation |
Returns
| Type | Description |
|---|---|
| Date |
Payment discount date |
GetRemainingPmtDiscPossible
Gets the remaining payment discount possible for the entry based on a reference date.
procedure GetRemainingPmtDiscPossible(ReferenceDate: Date): DecimalParameters
| Name | Type | Description |
|---|---|---|
| ReferenceDate | Date |
Reference date for payment discount calculation |
Returns
| Type | Description |
|---|---|
| Decimal |
Remaining payment discount amount possible |
Events
OnAfterCopyFromCustLedgerEntry
Integration event raised after copying data from a customer ledger entry. Enables customization of the copy process for customer-specific requirements.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromCustLedgerEntry(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"; CustLedgerEntry: Record "Cust. Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record being populated |
| CustLedgerEntry | Table Microsoft.Sales.Receivables."Cust. Ledger Entry" |
Source customer ledger entry |
OnAfterCopyFromVendLedgerEntry
Integration event raised after copying data from a vendor ledger entry. Enables customization of the copy process for vendor-specific requirements.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromVendLedgerEntry(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"; VendorLedgerEntry: Record "Vendor Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record being populated |
| VendorLedgerEntry | Table Microsoft.Purchases.Payables."Vendor Ledger Entry" |
Source vendor ledger entry |
OnAfterCopyFromEmplLedgerEntry
Integration event raised after copying data from an employee ledger entry. Enables customization of the copy process for employee-specific requirements.
[IntegrationEvent(False,False)]
local procedure OnAfterCopyFromEmplLedgerEntry(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"; EmployeeLedgerEntry: Record "Employee Ledger Entry")Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record being populated |
| EmployeeLedgerEntry | Table Microsoft.HumanResources.Payables."Employee Ledger Entry" |
Source employee ledger entry |
OnAfterSetClosedFields
Integration event raised after setting closed-related fields in the buffer. Enables custom processing when ledger entries are marked as closed.
[IntegrationEvent(False,False)]
local procedure OnAfterSetClosedFields(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer")Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record with updated closed fields |
OnAfterGetPmtDiscountDate
Integration event raised after calculating payment discount date. Enables customization of payment discount date calculation logic.
[IntegrationEvent(False,False)]
local procedure OnAfterGetPmtDiscountDate(CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"; ReferenceDate: Date; var PmtDiscountDate: Date)Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record for payment discount calculation |
| ReferenceDate | Date |
Date used as reference for calculation |
| PmtDiscountDate | Date |
Calculated payment discount date (by reference) |
OnAfterGetRemainingPmtDiscPossible
Integration event raised after getting remaining payment discount possible. Enables customization of payment discount calculations based on specific business rules.
[IntegrationEvent(False,False)]
local procedure OnAfterGetRemainingPmtDiscPossible(CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"; ReferenceDate: Date; var RemainingPmtDiscPossible: Decimal)Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record with payment discount information |
| ReferenceDate | Date |
Reference date for payment discount calculation |
| RemainingPmtDiscPossible | Decimal |
Remaining payment discount amount that can be modified |
OnAfterRecalculateAmounts
Integration event raised after recalculating amounts in currency conversion. Enables custom processing when amounts are converted between currencies.
[IntegrationEvent(False,False)]
local procedure OnAfterRecalculateAmounts(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date)Parameters
| Name | Type | Description |
|---|---|---|
| CVLedgerEntryBuffer | Table Microsoft.Finance.ReceivablesPayables."CV Ledger Entry Buffer" |
Buffer record with recalculated amounts |
| FromCurrencyCode | Code[10] |
Source currency code for conversion |
| ToCurrencyCode | Code[10] |
Target currency code for conversion |
| PostingDate | Date |
Date used for exchange rate lookup |