Versions Compared

Key

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

Insert excerpt
Def - Sales Shipments
Def - Sales Shipments
nopaneltrue
The purpose of this page is to record freight cost and other freight details for non-logistics shipments (shipments managed in the Load Management functional area). Additionally, users can add, edit or delete information on the shipment leg(s).

Software Version: 2021.xx.xx and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Export DetailsOpens the Export Details Record View for users to document additional shipment details related to exports, including port information and container details.
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Notes

Insert excerpt
Notes - Global
Notes - Global
nopaneltrue

Insert excerpt
Def - Notes
Def - Notes
nopaneltrue

Print
Insert excerpt
Print - RV Header
Print - RV Header
nopaneltrue

Save

Save & Close

Insert excerpt
Save/Save & Close - RV Header
Save/Save & Close - RV Header
nopaneltrue

...

FieldsDescription
Addtl. Gross Wt.

Displays the any additional Gross Weight not otherwise already included in the shipment. This is a numeric text box that is not required. It defaults as "0.00" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransaction.AdditionalWeight

Currency

Insert excerpt
Currency
Currency
nopaneltrue
This is a non-editable text box that is required. It defaults from and can be updated from the 'Currency' field on the 'Properties' tab of the Customer Record View for the selected Customer.

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue

Database Field: ERPx_ARCustomer.CurrencyID

Freight Terms

Identifies the freight terms assigned to the shipment. This is a single-select standard lookup that is only required if the 'Require Freight Terms' preference for the associated transaction class is set to "Yes". It defaults from the 'Freight Terms' selected on the 'Shipments' tab of the Sales Transaction Record View. This field is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - Freight Terms
Def - Freight Terms
nopaneltrue

This lookup contains a list of all 'Active' Freight Terms.

Database Fields: ERPx_SOFreightTerms.Name, ERPx_LMLoadTransaction.SOFreightTermsEN There is a SOFreightTermsEN column in the ERPx_LMLoadHeader table. Not sure when this is ever set. Additionally, the column name suggests it is an enumeration, even though the enumeration does not exist. Affected fields: ERPx_LMLoadTransaction.SOFreightTermsEN and ERPx_LMLoadHeader.SOFreightTermsEN

Order Weight UOM

Identifies the unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for the shipment. All calculated weight fields (Product Wt., Tare Wt., Shipping Wt. and Total Wt.) in the 'Home' tab of this record view will use this unit of measure. This is a single-select standard lookup that is required. It defaults from the 'Default Shipping UOM' field on the Sales Preferences page. This field is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

This lookup contains all 'Active' Weight UOMs configured on the Units of Measure Master File.

Database Field: ERPx_LMLoadHeader.UOMSK

Product Wt.

Displays the total ordered or allocated weight for all items on the shipment. This is a non-editable text box that is not required. It is calculated by summing the weight of all items on the shipment, where weight is ordered weight if the 'Show Weight for' field is "Ordered" and allocated weight if the 'Show Weight' for field is "Allocated". This field is never editable. This field is not stored in the database.

Shipment

Insert excerpt
Shipment ID
Shipment ID
nopaneltrue
This is a non-editable text box that is required. It defaults from the associated Shipment ID, is a system assigned value and is never editable.

Database Field: ERPx_LMLoadHeader.LoadID

Shipping Wt. Displays the shipping weight for all items on the shipment. This is a non-editable text box that is not required. It is calculated using ordered weight if the 'Show Weight for' field is "Ordered" and allocated weight if the 'Show Weight' for field is "Allocated". Additionally, this field takes into account the 'Unit Tare Weight' and 'Shipping Weight' properties on the associated Item Record View. See the How is Shipment Weight Calculated? FAQ for specific calculations based on an item's properties. This field is for information only, is not editable and is not stored in the database.
Show Weight for

Identifies whether the weight fields for the shipment are based on Allocated or Ordered weight. All calculated weight fields (Product Wt., Tare Wt., Shipping Wt. and Total Wt.) in the 'Home' tab of this record view will be based on this selection. This is a single-select standard lookup that is required. It defaults as "Ordered" if the associated transaction is in a Status less than 'Shipped'. Else, this field defaults as "Allocated". This field is always editable while the associated transaction is in a Status less than 'Approved'. This field is not stored in the database.

Tare Wt.

