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/Field Sales Invoice — entity reference
REFERENCE · Last reviewed

Field Sales Invoice — entity reference

The join between a FieldSales van run and an Invoice raised during it, plus the cash actually collected against that invoice. CollectedAmount is not typed by the user: the day-end unload step overwrites it with the linked invoice's adjusted amount and sums those figures into the run's CashExpected, which is the number the rep is then held to at reconciliation.

Fields

FieldLabelTypeRequiredWhat it does
AccountIdAccountLookup
CollectedAmountCollected AmountNumberCash collected against this invoice on the run. It is overwritten at day end with the invoice's adjusted amount rather than being entered, and the sum of these values becomes the run's CashExpected.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
FieldSalesIdField SalesLookup
IdIdGuidYes
InvoiceAmountInvoice AmountNumberThe invoice's face value carried onto the join row. Nothing writes it during the run - the day-end rollup only touches CollectedAmount - so it is populated by whatever created the join row.
InvoiceIdInvoiceLookup → Invoice
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYes
OwnerIdOwnerLookup → UserAccountYes
RecordTypeIdRecord TypeGuid, hidden
UIPropsUI PropsText
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
CloneCloneServerAction (Clone)Create a copy of this record