Table 113 "Sales Invoice Line"

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

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: Document No., Line No. (clustered)
• Key2: Blanket Order No., Blanket Order Line No.
• Key3: Sell-to Customer No.
• Key5: Shipment No., Shipment Line No.
• Key6: Job Contract Entry No.
• Key7: Bill-to Customer No.
• Key8: Order No., Order Line No., Posting Date
• Key9: Document No., Location Code
• Key10: Type, No.
• Key11: Job No., Job Task No.

Events published

• OnAfterCalcQty(var SalesInvoiceLine: Record "Sales Invoice Line"; QtyBase: Decimal; var Result: Decimal) (integration): Raised after calculating the quantity for the sales invoice line.
• OnAfterInitFromSalesLine(var SalesInvLine: Record "Sales Invoice Line"; SalesInvHeader: Record "Sales Invoice Header"; SalesLine: Record "Sales Line") (integration): Raised after initializing the sales invoice line from a sales line.
  • subscribers: Codeunit 8063 “Sales Documents” SalesInvLineCopyContractNoOnAfterInitFromSalesLine
• OnBeforeGetItemLedgEntries(var SalesInvLine: Record "Sales Invoice Line"; var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean; var IsHandled: Boolean) (integration): Raised before getting item ledger entries for the sales invoice line.
• OnBeforeCalcVATAmountLines(SalesInvLine: Record "Sales Invoice Line"; SalesInvHeader: Record "Sales Invoice Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary; var IsHandled: Boolean) (integration): Raised before calculating VAT amount lines for the sales invoice.
• OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry"; SetQuantity: Boolean) (integration): Raised before inserting the temporary item ledger entry during GetItemLedgEntries.
• OnBeforeShowDeferrals(SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean) (integration): Raised before showing deferrals for the sales invoice line.
• OnBeforeSetSecurityFilterOnRespCenter(var SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean) (integration): Raised before setting the security filter on responsibility center for the sales invoice line.
• OnAfterGetVATPct(var SalesInvoiceLine: Record "Sales Invoice Line"; var VATPct: Decimal) + BC26 (integration): Raised after getting the VAT percentage for the sales invoice line.
• OnAfterCalcShippedSaleNotReturned(var SalesInvoiceLine: Record "Sales Invoice Line"; var ShippedQtyNotReturned: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean) + BC26 (integration): Raised after calculating the shipped sales quantity not returned.

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 1173 “Document Attachment Mgmt” DeleteAttachedDocumentsOnAfterDeleteSalesInvoiceLine, Codeunit 8059 “Sub. Contracts General Mgt.” SalesInvoiceLineDeleteArchivedBillingLines

Procedures

• GetCurrencyCode(): Code[10]: Retrieves the currency code from the sales invoice header.
• ShowDimensions(): Opens the dimension set entries page for this invoice line.
• ShowItemTrackingLines(): Opens the Item Tracking Lines page showing the tracking for this invoice line.
• CalcVATAmountLines(SalesInvHeader: Record "Sales Invoice Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary): Calculates VAT amount lines for the invoice based on the invoice lines.
• GetLineAmountExclVAT(): Decimal: Calculates the line amount excluding VAT.
• GetLineAmountInclVAT(): Decimal: Calculates the line amount including VAT.
• GetInvoiceHeader(): Record "Sales Invoice Header": Retrieves the sales invoice header record for this line.
• GetCaptionClass(FieldNumber: Integer): Text[80]: Retrieves the caption class for a specified field to handle VAT-inclusive pricing display.
• RowID1(): Text[250]: Generates a unique row identifier for item tracking purposes.
• GetSalesShptLines(var TempSalesShipmentLine: Record "Sales Shipment Line" temporary) Δ BC26: Retrieves the sales shipment lines associated with this invoice line.
• CalcShippedSaleNotReturned(var ShippedQtyNotReturned: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean): Calculates the shipped sales quantity that has not been returned.
• GetItemLedgEntries(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean): Retrieves item ledger entries associated with this invoice line.
• FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry"): Applies filters to value entries to retrieve entries for this posted document line.
• ShowItemShipmentLines(): Opens a page displaying the shipment lines for this invoice line.
• ShowLineComments(): Opens a page displaying the comments for this invoice line.
• ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20]): Retrieves the shortcut dimension codes for this invoice line.
• InitFromSalesLine(SalesInvHeader: Record "Sales Invoice Header"; SalesLine: Record "Sales Line"): Initializes the sales invoice line from a sales line when posting an invoice.
• ShowDeferrals(): Opens a page displaying the deferral schedule for this invoice line.
• UpdatePriceDescription(): Updates the price description field based on current line values.
• FormatType(): Text: Formats the line type for display, handling blank types specially.
• GetDocumentType(): Integer: Retrieves the document type integer for this posted invoice line.
• HasTypeToFillMandatoryFields(): Boolean: Determines whether the line has a type that requires mandatory fields to be filled.
• IsCancellationSupported(): Boolean: Checks if the line type supports invoice cancellation.
• SetSecurityFilterOnRespCenter(): Applies a security filter based on the user’s responsibility center setup.
• GetDateForCalculations(): Date: Retrieves the date to use for calculations, defaulting to work date if posting date is not set.
• GetVATPct(): Decimal + BC26 (internal)

