Table 5907 "Service Ledger Entry"
Base Application · Microsoft.Service.Ledger
Across versions
- BC23present
- BC244 fields changed, 1 fields added
- BC25unchanged
- BC261 procedures changed
- BC27unchanged
- BC2850 fields changed
- BC291 fields changed, 1 fields added
- BC30unchanged
Neighbourhood 36 connected objects and pages
Base Application · Microsoft.Service.Ledger · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Service Ledger Entry |
| DataClassification | CustomerContent |
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.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 2 | Service Contract No. Δ BC28 | Code[20] | Specifies the number of the service contract, if this entry is linked to a service contract. | TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract))) |
| 3 | Document Type Δ BC28 | Enum “Service Ledger Entry Document Type” | Specifies the document type of the service ledger entry. | enum Enum 5909 “Service Ledger Entry Document Type” |
| 4 | Document No. Δ BC28 | Code[20] | Specifies the number of the document from which this entry was created. | |
| 5 | Serv. Contract Acc. Gr. Code Δ BC28 | Code[10] | Specifies the service contract account group code the service contract is associated with, if this entry is included in a service contract. | TableRelation Table 5973 “Service Contract Account Group” (“Service Contract Account Group”.Code) |
| 6 | Document Line No. | Integer | — | |
| 8 | Moved from Prepaid Acc. Δ BC28 | Boolean | Specifies that this entry is not a prepaid entry from a service contract. | |
| 9 | Posting Date Δ BC28 | Date | Specifies the date when this entry was posted. | |
| 11 | Amount (LCY) Δ BC28 | Decimal | Specifies the amount of the entry in LCY. via Page 168 “Service Ledger Entries Preview” | |
| 12 | Customer No. Δ BC28 | Code[20] | Specifies the number of the customer related to this entry. | TableRelation Table 18 “Customer” |
| 13 | Ship-to Code Δ BC28 | Code[10] | Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment. | TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”))) |
| 14 | Item No. (Serviced) | Code[20] | Specifies the number of the serviced item associated with this entry. via Page 168 “Service Ledger Entries Preview” | TableRelation Table 27 “Item” |
| 15 | Serial No. (Serviced) | Code[50] | Specifies the serial number of the serviced item associated with this entry. via Page 168 “Service Ledger Entries Preview” | |
| 16 | User ID Δ BC28 | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 17 | Contract Invoice Period Δ BC28 | Text[30] | Specifies the invoice period of that contract, if this entry originates from a service contract. | |
| 18 | Global Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 19 | Global Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 20 | Service Item No. (Serviced) | Code[20] | Specifies the number of the serviced item associated with this entry. via Page 168 “Service Ledger Entries Preview” | TableRelation Table 5940 “Service Item” (Service Item) |
| 21 | Variant Code (Serviced) | Code[10] | — | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No. (Serviced)”))) |
| 22 | Contract Group Code Δ BC28 | Code[10] | Specifies the contract group code of the service contract to which this entry is associated. | TableRelation Table 5966 “Contract Group” (“Contract Group”.Code) |
| 23 | Type Δ BC28 | Enum “Service Ledger Entry Type” | Specifies the type of origin of this entry. | enum Enum 5907 “Service Ledger Entry Type” |
| 24 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation Table 156 “Resource”, Table 27 “Item”, Table 5905 “Service Cost” (if (Type = const(“Service Contract”)) “Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract)) else if (Type = const(” “)) “Standard Text” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(“Service Cost”)) “Service Cost” else i…) |
| 25 | Cost Amount Δ BC28 | Decimal | Specifies the total cost on the line by multiplying the unit cost by the quantity. | |
| 26 | Discount Amount Δ BC28 | Decimal | Specifies the total discount amount on this entry. | |
| 27 | Unit Cost Δ BC28 | Decimal | Specifies the cost of one unit of the item or resource on the line. | |
| 28 | Quantity Δ BC28 | Decimal | Specifies the number of units in this entry. | |
| 29 | Charged Qty. Δ BC28 | Decimal | Specifies the number of units in this entry that should be invoiced. | |
| 30 | Unit Price Δ BC28 | Decimal | Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. | |
| 31 | Discount % Δ BC28 | Decimal | Specifies the discount percentage of this entry. | |
| 32 | Contract Disc. Amount Δ BC28 | Decimal | Specifies the total contract discount amount of this entry. | |
| 33 | Bill-to Customer No. Δ BC28 | Code[20] | Specifies the number of the customer that you send or sent the invoice or credit memo to. | TableRelation Table 18 “Customer” |
| 34 | Fault Reason Code Δ BC28 | Code[10] | Specifies the fault reason code for this entry. | TableRelation Table 5917 “Fault Reason Code” (Fault Reason Code) |
| 35 | Description Δ BC28 | Text[100] | Specifies a description of the resource, item, cost, standard text, general ledger account, or service contract associated with this entry. | |
| 37 | Service Order Type Δ BC28 | Code[10] | Specifies the type of the service order if this entry was created for a service order. | TableRelation Table 5903 “Service Order Type” (Service Order Type) |
| 39 | Service Order No. Δ BC28 | Code[20] | Specifies the number of the service order, if this entry was created for a service order. | |
| 40 | Job No. Δ BC24 Δ BC28 Δ BC29 | Code[20] | Specifies the number of the related project. | TableRelation Job.“No.” |
| 41 | Gen. Bus. Posting Group Δ BC28 | Code[20] | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 42 | Gen. Prod. Posting Group Δ BC28 | Code[20] | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 43 | Location Code Δ BC28 | Code[10] | Specifies the code for the location associated with this entry. | TableRelation Table 14 “Location” |
| 44 | Unit of Measure Code | Code[10] | — | TableRelation Table 204 “Unit of Measure” (Unit of Measure) |
| 45 | Work Type Code | Code[10] | — | TableRelation Table 200 “Work Type” (Work Type) |
| 46 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))) |
| 47 | Responsibility Center | Code[10] | — | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 48 | Variant Code | Code[10] | — | TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”))) |
| 50 | Entry Type Δ BC28 | Enum “Service Ledger Entry Entry Type” | Specifies the type for this entry. | enum Enum 5908 “Service Ledger Entry Entry Type” |
| 51 | Open Δ BC28 | Boolean | Specifies contract-related service ledger entries. | |
| 52 | Serv. Price Adjmt. Gr. Code | Code[10] | — | TableRelation Table 6082 “Service Price Adjustment Group” (Service Price Adjustment Group) |
| 53 | Service Price Group Code | Code[10] | — | TableRelation Table 6080 “Service Price Group” (Service Price Group) |
| 54 | Prepaid Δ BC28 | Boolean | Specifies whether the service contract or contract-related service order was prepaid. | |
| 55 | Apply Until Entry No. | Integer | — | |
| 56 | Applies-to Entry No. Δ BC28 | Integer | Specifies the number of the entry to which this entry is applied, if an entry is created for a service credit memo. | |
| 57 | Amount Δ BC28 | Decimal | Specifies the amount on this entry. | |
| 58 | Job Task No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the related project task. | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 59 | Job Line Type Δ BC24 Δ BC28 | Enum “Job Line Type” | Specifies the journal line type that is created in the Project Planning Line table and linked to this project ledger entry. | enum Enum 1002 “Job Line Type” |
| 60 | Job Posted Δ BC24 | Boolean | Project Posted caption | |
| 61 | External Document No. + BC24 Δ BC28 | Code[35] | Specifies a document number that refers to the customer’s numbering system. | |
| 95 | Service Register No. + BC29 | Integer | Specifies the service register number that this entry belongs to. | TableRelation Table 5934 “Service Register” (Service Register); not editable |
| 480 | Dimension Set ID Δ BC28 | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Document No., Posting Date
- Key3: Entry Type, Document Type, Document No., Document Line No.
- Key4: Service Contract No., Entry No., Entry Type, Type, Moved from Prepaid Acc., Posting Date, Open, Prepaid, Service Item No. (Serviced), Customer No., Contract Group Code, Responsibility Center
- Key5: Service Order No., Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Posting Date, Open, Type, Service Contract No.
- Key6: Type, No., Entry Type, Moved from Prepaid Acc., Posting Date, Open, Prepaid
- Key7: Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Type, Posting Date, Open, Service Contract No., Prepaid, Customer No., Contract Group Code, Responsibility Center
- Key8: Service Item No. (Serviced), Entry Type, Type, Service Contract No., Posting Date, Service Order No.
- Key9: Service Register No.
- Key10: Service Contract No., Service Item No. (Serviced), Entry Type, Applies-to Entry No.
Events published
OnAfterCopyFromServHeader(var ServiceLedgerEntry: Record "Service Ledger Entry"; ServiceHeader: Record "Service Header")(integration)OnAfterCopyFromServLine(var ServiceLedgerEntry: Record "Service Ledger Entry"; ServiceLine: Record "Service Line")(integration)
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 6499 “Serv. Posting Preview Handler” OnInsertServiceLedgerEntry
- OnAfterModifyEvent: Codeunit 6499 “Serv. Posting Preview Handler” OnModifyServiceLedgerEntry
- OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceLedgerEntry
Procedures
GetNextEntryNo(): Integer+ BC29: Gets the next entry number for the Service Ledger Entry table.GetLastEntryNo(): IntegerΔ BC26ShowDimensions()CopyFromServHeader(ServHeader: Record "Service Header")CopyFromServLine(ServLine: Record "Service Line"; DocNo: Code[20])CopyServicedInfo(ServiceItemNo: Code[20]; ItemNo: Code[20]; SerialNo: Code[50]; VariantCode: Code[10])
Relations
- drill-down page Page 5912 “Service Ledger Entries”
- lookup page Page 5912 “Service Ledger Entries”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Location Code: TableRelation Table 14 “Location”
- No.: TableRelation Table 156 “Resource” (conditional)
- Bill-to Customer No.: TableRelation Table 18 “Customer”
- Customer No.: TableRelation Table 18 “Customer”
- Work Type Code: TableRelation Table 200 “Work Type”
- Unit of Measure Code: TableRelation Table 204 “Unit of Measure”
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Item No. (Serviced): TableRelation Table 27 “Item”
- No.: TableRelation Table 27 “Item” (conditional)
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- 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”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Variant Code (Serviced): TableRelation Table 5401 “Item Variant”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Service Order Type: TableRelation Table 5903 “Service Order Type”
- No.: TableRelation Table 5905 “Service Cost” (conditional)
- Fault Reason Code: TableRelation Table 5917 “Fault Reason Code”
- Service Register No.: TableRelation Table 5934 “Service Register”
- Service Item No. (Serviced): TableRelation Table 5940 “Service Item”
- No.: TableRelation Table 5965 “Service Contract Header” (conditional)
- Service Contract No.: TableRelation Table 5965 “Service Contract Header”
- Contract Group Code: TableRelation Table 5966 “Contract Group”
- Serv. Contract Acc. Gr. Code: TableRelation Table 5973 “Service Contract Account Group”
- Service Price Group Code: TableRelation Table 6080 “Service Price Group”
- Serv. Price Adjmt. Gr. Code: TableRelation Table 6082 “Service Price Adjustment Group”
- No.: TableRelation Table 7 “Standard Text” (conditional)
- Bin Code: TableRelation Table 7354 “Bin”
Referenced by
17 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 5940 “Service Item”: Contract Cost, Cost Used, Invoiced Amount, Parts Used, Prepaid Amount, Resources Used, Total Qty. Consumed, Total Qty. Invoiced, Total Quantity, Usage (Amount), Usage (Cost)
- Table 5965 “Service Contract Header”: Contract Cost Amount, Contract Discount Amount, Contract Invoice Amount, Contract Prepaid Amount
- Table 5934 “Service Register”: From Entry No., To Entry No.
Pages and codeunits on this table
- Page 168 “Service Ledger Entries Preview” (source table)
- Page 5912 “Service Ledger 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 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue) - Codeunit 9500 “Sequence No. Mgt.” (1 call:
GetNextEntryNo → GetNextSeqNo)
Recent changes
- 2026-09-03 #10867 [29.x][ALL-E]Issues with Service Contract Invoicing and Retrospective Billing–when the second unposted Service Invoice is deleted the values on the Service Contract are no longer reset–The “Invoiced to Date” field does not resetInitial commit- #10345Initial commit (releases/29.x, BC29, fix)
- 2026-09-03 #10345 [Main][ALL-E]Issues with Service Contract Invoicing and Retrospective Billing–when the second unposted Service Invoice is deleted the values on the Service Contract are no longer reset–The “Invoiced to Date” field does not resetInitial commit (main, BC30, fix)
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: "Service Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.