A rebuildable aggregate of posted journal lines per GL account, fiscal period and dimension tuple — a cache, never the source of truth. Rows are maintained inside the posting unit of work as journals post and reverse, and can be re-derived wholesale from the ledger by the rebuild action on the fiscal period; a verification pass re-aggregates the ledger and reports any drift. To change a balance you post a journal; to repair one you rebuild.
Fields
| Field | Label | Type | Required | What it does |
|---|
BranchId | Branch | Lookup → Branch | | Part of the composite key the balance row is bucketed by, copied from the posted line after its own branch defaulting has run. A blank branch is a distinct bucket, not a wildcard. |
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | Part of the composite key, taken from the posted line's resolved business unit. Segment reporting reads these buckets, which is why the line-level resolution order deliberately prefers the branch's unit over the GL account's default. |
ClosingBalance | Closing Balance | Currency | | Computed as opening plus period debits minus period credits and rounded to two decimals, so it is signed debit-positive and credit-negative. Because the opening value is never carried forward, in practice this equals the period's net movement rather than a cumulative account balance. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
FiscalPeriodId | Fiscal Period | Lookup → FiscalPeriod | | |
GLAccountId | GL Account | Lookup → GLAccount | | |
GSTRegistrationId | GST Registration | Lookup → GSTRegistration | | Part of the composite key, carried from the posted line where it is normally derived from the branch. Two registrations on the same account and period therefore hold separate balance rows. |
Id | Id | Guid | Yes | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | GL Account Name | Text, unique | Yes | |
OpeningBalance | Opening Balance | Currency | | A stored field that neither posting nor the rebuild ever populates: new rows are created with zero and rebuild leaves existing values untouched. Do not read it as a carried-forward prior-period balance — an opening position should be derived from the ledger or taken from the account-ledger and statement actions, which compute their own opening figures. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | Stamped from the owning company on the journal header when the row is first created. It is NOT part of the key the posting engine matches rows on — that key is account, period, branch, business unit, registration and the reporting subtype — so this value reflects whichever journal happened to open the row and should not be relied on to scope balances by company; scope through the GL account's company instead. |
PeriodCredit | Period Credit | Currency | | The running sum of credit amounts for the same account and dimension tuple within the period. The verification pass re-aggregates the posted ledger and reports any row whose stored debit or credit total differs from the recomputed one. |
PeriodDebit | Period Debit | Currency | | The running sum of debit amounts posted to this account and dimension tuple within the fiscal period, incremented as each journal posts and rewritten wholesale by a rebuild. Reversal journals add to this figure on the opposite side rather than subtracting from it, so gross totals stay visible. |
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. |
