Sales Order Fields

The Sales Order object includes the following fields.

Key: * – Mandatory field, A - Automatically populated when you calculate tax using Avalara AvaTax.

Sales Order Fields
Field Name		Description
Applied Discount		Discount applied to the sales order.
Applied Rebate Amount		Total amount of rebate applied from the sales order lines.
Approval Date		Date and time when the sales order was approved.
Avalara Location Code		Code of the location in Avalara AvaTax that represents the physical location where the sales order is sold from. This is used for location-based filing in Avalara.
Billed Status		Indicates the billing status of the sales order.
Confirm To		The customer representative that placed the order.
Customer Site Sold To		The name of the active customer account.
Default Bill To		The default address for billing.
Default Ship To		The default address for shipping.
Drop Ship		If selected, indicates a shipping address is defined in the drop ship address fields on the sales order. This field is only available when the sales order is of type drop ship.
Drop Ship Address Validated		If selected, indicates the drop ship address of the sales order has been validated by Avalara AvaTax. This field is automatically selected when you validate the address using the Validate Drop Ship Address Lightning action. Automatically deselected when you change any of the following fields: Drop Ship City Drop Ship Country Drop Ship Line 1 Drop Ship Line 2 Drop Ship State / Province Drop Ship Zip / Postal Code
Drop Ship City		Drop ship address information, only used if the Drop Ship field is selected.
Drop Ship Country
Drop Ship Line 1
Drop Ship Line 2
Drop Ship Name
Drop Ship State / Province
Drop Ship Zip / Postal Code
Editable Sales Order Line Item Name		For system use. Used to enable the Foundations Transform service to edit the record.
Engagement		The Engagement Represents a single customer engagement that can include diverse revenue streams. It links together related products for a customer within a given time frame, such as professional services, subscriptions, and goods. that relates to the sales order. If you use the OIM to BC integration for Consolidated Invoicing to create billing documents from invoices and credit invoices, the sales order's engagement is automatically copied to the billing documents. When the sales order related to a billing event has an engagement defined, the Engagement value is copied from the sales order to the Engagement lookup on the resulting billing documents. For more information, see Engagements.
Existing Sales Order Number	*	This field is required during the loading of legacy sales orders.
External Tax Status	A	The status of the tax calculation when using an external system to calculate tax for the sales order. The following statuses are available: "Not Calculated" "Calculated" If you make any of the following changes after calculating tax, the value automatically changes from "Calculated" to "Not Calculated": Add a new line to the sales order. Change a field related to tax on the sales order. These fields include: Drop ship address fields Override Ship to Address Customer Site Sold To Change a field related to tax on an existing sales order line item. These fields include: Delivery Method Item Master Override Avalara Tax Code Price Quantity
Override Bill to Address		The alternative billing address that relates to the sales order. By default, the bill to address is set from the customer account related to the sales order.
Override Billing Account		The override billing account that relates to the sales order. This is the account to be billed when the customer account is not to be billed for the sales order.
Override Billing Account Address		The override billing account address that relates to the sales order. This is the customer address associated with the override billing account to be used as the billing address instead of the default.
Override Ship to Address		The alternative shipping address that relates to the sales order. By default, the ship to address is set from the customer account related to the sales order.
Ownership		The ownership that relates to the sales order. This field refers to the customer or supplier that owns the inventory items on the sales order.
Partial Invoicing		The selected process by which invoices are generated for each shipment. Setting partial invoicing on the sales order to 'Yes' allows separate invoices to be created for each shipment of tangible items and for each billing of intangible items. Setting partial invoicing on the sales order header to 'No' ensures the sales invoice remains open after the tangible items are shipped. The sales invoice can then be reviewed and the intangible items can be billed, which adds the intangible line items to the original sales invoice.
Sales Order Number		Auto number with a format of SO-{0000000}.
Total Customer Rebate Discount		Total customer rebate amount rolled-up from the sales order lines. This is the total amount of rebate to be deducted from the price the customer pays.
Total Open Value		Total value of items that are yet to be shipped. Note: When a sales order line for an intangible item is complete, the value for that line is deducted from the open value field on the sales order. In addition, the shipped quantity is updated to reflect the completed line.
Total Tax	A	Total amount of tax on the sales order.
Total Value After Rebate		Total value of the sales order after rebates.
Warehouse		The warehouse that relates to the sales order. This field indicates the warehouse designated for item allocation within the sales order. When you click Allocate on the sales order, items are automatically allocated from the warehouse.

Sales Order Line Item Fields

The Sales Order Line Item object includes the following fields.

Key: * – Mandatory field, A - Automatically populated when you calculate tax using Avalara AvaTax.

