The stored total of posted journal lines for one customer or supplier under one control account (such as receivables or payables) in one fiscal period and business unit. Posting adds every line that posts to an account marked as a control account and names a party; lines on other accounts never create these rows. Rebuild Balances on the fiscal period recalculates them, and Verify Ledger compares them with the posted journals. Customer and supplier ledgers, ageing and statements are worked out from the journal lines and open items, not from these rows. Creating, editing, cloning or deleting a row from a screen, an import or the data API is refused. The record is in no app; rows are named PPB- followed by a random code.
Fields
| Field | Label | Type | Required | What it does |
|---|
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | Business unit of the posted lines this row totals. Unlike GL period balances, party rows are not split by branch, GST registration or cost centre; the record page does not show this field. |
ClosingBalance | Closing Balance | Currency | | Opening Balance plus Period Debit minus Period Credit, rounded to two decimals. Because the opening is 0, it is the period's net movement for the party (for receivables, invoiced less received in the period), not the total the party owes. |
ControlGLAccountId | ControlGL Account | Lookup → GLAccount | | The control account the party's lines were posted to, such as trade receivables or trade payables. |
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. |
GLAccountName | Name | Text, unique | Yes | Not stored. A value typed here is not saved. |
Id | Id | Guid | Yes | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
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 the party's balance brought forward. |
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. |
PartyAccountId | Party Account | Lookup → Account | | The customer or supplier whose posted movement this row totals, taken from the journal line's party. |
PeriodCredit | Period Credit | Currency | | Total of the credit amounts posted for this party, control account and business unit in the period. Verify Ledger reports a difference from the posted journals as party balance drift. |
PeriodDebit | Period Debit | Currency | | Total of the debit amounts posted for this party, control account and business unit in the period. |
RecordTypeId | Record Type | Guid, hidden | | |
UIProps | UI Props | Text | | |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
Actions
| Action | Label | Type | What it does |
|---|
Clone | Clone | ServerAction (Clone) | Create a copy of this record |
Delete | Delete | Delete | Always fails. The platform rejects direct deletion of derived subledger balances; use the rebuild-ledger-balances action on the fiscal period to resync them with the posted ledger. |
DeleteEntity | Delete | Delete | DeleteEntity |
DeleteRow | Delete | Delete | DeleteRow |
EditEntity | Edit | Edit | Always fails. The row is a projection of the ledger, and hand-editing it would break the invariant that party balances under a control account sum to that account's GL period balance. Post or reverse a journal, or rebuild the period. |
EditRow | Edit | Edit | EditRow |
New | New | New | Always fails. Subledger balances are derived from posted control-account journal lines and may only be written by the posting and rebuild services; post a journal against the control account with a party to create the row. |