Displays the total tare weight of all items on the shipment. This is a non-editable text box that is not required. It is calculated using ordered weight if the 'Show Weight for' field is "Ordered" and allocated weight if the 'Show Weight' for field is "Allocated". Additionally, this field takes into account the 'Unit Tare Weight' and 'Shipping Weight' properties on the associated Item Record View. See the How is Shipment Weight Calculated? FAQ for specific calculations based on an item's properties. This field is for information only, is not editable and is not stored in the database.

Total Wt.Displays the total weight of the shipment, including any additional gross weight. This is a non-editable text box that is not required. It is calculated as [Shipping Wt.] + [Addtl. Gross Wt.]. This field is for information only, is not editable and is not stored in the database.
Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
This is a non-editable text box that is required. It defaults from the associated Transaction ID, is a system assigned value and is never editable.

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

Database Field: ERPx_SOOrderHeader.OrderID

...

FieldsDescription
Carrier arrived at our facility

Identifies the actual date the carrier arrived at the facility. This is a date picker that is not required. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ActualArrivalDate

Carrier arrived time at our facility

Identifies the actual time the carrier arrived at the facility. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ActualArrivalTime

Carrier scheduled time to arrive at our facility

Identifies the time the carrier is scheduled to arrive at the facility. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ScheduledArrivalTime

Carrier scheduled time to depart our facility

Identifies the time the carrier is scheduled to leave the facility. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ScheduledDepartureTime

Carrier scheduled to arrive at our facility

Identifies the date the carrier is scheduled to arrive at the facility. This is a date picker that is not required. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ScheduledArrivalDate

Carrier scheduled to depart our facility

Identifies the date the carrier is scheduled to leave the facility. This is a date picker that is not required. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ScheduledDepartureDate

Driver

Identifies the driver assigned to the shipment. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.DriverName

Scheduled By

Displays the name of the employee who scheduled the shipment. This is a text box that is not required. If entered, it must be <= 100 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.ScheduledBy

Site

Identifies the Site ID (warehouse ID) where the shipment will ship from. This is a non-editable text box that is required. It defaults from the 'Site' field on the 'Shipments' tab of the Sales Transaction Record View. This field is for information only and never editable.

Insert excerpt
Def - Site
Def - Site
nopaneltrue

Database Field: ERPx_MFSite.SiteName, ERPx_LMLoadHeader.SiteSk

Trailer

Identifies the trailer assigned to the shipment. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadHeader.Trailer

Truck

Identifies the truck assigned to the shipment. This is a single-select standard lookup that is not required. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

This lookup contains a list of all Trucks in the Trucks Master File where the Carrier matches the Carrier on the shipment.

Database Field: ERPx_LMTruck.TruckID, ERPx_LMLoadHeader.TruckSK

...

Toolbar IconsDescription
Delete

Insert excerpt
Delete - RV Grid - No Status
Delete - RV Grid - No Status
nopaneltrue
 This toolbar icon is only enabled when the associated transaction is in a Status less than 'Approved'.

Excel
Insert excerpt
Excel - RV Header
Excel - RV Header
nopaneltrue
New

Insert excerpt
New - single row - RV Grid
New - single row - RV Grid
nopaneltrue
This toolbar icon is only enabled when the associated transaction is in a Status less than 'Approved'.

Notes

Insert excerpt
Notes - RV Grid
Notes - RV Grid
nopaneltrue

Insert excerpt
Def - Notes
Def - Notes
nopaneltrue

FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Address 1

Displays the first line of the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 75 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

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

Database Field: ERPx_LMLoadTransactionLeg.AddressLine1

Address 2

Displays the second line of the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 75 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - Address - Address Line 2
Def - Address - Address Line 2
nopaneltrue

Database Field: ERPx_LMLoadTransactionLeg.AddressLine2

Address Name

Displays the address name for the corresponding leg. This is a text box that is not required. If entered, it must be <= 150 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - Address - Address Name
Def - Address - Address Name
nopaneltrue

Database Field: ERPx_LMLoadTransactionLeg.AddressName

Carrier

Identifies the carrier associated with the corresponding leg. This is a single-select standard lookup that is sometimes required. This field is only required if the sales preference for 'Do Sales Orders Require a Carriers?' is set to "Yes". It defaults as blank. This field is always editable while the associated transaction is in a Status less than 'Approved'. If required and missing, the message "Carrier is required for all Legs" will be displayed on Save.

Insert excerpt
Def - Carrier
Def - Carrier
nopaneltrue

This lookup contains a list of all active Carriers.