Sales Order Line Item Fields
Field Name		Description
Allocate Message		Shows details of missing items required to completely fulfill the allocation of a virtual kit. The details are available in this field when the sales order line is allocated.
Already Returned		The current quantity already returned by the customer.
Applied Rebate Amount		The total amount of rebate applied to the sales order line item.
Avalara Tax Code	A	If tax calculation using Avalara AvaTax is enabled in your org, this is the tax code used to calculate tax for the line. The code is automatically populated using the predefined mappings, according to the item being sold and the delivery method. For more information, see AvaTax Code to Product Group Mappings.
Commitment Date		The date on which the items included in the sales order line item are confirmed to be delivered to the customer. This field is mandatory for sales order line items of types Accounting, Drop-Ship, Item, or Service.
Condition		The condition code that relates to the item in the sales order line item.
Core Item Number		The number from the core item in the sales order line item to be returned by the customer. This field is mandatory for sales order line items of type Exchange.
Core Return Date		The date on which the core item in the sales order line item is expected to be returned by the customer. This field is mandatory for sales order line items of type Exchange.
Core Return Warehouse		The return warehouse that relates to the core item in the sales order line item. This is the warehouse where the customer must return the core item. This field is mandatory for sales order line items of type Exchange.
Core Valuation		The value of the core item in the sales order line item. The customer must be invoiced this amount if the core item is not received. This field is mandatory for sales order line items of type Exchange.
Customer Rebate Discount		The amount of rebate to be deducted from the total customer price.
Ext. Used in Order and Inventory Management as an abbreviation of the word extended. In Order and Inventory Management, the term extended is used to represent an amount that represents the quantity of the items on a line such as a customer quotation line. Price After Rebate Discount		The price the customer is to pay after the customer rebate amount has been deducted.
Item Master	*	The item master that relates to the sales order line item.
Open Value		The sum of the amounts of the units that are pending to be shipped for the sales order line item. This amount is calculated considering the price with options and the rebate discount.
Override Avalara Tax Code		The Avalara tax code used for the line. When defined, the value is used to calculate tax for the line in AvaTax. When this is not defined, the tax code is determined from AvaTax code to product group mappings. This is stored in the Avalara Tax Code field. For more information, see AvaTax Code to Product Group Mappings.
Override Avalara Tax Code		The tax code that is used to override the original Avalara mapped tax code.
Price	*	The selling price per unit of measure included in the sales order line item.
Quantity	*	The total number of units to include in the sales order line item.
Quantity Allocated		The number of units allocated to the sales order line item. This field is automatically set by a background process.
Quantity Backordered		The number of units that are backordered for the sales order line item. This field is automatically populated by a background process.
Quantity Billed		The number of units that have already been billed for this sales order line item. Normally this is a whole number but when billing against a fixed amount in sections this can be a decimal number.
Quantity Packed		The quantity of serial numbers that have been packed per item with inbound/outbound serial number control in the sales order line item. This field is automatically populated by a background process.
Quantity Shipped		The number of units that have already been shipped for the sales order line item. This field is automatically populated by a background process.
Remaining Quantity to Bill		The number of units that have not been billed for the sales order line item yet. This field is automatically populated by a background process.
Selected Option Count		The number of selected options in the sales order line item. This field is populated if the related item was configured.
Status		The status of the sales order line. Note: When a sales order line for an intangible item is complete, the value for that line is deducted from the open value field on the sales order. In addition, the shipped quantity is updated to reflect the completed line.
Tax	A	The total tax value for the line item.
Tax Name 1-3	A	The name of the tax used when calculating tax for the sales order line item. You can use up to three fields to represent the state, county, and city tax authorities.
Tax Rate	A	The total tax rate to use when calculating tax for the sales order line item.
Tax Rate 1-3	A	The tax rate to use when calculating tax for the sales order line item. This enables you to view a breakdown of the tax rates applied per jurisdiction.
Tax Value 1-3	A	The tax value calculated from the corresponding tax rate. This enables you to view a breakdown of the calculated tax values per jurisdiction.
Total Cost		The total cost of the sales order line item. This is the sum of the values in the External Cost field of all picklist details associated with the sales order line item.

Option Item

The Option Items related list on a sales order line shows the options that have been configured on the line.

If a sales order line item includes options, those options are included in the Ext. Closed Used in Order and Inventory Management as an abbreviation of the word extended. In Order and Inventory Management, the term extended is used to represent an amount that represents the quantity of the items on a line such as a customer quotation line. price, but the quantity field does not reflect the number of options. For instance, if the quantity on the sales order line item is one, the price is $299 and the line includes two options at $42 and $67, the ext. price is $408.

Buttons

Key: L - Only available in Lightning Experience

Sales Order Buttons
Button Name		Description
Calculate Tax	L	Calculates tax for the sales order using the external tax calculation service. For more information, see Calculating Tax for a Sales Order Using Avalara AvaTax.
Create and Edit PO		Enables you to create and manage purchase orders for a sales order.
Create and Edit Purchase Orders	L
Create Production Orders		Creates production orders for sales order lines that are configurable manufactured kits. Note: You can only create production orders from a sales order for items that are configurable manufactured kits. For non configurable manufactured kits, use the standard production order process.
Review Invoice		Enables you to add drop ship lines or lines for intangible items (such as accounting lines) to an existing invoice. It also enables you to create a completely new invoice record if the sales order contains only drop ship lines or lines for intangible items and no invoice record is automatically generated when the sales order is approved.
Validate Drop Ship Address	L	Validates the drop ship address of the sales order in Avalara AvaTax. For more information, see Validating the Drop Ship Address of a Sales Order.

Extension Packages That Add Fields to the Sales Order Object

Several Certinia extension packages add fields and buttons to the Sales Order and Sales Order Line Item objects. For more information, follow the relevant links.