Table 21 "Cust. Ledger Entry"

Base Application · Microsoft.Sales.Receivables · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 25 “Customer Ledger Entries” (6 Learn pages), Page 1951 “LP Prediction FactBox” (1).

Properties

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

Keys

• Key1: Entry No. (clustered)
• Key2: Customer No., Currency Code
• Key4: Document No.
• Key5: External Document No.
• Key6: Customer No., Open, Positive, Due Date, Currency Code
• Key7: Open, Due Date
• Key8: Customer No., Document Type, Posting Date, Currency Code
• Key9: Salesperson Code, Posting Date
• Key10: Closed by Entry No.
• Key11: Transaction No.
• Key17: Customer No., Applies-to ID, Open, Positive, Due Date
• Key18: Document Type, Posting Date
• Key19: Document Type, Customer No., Open, Due Date
• Key20: Customer Posting Group
• Key21: Document Type, Open, Posting Date, Closed at Date
• Key22: Salesperson Code
• Key23: SystemModifiedAt
• Key35: Customer No., Posting Date, Applies-to ID
• Key36: Document Type, Reversed, Posting Date
• Key37: Applies-to ID

Events published

• OnAfterCopyCustLedgerEntryFromGenJnlLine(var CustLedgerEntry: Record "Cust. Ledger Entry"; GenJournalLine: Record "Gen. Journal Line") (integration): Raised after copying customer ledger entry fields from a general journal line.
• OnAfterCopyCustLedgerEntryFromCVLedgEntryBuffer(var CustLedgerEntry: Record "Cust. Ledger Entry"; CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer") (integration): Raised after copying customer ledger entry fields from a CV ledger entry buffer.
• OnAfterRecalculateAmounts(var CustLedgerEntry: Record "Cust. Ledger Entry"; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date) (integration): Raised after recalculating amounts from one currency to another.
• OnValidateAmounttoApplyBeforeFieldError(var CustLedgerEntry: Record "Cust. Ledger Entry") + BC25 (integration): Raised before validating the Amount to Apply field to allow custom validation.
• OnAfterShowDoc(var CustLedgerEntry: Record "Cust. Ledger Entry") (integration): Raised after attempting to show the document associated with the entry.
• OnAfterShowPostedDocAttachment(var CustLedgerEntry: Record "Cust. Ledger Entry"; DocumentFound: Boolean) + BC25 − BC25 (integration): Raised after showing the posted document attachment.
  • subscribers: Codeunit 6450 “Serv. Integration Mgt.” CustLedgerEntryOnAfterShowPostedDocAttachment
• OnAfterHasPostedDocAttachment(var CustLedgerEntry: Record "Cust. Ledger Entry"; var HasPostedDocumentAttachment: Boolean) (integration): Raised after checking whether the posted document has attachments.
  • subscribers: Codeunit 6450 “Serv. Integration Mgt.” CustLedgerEntryOnAfterHasPostedDocAttachment
• OnBeforeDrillDownEntries(var CustLedgerEntry: Record "Cust. Ledger Entry"; var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; var DrillDownPageID: Integer) (integration): Raised before drilling down on customer ledger entries.
• OnBeforeDrillDownOnOverdueEntries(var CustLedgerEntry: Record "Cust. Ledger Entry"; var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; var DrillDownPageID: Integer) (integration): Raised before drilling down on overdue customer ledger entries.
• OnBeforeSetAmountToApply(var CustLedgerEntry: Record "Cust. Ledger Entry"; AppliesToDocNo: Code[20]; CustomerNo: Code[20]) (integration): Raised before setting the amount to apply for a customer ledger entry.
• OnBeforeSetStyle(var Style: Text; var IsHandled: Boolean) (integration): Raised before determining the visual style for the entry.
• OnBeforeShowDoc(CustLedgerEntry: Record "Cust. Ledger Entry"; var IsPageOpened: Boolean; var IsHandled: Boolean) (integration): Raised before showing the document associated with the entry.
  • subscribers: Codeunit 6450 “Serv. Integration Mgt.” CustLedgerEntryOnBeforeShowDoc
• OnBeforeValidateMessagetoRecipient(var CustLedgerEntry: Record "Cust. Ledger Entry"; var IsHandled: Boolean) (integration): Raised before validating the Message to Recipient field.
• OnAfterUpdateAmountsForApplication(var CustLedgerEntry: Record "Cust. Ledger Entry"; ApplnDate: Date; ApplnCurrencyCode: Code[10]; RoundAmounts: Boolean; UpdateMaxPaymentTolerance: Boolean) (integration): Raised after updating amounts for application.
• OnAfterGetRemainingPmtDiscPossible(CustLedgerEntry: Record "Cust. Ledger Entry"; ReferenceDate: Date; var RemainingPmtDiscPossible: Decimal) (integration): Raised after getting the remaining payment discount possible.
• OnBeforeDrillDownOnOverdueEntriesBeforeCode(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; var IsHandled: Boolean) (integration): Raised before drilling down on overdue entries to allow custom handling.
• OnBeforeRecalculateAmounts(var CustLedgerEntry: Record "Cust. Ledger Entry"; FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date; var IsHandled: Boolean) + BC24 (integration): Raised before recalculating amounts from one currency to another.
• OnBeforeUpdateAmountsForApplication(var CustLedgerEntry: Record "Cust. Ledger Entry"; ApplnDate: Date; ApplnCurrencyCode: Code[10]; RoundAmounts: Boolean; UpdateMaxPaymentTolerance: Boolean; var IsHandled: Boolean) + BC24 (integration): Raised before updating amounts for application.
• OnSetAmountToApplyOnAfterCalcRemainingAmount(var CustLedgerEntry: Record "Cust. Ledger Entry") + BC25 (integration): Raised after calculating the remaining amount when setting amount to apply.
• OnValidateMaxPaymentToleranceOnBeforeFieldError(var CustLedgerEntry: Record "Cust. Ledger Entry") + BC25 (integration): Raised before validating the Max Payment Tolerance field to allow custom validation.

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterDeleteCustomerLedgerEntry, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterDeleteCustomerLedgerEntry
• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertCustLedgerEntry, Codeunit 5477 “Sales Invoice Aggregator” OnAfterInsertCustomerLedgerEntry, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterInsertCustomerLedgerEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyCustLedgerEntry, Codeunit 5477 “Sales Invoice Aggregator” OnAfterModifyCustomerLedgerEntry, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterModifyCustomerLedgerEntry
• OnAfterRenameEvent: Codeunit 5477 “Sales Invoice Aggregator” OnAfterRenameCustomerLedgerEntry, Codeunit 5508 “Graph Mgt - Sal. Cr. Memo Buf.” OnAfterRenameCustomerLedgerEntry

Procedures

• GetLastEntryNo(): Integer Δ BC26: Gets the entry number of the last customer ledger entry in the table.
• ShowDoc(): Boolean: Opens the appropriate posted document page based on the document type.
• ShowPostedDocAttachment(): Opens the document attachment details page for the posted document associated with this entry.
• HasPostedDocAttachment(): Boolean: Checks whether the posted document associated with this entry has any attachments.
• DrillDownOnEntries(var DtldCustLedgEntry: Record "Detailed Cust. Ledg. Entry"): Opens the Customer Ledger Entries page filtered by the specified detailed customer ledger entry filters.
• DrillDownOnOverdueEntries(var DtldCustLedgEntry: Record "Detailed Cust. Ledg. Entry"): Opens the Customer Ledger Entries page filtered to show only overdue entries.
• GetOriginalCurrencyFactor(): Decimal: Gets the original currency factor, returning 1 if not set.
• GetAdjustedCurrencyFactor(): Decimal: Gets the adjusted currency factor, returning 1 if not set.
• ShowDimensions(): Opens the Dimension Set Entries page showing the dimensions for this entry.
• SetStyle(): Text: Determines the visual style for displaying this entry based on its payment status.
• SetApplyToFilters(CustomerNo: Code[20]; ApplyDocType: Option; ApplyDocNo: Code[20]; ApplyAmount: Decimal): Sets filters on the record to show entries that can be applied based on the specified criteria.
• SetAmountToApply(AppliesToDocNo: Code[20]; CustomerNo: Code[20]): Toggles the Amount to Apply field between the remaining amount and zero for the specified document.
• CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line"): Copies field values from a general journal line to this customer ledger entry.
• CopyFromCVLedgEntryBuffer(var CVLedgerEntryBuffer: Record "CV Ledger Entry Buffer"): Copies field values from a CV ledger entry buffer to this customer ledger entry.
• RecalculateAmounts(FromCurrencyCode: Code[10]; ToCurrencyCode: Code[10]; PostingDate: Date): Recalculates amount fields from one currency to another using exchange rates at the specified posting date.
• UpdateAmountsForApplication(ApplnDate: Date; ApplnCurrencyCode: Code[10]; RoundAmounts: Boolean; UpdateMaxPaymentTolerance: Boolean): Updates amount fields for application by converting to the application currency.
• GetRemainingPmtDiscPossible(ReferenceDate: Date): Decimal: Gets the remaining payment discount possible, allowing for customization through events.

Plus 2 local procedures.

Relations

• drill-down page Page 25 “Customer Ledger Entries”
• lookup page Page 25 “Customer Ledger Entries”
• Direct Debit Mandate ID: TableRelation Table 1230 “SEPA Direct Debit Mandate”
• Salesperson Code: TableRelation Table 13 “Salesperson/Purchaser”
• Dispute Status: TableRelation Table 142 “Dispute Status”
• Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
• Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
• Customer No.: TableRelation Table 18 “Customer”
• Sell-to Customer No.: TableRelation Table 18 “Customer”
• Closed by Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
• Reversed by Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
• Reversed Entry No.: TableRelation Table 21 “Cust. Ledger Entry”
• Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
• Source Code: TableRelation Table 230 “Source Code”
• Reason Code: TableRelation Table 231 “Reason Code”
• Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
• Recipient Bank Account: TableRelation Table 287 “Customer Bank Account”
• Payment Method Code: TableRelation Table 289 “Payment Method”
• No. Series: TableRelation Table 308 “No. Series”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Amount (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Credit Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Credit Amount (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Debit Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Debit Amount (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Original Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Original Amt. (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Remaining Amount: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Remaining Amt. (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
• Closed by Currency Code: TableRelation Table 4 “Currency”
• Currency Code: TableRelation Table 4 “Currency”
• IC Partner Code: TableRelation Table 413 “IC Partner”
• G/L Register No.: TableRelation Table 45 “G/L Register”
• Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
• Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
• Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
• Transaction No.: TableRelation Table 57 “G/L Transaction”
• Customer Posting Group: TableRelation Table 92 “Customer Posting Group”

Referenced by

46 fields in 32 objects relate to this table (TableRelation or CalcFormula).

• Table 1208 “Direct Debit Collection Entry”: Applies-to Entry Currency Code, Applies-to Entry Description, Applies-to Entry Document No., Applies-to Entry Open, Applies-to Entry Posting Date, Payment Reference, Applies-to Entry No.
• Table 18 “Customer”: First Transaction Date, Inv. Discounts (LCY), Profit (LCY), Sales (LCY)
• Table 112 “Sales Invoice Header”: Closed, Reversed, Cust. Ledger Entry No.
• Table 21 “Cust. Ledger Entry”: Closed by Entry No., Reversed by Entry No., Reversed Entry No.
• Table 114 “Sales Cr.Memo Header”: Paid, Cust. Ledger Entry No.
• Table 1053 “Line Fee Note on Report Hist.”: Cust. Ledger Entry No
• Table 1206 “Credit Transfer Entry”: Applies-to Entry No.
• Table 1293 “Payment Application Proposal”: Applies-to Entry No.
• Table 1294 “Applied Payment Entry”: Applies-to Entry No.
• Table 1313 “Activities Cue”: Sales Invoices Due Next Week
• Table 1692 “Posted Bank Deposit Line”: Entry No.
• Table 179 “Reversal Entry”: Entry No.
• Table 296 “Reminder Line”: Entry No.
• Table 298 “Issued Reminder Line”: Entry No.
• Table 300 “Reminder/Fin. Charge Entry”: Customer Entry No.
• Table 30133 “Shpfy Order Transaction”: Used
• Table 30154 “Shpfy Suggest Payment”: Customer Ledger Entry No.
• Table 303 “Finance Charge Memo Line”: Entry No.
• Table 305 “Issued Fin. Charge Memo Line”: Entry No.
• Table 379 “Detailed Cust. Ledg. Entry”: Cust. Ledger Entry No.
• Table 382 “CV Ledger Entry Buffer”: Closed by Entry No.
• Table 4 “Currency”: Cust. Ledg. Entries in Filter
• Table 5475 “Sales Invoice Entity Aggregate”: Cust. Ledger Entry No.
• Table 5495 “Sales Order Entity Buffer”: Cust. Ledger Entry No.
• Table 5505 “Sales Quote Entity Buffer”: Cust. Ledger Entry No.
• Table 5507 “Sales Cr. Memo Entity Buffer”: Cust. Ledger Entry No.
• Table 57 “G/L Transaction”: No. of Customer Ledger Entries
• Table 6220 “Sustainability Cue”: Sales Invoices Due Next Week
• Table 846 “Cash Flow Worksheet Line”: Source No.
• Table 847 “Cash Flow Forecast Entry”: Source No.
• Table 9054 “Finance Cue”: Overdue Sales Documents
• Table 9060 “SB Owner Cue”: Overdue Sales Documents

Pages and codeunits on this table

• Page 1160 “Sales Documents” (source table)
• Page 126 “Cust. Ledg. Entries Preview” (source table)
• Page 1951 “LP Prediction FactBox” (source table)
• Page 1954 “LP - Invoices at Risk” (source table)
• Page 232 “Apply Customer Entries” (source table)
• Page 25 “Customer Ledger Entries” (source table)
• Page 5939 “Serv. Apply Customer Entries” (source table)
• Page 61 “Applied Customer Entries” (source table)
• Page 9106 “Customer Ledger Entry FactBox” (source table)
• Codeunit 103 “Cust. Entry-Edit” (codeunit runs on it)
• Codeunit 1213 “Pmt. Export Cust. Ledger Check” (codeunit runs on it)
• Codeunit 226 “CustEntry-Apply Posted Entries” (codeunit runs on it)

Extended by

• Table extension 1952 “CustomerLedgerEntryLPP”
• Table extension 30201 “Shpfy Cust. Ledger Entry”
• Table extension 8003 “Cust. Ledger Entry”

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

• Codeunit 103 “Cust. Entry-Edit” (1 call: SetAmountToApply → (object))
• Codeunit 408 “DimensionManagement” (1 call: ShowDimensions → ShowDimensionSet)
• Codeunit 700 “Page Management” (1 call: ShowDoc → PageRun)
• Codeunit 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)
• Codeunit 710 “Math” (1 call: AreOppositeSign → Sign)
• Page 438 “Issued Reminder” (1 call: ShowDoc → (object))
• Page 450 “Issued Finance Charge Memo” (1 call: ShowDoc → (object))

Recent changes

• 2026-09-14 #10840 Bugs/625412 Wrong posted G/L Entries and VAT Entries using Cash Basis Unrealized VAT from a partial Credit Memo if we mix VAT types and use only part of the amount in the Mexican version. (main, BC30, fix)
• 2026-07-20 #9089 Merge-ES-Excluded-from-Calculation-to-W1 (main, BC30, feature)

Countries that replace it

AU, CA, CH, ES, FI, IS, IT, MX, NL, NZ, RU, US

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Cust. Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.