Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 6 Next »

Error rendering macro 'excerpt-include' : No link could be created for 'Def - Sales Shipments'.
The purpose of this page is to record freight cost and other freight details. Additionally, users can add, edit or delete information on the shipment leg(s).

Software Version: 2020.xx.xx and newer

Page Header

Header Toolbar

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 LayoutOpens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

NotesOpens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled. 
PrintOpens the Print dialog, showing any applicable printable reports to be printed, downloaded, and/or emailed. 

Save

Save & Close

Either saves your changes and closes the page or saves your changes and leaves you on the page.

(lightbulb) The Save button is only activated when a change is detected on the page. When the Save button is active, a ‘ + ‘ character is displayed in the page border. Saving reloads the page.


Home Tab 

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

Identifies the Currency assigned to the transaction. 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.

The Currency identifies the kind of money used for transactions. For example, if a Customer or Vendor is setup with a Currency of "USD" then all transactions for them are stated in terms of US Dollars and all payments received or made must be in US Dollars.

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'.

Freight Terms are used to describe the contract terms between the shipper and receiver or product. They can be assigned to Inventory Transfer and Sales Order Shipments. These can print on transaction documents but do not drive an other functionality.

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'.

A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext.

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

Identifies the unique Shipment ID for the shipment. 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

Identifies the unique Transaction ID for each transaction. 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.

Sales transaction numbers may be system assigned IDs to differentiate unique transactions. Transaction ID's are unique by the unique combination of 'Document Prefix' + 'Next Document Number'.

Database Field: ERPx_SOOrderHeader.OrderID

Properties Tab

FieldsDescription
Carrier arrived at our facility


Database Field: ERPx_LMLoadHeader.ActualArrivalDate

Carrier arrived time at our facility


Database Field: ERPx_LMLoadHeader.ActualArrivalTime

Carrier scheduled time to arrive at our facility


Database Field: ERPx_LMLoadHeader.ScheduledArrivalTime

Carrier scheduled time to depart our facility


Database Field: ERPx_LMLoadHeader.ScheduledDepartureTime

Carrier scheduled to arrive at our facility


Database Field: ERPx_LMLoadHeader.ScheduledArrivalDate

Carrier scheduled to depart our facility


Database Field: ERPx_LMLoadHeader.ScheduledDepartureDate

Driver


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


Database Field: ERPx_MFSite.SiteName, ERPx_SOOrderHeader.SiteSK, ERPx_LMLoadHeader.SiteSk

Trailer


Database Field: ERPx_LMLoadHeader.Trailer

Truck


Database Field: ERPx_LMTruck.TruckID, ERPx_LMLoadHeader.TruckSK

Attributes Tab

FieldsDescription
Attributes

A non editable text box that shows the name of the Attribute. Attributes are user-definable fields that are used on master files and transactions and are editable from the Attributes List View. The Attribute will only be displayed if the Applies property on the Assign Attribute Rules by page is set to either "Yes - Required" or "Yes - Not Required". Attributes set to "No" will not be displayed. The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company → Setup → Attributes →..... )

Available

A non editable text box that shows whether the Attribute Value is required or not. If the Attribute Value is required it will display "Yes - Required" if it is optional it will display "Yes - Not Required". This value is only editable from the 'Assign Attribute Rules' page (Company → Setup → Attributes →.....). 

Value

Identifies the value assigned to the corresponding attribute.

Because Attributes are configurable as either Text, List, Date, or Date/Time the data entry is either a text box, lookup, or date picker. The value defaults to blank and is only required if the Attribute's 'Applies' property is set to "Yes - Required" in the Assign Attribute Rules page. Attribute Values for Master Flies are always editable. Attribute Values for transactions are always editable for unposted transactions.

Page Detail

Items Grid

Toolbar IconsDescription
Delete

 Deletes the selected line(s) from the transaction. When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This icon is only enabled for transactions with a Status of 'New'. This toolbar icon is only enabled when the transaction is in a Status of 'New'. 

Excel Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 
New

 Adds new blank row in the grid section to allow for data entry. This toolbar icon is only enabled when the transaction status is New. 

Notes
FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Address 1


Database Field: ERPx_LMLoadTransactionLeg.AddressLine1

Address 2


Database Field: ERPx_LMLoadTransactionLeg.AddressLine2

Address Name


Database Field: ERPx_LMLoadTransactionLeg.AddressName

Carrier


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

City


Database Field: ERPx_LMLoadTransactionLeg.City

Country


Database Field: ERPx_LMLoadTransactionLeg.Country

Exch. Rate - Leg to Transaction


Database Field: ERPx_LMLoadTransactionLeg.ExchangeRate

Exch. Table - Leg to Transaction


Database Fields: ERPx_MFCurrencyExchange.ExchangeID, ERPx_LMLoadTransactionLeg.ExchangeSK

External Leg ID


Database Field: ERPx_LMLoadTransactionLeg.ExternalLegID

External Load ID


Database Field: ERPx_LMLoadTransactionLeg.ExternalLoadID

Freight Rate


Database Field: ERPx_LMLoadTransactionLeg.FreightRate

Freight Rate Type


Database Field: ERPx_LMLoadTransactionLeg.FreightRateTypeEN

Freight Weight


Database Field: ERPx_LMLoadTransactionLeg.FreightWeight

Frt. Rate UOM

Order Weight UOM is used as the default 'Frt. Rate UOM' for new Legs created in the grid section.


Database Fields: ERPx_IMUOM.UOMName, ERPx_LMLoadTransactionLeg.FreightWeightUOMSK

Inverse Exch.


Database Field: ERPx_LMLoadTransactionLeg.IsInverseExchange

Leg


Database Field: ERPx_LMLoadTransactionLeg.LegSequence

Leg Currency


Database Field: ERPx_MFCurrency.CurrencyID, ERPx_LMLoadTransactionLeg.CurrencySK

Other Charges


Database Field: ERPx_LMLoadTransactionLeg.OtherCharges

Rate Type - Leg to Transaction


Database Field: ERPx_LMLoadTransactionLeg.ExchangeRateCalculationMethodEN

Source


Database Field: ERPx_LMLoadTransactionLeg.LoadTransactionSourceEN

State


Database Field: ERPx_LMLoadTransactionLeg.State

Surcharge %


Database Field: ERPx_LMLoadTransactionLeg.Surcharge

Total Frt Amt - Leg Currency


Database Field: ERPx_LMLoadTransactionLeg.TotalFreight

Total Frt Amt - Trans. Currency


Database Field: Calculated - not stored in DB

Zip


Database Field: ERPx_LMLoadTransactionLeg.Zip


Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels