Versions Compared

Key

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

Table of Contents

Overview

...

  • Extended Price: Displays the product of the line item’s price per unit of measure and number of units ordered. This field auto-populates upon entering the units and price.
  • Item: Description: Displays the item ID and the description of the line item corresponding to the item number.
  • Price: Displays a text box field for the user to enter the price per unit of measure for the line item. If the item is on one of the customer’s assigned price lists the price will default but can be overwritten if price variances are allowed, per the Sales Order preferences. Once the price is entered, select the price unit of measure from the drop-down menu, which will default from the price list if the line item is assigned to a price list. In other case the price UOM defaults from the customer/address favorites configuration.configuration.  Note: The Price UOM is required to save a line item. 
  • Units: Displays a text box field for the user to enter the number of units ordered. A drop-down menu is also displayed for the user to select the units unit of measure (this field is required), which will default from the price list if the line item is assigned to a price list.
  • Weight: Displays a text box field for the user to enter the amount of weight ordered and a drop-down menu for the user to select the weight unit of measure (this field is required), both of which will default after units have been entered if the information is known.  

Once the item information for the order has been entered, click the Save and Refresh toolbar icon. This will assign the transaction ID displaying the ID in the Transaction field. The ID is assigned based on the Transation Transaction Class properties, but users can also manually assign a transaction ID. The ID must be entered before the Save & Refress Refresh toolbar is clicked. To navigate to the transaction record view, click Go to Order toolbar icon. This will open the Order record view with all known information defaulted.

...

  • Currency: The currency field displays the currency the order is invoiced in. The value is pulled from the customer record and the field is for informational use only and cannot be edited. The order is created in this currency, but the Journal Entry created for the transaction is created in the company currency. The Exchange Rate table (System > Currency Exchanges) determines the conversion rate. 
  • Default Carrier: Displays a drop-down menu of all active carriers for the user to select the shipment method for the order. If the address being shipped to has a carrier assigned to it, this field will default to select the assigned carrier. Or, if there is no carrier assigned to the address but there is a carrier selected for the “Default Carrier” Sales preference, this field will default to select the preference carrier. If the selected Carrier is visible to Logistics, the shipments on the transaction will be managed in the Logistics module. Whether or not the Carrier is required is determined by the ‘Are Carriers required for Orders and Returns?' Sales Order preference.
  • Default Deliver On: Displays a text box field for the user to enter the date on which the order needs to be delivered. This field defaults to the date selected for the Deliver On field on the Select Ship-To window. Updating the field will update the Deliver On date in the Shipments tab when the transaction has a single shipment. 
  • Default Ship By: Displays a text box field for the user to enter the date by which the order must be shipped. This field defaults to the date selected for the Ship by field on the Select Ship-To window.
  • Default Site: Displays a drop-down menu of all the sites assigned to the workflow group for the address. These sites are determined in the Workflow setup in the System module.
  • Purchase Order: Displays a text box field for the user to enter the purchase order associated with the order. If the Purch. Order field on the Select Ship-To window was completed, the PO field will auto-populate to reflect the same entry.Hold Code: Displays a drop-down menu of all the Hold Codes configured in Hold Codes Master Listwill auto-populate to reflect the same entry.
  • Hold Code: Displays a drop-down menu of all the Hold Codes configured in Hold Codes Master File.  If a Hold Code is applied to the transaction, the Status and Workflow fields and the Print toolbar icon will be disabled/enabled dependent on what property is set for each Control in the Hold Code Master File. For more information on the Hold Code Master File properties, click here.
  • Ship to: Displays a drop-down menu of the available shipping addresses for the customer by ID. The address of the selected address ID is populated as read-only beneath the selection. This field’s title displays a hyperlink that, when clicked, opens the Edit ship-to address window, which allows the user to edit the “Ship Attention To” name, the address, and the phone number without affecting the address or customer record.
  • Status: Displays a drop-down menu of the status options for the order. This field defaults to ‘New’ but all available statuses are determined in Status Setup.
  • Workflow: Displays a drop-down menu of the workflow options for the order. These workflow options are determined in the Workflow setup in the System module.

...

If the preference is set to Place on Credit Hold, a message prompt is displayed for the user and the Sales Order Hold Code field automatically populates with value Credit Hold. When the order has been placed on a credit hold, the Status and Workflow fields and the Print toolbar icon become disabledbeen placed on a credit hold, the Status and Workflow fields and the Print toolbar icon become disabled (if the Disabled property in the Hold Code Master File is set to 'Yes' for all three fields). The credit hold can be manually removed by clicking the Hold Code menu and selecting an empty value. This allows a user to proceed with the orderHold Code menu and selecting an empty value. This allows a user to proceed with the order.

