Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The purpose of this page is to

Software Version: 2020.xx.xx and newer

Table of Contents
typeflat

Page Header

...

Search Options

...

Description

...

This lookup contains the values in the IncludeInLotBalance Enumeration Class.

...

The lookup contains a list of all Items in the Items master file.

...

The lookup contains a list of all Item Classes.

...

The lookup contains a list of all Lot Owners.

...

  • Attribute Values
  • Item Description
  • Item ID
  • Lot Owner
  • Production Batch
  • Site ID
  • Site Name
  • Warehouse Lot 

...

The lookup contains a list of all active Sites.

...

Order Summary Tab

...

Fields

...

Description

...

Displays the allocated units to be added or subtracted from the Available balance for the line item. This is a non-editable text box that is not required. It defaults as the unity quantity allocation fro the item saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Weight Only". This field is never editable from this text box, but it can be updated from the 'Alloc. Units' column for the associated inventory lot on the Find Lots Record View or the 'Units' column for the associated item on the Allocate Sales Transaction Item Record View for the transaction while the status of the Transaction is less than Approved.

Database Field: ERPx_SOOrderHeader.AllocatedUnits

...

Displays the allocated weight to be added or subtracted from the Available balance for the line item. This is a non-editable text box that is not required. It defaults as the weight allocation for the item saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Units Only". This field is never editable from this text box, but it can be updated from the 'Alloc. Weight' column for the associated inventory lot on the Find Lots Record View or the 'Weight' column for the associated item on the Allocate Sales Transaction Item Record View for the transaction while the status of the Transaction is less than Approved.

Database Field: ERPx_SOOrderHeader.AllocatedWeight

...

Displays whether the item is a substitute item and the item description of the item which it was substituted for. This is a non-editable text box that is not required. It defaults a blank. This field is never editable and is not stored in the database.

...

Database Fields: ERPx_IMItem.ItemDescription, ERPx_SOOrderItem.OrderItemSK

...

The purpose of this page is to populate some basic transaction header information and to select the correct Ship-To address. Selecting the Ship-To also assigns the Customer. When this page opens, it displays all the all the active ship to address. From here, users can click on the Find Items, Find Lots, or Go to Order icons.

(lightbulb) This record view also contains columns for each Attribute that is set up for the 'Customer Addresses' attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout.Customer Addresses attributes are not included in the help documentation.

Software Version: 2022.03.18 and newer

Table of Contents
typeflat

Page Header 

Toolbar IconsDescription
Find Items

Insert excerpt
Find Items - RV Grid 3.0
Find Items - RV Grid 3.0
nopaneltrue

Find Items with Balance

Insert excerpt
Find Items with Balances - RV Grid 3.0
Find Items with Balances - RV Grid 3.0
nopaneltrue

Find Lots

Insert excerpt
Find Lots - RV Grid 3.0
Find Lots - RV Grid 3.0
nopaneltrue

Go to Order
Insert excerpt
Go to Order - RV Header 3.0
Go to Order - RV Header 3.0
nopaneltrue
FieldsDescription
Carrier

Insert excerpt
Carrier - Default
Carrier - Default
nopaneltrue
This is a single-select standard lookup that is sometimes required. This field is required when the selected transaction class 'Is Carrier Required' property is set to "Yes". If required and no Carrier defaults are assigned, the message "Carrier is required and there is no transaction class or customer address default set." will be displayed on Save. This defaults as "(Use Default)" and is always editable.

If the Carrier is not manually assigned (left as "(Use Default)"), it will be auto-assigned from a default if possible, if not the Carrier will be blank. The defaults are assigned in the following sequence:

  1. From the 'Sales Order Carrier' assigned to the Customer Address
  2. From the 'Default Carrier' assigned to the Sales Order Transaction Class
  3. No default exists and the Carrier will be blank 

Insert excerpt
Def - Carrier
Def - Carrier
nopaneltrue

This lookup contains a list of all active Carriers.

Database Field: ERPx_SOCarrier.CarrierName

Deliver On

Insert excerpt
Date - Deliver On (Default)
Date - Deliver On (Default)
nopaneltrue
 This is a date picker that is sometimes required. It is required when the selected transaction class 'Require a Deliver On Date' property is set to "Yes". It defaults as blank and is editable if the 'Single Date Management' property on the Order Transaction Class Record View is set to "No". If required and not entered, the message "Deliver On Date is required for orders in the transaction class." will be displayed on Save. If entered it must be on or after the Order Date, else the message "Deliver On Date must be on or after Order Date." will be displayed on Save.

Database Field: ERPx_SOOrderHeader.ScheduledDeliveryDate

Freight Terms