Database Field: ERPx_SOCarrier.CarrierName, ERPx_LMLoadHeader.CarrierSK, ERPx_LMLoadTransactionLeg.CarrierSK

City

Displays the City associated with the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 35 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

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

Database Field: ERPx_LMLoadTransactionLeg.City

Country

Displays the Country associated with the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - Address - Country
Def - Address - Country
nopaneltrue

Database Field: ERPx_LMLoadTransactionLeg.Country

Exch. Rate - Leg to Transaction

Displays the rate used to calculate the Total Freight Amount in the transaction currency. This is a non-editable text box that is required. If the 'Leg Currency' is the same as the Currency of the associated transaction, then this defaults to "1.00000". Else if the 'Leg Currency' is the different from the Currency of the associated transaction, this defaults from the exchange table based on the 'Invoiced' date field for the associated shipment. If the transaction does not have an 'Invoiced' date, the rate is assigned based on the 'Order Date' of the associated transaction. If the exchange table does not contain a rate for the Invoiced/Order Date, then the most recent rate prior to the current date will be used. This field is for information only and cannot be edited.

Database Field: ERPx_LMLoadTransactionLeg.ExchangeRate

Exch. Table - Leg to Transaction

Displays the ID of the Exchange Table where the ‘Exch. Rate – Leg to Transaction’ was retrieved. This is a non-editable text box that is sometimes required. It is only required if the 'Leg Currency' is different from the Currency of the associated transaction. It defaults from the 'Exchange Table ID' field on the associated Exchange Table. This field is for information only and cannot be edited.

Database Fields: ERPx_MFCurrencyExchange.ExchangeID, ERPx_LMLoadTransactionLeg.ExchangeSK

External Leg ID

Identifies the Leg ID from an external source. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.ExternalLegID

External Load ID

Identifies the Load ID from an external source. This is a text box that is not required. If entered, it must be <= 50 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.ExternalLoadID

Freight Rate

Identifies the rate used to calculate the Total Freight for the shipment. This is a numeric text box that is not required. It defaults as "0.00000" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.FreightRate

Freight Rate Type

Identifies how the total freight is calculated. This is a single-select standard lookup that is required. If missing, the message "Freight Rate Type is required when other components of freight are filled in." will be displayed on Save. This defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

This lookup contains the values in the FreightRateType Enumeration Class.

Database Field: ERPx_LMLoadTransactionLeg.FreightRateTypeEN

Freight Weight

Identifies the total Freight Weight assigned to the leg. The weight is calculated from the allocated weight, if the order has been allocated and from the ordered weight, if the order has no allocations. Not true if the Load Status is new - if a shipment has allocations, this field will use ordered weight if the Load Status is New. Not sure if this is a bug or expected behavior. This is a non-editable text box that is required. It defaults from the 'Shipping Wt." field in the 'Home' tab of this Record View if the ‘Freight Rate Type’ is either the "Fixed Amt – Gross Wt." or "$/UOM -Gross Wt.". If the ‘Freight Rate Type’ is either "Fixed Amt. – Net Wt." or "$/UOM – Net Wt.", then this field defaults from the 'Total Wt.' field. This is for information only and is never editable.

Q1: Is this field dependent on Load Status or Order Status when it determines whether to use ordered weight or allocated weight? Or neither?

Q2: Using the "$/UOM - Gross Wt." or "Fixed Amt - Gross Wt." rate types does not yield a value in the field as expected. Expectation is that is uses the "Shipping Wt." field in the 'Home' tab. Additionally, using the "$/UOM - Net Wt." or "Fixed Amt - Net Wt." rate types uses the 'Shipping Wt." field, when it should use the "Total Wt." field.

Database Field: ERPx_LMLoadTransactionLeg.FreightWeight

Frt. Rate UOM

Identifies the Unit of Measure for the leg freight rate. This is a single-select standard lookup that is sometimes required. This is required when the 'Freight Rate Type' field is either "$/UOM – Gross Wt." or "$/UOM – Net Wt". If required and missing, the message "Freight Rate UOM is required when a Freight Rate Type is $/UOM." will be displayed on Save. The field defaults to the ‘Order Weight UOM’ in the 'Home' tab of this Record View. It is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

This lookup contains all 'Active' Weight UOMs configured on the Units of Measure Master File.

Database Fields: ERPx_IMUOM.UOMName, ERPx_LMLoadTransactionLeg.FreightWeightUOMSK

