Table 15 "G/L Account"

Base Application · Microsoft.Finance.GeneralLedger.Account · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 16 “Chart of Accounts” (8 Learn pages), Page 18 “G/L Account List” (3), Page 422 “G/L Balance/Budget” (2), Page 570 “Chart of Accounts (G/L)” (2), Page 634 “Chart of Accounts Overview” (2), Page 791 “G/L Accounts ListPart” (2), Page 1158 “Cash Account Balances” (2), Page 20014 “APIV1 - Accounts” (2), Page 30014 “APIV2 - Accounts” (2), Page 17 “G/L Account Card” (1), Page 154 “G/L Account Balance/Budget” (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: No. (clustered)
• Key2: Search Name
• Key3: Reconciliation Account
• Key4: Gen. Bus. Posting Group
• Key5: Gen. Prod. Posting Group
• Key6: Consol. Debit Acc., Consol. Translation Method
• Key7: Consol. Credit Acc., Consol. Translation Method
• Key8: Name
• Key9: Account Type
• Key10: Account Category

Events published

• OnAfterCheckGLAcc(var GLAccount: Record "G/L Account") (integration): Integration event raised after validating that a general ledger account is ready for posting. Allows extensions to add custom validation logic for account posting readiness.
• OnAfterSetupNewGLAcc(var GLAccount: Record "G/L Account") (integration): Integration event raised after setting up a new general ledger account with default values. Allows extensions to add custom initialization logic for new accounts.
• OnAfterValidateShortcutDimCode(var GLAccount: Record "G/L Account"; var xGLAccount: Record "G/L Account"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised after validating and updating shortcut dimension codes. Allows extensions to perform additional processing after dimension validation.
• OnBeforeValidateShortcutDimCode(var GLAccount: Record "G/L Account"; var xGLAccount: Record "G/L Account"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised before validating shortcut dimension codes. Allows extensions to modify validation logic or skip default validation.
• OnBeforeCheckGenProdPostingGroup(var GLAccount: Record "G/L Account"; var IsHandled: Boolean) (integration): Integration event raised before checking general product posting group requirements. Allows extensions to override or supplement posting group validation logic.
• OnBeforeOnDelete(var GLAccount: Record "G/L Account"; var IsHandled: Boolean) (integration): Integration event raised before deleting a general ledger account. Allows extensions to perform custom validation or cleanup before account deletion.
• OnBeforeCheckSalesOrdersPrepmtToDeduct(var GLAccount: Record "G/L Account"; var IsHandled: Boolean) + BC25 (integration): Integration event raised before checking sales orders with prepayments to deduct. Allows extensions to override or supplement prepayment validation logic for sales orders.

Trigger event subscribers

• OnAfterDeleteEvent: Codeunit 7006 “Price Helper - V16” AfterDeleteGLAccount
• OnAfterRenameEvent: Codeunit 7006 “Price Helper - V16” AfterRenameGLAccount

Procedures

• ShowPriceListLines(PriceType: Enum "Price Type"; AmountType: Enum "Price Amount Type"): Displays price list lines for this general ledger account filtered by price type and amount type.
• SetupNewGLAcc(OldGLAcc: Record "G/L Account"; BelowOldGLAcc: Boolean): Initializes a new general ledger account with default values based on an existing account. Copies income/balance classification and other relevant setup from the reference account.
• CheckGLAcc(): Validates that the general ledger account is ready for posting transactions. Checks that account type is Posting and account is not blocked.
• ValidateAccountSubCategory(NewValue: Text[80]): Validates and sets the account subcategory based on text input from user interface. Matches input text against available subcategory descriptions for the account category.
• LookupAccountSubCategory(): Opens a lookup page for selecting account subcategory based on the account’s income/balance type and category. Updates the account category and subcategory based on user selection.
• GetCurrencyCode(): Code[10]: Returns the additional reporting currency code from General Ledger Setup. Used for additional currency amount formatting in flowfields.
• ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]): Validates and updates the shortcut dimension code for the specified dimension field. Saves the dimension value as a default dimension for this account.
• TranslationMethodConflict(var GLAcc: Record "G/L Account"): Boolean: Checks for consolidation translation method conflicts with other accounts using same consolidation accounts. Prevents inconsistent translation methods for accounts that consolidate to the same target account.
• CheckGenProdPostingGroup(): Validates that the general product posting group is specified for the account. Logs an error message if the posting group is missing for posting-type accounts.
• IsTotaling(): Boolean: Determines whether the account type supports totaling functionality. Returns true for Total and End-Total account types used in account hierarchies.

Plus 8 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• drill-down page Page 16 “Chart of Accounts”
• lookup page Page 18 “G/L Account List”
• Cost Type No.: TableRelation Table 1103 “Cost Type”
• Add.-Currency Balance at Date: CalcFormula Table 17 “G/L Entry”
• Add.-Currency Credit Amount: CalcFormula Table 17 “G/L Entry”
• Add.-Currency Debit Amount: CalcFormula Table 17 “G/L Entry”
• Additional-Currency Balance: CalcFormula Table 17 “G/L Entry”
• Additional-Currency Net Change: CalcFormula Table 17 “G/L Entry”
• Balance: CalcFormula Table 17 “G/L Entry”
• Balance at Date: CalcFormula Table 17 “G/L Entry”
• Credit Amount: CalcFormula Table 17 “G/L Entry”
• Debit Amount: CalcFormula Table 17 “G/L Entry”
• Net Change: CalcFormula Table 17 “G/L Entry”
• Source Curr. Balance at Date: CalcFormula Table 17 “G/L Entry”
• Source Currency Balance: CalcFormula Table 17 “G/L Entry”
• Source Currency Net Change: CalcFormula Table 17 “G/L Entry”
• VAT Amt.: CalcFormula Table 17 “G/L Entry”
• Default Deferral Template Code: TableRelation Table 1700 “Deferral Template”
• Business Unit Filter: TableRelation Table 220 “Business Unit”
• Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
• Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
• 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”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
• Source Currency Code: TableRelation Table 4 “Currency”
• Default IC Partner G/L Acc. No: TableRelation Table 410 “IC G/L Account”
• Account Subcategory Descript.: CalcFormula Table 570 “G/L Account Category”
• Account Subcategory Entry No.: TableRelation Table 570 “G/L Account Category”
• Budget Filter: TableRelation Table 95 “G/L Budget Name”
• Budget at Date: CalcFormula Table 96 “G/L Budget Entry”
• Budgeted Amount: CalcFormula Table 96 “G/L Budget Entry”
• Budgeted Credit Amount: CalcFormula Table 96 “G/L Budget Entry”
• Budgeted Debit Amount: CalcFormula Table 96 “G/L Budget Entry”
• Comment: CalcFormula Table 97 “Comment Line”

Referenced by

375 fields in 176 objects relate to this table (TableRelation or CalcFormula).

• Table 5606 “FA Posting Group”: Accum. Depr. Acc. on Disposal, Accum. Depreciation Account, Acq. Cost Acc. on Disposal, Acquisition Cost Account, Acquisition Cost Bal. Acc., Apprec. Bal. Acc. on Disp., Appreciation Acc. on Disposal, Appreciation Account, Appreciation Bal. Account, Book Val. Acc. on Disp. (Gain), Book Val. Acc. on Disp. (Loss), Custom 1 Account, Custom 1 Account on Disposal, Custom 1 Bal. Acc. on Disposal, Custom 1 Expense Acc., Custom 2 Account, Custom 2 Account on Disposal, Custom 2 Bal. Acc. on Disposal, Custom 2 Expense Acc., Depreciation Expense Acc., Gains Acc. on Disposal, Losses Acc. on Disposal, Maintenance Bal. Acc., Maintenance Expense Account, Sales Acc. on Disp. (Gain), Sales Acc. on Disp. (Loss), Sales Bal. Acc., Write-Down Acc. on Disposal, Write-Down Account, Write-Down Bal. Acc. on Disp., Write-Down Expense Acc.
• Table 252 “General Posting Setup”: COGS Account, COGS Account (Interim), Direct Cost Applied Account, Direct Cost Non-Inv. App. Acc., Inventory Adjmt. Account, Invt. Accrual Acc. (Interim), Overhead Applied Account, Purch. Account, Purch. Credit Memo Account, Purch. FA Disc. Account, Purch. Inv. Disc. Account, Purch. Line Disc. Account, Purch. Pmt. Disc. Credit Acc., Purch. Pmt. Disc. Debit Acc., Purch. Pmt. Tol. Credit Acc., Purch. Pmt. Tol. Debit Acc., Purch. Prepayments Account, Purchase Variance Account, Sales Account, Sales Credit Memo Account, Sales Inv. Disc. Account, Sales Line Disc. Account, Sales Pmt. Disc. Credit Acc., Sales Pmt. Disc. Debit Acc., Sales Pmt. Tol. Credit Acc., Sales Pmt. Tol. Debit Acc., Sales Prepayments Account
• Table 208 “Job Posting Group”: G/L Costs Applied Account, G/L Expense Acc. (Contract), Item Costs Applied Account, Job Costs Adjustment Account, Job Costs Applied Account, Job Sales Adjustment Account, Job Sales Applied Account, Recognized Costs Account, Recognized Sales Account, Resource Costs Applied Account, WIP Accrued Costs Account, WIP Accrued Sales Account, WIP Costs Account, WIP Invoiced Sales Account
• Table 92 “Customer Posting Group”: Add. Fee per Line Account, Additional Fee Account, Credit Curr. Appln. Rndg. Acc., Credit Rounding Account, Debit Curr. Appln. Rndg. Acc., Debit Rounding Account, Interest Account, Invoice Rounding Account, Payment Disc. Credit Acc., Payment Disc. Debit Acc., Payment Tolerance Credit Acc., Payment Tolerance Debit Acc., Receivables Account, Service Charge Acc.
• Table 93 “Vendor Posting Group”: Credit Curr. Appln. Rndg. Acc., Credit Rounding Account, Debit Curr. Appln. Rndg. Acc., Debit Rounding Account, Invoice Rounding Account, Payables Account, Payment Disc. Credit Acc., Payment Disc. Debit Acc., Payment Tolerance Credit Acc., Payment Tolerance Debit Acc., Service Charge Acc.
• Table 4 “Currency”: Conv. LCY Rndg. Credit Acc., Conv. LCY Rndg. Debit Acc., Realized G/L Gains Account, Realized G/L Losses Account, Realized Gains Acc., Realized Losses Acc., Residual Gains Account, Residual Losses Account, Unrealized Gains Acc., Unrealized Losses Acc.
• Table 220 “Business Unit”: Comp. Exch. Rate Gains Acc., Comp. Exch. Rate Losses Acc., Equity Exch. Rate Gains Acc., Equity Exch. Rate Losses Acc., Exch. Rate Gains Acc., Exch. Rate Losses Acc., Minority Exch. Rate Gains Acc., Minority Exch. Rate Losses Acc, Residual Account
• Table 5813 “Inventory Posting Setup”: Cap. Overhead Variance Account, Capacity Variance Account, Inventory Account, Inventory Account (Interim), Mat. Non-Inv. Variance Acc., Material Variance Account, Mfg. Overhead Variance Account, Subcontracted Variance Account, WIP Account
• Table 1828 “Business Unit Information”: Comp. Exch. Rate Gains Acc., Comp. Exch. Rate Losses Acc., Equity Exch. Rate Gains Acc., Equity Exch. Rate Losses Acc., Minority Exch. Rate Gains Acc., Minority Exch. Rate Losses Acc, Residual Account
• Table 325 “VAT Posting Setup”: Non-Ded. Purchase VAT Account, Purch. VAT Unreal. Account, Purchase VAT Account, Reverse Chrg. VAT Acc., Reverse Chrg. VAT Unreal. Acc., Sales VAT Account, Sales VAT Unreal. Account
• Table 30102 “Shpfy Shop”: Cash Roundings Account, Refund Acc. non-restock Items, Refund Account, Shipping Charges Account, Sold Gift Card Account, Tip Account
• Table 320 “Tax Jurisdiction”: Reverse Charge (Purchases), Tax Account (Purchases), Tax Account (Sales), Unreal. Rev. Charge (Purch.), Unreal. Tax Acc. (Purchases), Unreal. Tax Acc. (Sales)
• Table 326 “Tax Setup”: Reverse Charge (Purchases), Tax Account (Purchases), Tax Account (Sales), Unreal. Rev. Charge (Purch.), Unreal. Tax Acc. (Purchases), Unreal. Tax Acc. (Sales)
• Table 6786 “Withholding Tax Posting Setup”: Bal. Payable Account No., Bal. Prepaid Account No., Payable Wthldg. Tax Acc. Code, Prepaid Wthldg. Tax Acc. Code, Purch. Wthldg. Tax Adj. Acc No, Sales Wthldg. Tax Adj. Acc No
• Table 1570 “G/L Entry Posting Preview”: Account Id, G/L Account Name, Account Id, Bal. Account No., G/L Account No.
• Table 17 “G/L Entry”: Account Id, G/L Account Name, Account Id, Bal. Account No., G/L Account No.
• Table 5221 “Employee Posting Group”: Credit Curr. Appln. Rndg. Acc., Credit Rounding Account, Debit Curr. Appln. Rndg. Acc., Debit Rounding Account, Payables Account
• Table 6928 “Expense Posting Group”: Credit Rounding Account, Debit Rounding Account, Non-Refundable Debit Account, Prepayment Credit Account, Refundable Debit Account
• Table 81 “Gen. Journal Line”: Account Id, Account No., Bal. Account No., Balance Account Id
• Table extension 6900 “Exp. Employee Posting Group”: Exp. Report Prepayment Account, Expense Payable Bank Paid Acc., Expense Payable Card Paid Acc., Expense Report Payable Account
• Table extension 8066 “General Posting Setup”: Cust. Sub. Contr. Def Account, Cust. Sub. Contract Account, Vend. Sub. Contr. Def. Account, Vend. Sub. Contract Account
• Table 1251 “Text-to-Account Mapping”: Bal. Source No., Credit Acc. No., Debit Acc. No.
• Table 181 “Posted Gen. Journal Line”: Account Id, Account No., Bal. Account No.
• Table 1877 “VAT Setup Posting Groups”: Purchase VAT Account, Reverse Chrg. VAT Acc., Sales VAT Account
• Table 1004 “Job WIP Entry”: G/L Account No., G/L Bal. Account No.
• Table 1005 “Job WIP G/L Entry”: G/L Account No., G/L Bal. Account No.
• Table 1014 “Job G/L Account Price”: Description, G/L Account No.
• Table 1018 “Job WIP Buffer”: Bal. G/L Account No., G/L Account No.
• Table 1661 “Import G/L Transaction”: G/L Account Name, G/L Account
• Table 1704 “Posted Deferral Header”: Account No., Deferral Account
• Table 221 “Gen. Jnl. Allocation”: Account Name, Account No.
• Table 312 “Purchases & Payables Setup”: Credit Acc. for Non-Item Lines, Debit Acc. for Non-Item Lines
• Table 368 “Dimension Selection Buffer”: Dimension Value Filter, New Dimension Value Code
• Table 37 “Sales Line”: Description, No.
• Table 376 “G/L Account (Analysis View)”: No., Totaling
• Table 39 “Purchase Line”: Description, No.
• Table 413 “IC Partner”: Payables Account, Receivables Account
• Table 4851 “Automatic Account Line”: Description, G/L Account No.
• Table 5261 “G/L Account Mapping Line”: G/L Account Name, G/L Account No.
• Table 5615 “FA Allocation”: Account Name, Account No.
• Table 5973 “Service Contract Account Group”: Non-Prepaid Contract Acc., Prepaid Contract Acc.
• Table 751 “Standard General Journal Line”: Account No., Bal. Account No.
• Table extension 4701 “VAT Report Setup Extension”: Group Settlement Account, VAT Settlement Account
• Table 1003 “Job Planning Line”: No.
• Table 110 “Sales Shipment Header”: Bal. Account No.
• Table 1103 “Cost Type”: G/L Account Range
• Table 1104 “Cost Entry”: G/L Account
• Table 111 “Sales Shipment Line”: No.
• Table 112 “Sales Invoice Header”: Bal. Account No.
• Table 113 “Sales Invoice Line”: No.
• and 126 more objects (126 fields): data/code/relations/29.json

Pages and codeunits on this table

• Page 1158 “Cash Account Balances” (source table)
• Page 154 “G/L Account Balance/Budget” (source table)
• Page 16 “Chart of Accounts” (source table)
• Page 17 “G/L Account Card” (source table)
• Page 18 “G/L Account List” (source table)
• Page 20014 “APIV1 - Accounts” (source table)
• Page 30014 “APIV2 - Accounts” (source table)
• Page 30304 “API Finance - GL Account” (source table)
• Page 414 “G/L Balance” (source table)
• Page 415 “G/L Account Balance” (source table)
• Page 422 “G/L Balance/Budget” (source table)
• Page 46866 “BC14 Balance Validation” (source table)
• Page 570 “Chart of Accounts (G/L)” (source table)
• Page 6225 “G/L Accounts Subform” (source table)
• Page 628 “IC Mapping CoA Outgoing” (source table)
• Page 634 “Chart of Accounts Overview” (source table)
• Page 791 “G/L Accounts ListPart” (source table)
• Page 792 “Uncategorized G/L Accounts” (source table)
• Page 8396 “Totaling Accounts Factbox” (source table)
• Codeunit 7 “GLBudget-Open” (codeunit runs on it)

Extended by

• Table extension 22210 “G/L Account Review Policy”
• Table extension 4852 “AutoAcc G/L Account”
• Table extension 6227 “Sust. G/L Account”
• Table extension 6786 “Withholding GL Account Ext”

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” (5 calls: OnDelete → DeleteDefaultDim, OnInsert → UpdateDefaultDim, OnRename → RenameDefaultDim, …)
• Codeunit 1100 “Cost Account Mgt” (3 calls: OnInsert → UpdateCostTypeFromGLAcc, OnModify → UpdateCostTypeFromGLAcc, OnRename → UpdateCostTypeFromGLAcc)
• Codeunit 1431 “Forward Link Mgt.” (1 call: CheckGenProdPostingGroup → GetHelpCodeForEmptyPostingSetupAccount)
• Codeunit 28 “Error Message Management” (1 call: CheckGenProdPostingGroup → LogContextFieldError)
• Codeunit 361 “MoveEntries” (1 call: OnDelete → MoveGLEntries)
• Codeunit 7018 “Price UX Management” (1 call: ShowPriceListLines → ShowPriceListLines)

Recent changes

• 2026-09-09 #11160 Ruleset hardening: promote three mechanical rules to Error (main, BC30, refactor)
• 2026-07-31 #8959 Deliverable 638799: Spend Requests in Base App (main, BC30, feature)

Countries that replace it

AT, AU, BE, CA, CH, DE, ES, FI, FR, IS, MX, NL, 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: "G/L Account"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.