Insert excerpt
Software Version: 2021.xx.xx and newer
Table of Contents | ||
---|---|---|
|
Page Header
Search
...
...
...
The lookup contains a list of all Carriers.
...
The lookup contains a list of all Customers.
...
Used to select the type of date to search on. This is a single-select standard lookup that is required to return results. It defaults as "Ordered".
The lookup contains the values "Ordered", "Shipped" and "Invoiced".
...
...
- Attribute Values
- Carrier
- Customer
- Invoice
- Item Description
- Item ID
- Order #
- Purchase Order
- Site ID
- Site Name
...
The lookup contains a list of all active Sites.
...
The lookup contains a list of all Transaction Classes.
Page Details
...
Address ID
...
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Software Version: 2023.11.30 and newer
Table of Contents | ||
---|---|---|
|
Page Header
Search
Search Options | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Auto Hide Filters |
| ||||||||||||||||
Auto Refresh on Open |
| ||||||||||||||||
Carrier |
The lookup contains a list of all 'Active' Carriers. | ||||||||||||||||
Customer |
The lookup contains a list of all 'Active' Customers. | ||||||||||||||||
Date Range | Used to select the date the transaction was ordered, shipped or invoiced. It is used in conjunction with the Date Type field. This is a date range control that allows users to select a single date or a range of dates, formatted from the users 'Date Format' preference. This is required to return results and defaults with a date range of the past 30 days. | ||||||||||||||||
Date Type | Used to select the type of date to search on. It is used in conjunction with the Date Range field. This is a single-select standard lookup that is required to return results. It defaults as "Ordered". The lookup contains the values "Ordered", "Shipped" and "Invoiced". | ||||||||||||||||
Include | Used to specify the whether transactions in a status of "Void" should be included. This is a single-select standard lookup that is not required to return results. It defaults as blank. The lookup contains an option for "Voids". | ||||||||||||||||
Saved Searches |
| ||||||||||||||||
Search |
| ||||||||||||||||
Site |
The lookup contains a list of all 'Active' Sites. | ||||||||||||||||
Trans Class |
The lookup contains a list of all 'Active' Transaction Classes, with the exception of Quote type transaction classes. |
Page Details
Toolbar Icons | Description | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||
Favorites |
| ||||||||||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||||||||||
Help |
| ||||||||||||||||||||||||
| |||||||||||||||||||||||||
Quick Column Filter |
| ||||||||||||||||||||||||
Refresh |
| ||||||||||||||||||||||||
Saved Layouts |
| ||||||||||||||||||||||||
Search Options |
| ||||||||||||||||||||||||
View |
| ||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||
Checkbox |
| ||||||||||||||||||||||||
Address ID |
Database Fields: ERPx_ARCustomerAddress.AddressID, ERPh_SOOrderHeader.AddressSK | ||||||||||||||||||||||||
Address Name |
Database Fields: ERPx_ARCustomerAddress.AddressName, ERPh_SOOrderHeader.AddressSK | ||||||||||||||||||||||||
Amount | Identifies the sum of all the Line Items allocated extended amount, formatted to 2 decimal places. This is a calculated field that is not editable. 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: ERPh_SOOrderHeader.AllocatedAmount | ||||||||||||||||||||||||
Attention To |
Database Fields: ERPx_ARCustomerAddress.AttentionTo, ERPh_SOOrderHeader.ShipAttentionTo | ||||||||||||||||||||||||
Brokerage Amt. |
This field uses the Ordered Ext Amount for transactions where the Status is less than "Shipped" and Allocated Ext Amount for transactions where the Status is "Shipped" or greater. Database Field: ERPx_SPProgramSettlementItem.ComputedAmount | ||||||||||||||||||||||||
Cost Amt. |
This field uses the last applicable cost for unallocated line items and the Actual or Market Cost for allocated items. Database Field: ERPh_SOOrderHeader.ExtendedCostAmount | ||||||||||||||||||||||||
Currency |
Database Fields: ERPx_MFCurrency.CurrencyID, ERPh_SOOrderHeader.CurrencySK | ||||||||||||||||||||||||
Customer ID |
Database Fields: ERPxERPx_ARCustomerAddressARCustomer.AddressIDCustomerID, ERPh ERPh_SOOrderHeader.AddressSKCustomerSK | ||||||||||||||||||||||||
Customer Name | Address ID | nopanel | true |
Address ID |
Database Fields: ERPx_ARCustomerAddressARCustomer.AddressNameCustomerName, ERPh ERPh_SOOrderHeader.AddressSK | ||||||||||||||||||||
Amount | 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 Transaction 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 | ||||||||||||||||||||||||
Attention To | |||||||||||||||||||||||||
Insert excerpt | Attention To | Attention To | |||||||||||||||||||||||
nopanel | true | Brokerage Amt. | |||||||||||||||||||||||
Insert excerpt | Def - Brokerage Amt. | Def - Brokerage Amt. | |||||||||||||||||||||||
nopanel | true | Currency |
Currency | Currency | nopanel | true | | ||||||||||||||||||
Freight Amt. |
This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater. Database Field: ERPh_SOOrderHeader.FreightAccrualAmount | ||||||||||||||||||||||||
GL Date |
Database Field: ERPh_SOInvoiceHeader.GLDate | ||||||||||||||||||||||||
GL Period |
| ||||||||||||||||||||||||
GL Year |
| ||||||||||||||||||||||||
Gross Margin Amt. | Identifies the profit amount, using only product costs, on the transaction. This is not required and not stored in the database. This may be edited by editing any of the fields used in calculating this amount.
nopanel | true | Database Fields: ERPx_MFCurrency.CurrencyID, ERPh_SOOrderHeader.CurrencySK | Customer ID |
Customer ID - Transaction | Customer ID - Transaction
| |||||||||||||||||||
Gross Margin Pct. | Identifies the percentage of profit, using only product costs, on the transaction. This is not required and not stored in the database. This may be edited by editing any of the fields used in calculating this amount.
Database Fields: ERPx_ARCustomer.CustomerID, ERPh_SOOrderHeader.CustomerSK | ||||||||||||||||||||||||
Customer Name | Invoice |
Database Field: ERPh_SOInvoiceHeader.InvoiceNumber | |||||||||||||||||||||||
Invoiced | Identifies the date the shipment containing the item was invoiced, formatted from the users 'Date Format' preference. This comes from the 'Ship ToInvoiced' field on the 'HomeShipments' tab of the Sales Order Transaction Record View. It is not editable. Insert excerpt | | Def - Customer Name | Def - Customer Name | |||||||||||||||||||||
nopanel | true | Freight Amt. | Identifies the total freight amount for all shipments on the transaction. This field is not required. This can be edited by updating the 'Freight Rate', 'Surcharge %' or 'Other Charges' fields on the Shipment Details Record View. This is a calculated field Database Field: ERPh_SOInvoiceHeader.InvoiceDate | ||||||||||||||||||||||
Net Margin Amt. | Identifies the final profit amount on the transaction. This is not required and not stored in the database. This may be edited by editing any of the fields used in calculating this amount.
| Freight
| Freight
| GL Date | GL Period | GL Year | |||||||||||||||||||
Net Margin Pct. | Identifies the | profit amount, using only product costs, percentage of final profit on the transaction. This | field is not required and not stored in the database. This | field may be edited by editing any of the fields used in calculating this amount.
| Gross
| Amt
| Gross
| Amt
| Gross Margin Pct.|||||||||||||||||
Order # | Identifies the | percentage of profit, using only product costs, on the transaction. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount.transaction ID of the original posted transaction. It is a system assigned value and is not editable. It will display the source transaction ID on Price Adjustment and Return transactions. It will also display the source transaction ID on Sales Order transactions that were created as a result of approving a Sales Quote transaction. It is not editable.
| - Gross Margin Pct.
| - Gross Margin Pct.Invoiced | Net Margin Amt. | ||||||||||||||||||||
Insert excerpt | Def - Net Margin Amt. | Def - Net Margin Amt. | |||||||||||||||||||||||
nopanel | true | Net Margin Pct. | Identifies the percentage of final profit on the transaction. This field is not required and not stored in the database. This field may be edited by editing any of the fields used in calculating this amount.
| Invoice | Database Field: ERPh_SOOrderHeader.OriginTransID | ||||||||||||||||||||
Order Trans Class |
| Net Margin Pct.Def - Net Margin Pct.Order Trans Class |
| Order # | Database Field: ERPx_SOOrderTypeDocument.DocumentID | ||||||||||||||||||||
Ordered |
comes from the 'Order Date' field on the 'Home' tab of the Sales Transaction Record View. It is not editable. Database Field: ERPh_SOOrderHeader.OrderDate | ||||||||||||||||||||||||
Other Accrual Amt. |
| field displays the total 'Program Amt.' of all line items on the transaction that qualify for | the programone or more related non-freight Accrual programs. This | field is not required. This | field is a calculated field | and may be edited from the Sales Program Details Record Viewand may be edited from the Sales Program Details Record View. This field uses the Ordered Ext Amount for calculations on transactions where the Status is less than "Shipped" and the Allocated Ext Amount on transactions where the Status is "Shipped" or greater. Database Field: ERPx_SPProgramSettlementItem.ComputedAmount | |||||||||||||||||||
Payment Terms | |||||||||||||||||||||||||
Pct. Filled Units | Identifies the percentage of total allocated units versus total ordered units. This can be edited by changing the unit allocation or 'Ord. Units' quantity for one or more line items. This field is not stored in the database. | ||||||||||||||||||||||||
Pct. Filled Weight | Identifies the percentage of total allocated weight versus total ordered weight. This can be edited by changing the weight allocation or 'Ord. Weight' quantity for one or more line items. This field is not stored in the database.
Linked Database Field: ERPh_SOOrderHeader.PaymentTermsSK | ||||||||||||||||||||||||
Product Cost Amt. | Identifies the actual cost of all items on the transaction. This field is not required. If the item is ordered, but not allocated, this field may be edited from the 'Actual Cost' field for the Item in the Item Master File. It the item is allocated ; this field may be edited from the 'Actual Cost' assigned on the Inventory Lot.
Database Fields: ERPh_SOOrderItem. OrderItemActualCost, ERPx_IMLotCostHistory.Cost, ERPx_IMLotBalance.LotSK | ||||||||||||||||||||||||
Purchase Order |
Database Field: ERPh_SOOrderHeader.PurchaseOrder | ||||||||||||||||||||||||
Rebate Amt. |
This displays the total 'Program Amt.' of all line items on the transaction that qualify for one or more related Rebate programs. This is not required. This is a calculated field and may be edited from the 'Purchase Order' field on the 'Home' tab of the Sales Order Record View. Insert excerpt | | Def - Purchase Order | Def - Purchase Order | |||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||
Salesperson - Inside |
comes from the 'Salesperson - Inside Sales' field on the 'Properties' tab of the Sales Transaction Record View. It is not editable.
Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 2, ERPh_SOOrderHeader.InsideSalespersonSK | ||||||||||||||||||||||||
Salesperson - Outside |
comes from the 'Salesperson - Outside Sales' field on the 'Properties' tab of the Sales Transaction Record View. It is not editable.
Database Fields: ERPx_SPSalesperson.Salespersonname where SalespersonTypeEN = 1, ERPh_SOOrderHeader.SalesPersonSK | ||||||||||||||||||||||||
Ship City/State | Displays the destination City and State where the order will be shipped to. This can be edited comes from the '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 Viewthe Customer Addresses Record View when the transaction was created. Once the transaction is posted, this field is not editable.
Database Fields: ERPx_ARCustomerAddress.City, ERPx_ARCustomerAddress.State, ERPh_SOOrderHeader.ShipCity, ERPh_SOOrderHeader.ShipState | ||||||||||||||||||||||||
Ship Country | Displays the Country the order will be shipped to. This can be edited comes 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 Viewwhen the transaction was created. Once the transaction is posted, this field is not editable.
Database Fields: ERPx_ARCustomerAddress.Country, ERPh_SOOrderHeader.ShipCountry | ||||||||||||||||||||||||
Ship Phone | Displays the phone number at the address where the order will be shipped to. This can be edited comes 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 Viewwhen the transaction was created. Once the transaction is posted, this field is not editable.
Database Fields: ERPx_ARCustomerAddress.Phone1, ERPh_SOOrderHeader.ShipPhone1 | ||||||||||||||||||||||||
Status |
| is required and can be edited comes from the 'Status' on the 'Home' tab of the Sales Transaction Record View. It is not editable.
| List View Inquiry include:
| Ready to PostDef - Status - Ready to Post | |||||||||||||||||||||
nopanel | true | ||||||||||||||||||||||||
Insert excerpt |
Database Fields: ERPx_SOOrderStatus.OrderStatusName, | ERPxERPh_SOOrderHeader.OrderStatusSK | |||||||||||||||||||||||
Trans Class |
Database Field: ERPx_SOOrderTypeSOOrderTypeDocument.DocumentID | ||||||||||||||||||||||||
Trans Type |
This is a system assigned value and is not editable. The transaction types are: Invoice, Return and Price Adjustment.
Database Field: ERPx_ SOOrderType. OrderTypeName | ||||||||||||||||||||||||
Transaction |
Database Field: ERPh_SOOrderHeader.OrderID | ||||||||||||||||||||||||
Units | 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 Transaction Record Viewthat is not editable. Database Field: ERPx ERPh_SOOrderHeader.AllocatedUnits | ||||||||||||||||||||||||
Weight | 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 Transaction Record Viewthat is not editable. Database Field: ERPx ERPh_SOOrderHeader.AllocatedWeight |
Related Topics
...