Table of Contents

View Acc_Trial_Balance_Summary

Entity

Entity: Finance.Accounting.TrialBalanceSummary

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)

Summary

Name Type Description
Account_Id uniqueidentifier General Ledger Account
Closing decimal(38, 2) Closing Balance (debit balance is positive, credit - negative)
Closing_Base decimal(38, 2) Closing balance in base currency (debit balance is positive, credit - negative)
Closing_Credit decimal(38, 2) Closing balance when it is credit
Closing_Credit_Base decimal(38, 2) Closing balance in base currency when it is credit
Closing_Debit decimal(38, 2) Closing balance when it is debit
Closing_Debit_Base decimal(38, 2) Closing balance in base currency when it is debit
Closing_Reporting decimal(38, 2) Closing balance in reporting currency
Credits decimal(38, 2) Total credits for the period
Credits_Base decimal(38, 2) Total credits (Base Currency)
Credits_Reporting decimal(38, 2) Total credits (Reporting Currency)
Currency_Id uniqueidentifier Currency
Debits decimal(38, 2) Total debits for the period
Debits_Base decimal(38, 2) Total debits (Base Currency)
Debits_Reporting decimal(38, 2) Total debits (Reporting Currency)
Enterprise_Company_Id uniqueidentifier Enterprise Company
Enterprise_Company_Location_Id uniqueidentifier Enterprise Company Location
From_Date date Period Start Date - Should be filtered with exact date
Level_1_Account_Group_Id uniqueidentifier Level 1 Account Group
Level_2_Account_Group_Id uniqueidentifier Level 2 Account Group
Level_3_Account_Group_Id uniqueidentifier Level 3 Account Group
Level_4_Account_Group_Id uniqueidentifier Level 4 Account Group
Level_5_Account_Group_Id uniqueidentifier Level 5 Account Group
Level_6_Account_Group_Id uniqueidentifier Level 6 Account Group
Opening decimal(38, 2) Opening balance (debit balance is positive, credit - negative)
Opening_Base decimal(38, 2) Opening balance in base currency (debit balance is positive, credit - negative)
Opening_Credit decimal(38, 2) Opening balance when it is credit
Opening_Credit_Base decimal(38, 2) Opening balance in base currency when it is credit
Opening_Debit decimal(38, 2) Opening balance when it is debit
Opening_Debit_Base decimal(38, 2) Opening balance in base currency when it is debit
Opening_Reporting decimal(38, 2) Opening Reporting
To_Date date Period End Date - Should be filtered with exact date

Columns

Account_Id

General Ledger Account

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Account_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Closing

Closing Balance (debit balance is positive, credit - negative)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Closing_Base

Closing balance in base currency (debit balance is positive, credit - negative)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Closing_Credit

Closing balance when it is credit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Closing_Credit_Base

Closing balance in base currency when it is credit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Closing_Debit

Closing balance when it is debit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Closing_Debit_Base

Closing balance in base currency when it is debit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Closing_Reporting

Closing balance in reporting currency

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Credits

Total credits for the period

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Credits_Base

Total credits (Base Currency)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Credits_Reporting

Total credits (Reporting Currency)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Currency_Id

Currency

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Currency_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Debits

Total debits for the period

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Debits_Base

Total debits (Base Currency)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Debits_Reporting

Total debits (Reporting Currency)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Enterprise_Company_Id

Enterprise Company

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Enterprise_Company_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Enterprise_Company_Location_Id

Enterprise Company Location

Property Value
Auto Complete no
Base Table.Column Cm_Company_Locations.Company_Location_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Enterprise_Company_Location_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

From_Date

Period Start Date - Should be filtered with exact date

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

From_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Level_1_Account_Group_Id

Level 1 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_1_Account_Group_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Level_2_Account_Group_Id

Level 2 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_2_Account_Group_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Level_3_Account_Group_Id

Level 3 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_3_Account_Group_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Level_4_Account_Group_Id

Level 4 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_4_Account_Group_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Level_5_Account_Group_Id

Level 5 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_5_Account_Group_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Level_6_Account_Group_Id

Level 6 Account Group

Property Value
Auto Complete no
Base Table.Column Acc_Account_Groups.Account_Group_Id
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Level_6_Account_Group_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Opening

Opening balance (debit balance is positive, credit - negative)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Opening_Base

Opening balance in base currency (debit balance is positive, credit - negative)

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Opening_Credit

Opening balance when it is credit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Opening_Credit_Base

Opening balance in base currency when it is credit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Opening_Debit

Opening balance when it is debit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Opening_Debit_Base

Opening balance in base currency when it is debit

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Opening_Reporting

Opening Reporting

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(38, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

To_Date

Period End Date - Should be filtered with exact date

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type date
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

To_Date - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no