Table 380 "Detailed Vendor Ledg. Entry"

Base Application · Microsoft.Purchases.Payables · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 574 “Detailed Vendor Ledg. Entries” (1 Learn page), Page 624 “Unapply Vendor Entries” (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: Vendor No., Currency Code, Excluded from calculation
• Key3: Vendor Ledger Entry No., Entry Type, Posting Date
• Key4: Vendor Ledger Entry No., Ledger Entry Amount, Posting Date, Excluded from calculation
• Key5: Initial Document Type, Entry Type, Vendor No., Currency Code, Initial Entry Global Dim. 1, Initial Entry Global Dim. 2, Posting Date
• Key6: Vendor No., Currency Code, Initial Entry Global Dim. 1, Initial Entry Global Dim. 2, Initial Entry Due Date, Posting Date, Excluded from calculation
• Key7: Document No., Document Type, Posting Date
• Key8: Applied Vend. Ledger Entry No., Entry Type
• Key9: Transaction No., Vendor No., Entry Type
• Key10: Application No., Vendor No., Entry Type
• Key11: Initial Document Type, Initial Entry Due Date
• Key12: Vendor No., Entry Type, Posting Date

Events published

• OnAfterUpdateDebitCredit(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; Correction: Boolean) (integration)
• OnBeforeSetLedgerEntryAmount(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var IsHandled: Boolean) + BC24 (integration)
• OnSetZeroTransNoOnBeforeDetailedVendorLedgEntryModify(var DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry") (integration)

Trigger event subscribers

• OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertDetailedVendorLedgEntry
• OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyDetailedVendorLedgerEntry

Procedures

• GetLastEntryNo(): Integer Δ BC26
• UpdateDebitCredit(Correction: Boolean)
• SetZeroTransNo(TransactionNo: Integer)
• GetUnrealizedGainLossAmount(EntryNo: Integer): Decimal

Plus 1 local procedures.

Triggers

OnInsert

Relations

• drill-down page Page 574 “Detailed Vendor Ledg. Entries”
• lookup page Page 574 “Detailed Vendor Ledg. Entries”
• Vendor No.: TableRelation Table 23 “Vendor”
• Source Code: TableRelation Table 230 “Source Code”
• Reason Code: TableRelation Table 231 “Reason Code”
• Vendor Ledger Entry No.: TableRelation Table 25 “Vendor Ledger Entry”
• Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• Tax Jurisdiction Code: TableRelation Table 320 “Tax Jurisdiction”
• VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
• VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
• Initial Entry Global Dim. 1: TableRelation Table 349 “Dimension Value”
• Initial Entry Global Dim. 2: TableRelation Table 349 “Dimension Value”
• Unapplied by Entry No.: TableRelation Table 380 “Detailed Vendor Ledg. Entry”
• Currency Code: TableRelation Table 4 “Currency”
• G/L Register No.: TableRelation Table 45 “G/L Register”
• Transaction No.: TableRelation Table 57 “G/L Transaction”
• Exch. Rate Adjmt. Reg. No.: TableRelation Table 86 “Exch. Rate Adjmt. Reg.”
• Posting Group: TableRelation Table 93 “Vendor Posting Group”

Referenced by

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

• Table 23 “Vendor”: Balance, Balance (LCY), Balance Due, Balance Due (LCY), Cr. Memo Amounts, Cr. Memo Amounts (LCY), Credit Amount, Credit Amount (LCY), Debit Amount, Debit Amount (LCY), Fin. Charge Memo Amounts (LCY), Finance Charge Memo Amounts, Inv. Amounts (LCY), Invoice Amounts, Net Change, Net Change (LCY), Other Amounts, Other Amounts (LCY), Payments, Payments (LCY), Pmt. Disc. Tolerance (LCY), Pmt. Discounts (LCY), Pmt. Tolerance (LCY), Refunds, Refunds (LCY), Reminder Amounts, Reminder Amounts (LCY)
• Table 25 “Vendor Ledger Entry”: Amount, Amount (LCY), Credit Amount, Credit Amount (LCY), Debit Amount, Debit Amount (LCY), Original Amount, Original Amt. (LCY), Remaining Amount, Remaining Amt. (LCY)
• Table 4 “Currency”: Vendor Balance, Vendor Balance (LCY), Vendor Balance Due
• Table 122 “Purch. Inv. Header”: Remaining Amount
• Table 124 “Purch. Cr. Memo Hdr.”: Remaining Amount
• Table 380 “Detailed Vendor Ledg. Entry”: Unapplied by Entry No.
• Table 86 “Exch. Rate Adjmt. Reg.”: Adjusted Vendors
• Table 9151 “My Vendor”: Balance (LCY)
• Table 98 “General Ledger Setup”: Vendor Balances Due

Pages and codeunits on this table

• Page 129 “Detailed Vend. Entries Preview” (source table)
• Page 574 “Detailed Vendor Ledg. Entries” (source table)
• Page 624 “Unapply Vendor Entries” (source table)

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 703 “Find Record Management” (1 call: GetLastEntryNo → GetLastEntryIntFieldValue)

Recent changes

• 2026-07-20 #9089 Merge-ES-Excluded-from-Calculation-to-W1 (main, BC30, feature)

Countries that replace it

AU, ES, FR, IT, NZ, RU

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: "Detailed Vendor Ledg. Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.