Inverse Exch.

This field identifies if an inverse of an exchange table was used to calculate the Total Freight Amount. This is a non-editable text box that is not required. It defaults as blank if the 'Leg Currency' is the same as the Currency of the associated transaction. Else, if the 'Leg Currency' is different from the Currency of the associated transaction, then this field will display as "No" when the 'Leg Currency' equals the 'From Currency' of the Exchange Table Record View and the transaction currency equals the 'To Currency' on the Exchange Table Record View. If the 'Leg Currency' is different from the Currency of the associated transaction, then this field will display as "Yes" when 'Leg Currency' equals the 'To Currency' of the Exchange Table Record View and the transaction currency equals the 'From Currency' on the Exchange Table Record View. This is a system assigned value, for information only and is never editable.

Database Field: ERPx_LMLoadTransactionLeg.IsInverseExchange

Leg

Identifies the sequence of the leg on the shipment. This is a non-editable text box that is required. This is a system assigned value, for information only and is never editable.

Database Field: ERPx_LMLoadTransactionLeg.LegSequence

Leg Currency

Identifies the currency for the corresponding leg. This is a single-select standard lookup that is required. If missing, the message "Currency is required for all Legs." will be displayed on Save. The field defaults from the 'Currency' field on the 'Home' tab of the Sales Transaction Record View. It is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_MFCurrency.CurrencyID, ERPx_LMLoadTransactionLeg.CurrencySK

Other Charges

Identifies an additional charge amount, in the Leg Currency, which is added to the Total Freight Amount. This is a numeric text box that is not required. It defaults as "0.00000" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.OtherCharges

Rate Type - Leg to Transaction

Identifies the calculation method (multiply or divide) used to calculate the Total Freight Amount in the transaction currency. This is a non-editable text box that is required. It defaults from the 'Calculation Method' field on the 'Properties' tab of the Currency Exchange Record View if the 'Exch. Table - Leg to Transaction' exchange table is set to calculate from the 'Leg Currency' to the transaction currency. Else, this field defaults to the inverse of the 'Calculation Method' field on the 'Properties' tab of the Currency Exchange Record View if the 'Exch. Table - Leg to Transaction' exchange table is set to calculate from the transaction currency to the 'Leg Currency'. This field is for information only and cannot be edited.

Database Field: ERPx_LMLoadTransactionLeg.ExchangeRateCalculationMethodEN

Source

Identifies where the leg originated. The source can be Manual or Integrated. This is a non-editable text box that is required. This is a system assigned value, for information only and is never editable.

Database Field: ERPx_LMLoadTransactionLeg.LoadTransactionSourceEN

State

Displays the State associated with the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 30 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

Insert excerpt
Def - Address - State
Def - Address - State
nopaneltrue

Database Field: ERPx_LMLoadTransactionLeg.State

Surcharge %

Identifies the surcharge percentage of the corresponding leg. This is a numeric text box that is not required. It defaults as "0.00000" and is always editable while the associated transaction is in a Status less than 'Approved'.

Database Field: ERPx_LMLoadTransactionLeg.Surcharge

Total Frt Amt - Leg Currency

Identifies the Total Freight Amount in the transaction currency.This is a non-editable text box that is required. This field is for information only and is never editable. It is calculated as:

  • If the ‘Freight Rate Type’ is a "$/UOM" type: [Freight Weight] * [Freight Rate] * (1+ [Surcharge%]/100) + [Other Charges]
  • If the ‘Freight Rate Type’ is a "Fixed Amt." type: [Freight Rate] * (1 + [Surcharge%]/100) + [Other Charges]

Database Field: ERPx_LMLoadTransactionLeg.TotalFreight

Total Frt Amt - Trans. Currency

Identifies the Total Freight Amount in the transaction currency. This is a non-editable field that is required. It is calculated as [Total Frt Amt – Leg Currency] [Rate Type - Leg to Transaction] [Exch. Rate – Leg to Transaction], where the [Rate Type – Leg to Transaction] determines the calculation method.  This field is for information only, is not editable and is not stored in the database.

Zip

Displays the Zip Code associated with the address for the corresponding leg. This is a text box that is not required. If entered, it must be <= 15 characters. Else, the message "String or binary data would be truncated." will be displayed on Save. It defaults as blank and is always editable while the associated transaction is in a Status less than 'Approved'.

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

Database Field: ERPx_LMLoadTransactionLeg.Zip

...