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 Line — entity reference
REFERENCE · Last reviewed

Field Sales Line — entity reference

One item line of a van-sales run, carrying the same item through every stage of the journey in separate quantity buckets rather than mutating one figure: Quantity is the dispatcher's planned load, ReceivedQuantity plus the TakeIn damaged/shortage/excess trio is what the rep confirmed onto the van, SoldQuantity is accumulated back from the run's invoice lines at day end, and the CheckIn quantities are what the dispatcher counted back into the depot. Each stage's numbers are copied onto the corresponding Transfer lines, which is what actually moves stock. Lines are commonly edited standalone in a grid rather than through the parent, so the service reloads them explicitly when a Perform flag fires.

Fields

FieldLabelTypeRequiredWhat it does
AmountAmountNumber
CheckInDamagedQuantityCheck-In Damaged QuantityDecimalDamage found when stock came back off the van, copied onto the return transfer's damaged bucket. Distinct from the take-in damage, which was found on the way out.
CheckInExcessQuantityCheck-In Excess QuantityDecimal
CheckInReceivedQuantityCheck-In Received QuantityDecimalWhat the dispatcher counted back into the depot at day end - the quantity the return transfer is built from. A line with nothing checked in produces no return leg at all.
CheckInShortageQuantityCheck-In Shortage QuantityDecimal
ConversionRatioConversion RatioNumber
ConversionRatio1Conversion Ratio 1Number
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
DamagedQuantityDamaged QuantityNumberA general damage figure separate from the stage-specific take-in and check-in damage fields; the transfers are built from those stage fields, not from this one, so nothing posted depends on it.
ExcessQuantityExcess QuantityCalculated
ExpectedReceivedQuantityExpected Received QuantityCalculated
FieldSalesIdField SalesLookupYes
IdIdGuidYes
ItemIdItemLookup
ItemLotIdItem LotLookup
ModifiedByIdModified ByLookup → UserAccountYes
NameLine NameTextYes
OwnerIdOwnerLookup → UserAccountYes
QuantityQuantityNumberThe dispatcher's planned load quantity - the figure the outward depot-to-van transfer is built from and the one the van capacity check multiplies by item weight and volume. It is not what the rep received; that is ReceivedQuantity.
ReceivedQuantityReceived QuantityNumberWhat the rep confirmed onto the van at take-in, and the quantity the inward take-in transfer is built from. When left empty the take-in falls back to the planned Quantity. The day-end rollup deliberately does not overwrite it, so it stays the rep-confirmed figure.
RecordTypeIdRecord TypeGuid, hidden
ShortageQuantityShortage QuantityCalculated
SKUIdItem SKULookup
SoldQuantitySold QuantityNumberAccumulated at day end from the invoice lines raised on the run, matched to this line by item, SKU and lot.
TakeInDamagedQuantityTake-In Damaged QuantityDecimalDamage the rep found when taking stock onto the van; it is copied straight onto the inward take-in transfer's damaged bucket, which is what actually posts it. Separate from the check-in damage recorded at day end.
TakeInExcessQuantityTake-In Excess QuantityDecimal
TakeInShortageQuantityTake-In Shortage QuantityDecimal
UIPropsUI PropsText
UOMUOMPickList
UOM1UOM1PickList
UOMQuantityUOM QuantityNumber
UOMQuantity1UOM Quantity 1Number
UpdatedDateTimeModified DateDateAndTimeYes

Actions

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