The stored total of posted journal lines for one GL account in one fiscal period, kept separately for each combination of branch, business unit, GST registration, cost centre and reporting subtype. It is a derived figure, not the ledger itself: posting a journal adds its lines to the matching rows (creating a row the first time a combination appears), and Rebuild Balances on the fiscal period recalculates the period's rows from its posted and reversed journals. Period-aligned financial statements add these rows up instead of re-reading every journal line, and dates that cut through a period are read from the journal lines directly. Creating, editing, cloning or deleting a row from a screen, an import or the data API is refused; to change a balance, post a journal, and to repair drift, run Verify Ledger and then Rebuild Balances on the period. The record is in no app; rows are named GLB- followed by a random code.
Fields
| Field | Label | Type | Required | What it does |
|---|
BranchId | Branch | Lookup → Branch | | Branch of the posted lines this row totals. A blank branch is its own row, not a wildcard; the record page does not show this field. |
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | Business unit of the posted lines this row totals, as resolved on each line at posting. Statements broken out or filtered by business unit read this value; the record page does not show it. |
ClosingBalance | Closing Balance | Currency | | Opening Balance plus Period Debit minus Period Credit, rounded to two decimals: positive for a net debit, negative for a net credit. Because the opening is 0, it shows the period's net movement, not the account's cumulative balance. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
FiscalPeriodId | Fiscal Period | Lookup → FiscalPeriod | | The fiscal period the totals belong to: the period of the journal, which the journal date decides when the journal is posted. |
GLAccountId | GL Account | Lookup → GLAccount | | The GL account whose posted movement this row totals. |
GSTRegistrationId | GST Registration | Lookup → GSTRegistration | | GST registration of the posted lines this row totals. Two registrations on the same account and period are kept in separate rows. |
Id | Id | Guid | Yes | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | GL Account Name | Text, unique | Yes | System name GLB- followed by a random code, set when the row is created. Despite the label it is not the account name; the account is in GL Account. |
OpeningBalance | Opening Balance | Currency | | Always 0 for rows created by posting or by Rebuild Balances, and Rebuild Balances keeps whatever is stored. It is not a balance brought forward; statements work out the opening position by adding up the earlier periods. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The company of the journal that first created the row. It is not one of the values that decide which row a line is added to. Rows recreated by Rebuild Balances leave it blank. |
PeriodCredit | Period Credit | Currency | | Total of the credit amounts posted to this row in the period. Verify Ledger compares this figure and Period Debit with the posted journals and reports any difference as drift. |
PeriodDebit | Period Debit | Currency | | Total of the debit amounts posted to this row in the period. A reversal adds the original credits here rather than reducing the original debits, so both sides keep their gross totals. |
RecordTypeId | Record Type | Guid, hidden | | |
UIProps | UI Props | Text | | |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
BulkDelete | Delete | Delete | Delete the selected records. |
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
Delete | Delete | Delete | Always fails. Removing a derived balance row does not remove the underlying ledger movement, so the platform refuses it outright; the rebuild-ledger-balances action on the fiscal period is the supported way to bring rows back in line with the posted ledger. |
DeleteInList | Delete | Delete | Delete in a list page |
Edit | Edit | Edit | Always fails. Correct a balance by posting or reversing a journal, or resync the whole period with the rebuild-ledger-balances action on the fiscal period. |
EditListRow | Edit | Edit | EditListRow |
New | New | New | Always fails. These rows are a derived projection of the posted ledger and the platform rejects any create through the data API — the only legitimate writers are journal posting and the rebuild service. To bring a balance into existence, post a journal that touches the account and period. |