Note: "When credit limits are exceeded" preference is set to "Place on Credit Hold" the preference "Default code for Credit Holds on Order" must be filled in otherwise a message “Default code for Credit Holds on Order is required.” will be displayed.

Changing customer

The customer and the ship to address can be changed on an existing order when the Sales Order status is Shipped or lower. This can be done by clicking More Actions toolbar icon and selecting Change Customer. A new window is opened, which allows a user to select the new customer. The new customer can be searched by using the toolbar search field or simply selecting the customer name from the list. When the customer has been selected, Save&Close toolbar icon closes the Change Customer window and updates the customer name, ship to address and sales programs on the sales order.

...

  • Alloc. Units: Displays the number of units allocated of the line item. This field is only editable in Allocate View or the Alloc. Details window.
  • Alloc. Weight: Displays the amount of weight allocated of the line item. This field is only editable in Allocate View or the Alloc. Details window.
  • Carrier: Displays the name of the Carrier that will ship the item(s). This field defaults from the Carrier header field. The Carrier field is editable when new lines items are entered and the Carrier can be changed for saved line items by changing the Shipment to Unassigned. This will enable the Carrier field.
  • Certification: Allows users to select a certification for the item. If the Sales Order preference 'Assign all Certifications to new Orders' is set to yes, the certification field auto-populates based on the item's certification setup. When a certification is selected, only lots with the certification(s) are being allocated.
  • Contract: Displays a drop-down menu for the user to select the contract to which to apply the line item(s). The available contracts will be those in the Sales Contracts module that are assigned to the customer for the specified line item with remaining quantities.
  • Extended Price*: Displays the product of the line item’s price per unit of measure and number of units ordered. This field is read-only.
  • Invoice Description: Displays the Sales Invoice Description saved on the Item record.
  • Item DescriptionDescription: Displays the description of the line item. This field is read-only.
  • Item: Displays the line item’s number. This field is read-only.
  • Ord. Units: Displays the amount of units ordered of the line item.
  • Ord. Weight: Displays the description amount of weight ordered of the line item. This field is read-only.Item 
  • Price UOM: Displays the line item’s number. This field is read-only.
  • Ord. Units: Displays the amount of units ordered of the line item.
  • Ord. Weight: Displays the amount of weight ordered of the line item.
  • Override Wt.: Allows users to enter an alternative Weight that is displayed on specified documentation like shipping documents. The entered weight does not impact the price or inventory calculations. Note: This column is not in the system view. 
  • Price UOM: Displays the unit of measure the price is contingent upon. Defaults to the price list price UOM, if the item is assigned to a price list. If not assigned to a price list, the value defaults to the UOM configured on the customer/address favorites. In other case the price UOM defaults to the Item record Price UOM.
  • Price: Displays the price per unit of measure. The value defaults to the price list price, if the item assigned to an active price list. If the Sales Order price list is updated after the transaction was created. Clicking Save & Reprice header toolbar icon updates the item price according to the latest price assigned to the price list. 
  • Ship By: Displays the date by which the line item(s) must be unit of measure the price is contingent upon. Defaults to the price list price UOM, if the item is assigned to a price list. If not assigned to a price list, the value defaults to the UOM configured on the customer/address favorites. In other case the price UOM defaults to the Item record Price UOM.
  • Price: Displays the price per unit of measure. The value defaults to the price list price, if the item assigned to an active price list. If the Sales Order price list is updated after the transaction was created. Clicking Save & Reprice header toolbar icon updates the item price according to the latest price assigned to the price list. 
  • Ship By: Displays the date by which the line item(s) must be shipped. This field defaults from the Ship By header field. However, if the transaction allows multiple shipments, the Ship By field is editable at the line item level.
  • Shipment**: Displays the ID of the shipment. The shipment is created automatically based on the Carrier, Site and Ship By date combination and the line items with the same Carrier, Site and Ship By date are placed on the same shipment. The Shipment can be unassigned by selecting Unassigned from the Shipment drop-down. This enables the Carrier field for editing. All items on the Sales Order transaction must be on shipments in order to ship or approve an order.
  • Site: Displays the name of the site to which the line item(s) are being shipped. This field defaults from the Ship By header Site field. However, if the transaction allows multiple shipments, the Ship By Site field is editable at the line item level.
  • Shipment**: Displays the ID of the shipment. The shipment is created automatically based on the Carrier, Site and Ship By date combination and the line items with the same Carrier, Site and Ship By date are placed on the same shipment. The Shipment can be unassigned by selecting Unassigned from the Shipment drop-down. This enables the Carrier field for editing. All items on the Sales Order transaction must be on shipments in order to ship or approve an order.
  • Site: Displays the name of the site to which the line item(s) are being shipped. This field defaults from the header Site field. However, if the transaction allows multiple shipments, the Site field is editable at the line item level.
  • Status: Displays the status of the line item(s). This field defaults from the header Status field.
  • Units UOM: Displays the unit of measure in which the units are displayed.
  • Weight UOM: Displays the unit of measure in which the weight is displayed.