Identifies the Freight Terms that will default for all shipments on the transaction. This is a single-select standard lookup that is sometimes required. It is required when the selected transaction class 'Require Freight Terms' property is set to "Yes". If required and no Freight Term defaults are assigned, the message "Freight Terms are required and there is no transaction class or customer address default set." will be displayed on Save. This defaults as "(Use Default)" and is always editable.

If the Freight Term is not manually assigned (left as "(Use Default)"), it will be auto-assigned from a default if possible, if not the Freight Terms will be blank. The defaults are assigned in the following sequence:

  1. From the 'Freight Terms' assigned to the Customer Address
  2. From the 'Default Freight Terms' assigned to the Sales Order Transaction Class
  3. No default exists and the Freight Terms will be blank 

Insert excerpt
Def - Freight Terms
Def - Freight Terms
nopaneltrue

This lookup contains a list of all active Freight Terms.

Database Fields: ERPx_SOFreightTerms.Description

Order Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
This is a date picker that is required. It is formatted in the user's 'Date Format' preference. It defaults as the current date and is always editable. If missing, the message "Order Date is required." will be displayed on Save. The Order Date must be on or before the Ship By Date and the Deliver On Date, else the messages "Ship by Date must not be earlier than Order Date." and "Deliver On Date must be on or after Order Date." will be displayed on Save.

Database Field: ERPx_SOOrderHeader.OrderDate

Purch. Order

Insert excerpt
Purchase Order
Purchase Order
nopaneltrue
This is a text box that is not required. It defaults as blank and is always editable. If entered, this field must be <=35 characters and validation will occur to determine whether the same Purchase Order number has been used for the same customer on any non-Void sales transaction (Order, Quote, Price Adjustment or Return). If so, the message "Warning: This Purchase Order has been used on at least one non-Void sales transaction for this Customer." will be displayed when the user clicks the Find Items, Find Lots or Go to Order buttons.

Insert excerpt
Def - Purchase Order
Def - Purchase Order
nopaneltrue

Database Field: ERPx_SOOrderHeader.PurchaseOrder

Ship By

Insert excerpt
Ship By - Default
Ship By - Default
nopaneltrue
This is a date picked that is sometimes required. It is required when the selected transaction class 'Require a Ship By Date' property is set to "Yes". It defaults as blank and is editable if the 'Single Date Management' property on the Order Transaction Class Record View is set to "No". If required and not entered, the message "Ship by Date is required for orders in the transaction class." will be displayed on Save.If entered it must be on or after the Order Date, else the message "Ship by Date must not be earlier than Order Date." will be displayed on Save.

Database Field: ERPx_SOOrderHeader.ScheduledShipDate

Ship From Site

Insert excerpt
Site Name
Site Name
nopaneltrue
This is a single-select standard lookup that is required. If missing and no defaults are set, the message "Ship From Site is required and there is no transaction class or customer address default set." will be displayed on Save. This defaults as "(Use Default)" and is always editable.

If the Ship From Site is not manually assigned (left as "(Use Default)"), it will be auto-assigned from a default if possible, if not the Ship From Site will be blank. The defaults are assigned in the following sequence:

  1. From the 'Sales Order Site' assigned to the Customer Address
  2. From the 'Default Ship From Site' assigned to the Sales Order Transaction Class

Insert excerpt
Def - Site
Def - Site
nopaneltrue

This lookup contains a list of all active Sites where the 'Visible to Sales' property is set to "Yes".

Database Fields: ERPx_MFSite.SiteName, ERPx_SOOrderHeader.SiteSK

Transaction 

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
This is a text box that is required. It defaults with "(Use Next Trans. #)" and is always editable. If missing, the system will auto assign based on how the Transaction Class is configuredTransaction IDs are set as follows for each Transaction Type:

  • Quotes: From the Order's Transaction Class or from the Quote's Transaction Class. 
  • Orders: From the Transaction Class
  • Price AdjustmentsFrom the Source Order, Price Adjustment Transaction Class or the Source Invoice
  • ReturnsFrom the Return Transaction Class or the Source Invoice

When generating a Transaction ID from a Transaction Class it is made up as the 'Document Prefix' + 'Next Document Number'. If the transaction number is manually entered,  it must be unique. Else the message "The Transaction ID you are trying to add has already been used. Please check your transaction class setup to make sure the next document number available has not already been used." will be displayed on Save.

Insert excerpt
Def - Transaction ID - Sales
Def - Transaction ID - Sales
nopaneltrue

Database Field: ERPx_SOOrderHeader.OrderID

