xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Settlement Allocation — entity reference
REFERENCE · Last reviewed

Settlement Allocation — entity reference

One settlement of one OpenTransaction by one settling document, and the successor of PaymentAdjustment. The settling document is a Payment (PaymentId) or, for a credit note / advance / write-off document, the polymorphic SourceEntityName + SourceRecordId pair; the single OpenTransactionId FK replaces the six nullable document FKs the legacy design used. Beyond AllocatedAmount it records the non-cash components of the settlement — discount taken, TDS, write-off and rounding — and it POSTS: the allocation carries JournalId, so the ledger and the open items can never drift apart. Reversal is a status change to Reversed, which returns the amount to the open item.

Fields

FieldLabelTypeRequiredWhat it does
AllocatedAmountAllocated AmountCurrencyThe amount applied to the open item, excluding the non-cash components. Reversing the allocation adds this amount back to OpenTransaction.OpenAmount and returns that item to Open.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated OnDateAndTimeYes
DiscountTakenDiscount TakenCurrencySettlement (early-payment) discount granted as part of this allocation. It is a non-cash component: it closes part of the open item without money moving, and it posts on the allocation's journal.
IdIdGuidYes
JournalIdJournalLookup → JournalThe journal this allocation posted. Allocations post precisely so the general ledger and the open items can never disagree — the non-cash components in particular have to reach the ledger.
LabelLabelText
ModifiedByIdModified ByLookup → UserAccountYes
NameGL Account NameText, uniqueYesThe platform record name/number of the allocation.
OpenTransactionIdOpen TransactionLookup → OpenTransactionThe open item this allocation settles — the single required FK that replaced the legacy design's six nullable document FKs. Every allocation reduces exactly one open item.
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → Account
PaymentIdPaymentLookup → PaymentThe payment or receipt doing the settling, when the settling document is a Payment. When it is something else — a credit note, an advance, a write-off document — this is null and the settling document is named by SourceEntityName + SourceRecordId instead.
RecordTypeIdRecord TypeGuid, hidden
RoundingAmountRounding AmountCurrencyRounding difference absorbed by this settlement, the last of the non-cash components; it posts on the allocation's journal alongside discount, TDS and write-off.
SettlementDateSettlement DateDateThe date the settlement is effective, and the date its journal is posted on — so it decides which fiscal period the settlement (and any discount, TDS or write-off on it) lands in.
SourceEntityNameSource Entity NameTextName of the settling document's entity when it is not a Payment (credit note, advance, write-off document), paired with SourceRecordId. Document reversal finds the allocations a document made by this pair and unwinds only those.
SourceRecordIdSource RecordGuidId of the settling document row, read together with SourceEntityName. Note this is the SETTLING side; the settled side is OpenTransactionId (whose own source pair identifies the invoice or bill).
StatusStatusTextPosted or Reversed, defaulting to Posted. Reversal does not delete the row: the allocation is marked Reversed and the amount is returned to the open item, keeping the audit trail intact.
TDSAmountTDS AmountCurrencyWithholding tax deducted by the payer on this settlement. Like the discount and write-off components it closes part of the open item without cash and is posted on the allocation's journal, which is why the deduction cannot leave the subledger and the GL disagreeing.
UIPropsUI PropsText
UpdatedDateTimeUpdated OnDateAndTimeYes
WriteOffAmountWrite Off AmountCurrencyBalance written off as part of this settlement — the small residual cleared rather than chased. A non-cash component that posts on the allocation's journal.

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete the selected records.
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete in a list page
EditEditEditEdit
EditListRowEditEditEditListRow
NewNewNewNew