Insert excerpt | Def - Sales Transactions | Def - Sales Transactions | nopanel | |||
---|---|---|---|---|---|---|
Insert excerpt | ||||||
|
This list view also contains columns for each Attribute that is set up for the 'Sales Order' attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout.Sales Order attributes are not included in the help documentation.
Software Version: 2021.02.19 and newer
...
Toolbar Icons | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Allocate | Opens the Allocate Sales Transaction Item Record View to allocate by Inventory Lot, Warehouse Lot or Item. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Column Filter Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Delete |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Favorites |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Help |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Mass Update |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
New |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Notes |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
When clicked, all the Reports assigned to the Functional Area of Sales, that launch from the Print Dialog, and that the user has rights to are displayed. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Quick Filter |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Refresh |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Saved Column Layouts |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Status | Checkbox | Opens a dialog box that allows users to mass update transactions to a specific Status. Assigns the selected Status to selected/filtered transactions when Apply is clicked. Options include:
| Def - Status - Shipped | Def - Status - Shipped | |||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Insert excerpt | Def - Status - Approved | Def - Status - Approved
|
Ready to Post Insert excerpt Def - Status -
Ready to PostShipped Def - Status - Shipped nopanel true
Insert excerpt
Def - Status - Approved Def - Status - Approved nopanel true
# of Shipments
Identifies the number of shipments associated with the transaction. This is required for the transaction to be saved in a status of 'Shipped' or greater. The number of shipments is auto generated based on a combination of Carrier, Site and Ship By Date. This field cannot be edited and is not stored in the database.
Insert excerpt Def - Status - Ready to Post Def - Status - Ready to Post nopanel true
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
# of Shipments
Identifies the number of shipments associated with the transaction. This is required for the transaction to be saved in a status of 'Shipped' or greater. The number of shipments is auto generated based on a combination of Carrier, Site and Ship By Date. This field cannot be edited and is not stored in the database.
Address ID
This is required and can be edited from the 'Address ID' field on the 'Properties' tab of the Customer Addresses Record View. This is the Address ID of the Ship To Address that was selected. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Address ID Address ID nopanel true
Insert excerpt Def - Customer Address ID Def - Customer Address ID nopanel true
Database Fields: ERPx_ARCustomerAddress.AddressID, ERPx_SOOrderHeader.AddressSK
This is required and can be edited from the 'Address Name' field on the 'Properties' tab of the Customer Addresses Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Address Name Address Name nopanel true
Database Fields: ERPx_ARCustomerAddress.AddressName, ERPx_SOOrderHeader.AddressSK
Identifies the sum of all the Line Items allocated extended amount, formatted to 2 decimal places. This is a calculated field and can only be edited by changing the unit/weight allocations or by updating the 'Price' field of a line item on the Sales Order Record View.
It is calculated as ([Allocated Quantity] * [Price]), where [Allocated Quantity] is the Allocated 'Units' when the 'Price UOM' is a Unit UOM and it is the Allocated 'Weight' when the 'Price UOM' is a Weight UOM.
Database Field: ERPx_SOOrderHeader.AllocatedAmount
Identifies the sum of all the Line Items allocated 'Units', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of allocated 'Units' on one or more line items on the Sales Order Record Viewwhen the 'Price UOM' is a Weight UOM.
Database Field: ERPx_SOOrderHeader.AllocatedUnitsAllocatedAmount
Identifies the sum of all the Line Items allocated 'WeightUnits', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of allocated 'WeightUnits' on one or more line items on the Sales Order Record View.
Database Field: ERPx ERPx_SOOrderHeader.AllocatedWeightAllocatedUnits
Identifies the sum of all the Line Items allocated 'Weight', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the
quantity of allocated 'Weight'
on one or more line items on the Sales Order Record View
.
Database Field: ERPx_SOOrderHeader.
AllocatedWeight
Insert excerpt
Amount - Original Amount - Original nopanel true
If the items on the transaction have been allocated (regardless of the transaction status), then this field displays the Allocated Amount. Else, if the items on the transaction have not been allocated, then this field displays the Ordered Amount. This is a calculated field and can be edited by
changing the
'Ord. Units', Ord. Weight' or 'Price' fields on the Sales Order Record View or unit/weight allocations. Is this true, or is it based on Status?
Database Fields: ERPx_
SOOrderHeader.
OrderedAmount, ERPx_SOOrderHeader.
AllocatedAmount
Insert excerpt
Attention To
Attention To nopanel true
This is not required and can be edited
by clicking the '
Ship To'
address hyperlink on the '
Home' tab of the Sales Order Record View.
Database
Fields: ERPx_ARCustomerAddress.AttentionTo, ERPx_SOOrderHeader.
ShipAttentionTo
This is not required and can be edited from the 'Default Carrier' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Carrier - Default Carrier - Default nopanel true Insert excerpt
Database Fields: ERPx_SOCarrier.CarrierName, ERPx_SOOrderHeader.CarrierSK
Created Insert excerpt
|
Database Field:Database Fields: ERPx_SOCarrier.CarrierName, ERPx_SOOrderHeader.CreatedDateCarrierSK
By Insert excerpt Created
ByCreated
This This field is required.nopanel true
Database Field: ERPx_SOOrderHeader.CreatedBy
Insert excerpt
Insert excerpt | |||||||
---|---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFCurrency.CurrencyID,Field: ERPx_SOOrderHeader.CurrencySKCreatedBy
Customer ID - Transaction
Insert excerpt |
---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_ARCustomerMFCurrency.CustomerIDCurrencyID, ERPx_SOOrderHeader.CustomerSKCurrencySK
Name Insert excerpt Customer
Name ID - Transaction Customer
This is required and can be edited from the 'Customer NameID' field on the 'Properties' tab of the Customer Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View.ID - Transaction nopanel true
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_ARCustomer.CustomerNameCustomerID, ERPx_SOOrderHeader.CustomerSK
CustomerSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
.
Database Field: ERPx_SOOrderHeader.LastUser
Insert excerpt
Insert excerpt |
---|
Database Field: ERPx_SOOrderHeader.ScheduledDeliveryDate
Database Field: ERPx_SOOrderHeader.LastUpdated
|
Database Fields: ERPx_ARCustomer.CustomerName, ERPx_SOOrderHeader.CustomerSK
This is required and can be edited from Insert excerpt Deliver On Date - Default Deliver On Date - Default nopanel true
the '
Hold CodeDefault Deliver On' field on the 'Home' tab of the Sales Order Record View
or via Mass Update on the Sales Transactions List View.A transaction may be placed on hold by assigning a Hold Code.
.
Database Field: ERPx_SOOrderHeader.ScheduledDeliveryDate
This field is required. Insert excerpt Last Updated Last Updated nopanel true
Database Field: ERPx_SOOrderHeader.LastUpdated
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_MFHoldCode.HoldCode
Identifies the sum of all the Line Items ordered extended amount, formatted to 2 decimal places. This is a calculated field and can only be edited by changing the unit/weight ordered quantities or by updating the 'Price' field of a line item on the Sales Order Record View.
It is calculated as ([Ordered Quantity] * [Price]), where [Ordered Quantity] is the Ordered 'Units' when the 'Price UOM' is a Unit UOM and it is the Ordered 'Weight' when the 'Price UOM' is a Weight UOM.
Database Field: ERPx_SOOrderHeader.OrderedAmount
SOOrderHeader.LastUser
This is required and can be edited from either the 'Hold Code' field on the 'Home' tab of the Sales Order Record View or via Mass Update on the Sales Transactions List View. Insert excerpt On Hold On Hold nopanel true
A transaction may be placed on hold by assigning a Hold Code. Insert excerpt Def - Hold Code Def - Hold Code nopanel true
Database Field: ERPx_MFHoldCode.HoldCode
Identifies the sum of all the Line Items Ordered 'Units'ordered extended amount, formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of Ordered 'Units' on one or more line items unit/weight ordered quantities or by updating the 'Price' field of a line item on the Sales Order Record View.
Database Field: ERPx_SOOrderHeader.OrderedUnits
Identifies the sum of all the Line Items Ordered 'Weight', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of Ordered 'Weight' on one or more line items on the Sales Order Record View.
Database Field: ERPx_SOOrderHeader.OrderedWeight
It is calculated as ([Ordered Quantity] * [Price]), where [Ordered Quantity] is the Ordered 'Units' when the 'Price UOM' is a Unit UOM and it is the Ordered 'Weight' when the 'Price UOM' is a Weight UOM.
Database Field: ERPx_SOOrderHeader.OrderedAmount
Identifies the sum of all the Line Items Ordered 'Units', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of Ordered 'Units' on one or more line items on the Sales Order Record View.
Database Field: ERPx_SOOrderHeader.
PurchaseOrderOrderedUnits
Identifies the sum of all the Line Items Ordered 'Weight', formatted to 2 decimal places. This is a calculated field and can only be edited by changing the quantity of Ordered 'Weight' on one or more line items on the Sales Order Record View.
Database Field: ERPx_SOOrderHeader.OrderedWeight
Insert excerpt |
---|
|
Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 2, ERPx_SOOrderHeader.InsideSalespersonSK
Insert excerpt | |||||||
---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 1,Field: ERPx_SOOrderHeader.SalesPersonSK
PurchaseOrder
Insert excerpt |
---|
|
|
|
|
This is not required and can be edited from the '
Salesperson - Inside Sales' field on the '
Properties' tab of the Sales Order Record View.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database
Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 2, ERPx_SOOrderHeader.
Displays the destination City, State where the order will be shipped to. This not is InsideSalespersonSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||
---|---|---|
|
|
|
|
|
Insert excerpt
Displays the Country the order will be shipped to. This is not SalesPersonSK
This is required and can be edited from the ' Insert excerpt Ship By - Default Ship By - Default nopanel true
Default Ship By' field on the '
PropertiesHome' tab of
the Customer Addressesthe Sales Order Record View. It comes from the 'Ship To' field on the
'Home' tab of the Sales Order Record View.'Home' tab of the Sales Order Record View.
Database Field: ERPx_SOOrderHeader.
ShipCountryScheduledShipDate
Displays the phone number at the address destination City, State where the order will be shipped to. This not is not required and can be edited from the 'Phone' field City' and 'State' fields on the 'Properties' tab of the Customer Addresses Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View.tab of the Sales Order Record View.
Insert excerpt Def - Address - City Def - Address - City nopanel true
Phone 1 Insert excerpt Def - Address -
Phone 1State Def - Address - State nopanel true
Database Fields: ERPx_ARCustomerAddress.City, ERPx_ARCustomerAddress.Phone1State, ERPx_SOOrderHeader.ShipCity, ERPx_SOOrderHeader.ShipPhone1ShipState
Displays the Country the order will be shipped to. This is
Database Field: ERPx_LMLoadHeader.LoadID
Identifies the status of the shipments associated with the transaction. This is required only if a shipment exists. It can be edited from the 'Load Status' field on the 'Shipments' tab of the Sales Order Record View. If the transaction contains multiple shipments, this field will display as "multiple".
This field is not in the LVnot required and can be edited from the 'Country' field on the 'Properties' tab of the Customer Addresses Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View.
Insert excerpt Def - Address - Country Def - Address - Country nopanel true
Database Fields: ERPx_ARCustomerAddress.Country, ERPx_SOOrderHeader.ShipCountry
Displays the phone number at the address where the order will be shipped to. This is not required and can be edited from the 'Phone' field on the 'Properties' tab of the Customer Addresses Record View. It comes from the 'Ship To' field on the 'Home' tab of the Sales Order Record View.
Insert excerpt Def - Address - Phone 1 Def - Address - Phone 1 nopanel true
Database Fields: ERPx_ARCustomerAddress.Phone1, ERPx_SOOrderHeader.ShipPhone1
Identifies the shipment ID(s) associated with the transaction. If more than one shipment exists, this field will list each shipment in a comma separated list. This is required for the transaction to be saved in a status of 'Shipped' and greater. The shipment ID is auto generated based on a combination of Carrier, Site and Ship By Date and cannot be edited.
Database Field: ERPx_LMLoadHeader.
LoadID
Database Fields: ERPx_LMLoadHeader.ActualShipDate, ERPx_SOOrderHeader.ActualShipDate
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFSite.SiteID, ERPx_SOOrderHeader.SiteSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_MFSite.SiteName, ERPx_SOOrderHeader.SiteSK
This is required and can be edited from the 'Status' on the 'Home' tab of the Sales Order Record View. Insert excerpt Status Status nopanel true
The Statuses that apply to transactions in this List View include: Insert excerpt Def - Status Def - Status nopanel true
Insert excerpt Def - Status - New Def - Status - New nopanel true
Insert excerpt Def - Status - Released Def - Status - Released nopanel true
Insert excerpt Def - Status - Shipped Def - Status - Shipped nopanel true
Insert excerpt Def - Status - Approved Def - Status - Approved nopanel true
Insert excerpt Def - Status - Ready to Post Def - Status - Ready to Post nopanel true
Database Fields: ERPx_SOOrderStatus.OrderStatusName, ERPx_SOOrderHeader.OrderStatusSK
Identifies if one or more of the items on the transaction is a substitute item. This is not required and can be edited by clicking the Substitution button on the Sales Order Record View and adding substitution items for the ordered item on the Sales Order Item Substitution Record View. This field is not stored in the database.
How is it identified?
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOOrderType.DocumentID
It is formatted from the users 'Date Format' preference. This is required and can be edited from the 'Order Date' field on the 'Home' tab of the Sales Order Record View. Insert excerpt Doc Date Doc Date nopanel true
Database Field: ERPx_SOOrderHeader.OrderDate
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_ARTransactionType.TransactionName
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_SOOrderHeader.OrderID
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt Def - Workflow Def - Workflow nopanel true
Database Fields: ERPx_MFWorkflow.WorkflowName, ERPx_SOOrderHeader.WorkflowSK
...