Transaction Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
This is a single-select standard lookup that is required. If missing, the message "Transaction Class is required." will be displayed on Save. It defaults from the value selected when the New button was clicked from the Sales Transactions List View or the Sales Items List View. It is always editable.

Insert excerpt
Def - Transaction Class
Def - Transaction Class
nopaneltrue

This lookup contains a list of all active Transaction Classes where the 'Transaction Type' property is set to "Order" or "Quote".

Database Field: ERPx_SOOrderType.DocumentID


Page Details

Ship To Tab

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help

Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
 

More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • IQ: Sales Item History: Opens the Sales Item History Inquiry in a new tab/window for the selected Customer displaying all Items ordered on posted sales transactions in the past 90 days.  If no Customer is selected the inquiry opens filtered to the first customer in the grid. 
  • RV: Address: Opens the Customer Address Record View for users to view Customer Address details
  • RV: Customer: Opens the Customer Record View for the selected Customer Address.
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox

Insert excerpt
Checkbox
Checkbox
nopaneltrue

Address

Displays the value in Address Line 1 of the Ship To Address. This is a non-editable text box that is not required.

 

It defaults

as the item unit quantity saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Weight Only"

from the 'Address 1' field on the 'Properties' tab of the Customer Addresses Record View. This field is

never

editable

from this text box, but it can be updated

from

'Ord. Units' column for the associated item on the Sales Order Record View while the status of the Transaction is less than Shipped.

the Customer Addresses Record View and the Customer Record View.

Insert excerpt
Def - Address - Address Line 1
Def - Address - Address Line 1
nopaneltrue
 

Database Field:

 ERPx

 ERPx_

SOOrderItem.OrderedUnitsOrd. WeightDisplays the weight ordered for the line item.

ARCustomerAddress.AddressLine1

Address ID

Insert excerpt
Address ID
Address ID
nopaneltrue
This is a non-editable text box that is

not

required. It defaults

as the item weight saved on the transaction, else it defaults to "0.00". This field also defaults to "0.00" if the item's "Manage Item By' property is set to "Units Only". This field is never editable from this text box, but it can be updated from 'Ord. Weight' column for the associated item on the Sales Order Record View while the status of the Transaction is less than Shipped.

Database Field: ERPx_SOOrderItem.OrderedWeight

Ship By

Identifies the date the shipment containing the item is scheduled to leave the Site, formatted from the users 'Date Format' preference. This is a non-editable text box that is required for the transaction to be saved in a status of 'Shipped' or greater and can be edited from the 'Ship By' field on the 'Shipments' tab of the Sales Order Record View. It defaults from the 'Default Ship By' field on the 'Home' tab of the Sales Order Record View.

Database Fields: ERPx_SOOrderItem.ScheduledShipDate, ERPx_LMLoadHeader.ScheduledShipDate

Site

Used to select one or more Sites. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Sites represent Plants, Warehouses, Distribution Centers, or virtual objects that are used to store and/or maintain inventory balances.

The lookup contains a list of all active Sites.

Database Fields: ERPx_MFSite.SiteID, ERPx_LMLoadHeader.SiteSk

Units UOM

Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK

Weight UOM

Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK

Saved Search OptionsDisplays the saved search options lookup and related icons. This tool allows users to select previously saved search options, create a new set of search options, save changes to existing search options, forget/delete saved search options and/or assign a saved search option as the default for the page. Once changes are made to the search options, the user can click the Save Options icon and save the changes. The new search option can also be set as the default.

Page Details

Database Field: ERPx_IMProductionLot.ProductionLotID

Database Field: ERPx_IMItem.ItemDescription

Database Field: ERPx_IMLotOwner.OwnerName

  This is required and can be edited from the 'Site ID' and 'Site Name' fields on the 'Properties' tab of the Site Record View. It comes from the 'Default Site' field on the 'Home' tab of the Sales Order from the 'Address ID' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Addresses Record View.

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - GlobalColumn Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0Excel - LV 3.0
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - GlobalGroup By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0Help - Global 3.0
nopaneltrue
Quick Filter
Insert excerpt
Quick FilterQuick Filter
nopaneltrue
RefreshSaved Column Layouts
Insert excerpt
Column Layouts for Framework 3.0 - GlobalColumn Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Alloc Units

Identifies the total number of allocated units for all line items, formatted to 2 decimal places. This is a calculated field and can be edited by changing the unit allocation of one or more line items.

Database Field:  This value is not stored in the database. Calculated field? 

Alloc WeightIdentifies the total allocated weight for all line items, formatted to 2 decimal places. This is a calculated field and can be edited by changing the weight allocation of one or more line items.

Database Field: This value is not stored in the database. Calculated field?  

Batch ItemOwnerSite