Plus 3 local procedures.

Triggers

OnDelete

Relations

• drill-down page Page 526 “Posted Sales Invoice Lines”
• lookup page Page 526 “Posted Sales Invoice Lines”
• Job Task No.: TableRelation Table 1001 “Job Task”
• Document No.: TableRelation Table 112 “Sales Invoice Header”
• Attached to Line No.: TableRelation Table 113 “Sales Invoice Line”
• Location Code: TableRelation Table 14 “Location”
• No.: TableRelation Table 15 “G/L Account” (conditional)
• No.: TableRelation Table 156 “Resource” (conditional)
• Job No.: TableRelation Table 167 “Job”
• Deferral Code: TableRelation Table 1700 “Deferral Template”
• Sell-to Customer Name: CalcFormula Table 18 “Customer”
• Bill-to Customer No.: TableRelation Table 18 “Customer”
• Sell-to Customer No.: TableRelation Table 18 “Customer”
• Work Type Code: TableRelation Table 200 “Work Type”
• Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
• Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• Transaction Type: TableRelation Table 258 “Transaction Type”
• Transport Method: TableRelation Table 259 “Transport Method”
• No.: TableRelation Table 27 “Item” (conditional)
• Exit Point: TableRelation Table 282 “Entry/Exit Point”
• Area: TableRelation Table 284 “Area”
• Transaction Specification: TableRelation Table 285 “Transaction Specification”
• Tax Area Code: TableRelation Table 318 “Tax Area”
• Tax Group Code: TableRelation Table 321 “Tax Group”
• VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
• VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
• Customer Disc. Group: TableRelation Table 340 “Customer Discount Group”
• Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Blanket Order No.: TableRelation Table 36 “Sales Header”
• Blanket Order Line No.: TableRelation Table 37 “Sales Line”
• IC Partner Code: TableRelation Table 413 “IC Partner”
• Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
• Variant Code: TableRelation Table 5401 “Item Variant”
• Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
• Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
• VAT Clause Code: TableRelation Table 560 “VAT Clause”
• No.: TableRelation Table 5600 “Fixed Asset” (conditional)
• Posting Group: TableRelation Table 5606 “FA Posting Group” (conditional)
• Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
• Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
• Responsibility Center: TableRelation Table 5714 “Responsibility Center”
• Purchasing Code: TableRelation Table 5721 “Purchasing”
• Item Category Code: TableRelation Table 5722 “Item Category”
• No.: TableRelation Table 5800 “Item Charge” (conditional)
• Customer Price Group: TableRelation Table 6 “Customer Price Group”
• Return Reason Code: TableRelation Table 6635 “Return Reason”
• Bin Code: TableRelation Table 7354 “Bin”
• Posting Group: TableRelation Table 94 “Inventory Posting Group” (conditional)

Referenced by

5 fields in 3 objects relate to this table (TableRelation or CalcFormula).

• Table 112 “Sales Invoice Header”: Amount, Amount Including VAT, Invoice Discount Amount
• Table 113 “Sales Invoice Line”: Attached to Line No.
• Table extension 6238 “Sust. Sales Invoice Header”: Sustainability Lines Exist

Pages and codeunits on this table

• Page 133 “Posted Sales Invoice Subform” (source table)
• Page 526 “Posted Sales Invoice Lines” (source table)
• Page 5852 “Get Post.Doc - S.InvLn Subform” (source table)

Extended by

• Table extension 30103 “Shpfy Sales Invoice Line”
• Table extension 4862 “AutoAcc Sales Invoice Line”
• Table extension 5022 “Serv. Decl. Sales Inv. Line”
• Table extension 6239 “Sust. Sales Invoice Line”
• Table extension 6905 “Exp - Sales Inv Line - Ext”
• Table extension 8056 “Sales Invoice Line”

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 408 “DimensionManagement” (2 calls: ShowDimensions → ShowDimensionSet, ShowShortcutDimCode → GetShortcutDimensions)
• Codeunit 1720 “Deferral Utilities” (1 call: ShowDeferrals → OpenLineScheduleView)
• Codeunit 5402 “Unit of Measure Management” (1 call: CalcQty → QtyRndPrecision)
• Codeunit 5700 “User Setup Management” (1 call: SetSecurityFilterOnRespCenter → GetSalesFilter)
• Codeunit 6500 “Item Tracking Management” (1 call: RowID1 → ComposeRowID)
• Codeunit 6503 “Item Tracking Doc. Management” (1 call: ShowItemTrackingLines → ShowItemTrackingForInvoiceLine)

Recent changes

• 2026-08-13 #9947 Allow long localized sales and purchase line type captions (main, BC30, fix)

Countries that replace it

AU, CA, CH, ES, FI, GB, IT, MX, NO, NZ, RU, SE, 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: "Sales Invoice Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.