--- id: object/table/7114 type: object title: Table 7114 "Analysis Line" summary: Table 7114 "Analysis Line" in Base Application (Microsoft.Inventory.Analysis). 26 fields, 4 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC28. tier: official language: en tags: - table - base application versions: introduced: null last_changed: "28" deprecated: null review: state: derived by: null at: null flags: [] generated: at: "2026-10-11T00:31:51.816Z" pipeline: 0.2.0 prompts: {} input_hash: be9c121ca0622490a98e3dc118ff572414e629d444f377e1ee44ccea02091c96 evidence: - kind: code url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisLine.Table.al title: src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisLine.Table.al (releases/29.x) date: null commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220 t: null quote: null links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] object_type: table object_id: 7114 name: Analysis Line namespace: Microsoft.Inventory.Analysis app: Base Application extends: null first_version: "23" last_version: "30" present_in: - "23" - "24" - "25" - "26" - "27" - "28" - "29" - "30" changed_in: - "24" - "28" source_major: "29" obsolete: null countries: [] ms_search_form_ids: [] counts: fields: 26 procedures: 7 events: 1 subscribers: 0 relations: out: 13 referenced_by: 1 pages: 9 extended_by: 0 event_subscribers: 0 calls: 0 called_by: 0 implements: 0 --- # Table 7114 "Analysis Line" > Table 7114 "Analysis Line" in Base Application (Microsoft.Inventory.Analysis). 26 fields, 4 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC28. Base Application · Microsoft.Inventory.Analysis · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Inventory/Analysis/AnalysisLine.Table.al) · facts from BC29 ## Properties | Property | Value | |---|---| | Caption | Analysis Line | | 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 | Analysis Area | Enum "Analysis Area Type" | — | enum [Enum 7130 "Analysis Area Type"](../enum/7130.md) | | 2 | Analysis Line Template Name | Code[10] | — | TableRelation [Table 7112 "Analysis Line Template"](../table/7112.md) ("Analysis Line Template".Name where("Analysis Area" = field("Analysis Area"))) | | 3 | Line No. | Integer | — | | | 4 | Row Ref. No. | Code[20] | Specifies a row reference number for the analysis line. | | | 5 | Description | Text[100] | Specifies a description for the analysis line. | | | 6 | Type | Enum "Analysis Line Type" | Specifies the type of totaling for the analysis line. The type determines which items within the totaling range that you specify in the Range field will be totaled. | enum [Enum 7114 "Analysis Line Type"](../enum/7114.md) | | 7 | Range | Text[250] | Specifies the number or formula of the type to use to calculate the total for this line. | TableRelation [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md), [Table 27 "Item"](../table/27.md) (if (Type = const(Item)) Item else if (Type = const(Customer)) Customer else if (Type = const(Vendor)) Vendor else if (Type = const("Item Group")) "Dimension Value".Code where("Dimension Code" = field("Group Dimension Code"), Blocked = const(false)) else if (Type = const("Customer Group")) "Dimension...) | | 8 | New Page | Boolean | Specifies if you want a page break after the current line when you print the analysis report. | | | 9 | Show | Option | Specifies whether you want the analysis line to be included when you print the report. | OptionCaption: Yes,No,If Any Column Not Zero | | 10 | Bold | Boolean | Specifies if you want the amounts on this line to be printed in bold. | | | 11 | Italic | Boolean | Specifies if you want the amounts in this line to be printed in italics. | | | 12 | Underline | Boolean | Specifies if you want the amounts in this line to be underlined when printed. | | | 13 | Show Opposite Sign | Boolean | Specifies if you want sales and negative adjustments to be shown as positive amounts and purchases and positive adjustments to be shown as negative amounts. | | | 14 | Source Type Filter | Enum "Analysis Source Type" | — | FlowFilter; enum [Enum 7131 "Analysis Source Type"](../enum/7131.md) | | 15 | Date Filter | Date | — | FlowFilter | | 16 | Item Budget Filter | Code[10] | — | TableRelation [Table 7132 "Item Budget Name"](../table/7132.md) ("Item Budget Name".Name where("Analysis Area" = field("Analysis Area"))); FlowFilter | | 17 | Location Filter | Code[10] | — | TableRelation [Table 14 "Location"](../table/14.md); FlowFilter | | 18 | Dimension 1 Filter | Code[20] | — | FlowFilter | | 19 | Dimension 2 Filter | Code[20] | — | FlowFilter | | 20 | Dimension 3 Filter | Code[20] | — | FlowFilter | | 21 | Dimension 1 Totaling | Text[80] | Specifies which dimension value amounts will be totaled on this line. | | | 22 | Dimension 2 Totaling | Text[80] | Specifies which dimension value amounts will be totaled on this line. If the type on the line is Formula, this field must be blank. Also, if you do not want the amounts on the line to be filtered by dimensions, this field must be blank. | | | 23 | Dimension 3 Totaling | Text[80] | Specifies which dimension value amounts will be totaled on this line. If the type on the line is Formula, this field must be blank. Also, if you do not want the amounts on the line to be filtered by dimensions, this field must be blank. | | | 24 | Source No. Filter | Code[20] | — | TableRelation [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md), [Table 27 "Item"](../table/27.md) (if ("Source Type Filter" = const(Customer)) Customer else if ("Source Type Filter" = const(Vendor)) Vendor else if ("Source Type Filter" = const(Item)) Item); FlowFilter | | 25 | Group Dimension Code | Code[20] | — | TableRelation [Table 348 "Dimension"](../table/348.md) | | 26 | Indentation | Integer | Specifies the indentation of the line. | | ## Keys - Key1: Analysis Area, Analysis Line Template Name, Line No. (clustered) ## Events published - `OnLookupTotalingRangeOnElse(var AnalysisLine: Record "Analysis Line"; var Text: Text; var Result: Boolean)` (integration) ## Procedures - `CheckFormula(Formula: Code[250])` - `LookupTotalingRange(var Text: Text): Boolean` - `LookupDimTotalingRange(var Text: Text; GroupDimCode: Code[20]): Boolean` - `GetCaptionClass(DimNo: Integer): Text[250]` Plus 2 local procedures. ## Triggers OnInsert, OnModify ## Relations - drill-down page [Page 7115 "Inventory Analysis Lines"](../page/7115.md) - lookup page [Page 7115 "Inventory Analysis Lines"](../page/7115.md) - Location Filter: TableRelation [Table 14 "Location"](../table/14.md) - Range: TableRelation [Table 18 "Customer"](../table/18.md) (conditional) - Source No. Filter: TableRelation [Table 18 "Customer"](../table/18.md) (conditional) - Range: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional) - Source No. Filter: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional) - Range: TableRelation [Table 27 "Item"](../table/27.md) (conditional) - Source No. Filter: TableRelation [Table 27 "Item"](../table/27.md) (conditional) - Group Dimension Code: TableRelation [Table 348 "Dimension"](../table/348.md) - Range: TableRelation [Table 349 "Dimension Value"](../table/349.md) (conditional) - Analysis Line Template Name: TableRelation [Table 7112 "Analysis Line Template"](../table/7112.md) - Item Budget Filter: TableRelation [Table 7132 "Item Budget Name"](../table/7132.md) ## Referenced by 1 fields in 1 objects relate to this table (TableRelation or CalcFormula). - [Table 771 "Analysis Report Chart Line"](../table/771.md): Analysis Line Line No. ## Pages and codeunits on this table - [Page 7115 "Inventory Analysis Lines"](../page/7115.md) (source table) - [Page 7117 "Sales Analysis Report"](../page/7117.md) (source table) - [Page 7118 "Purchase Analysis Report"](../page/7118.md) (source table) - [Page 7119 "Inventory Analysis Report"](../page/7119.md) (source table) - [Page 7120 "Sales Analysis Lines"](../page/7120.md) (source table) - [Page 7121 "Purchase Analysis Lines"](../page/7121.md) (source table) - [Page 9201 "Inventory Analysis Matrix"](../page/9201.md) (source table) - [Page 9205 "Purchase Analysis Matrix"](../page/9205.md) (source table) - [Page 9207 "Sales Analysis Matrix"](../page/9207.md) (source table) - [Codeunit 7110 "Analysis Report Management"](../codeunit/7110.md) (codeunit runs on it) ## Across versions - Present in: BC23-30 - Changed (declaration) in: BC24, BC28 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). 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: "Analysis Line")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.