New items can be added by clicking the Catalog Items grid toolbar icon, which will reopen the Select Items window with the ordered items and amounts appearing at the top. Follow the same steps as selecting new items to add items.

*Note: The Extended Price is calculated from the ordered units/weight, if the item has no allocations and the order status is less than shipped. When the item has allocations, the Extended Price is calculated from the Allocated Amount (Price * Allocated Amount). When the order status is changed to shipped, the Extended Price is always calculated from the Allocated Amount even when the item has no allocations.

**Note: If a Site and Carrier combination that is visible to logistics is selected, the Shipment is not automatically created and it must be created from the Logistics module (Loads > Build Loads). Once the Load has been created, the shipment field on the Sales Order transaction is updated accordingly when the Sales Order transaction is reloaded.

Allocation

...

  • Status: Displays the status of the line item(s). This field defaults from the header Status field.
  • Units UOM: Displays the unit of measure in which the units are displayed.
  • Weight UOM: Displays the unit of measure in which the weight is displayed.

New items can be added by clicking the Catalog Items grid toolbar icon, which will reopen the Select Items window with the ordered items and amounts appearing at the top. Follow the same steps as selecting new items to add items.

*Note: The Extended Price is calculated from the ordered units/weight, if the item has no allocations and the order status is less than shipped. When the item has allocations, the Extended Price is calculated from the Allocated Amount (Price * Allocated Amount). When the order status is changed to shipped, the Extended Price is always calculated from the Allocated Amount even when the item has no allocations.

**Note: If a Site and Carrier combination that is visible to logistics is selected, the Shipment is not automatically created and it must be created from the Logistics module (Loads > Build Loads). Once the Load has been created, the shipment field on the Sales Order transaction is updated accordingly when the Sales Order transaction is reloaded.

***Note: If an order has been added to or removed from a load in the Logistics module while another user has the order open, the user will be alerted via a message to reopen the order. 

Allocation

If the Sales Order Preference 'Update Allocated from Ordered for non-Lot Tracked Items shipping from non-Whse Lot Sites' is set to 'Yes', then non-lot tracked items shipping from non-warehouse lot tracked sites are automatically allocated. If the preference is set to 'No' or the item is lot tracked and/ or the site is a warehouse lot tracked site, then the item must be allocated. Users can allocate items manually or use the auto-allocate feature.  

There are two preferences for how sales order allocations drawing negative inventory are evaluated, the two preferences are ‘Stop over allocating for lot tracked items based on:’ and ‘Stop over allocating for non lot tracked items based on:’ and each contain the following three options: ‘Do Not Evaluate’, ‘Available Only’ and ‘Available and On Hand’.  When ‘Do Not Evaluate’ is selected the balances for an item are not evaluated and allow inventory to be drawn negative, when ‘Available Only’ is selected, the Available balance for an item is evaluated and will not allow inventory to be drawn negative and when ‘Available and On Hand’ is selected, the On Hand balance for an item is evaluated and will not allow inventory to be drawn negative.

Manual Allocation

To allocate items to the order, the Allocate grid toolbar icon has a dropdown menu with four different ways the item can be allocated to the order. The four ways to allocate are ‘Allocate Item’, ‘Allocate by Inventory Lot’, ‘Allocate by Warehouse Lot’ and ‘Allocate by Item’.

...

  • Available Units
  • Available Weight
  • Batch Date
  • Item: Description : Description 
  • Lot Exceptions: Displays “On Hold” for lots that are currently on hold, and/or “Mismatch Certs” when the lot certifications do not match the order item’s requested certification.
  • On Hand Units
  • On Hand Weight
  • Production Batch
  • Site
  • Units: Enter the units to be allocated from the corresponding lot. This field is only editable if the corresponding item is managed by units and weight or units only. 
  • Units UOM: This will display the unit of measure in which the unit allocation is being made. 
  • Warehouse Lot: This will display the warehouse lot id of the warehouse lot that corresponds to the inventory lot. 
  • Weight: Enter the weight to be allocated from the corresponding lot. This field is only editable if the corresponding item is managed by units and weight or weight only. 
  • Weight UOM: This will display the unit of measure in which the weight allocation is being made. 