Insert excerpt
Site IDSite ID
nopaneltrue
Insert excerpt
SiteSite
nopaneltrue
Insert excerpt
Def - Customer Address ID
Def - Customer Address ID
nopaneltrue

Note: Address Types of "Both" and Shipping" will be included on this page; Address Types of "Inactive" and "Billing" will not be included on this page.

Database Field: ERPx_ARCustomerAddress.AddressID

Address Name

Insert excerpt
Address Name
Address Name
nopaneltrue
This is is a non-editable text box that is required. It defaults from the 'Address Name' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Addresses Record View and the Customer Record View.

Database Field: ERPx_ARCustomerAddress.AddressName

Attention To 

Insert excerpt
Attention To
Attention To
nopaneltrue
This is a non-editable text box that is not required. It defaults from the 'Ship Attention To' field on the Edit Ship To Address dialog box. This field is editable via the More Actions button on the Sales Transaction Record View.

Database Field: ERPx_ARCustomerAddress.AttentionTo

Carrier Name

Identifies the Carrier that is assigned to the Ship To Address ID. This is a non-editable text box that is not required. It defaults from the 'Sales Order Carrier' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Record View or the Customer Addresses Record View.

Insert excerpt
Def - Carrier
Def - Carrier
nopaneltrue

Database Fields: ERPx_SOCarrier.CarrierName, ERPx_ARCustomerAddress.CarrierSK

City

Displays the destination City where the order will be shipped. This is a non-editable text box that is not required. It defaults from the 'City' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Addresses Record View and the Customer Record View.

Insert excerpt
Def - Address - City
Def - Address - City
nopaneltrue
 

Database Field: ERPx_ARCustomerAddress.City

Customer ID

Insert excerpt
Customer ID
Customer ID
nopaneltrue
This is a non-editable text box that is required. It defaults from the 'Customer ID' field on the 'Properties' tab of the Customer Record View. This field is editable from the Customer Record View.

Insert excerpt
Def - Customer ID
Def - Customer ID
nopaneltrue

Database Fields: ERPx_ARCustomer.CustomerID, ERPx_ARCustomerAddress.CustomerSK

Customer Name

Insert excerpt
Customer Name
Customer Name
nopaneltrue
This is a non-editable text box that is required. It defaults from the 'Customer Name' field on the 'Properties' tab of the Customer Record View. This field is editable from the Customer Record View.

Insert excerpt
Def - Customer Name
Def - Customer Name
nopaneltrue

Database Fields: ERPx_ARCustomer.CustomerName, ERPx_ARCustomerAddress.CustomerSK

Freight Terms

Identifies the Freight Terms that is assigned to the Ship To Address ID. This is a non-editable text box that is not required. It defaults from the 'Freight Terms' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Record View or the Customer Addresses Record View.

Insert excerpt
Def - Freight Terms
Def - Freight Terms
nopaneltrue

Database Fields: ERPx_SOFreightTerms.Description, ERPx_ARCustomerAddress.SOFreightTermsEN

Site Name

Identifies the name of the Site (Warehouse) that is assigned to the Ship To Address ID. This is a non-editable text box that is not required. It defaults from the 'Sales Order Site' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Record View or the Customer Addresses Record View.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Fields: ERPx_MFSite.SiteName, ERPx_ARCustomerAddress.SiteSK

State

Displays the destination State where the order will be shipped. This is a non-editable text box that is not required. It defaults from the 'State' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Addresses Record View and the Customer Record View.

Insert excerpt
Def -
Site
Address - State
Def - Address -
Site
State
nopaneltrue
Database Fields: ERPx_MFSite.SiteID, ERPx_MFSite.SiteName, ERPx_SOOrderHeader.SiteSK

Units

Database Field:

 This is a calculated field and not stored in the database.Units UOM

Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.UnitUOMSK 

Weight

Database Field: This is a calculated field and not stored in the database.

Weight UOM

Database Fields: ERPx_IMUOM.UOMName, ERPx_SOOrderItem.WeightUOMSK

WLot

 ERPx_ARCustomerAddress.State

Zip

Displays the destination Zip Code where the order will be shipped. This is a non-editable text box that is not required. It defaults from the 'Zip' field on the 'Properties' tab of the Customer Addresses Record View. This field is editable from the Customer Addresses Record View and the Customer Record View.

Insert excerpt
Def - Address - Zip
Def - Address - Zip
nopaneltrue
 

Database Field: ERPx ERPx_IMWarehouseLotARCustomerAddress.WarehouseLotIDZip

Related Topics

User Guide: Sales Order



Expand
titlePage Definitions

Page Definitions



Expand
titleTechnical Details

Technical Details