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/Account Stock — entity reference
REFERENCE · Last reviewed

Account Stock — entity reference

A stock observation recorded at a customer or partner account during a field visit, carrying the visit, visit plan, visit task and visit task activity keys that produced it.

Fields

FieldLabelTypeRequiredWhat it does
AccountIdAccountLookupThe customer or outlet whose shelf was counted, as distinct from the partner account, which is the company that owns the record.
AvailableQuantityQuantityNumberAn integer quantity, unlike the decimal quantities used everywhere else in inventory. The merchandising audit deliberately leaves it alone, because a shelf facing count is not the outlet's on-hand stock and conflating the two would corrupt stock reporting.
BranchIdBranchLookup
ConversionRatio1Conversion Ratio 1Number
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
IdIdGuidYes
ItemIdItemLookup
ItemLotTypeIdItem Lot TypeLookup
ItemSKUSKULookupThe SKU reference for the counted product. Note the unusual name: every other entity in the module calls this SKUId, so queries and mappings written by analogy will miss it.
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYes
OwnerIdOwnerLookup → UserAccountYes
PartnerAccountIdPartner AccountLookup → Account
RecordTypeIdRecord TypeGuid, hidden
ResourceIdResourceLookupThe field resource who performed the count, carried over from the visit so audit findings can be attributed to a rep.
UIPropsUI PropsText
UOMUOMPickListThe primary unit the counted quantity is expressed in. Not populated by the merchandising audit path, which records raw facing counts.
UOM1UOM1PickList
UOMQuantityUOM QuantityNumber
UOMQuantity1UOM Quantity1NumberCarries the counted facing quantity written by the merchandising audit - this, not the available quantity, is the number a planogram audit records. A zero is a genuine finding (the product had no facings), not a blank.
UpdatedDateTimeModified DateDateAndTimeYes
VisitIdVisitLookup
VisitPlanIdVisit PlanLookup
VisitTaskActivityVisit Task ActivityLookupThe specific activity within the visit task that produced this row, and the idempotency key for the audit: re-submitting the same activity reconciles its existing rows by product rather than appending a second set of counts. Note the name has no Id suffix, unlike the sibling visit references.
VisitTaskIdVisit TaskLookup

Actions

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