One outstanding receivable or payable amount in the subledger. Posting raises it: one per invoice, bill, credit note, debit note, refund and pay-later expense voucher (for the amount on the control line), a negative one for the unapplied part of a receipt or payment, one per expense claim, expense advance, full and final settlement, employee loan and payable interest charge, and one per employee on a payroll run. Payments, credit and debit notes, write-offs and withholding tax reduce it through settlement allocations; employee reimbursements, advance recoveries, payroll payments and loan recoveries reduce it directly. Manual journals never create, settle or reverse open transactions. The receivables and payables ageing statements, the interest run, the cash-flow forecast, the credit-limit check and Verify Ledger read it. Nothing protects the records from hand edits, so treat the list as read-only. It is in no app in the standard setup: open it from the App Launcher.
Fields
| Field | Label | Type | Required | What it does |
|---|
BranchId | Branch | Lookup → Branch | | The branch of the posting journal. |
BusinessUnitId | Business Unit | Lookup → BusinessUnit | | The finance division of the posting journal. Empty on full and final settlement and employee loan items. |
ControlGLAccountId | Control GL Account | Lookup → GLAccount | | The receivable, payable or employee control account the item sits on, taken from the posting's control line. Empty on the on-account item of an unapplied receipt or payment. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
Direction | Direction | Text | | Receivable (owed to you) or Payable (you owe). Credit documents keep the direction and carry a negative amount instead: a customer credit note is a negative Receivable item, a supplier debit note or purchase return a negative Payable item. |
DocumentDate | Document Date | Date | | The posting date of the source document. The ageing statements include the item only on as-of dates on or after it. |
DocumentNumber | Document Number | Text | | The number of the source document, copied at posting. |
DueDate | Due Date | Date | | When the amount falls due: the document's due date, or its posting date when it has none. The default ageing basis. Employee items have no due date. |
GSTRegistrationId | GST Registration | Lookup → GSTRegistration | | The GST registration. Filled only on payable interest items; other open transactions leave it empty. |
Id | Id | Guid | Yes | |
JournalId | Journal | Lookup → Journal | | The posting journal that raised the item. Reversing this journal by hand from the journal record does not reverse the item, so reverse or repost the document instead. |
Label | Label | Text | | A short description: the document number, 'On account: …' for unapplied money on a receipt or payment, or 'Employee payable …' / 'Net pay …' for staff items. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text, unique | Yes | The record number from the OT numbering series, for example OT-19102026-000001. |
OpenAmount | Open Amount | Currency | | What is still outstanding. Lowered by settlements, raised again when an application or write-off is undone, increased by tax collected at source, and set to zero on reversal. Editing it by hand posts nothing and is reported by Verify Ledger. |
OriginalAmount | Original Amount | Currency | | The amount when the item was raised; it does not change. Negative for credit notes, supplier debit notes, returns and unapplied money. Original minus Open is what has been settled. |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | Partner Account | Lookup → Account | | Your own company the item belongs to, taken from the posting journal. Ageing, reconciliation and the credit-limit check are run per company. |
PartyAccountId | Party Account | Lookup → Account | | The customer or supplier the amount is owed by or to. Empty on employee items (expense claims, expense advances, payroll net pay, full and final settlements, employee loans), which the receivables and payables ageing statements therefore leave out. |
RecordTypeId | Record Type | Guid, hidden | | |
SourceEntityName | Source Entity Name | Text | | The kind of document that raised the item, for example Invoice, Bill, CreditNote, DebitNote, Payment, ExpenseClaim, ExpenseAdvance, ExpenseVoucher, PayrollRun, FullAndFinalSettlement, LoanAdvance or InterestCharge. |
SourceRecordId | Source Record | Lookup → @sourceEntityName | | The document that raised the item; read it together with Source Entity Name. Reposting or reversing the document finds its items through this link. |
Status | Status | Text | | Open, PartiallySettled, Settled or Reversed, set by posting and settlement. Settled is not final: undoing an application moves the item back. Reversed means the document's posting was reversed or the document was un-approved or deleted. |
UIProps | UI Props | Text | | |
UpdatedDateTime | Modified Date | 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 | Delete |
DeleteInList | Delete | Delete | Delete in a list page |
Edit | Edit | Edit | Edit |
EditInLine | Edit | EditInline | EditInLine |
EditListRow | Edit | Edit | EditListRow |
New | New | New | New |