...

  • Available Units
  • Available Weight
  • Item: Description 
  • Lot Exceptions: Displays “On Hold” for lots that are currently on hold, and/or “Mismatch Certs” when the lot certifications do not match the order item’s requested certification.
  • On Hand Units
  • On Hand Weight
  • Owner
  • Production Batch
  • Site
  • Units: Enter the units to be allocated from the corresponding lot. This field is only editable if the corresponding item is managed by units and weight or units only. 
  • Units UOM: This will display the unit of measure in which the unit allocation is being made. 
  • Warehouse Lot: This will display the warehouse lot id of the warehouse lot that corresponds to the inventory lot. 
  • Weight: Enter the weight to be allocated from the corresponding lot. This field is only editable if the corresponding item is managed by units and weight or weight only. 
  • Weight UOM: This will display the unit of measure in which the weight allocation is being made. 

...

  • Available Units
  • Available Weight
  • Item: Description 
  • Lot Exceptions: Displays “On Hold” for lots that are currently on hold, and/or “Mismatch Certs” when the lot certifications do not match the order item’s requested certification.
  • On Hand Units
  • On Hand Weight
  • Owner
  • Site
  • Units: Enter the units to be allocated from the corresponding lot. This field is only editable if the corresponding item is managed by units and weight or units only. 
  • Units UOM: This will display the unit of measure in which the unit allocation is being made. 
  • Weight: Enter the weight to be allocated from the corresponding lot. This field is only editable if the corresponding item is managed by units and weight or weight only. 
  • Weight UOM: This will display the unit of measure in which the weight allocation is being made. 

...

“Based upon the available quantities for the [Group tab], auto allocation was unable to be completed and has resulted in an under allocation of product. Please use the allocate by inventory lot tab change the Allocate By Inventory Lot to complete the allocations."

When a user allocates Lots with Certifications assigned, the Lots need to meet the Certification criteria, otherwise it will be disabled on the allocation page. Lots with more certifications than what is assigned to the order item can be allocated.

...

The Shipments tab opens with a line item for each shipment. Shipments are determined by the line items’ Carrier, Site, and Ship By date and appear with the following information:

  • BOL#BOL: Displays the Bill of Lading number for the shipment. This field is a text field and it is not required.  Note: The maximum character limit for this field is 100 characters.
  • Carrier: Displays the carrier transporting the shipment.
  • Deliver On: Displays the date on which the shipment is to be delivered.
  • Export Details: This link opens Export Details form. This form allows users to enter additional information for export shipments.
  • Freight $: Displays the cost of the freight.This field cannot be edited on the Shipments tab. The Freight amount needs to be entered on the Load Record..
  • Freight Terms: Displays a drop-down menu of freight terms for the user to select the freight terms for the shipment. The field defaults to the Freight Terms configured on the Customer Address reocord.  The Freight Terms can also be saved on the Shipment record.
  • GL Date: This field allows users to enter a GL Date for the order. If not provided, the date defaults to the Invoice Date when the transaction is saved as Ready to Post. The date must reside within an open fiscal period. Note: This column is not in the system view. 
  • Invoice #: Displays the Invoice Number. The number can be manually entered, but the Invoice Number is retrieved from an Invoice when the Invoice is printed. The field is editable until the transaction status is Approved. A separate journal entry is created for each invoice assigned to the sales order transaction. The journal entry details can be reviewed by clicking the Journal Details from the header section. If the transaction has multiple invoices, a letter suffix is added to the invoice number starting from the second invoices e.g. ORD123B. The same invoice number is assigned to all shipments with the same invoice date and GL date. 
  • Invoiced: Displays the Invoice Date. The date can be manually entered, but the Invoice Date is retrieved from an Invoice when the Invoice is printed unless the Transaction Class property 'How Invoice Dates are Assigned' is set to 'Manually Assigned'. The Invoice Date is not automatically updated, if the Shipped/Transation date is changed after printing an invoice. The date can be manually updated before printing a new invoice if necessary. The field is editable until the transaction status is Approved.
  • Legs: Displays the total number of legs configured on the Shipment record.
  • Load Status: Displays the status of the shipment’s load. The Load Status is automatically changed to Shipped when the Sales Order has only one shipment and the Sales Order is saved as Shipped (Note that the Shipped date must be entered first). If the Sales Order has two or more shipments, then the status of each shipment must be manually changed to Shipped.
  • Notes: Opens the noted dialog, which allows users to enter additional notes for the Shipment.
  • Ship By: Displays the date by which the shipment is to be shipped.
  • Shipment: Displays the shipment number as a hyperlink, when clicked, opens the Shipment/Load Record, which allows users to enter Load details like Freight Costs. The Freight costs entered on the Load Record updates Freight $ amount on the shipment tab.
  • Shipped: Displays the date the shipment was actually shipped. This is required to save the Shipment in a status of ‘Shipped’.
  • Site: Displays the name of the site to which the shipment is being made.
  • Tracking #: Displays the shipment’s tracking number. This is a text field, which allows users to manually enter the tracking number.

...