Finance.Accounting.TrialBalanceSummary View

Namespace: Finance.Accounting

Displays aggregated debit and credit turnovers and balances by account for a selected period. Ideal for general financial overview and period-end reconciliation. Entity: Acc_Trial_Balance_Summary (Introduced in version 25.1.3.28)

Default Visualization

Default Display Text Format:
{FromDate}: {ToDate}
Default Search Members:
__
Category: Views
Show in UI: ShownByDefault

Aggregate

An aggregate is a cluster of domain objects that can be treated as a single unit.

Aggregate Tree

Finance.Accounting.TrialBalanceSummary

Attributes

Name	Type	Description
Closing	decimal (38, 2)	Closing Balance (debit balance is positive, credit - negative). `Required`
ClosingBase	decimal (38, 2)	Closing balance in base currency (debit balance is positive, credit - negative). `Required`
ClosingCredit	decimal (38, 2)	Closing balance when it is credit. `Required`
ClosingCreditBase	decimal (38, 2)	Closing balance in base currency when it is credit. `Required`
ClosingDebit	decimal (38, 2)	Closing balance when it is debit. `Required`
ClosingDebitBase	decimal (38, 2)	Closing balance in base currency when it is debit. `Required`
ClosingReporting	decimal (38, 2)	Closing balance in reporting currency. `Required`
Credits	decimal (38, 2)	Total credits for the period. `Required`
CreditsBase	decimal (38, 2)	Total credits (Base Currency). `Required`
CreditsReporting	decimal (38, 2)	Total credits (Reporting Currency). `Required`
Debits	decimal (38, 2)	Total debits for the period. `Required`
DebitsBase	decimal (38, 2)	Total debits (Base Currency). `Required`
DebitsReporting	decimal (38, 2)	Total debits (Reporting Currency). `Required`
FromDate	date	Period Start Date - Should be filtered with exact date. `Required` `Filter(eq)`
Opening	decimal (38, 2)	Opening balance (debit balance is positive, credit - negative). `Required`
OpeningBase	decimal (38, 2)	Opening balance in base currency (debit balance is positive, credit - negative). `Required`
OpeningCredit	decimal (38, 2)	Opening balance when it is credit. `Required`
OpeningCreditBase	decimal (38, 2)	Opening balance in base currency when it is credit. `Required`
OpeningDebit	decimal (38, 2)	Opening balance when it is debit. `Required`
OpeningDebitBase	decimal (38, 2)	Opening balance in base currency when it is debit. `Required`
OpeningReporting	decimal (38, 2)	Opening Reporting. `Required`
ToDate	date	Period End Date - Should be filtered with exact date. `Required` `Filter(eq)`

References

Name	Type	Description
Account	Accounts	General Ledger Account. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Accounts_Table.Account_Id`
Currency	Currencies	Currency. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Gen_Currencies_Table.Currency_Id`
EnterpriseCompany	EnterpriseCompanies	Enterprise Company. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Gen_Enterprise_<br />Companies_Table.Enterprise_Company_Id`
EnterpriseCompanyLocation	CompanyLocations	Enterprise Company Location. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Cm_Company_Locations_Table.Company_Location_Id`
Level1AccountGroup	AccountGroups	Level 1 Account Group. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Account_Groups_Table.Account_Group_Id`
Level2AccountGroup	AccountGroups	Level 2 Account Group. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Account_Groups_Table.Account_Group_Id`
Level3AccountGroup	AccountGroups	Level 3 Account Group. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Account_Groups_Table.Account_Group_Id`
Level4AccountGroup	AccountGroups	Level 4 Account Group. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Account_Groups_Table.Account_Group_Id`
Level5AccountGroup	AccountGroups	Level 5 Account Group. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Account_Groups_Table.Account_Group_Id`
Level6AccountGroup	AccountGroups	Level 6 Account Group. `Required` `Default(New Guid)` `Filter(multi eq)` `Inherited from Acc_Account_Groups_Table.Account_Group_Id`