The receivables and payables subledger balance: one row per party inside a control account, per fiscal period and business unit, aggregated from posted control-account journal lines. It exists so a customer or supplier position can be read without scanning the ledger, and the verification job asserts that the sum of party balances under a control account equals that account's GL period balance. Like the GL period balance it is a derived cache — direct create, edit and delete are refused, and the only legitimate writers are journal posting and the rebuild service.
Fields
| Field | Label | Type | Required | What it does |
|---|
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | The only dimension besides the control account, party and period that splits these rows — branch, GST registration and cost centre do NOT, unlike the GL period balance. A party's position is therefore held per business unit. |
ClosingBalance | Closing Balance | Currency | | Opening plus period debits minus period credits, rounded to two decimals and signed debit-positive. Since opening is always zero in practice, on a receivables control a positive figure is the period's net amount invoiced less received, not the total outstanding. |
ControlGLAccountId | ControlGL Account | Lookup → GLAccount | | The control account the subledger row hangs under, such as receivables or payables. Only lines posting to an account flagged as a control account create these rows, and the verification job asserts that the party rows under one control account and period sum to that account's GL period balance. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
FiscalPeriodId | Fiscal Period | Lookup → FiscalPeriod | | |
GLAccountName | Name | Text, unique | Yes | |
Id | Id | Guid | Yes | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
OpeningBalance | Opening Balance | Currency | | It is not a carried-forward prior-period position, so party ageing and statements should be derived from the ledger or the open-item subledger. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | The owning company, stamped from the journal header when the row is first created. It is NOT part of the key posting matches on — that key is control account, party, business unit and fiscal period — so a row opened by one company's journal keeps that stamp regardless of later activity; do not use this field to scope or filter party balances by company. |
PartyAccountId | Party Account | Lookup → Account | | The customer or supplier whose position this row holds, taken from the posted journal line's party. This is the counterparty, not the company that owns the ledger. |
PeriodCredit | Period Credit | Currency | | Sum of credit amounts for the same party, control account, business unit and period. A mismatch against the re-aggregated ledger is reported by the verification pass as party balance drift. |
PeriodDebit | Period Debit | Currency | | Sum of debit amounts posted to this control account for this party, business unit and period. Rebuild rewrites it from the posted ledger and zeroes any stored row the ledger no longer supports. |
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. |
