Share via

Table "G/L Account"

  • Reference
ID 15
Namespace: Microsoft.Finance.GeneralLedger.Account

Properties

Name Value
Caption G/L Account
DataCaptionFields 1,2
DrillDownPageID Microsoft.Finance.GeneralLedger.Account."Chart of Accounts"
LookupPageID Microsoft.Finance.GeneralLedger.Account."G/L Account List"
DataClassification CustomerContent

Fields

Name Type Description
"No." Code[20]
Name Text[100]
"Search Name" Code[100]
"Account Type" Microsoft.Finance.GeneralLedger.Account."G/L Account Type"
"Global Dimension 1 Code" Code[20]
"Global Dimension 2 Code" Code[20]
"Account Category" Microsoft.Finance.GeneralLedger.Account."G/L Account Category"
"Income/Balance" Option
"Debit/Credit" Option
"No. 2" Code[20]
Comment Boolean
Blocked Boolean
"Direct Posting" Boolean
"Reconciliation Account" Boolean
"New Page" Boolean
"No. of Blank Lines" Integer
Indentation Integer
"Source Currency Code" Code[10]
"Source Currency Posting" Microsoft.Finance.GeneralLedger.Account."G/L Source Currency Posting"
"Source Currency Revaluation" Boolean
"Unrealized Revaluation" Boolean
"Last Modified Date Time" DateTime
"Last Date Modified" Date
"Date Filter" Date
"Global Dimension 1 Filter" Code[20]
"Global Dimension 2 Filter" Code[20]
"Balance at Date" Decimal
"Net Change" Decimal
"Budgeted Amount" Decimal
Totaling Text[250]
"Budget Filter" Code[10]
Balance Decimal
"Budget at Date" Decimal
"Consol. Translation Method" Option
"Consol. Debit Acc." Code[20]
"Consol. Credit Acc." Code[20]
"Business Unit Filter" Code[20]
"Gen. Posting Type" Microsoft.Foundation.Enums."General Posting Type"
"Gen. Bus. Posting Group" Code[20]
"Gen. Prod. Posting Group" Code[20]
Picture Blob
"Debit Amount" Decimal
"Credit Amount" Decimal
"Automatic Ext. Texts" Boolean
"Budgeted Debit Amount" Decimal
"Budgeted Credit Amount" Decimal
"Tax Area Code" Code[20]
"Tax Liable" Boolean
"Tax Group Code" Code[20]
"VAT Bus. Posting Group" Code[20]
"VAT Prod. Posting Group" Code[20]
"VAT Amt." Decimal
"Additional-Currency Net Change" Decimal
"Add.-Currency Balance at Date" Decimal
"Additional-Currency Balance" Decimal
"Exchange Rate Adjustment" Microsoft.Finance.Currency."Exch. Rate Adjustment Type"
"Add.-Currency Debit Amount" Decimal
"Add.-Currency Credit Amount" Decimal
"Default IC Partner G/L Acc. No" Code[20]
"Omit Default Descr. in Jnl." Boolean
"Source Currency Net Change" Decimal
"Source Curr. Balance at Date" Decimal
"Source Currency Balance" Decimal
"Account Subcategory Entry No." Integer
"Account Subcategory Descript." Text[80]
"VAT Reporting Date Filter" Date
"Exclude From Consolidation" Boolean
"Dimension Set ID Filter" Integer
"Cost Type No." Code[20]
"Default Deferral Template Code" Code[10]
Id Guid
"API Account Type" Microsoft.Finance.GeneralLedger.Account."G/L Account Type"
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

ShowPriceListLines

procedure ShowPriceListLines(PriceType: Enum "Price Type", AmountType: Enum "Price Amount Type")

Parameters

Name Type Description
PriceType Microsoft.Pricing.PriceList."Price Type"
AmountType Microsoft.Pricing.PriceList."Price Amount Type"

SetupNewGLAcc

procedure SetupNewGLAcc(OldGLAcc: Record "G/L Account", BelowOldGLAcc: Boolean)

Parameters

Name Type Description
OldGLAcc Record "G/L Account"
BelowOldGLAcc Boolean

CheckGLAcc

procedure CheckGLAcc()

ValidateAccountSubCategory

procedure ValidateAccountSubCategory(NewValue: Text[80])

Parameters

Name Type Description
NewValue Text[80]

LookupAccountSubCategory

procedure LookupAccountSubCategory()

GetCurrencyCode

procedure GetCurrencyCode(): Code[10]

Returns

Type Description
Code[10]

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name Type Description
FieldNumber Integer
ShortcutDimCode Code[20]

TranslationMethodConflict

procedure TranslationMethodConflict(var GLAcc: Record "G/L Account"): Boolean

Parameters

Name Type Description
GLAcc Record "G/L Account"

Returns

Type Description
Boolean

CheckGenProdPostingGroup

procedure CheckGenProdPostingGroup()

IsTotaling

procedure IsTotaling(): Boolean

Returns

Type Description
Boolean

Events

OnAfterCheckGLAcc

[IntegrationEvent(False,False)]
local procedure OnAfterCheckGLAcc(var GLAccount: Record "G/L Account")

Parameters

Name Type Description
GLAccount Record "G/L Account"

OnAfterSetupNewGLAcc

[IntegrationEvent(False,False)]
local procedure OnAfterSetupNewGLAcc(var GLAccount: Record "G/L Account")

Parameters

Name Type Description
GLAccount Record "G/L Account"

OnAfterValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnAfterValidateShortcutDimCode(var GLAccount: Record "G/L Account", var xGLAccount: Record "G/L Account", FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name Type Description
GLAccount Record "G/L Account"
xGLAccount Record "G/L Account"
FieldNumber Integer
ShortcutDimCode Code[20]

OnBeforeValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateShortcutDimCode(var GLAccount: Record "G/L Account", var xGLAccount: Record "G/L Account", FieldNumber: Integer, var ShortcutDimCode: Code[20])

Parameters

Name Type Description
GLAccount Record "G/L Account"
xGLAccount Record "G/L Account"
FieldNumber Integer
ShortcutDimCode Code[20]

OnBeforeCheckGenProdPostingGroup

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckGenProdPostingGroup(var GLAccount: Record "G/L Account", var IsHandled: Boolean)

Parameters

Name Type Description
GLAccount Record "G/L Account"
IsHandled Boolean

OnBeforeOnDelete

[IntegrationEvent(False,False)]
local procedure OnBeforeOnDelete(var GLAccount: Record "G/L Account", var IsHandled: Boolean)

Parameters

Name Type Description
GLAccount Record "G/L Account"
IsHandled Boolean

See also