Salesforce

Sales Order Line Creation and Management

« Go Back
Article

Overview

This article outlines how to add Sales Order Lines, key fields, and their maintenance.

Navigation

 

Rootstock Site Map > Sales Orders > Sales Order Header
 

HV SO Entry:  Access an existing Sales Order Header; this will list existing Sales Order Lines as a related list right below the Advanced section. Because the Sales Order Lines are displayed as a related list, changes to displayed fields and their sorting can be managed by updating the standard Salesforce page layout for the Sales Order Header object and Sales Order Line related list; for details, see Salesforce article Customize Related Lists. 

note25 (1).png  NOTE  It is possible to access the Sales Order Lines page directly from the object listview. New Sales Order Lines addition from the listview is not supported but can be deleted or accessed for edits.

Normal SO Entry:  Access an existing Sales Order Header. The page will list existing Sales Order Lines in the Line Items area, right below the Advanced section.


Processing - Add Sales Order Lines

Below are listed the two different ways of manually adding Sales Order Lines: one-by-one SO Line Addition and Quick Entry button.

 

HV and Normal SO Entry processing steps are fundamentally the same. Any differences between the two UI are described below, one of the key differences being the visibility of Shipping and Requirement dates when processed using the HV SO Entry UI and the accessibility to the SO Line Additional section.
 

  • One-by-one SO Line addition

  1. Start new SO Line

  • HV SO Entry:  It is possible to manually add Sales Order Lines to an existing Sales Order (already saved), by clicking on the New Sales Order Line button at the top of the Sales Order Lines related list. This will take the user to a new Sales Order Line page where he can specify the new Sales Order Line details.

  • Normal SO Entry:  It is possible to add lines while also a new Sales Order Header is being created, or after it has been initially saved. Under the Line Items section, click Add. This will add a new row with all available input fields for the new Sales Order Line.

    • When adding Sales Order Lines to a Sales Order Header that has not yet been saved, it is possible to add lines up to a maximum before the switch to HV SO Entry. If the user tries to overpass this number, a warning message will be shown: Please save the Sales Order before adding more lines.

  1. (Optional) Click the Product Search button. For details, see: Sales Order Line - Product Search button. If this option is used, skip to number 5.

  2. (Optional) Select a Product Type, which will filter display options to select when the user moves to the Product field (this also applies when the Customer Setting salesorder_preloadproducts value is True. For details, see Sales Orders - Setup).

  3. Click the Product field, which will list, as a drop-down, available Products to select from. This is when the Customer Setting salesorder_preloadproducts value is True, and it is possible to type characters to reduce the list of options. If the salesorder_preloadproducts value is False, the user is not presented with the pre-loaded list of Products and will have to type in order for the auto-complete search to provide results. 

  •  If the Selectable Associated Inventory Item field is checked on the Product Master Inventory Tab, the user can change the Inventory Item (from those already set up on Product Master > Inventory Items Tab) for the Sales Order Line before it is saved, by clicking on the blue dotUser-added image below the Product field cell.

  • Selecting the Product will apply default details defined on the Product Master to the Sales Order Line, which may include a Default Qty Order, if this is the case, the Qty Ordered field will be filled in (Skip to step number 6).

  • If using Avalara Integration, the Product Group for the entered Product on Sales Order Line must have a defined Avalara Product Tax Code on Lead Times & Misc. tab. Otherwise, the Product will not appear under this Sales Order Line type-ahead field.

  1. Enter a value for Qty Ordered. It is possible to manage acceptance settings and the default value for this quantity by configuring the Product Master Order Qty Tab. Once the user clicks or tabs out of this field, the Price Discount Logic will be used automatically in order to fetch a Unit Price and a Discount Percentage.

  • For Stock - Product Type SO Lines, after the Product Name has been selected and applied to the line, a Quantity Available pop-up can be viewed for the Selected Inventory Item by clicking the small blue dot  User-added image under the Qty Ordered cell for this Sales Order Line. This pop-up displays important details about the Inventory Item associated with this Product, Qty On Hand, Qty Allocated, and availability for the current issue project and site for the line.

  • Once the Qty Ordered is entered and the user attempts to leave the field by either tabbing out of it or clicking on any area of the page (this includes clicks on buttons, which would not perform their intended action), the Retrieving Pricing Product process is initiated to fetch accurate Price/Discount details, as described on Price Discount Logic. This process takes a few seconds to run, and once completed, the Retrieving Pricing Product page holder disappears, and the user will be able to continue modifying Sales Order Line details or saving the record.

  • The 'Qty Ordered' can be set to zero when creating the Sales Order Line by unchecking the 'Firm' flag. Upon saving, the Sales Order Line will be created in 'Planned' status, and the system will consider this Line as completed.

  1. Adjust or enter the desired Unit Price.

  • By clicking on the small blue dot User-added image under the line Unit Price field, the Price Source pop-up is shown. It provides details related to the base price of the Product, Discounts, and Price/Discount Source information fetched by the Price Discount Logic (to get a more detailed log of steps by which the price is derived, set  Manufacturing Users > Current tab > Price Log Level field to Trace).

  1. (Optional) Enter a Discount Pct., which is applied to the Sales Order Line Unit Price.

  2. (Optional) Set a Due Date. Value defaults to Sales Order Line entered date + Customer Master lead time + Product Master lead times (Product Master Lead Time & Misc Tab). If overridden by the user, it is used to calculate the Scheduled Ship Date and the Required Date. The Required Date is a key value used not only by MRP to generate Supplies and specify their Due Date but also for any supply-related record generated from this Sales Order Line (such as Direct Purchased PO Line and/or Work Order generated upon SO Line firming step).

  • If using HV SO Entry, both the Scheduled Ship Date and Required Date fields are available for overrides on the Sales Order Line page.

  1. (Optional) Select a different Inventory Division if the Product has been configured with multiple. See Product Master Inventory Division Tab.

  2. (Optional) Update the Project, Sales UOM, and/or Firm (not for Quotes) box as desired.

  3. (Optional) Review the Sales Order Line Additional tabs that are available during Sales Order Line addition. The values defaulted to these tabs are those fetched from the SO Control and Product Master records.

  • HV SO Entry:  Open the Additional sectionUser-added image in the lower area of the page to access available tabs.

  • Normal SO Entry:  Click on the Additional button on the right end of the Line Item row. This will open a Sales Order Line pop-up that contains the same information that is displayed on the HV SO Entry Additional section.

  1. Click Save. This will create the Sales Order Line and, if configured to do so, generate Sales Order Line Components as per the setup of the Product just selected with the Sales Order Line.

    NOTE image.png  NOTE  When adding multiple Sales Order Lines to a Sales order Header, the field 'Intra-Company Direct Sale' on the Sales Order Lines can have different values only if the flags 'Bypass AP/AR for Intra-Company Txns' and 'Bypass Inter-Company Like Intra-Company' on the Company Master record are set to False.

  • Quick Entry button:  This can be used on both HV and Normal SO Entries after the Sales Order Header is initially Saved.

  1. Click the Quick Entry button, available in the list of buttons for the Sales Order Header. This will bring a pop-up window where more than one line can be added at once. 

  2. Press the Add button to initialize adding a new Sales Order Line.

  3. Values are set by default for fields Due Date, Inventory Division, and Project.

  4. Specify Product, Quantity Ordered, Unit Price, Discount Pct., Due Date, Inventory Division (if more than one is available on Product Master > Inventory Division tab), Project (and project Charge Code is active), and Firm status.

  • When the Unit Price is left blank, the Price will be determined when lines are saved using the Price Discount Logic

  1. Repeat from step 2 for each of the Sales Order Lines that are to be added.

  2. When done, click OK. This will automatically Save the newly added Sales Order Lines to the Sales Order Header and generate Sales Order Line Components, as per the Product setup selected for the Sales Order Line.

 

User-added image  NOTE  When using Avalara Integration and adding Sales Order Lines for Products using the Product Search or Quick Entry buttons, it could be the case that the selected Products do not have an Avalara Product Tax Code set on its Product Group. When this happens, a red icon User-added image will appear right before the Product name for the newly added Sales Order Line, and requires the user to set a value on the Product Group, Avalara Product Tax Code field.

 

NOTE image.png  NOTE  In Lightning, the Quick Entry button is available on the Sales Order Lines Grid (Sales Order Processes App > Sales Order Header > Related Tab > Sales Order Lines Grid). And it is visible when the custom setting 'EnableLUISOLineQuickEntry' is set to True.

 

Processing - Sales Order Line Management by SO Line Product Type
 

Once a Sales Order Line is marked as Firmed (either individually or using the Firm All Lines button) it is eligible on the SO Fulfillment.


Sales Order Line - Page Fields and Buttons definition

Fields
 

Line:  Auto-generated number that uniquely identifies this Sales Order Line in the Sales Order.

Product Type:  Type of Product associated with this Sales Order Line. From the Product Type drop-down, the user can select from the following Product Types for the Sales Order Line > All, Configured, Service, Stock, Kit, Miscellaneous. Available options can be controlled on the Customer Master Sales Order Defaults tab, with Customer Buys Products/Services fields. The selection of the Product Type will filter available Products to select from on the Product field. Valid Product Types are:

  • Stock:  Build or Purchase to stock. Firmed lines can be set for Direct Purchasing or Inter Company Direct Purchase, which can create a related Purchase Order (including drop-shipping) to offset demand. Otherwise, supply replenishments can be calculated by MRP or maintained manually.

  • Configured:  Build to a specific configuration driven by a Sales Order Line demand. Upon firming a Configured Sales Order Line, a Work Order will be created to satisfy its demand and linked to the Sales Order Line, according to settings on the Product Master Inventory Tab.

  • Kit:  A set of Inventory Items shipped together. The Items picked on the SO Fulfillment step will be those Inventory components specified on the Product Master Components Tab.

  • Service:  Services that are sold. They do not reference Inventory Items.

  • Miscellaneous:  Non-inventoried items.

Product types that are not directly added to Sales Order Lines:


Product:  The Product associated with this Sales Order Line. The field is a type-ahead, only editable while adding a new Sales Order Line. As the user enters Product Names, the type-ahead field will generate a drop-down list of Products configured for the Sales Division and which are of the type selected from the Product Type drop-down.
 

Qty Ordered:  The quantity to be ordered for this Sales Order Line Item. Once the Product Name has been applied to the line, the user can input a Qty Ordered for the Sales Order Line, values for Unit Price, Discount Pct, Extended, Due Date, Project, Sales UOM, Order Lines Total, and Pre-Tax Order Total are inherited from the Product Master & Customer Master settings and/or calculated (can be overridden) and are applied accordingly to the Sales Order Line. Valid Qty Ordered will be defined on Product Master > Order Qty Tab.   

Unit Price:  The unit cost of this line item. This field is auto-populated after input of Qty Ordered. The value can be overridden after the auto-fill. When the Sales Order Line Product and quantity have been defined, the initial price will be derived using the Price Discount Logic (also keeping in consideration Customer Master's field  Always Give Best Price on Customer Master > Sales Order Defaults tab). For Products type Configured and Kit, the Price may not be available for overrides if the option Price From Components (Kit and Config) is Active on Product Master > Inventory Tab.

note25 (1).png  NOTE  When the user checks the 'Update Price' checkbox in the Sales Order Line ListView OR on the Sales Order Line Lightning page (Sales Order Processes > Sales Order Lines > search for and select the Line > Details tab > Information section), the system recalculates the SO Line's 'Unit Price' using the SO Line price engine.


Discount Pct:  The Discount percentage allocated to this line item. This field is auto-populated after input of Qty Ordered. The value can be overridden after the auto-fill. The default value is fetched with the Price Discount Logic.

Extended:  This field shows the extended price amount (Unit Priceless Discount percentage times Qty Ordered).

Sales UOM:  Defaulted to Sales Unit of Measure (UOM) for Sales Order Lines Product. Can be overridden to other UOMs with a conversion factor with Conversion Type Sales to Inventory between the given Sales UOM and Inventory UOM (this UOM would be that specified on the Sales Order Demand record, usually matching the Inventory Item's UOM).

Due Date:  The Due Date for this line item, which should be the day the Customer expects to receive the order.

Inventory Div:  The Division associated with this line item when shipping. Available Inventory Divisions are the Default Inventory Division (Product Master > Inventory tab > Default inventory Division field), and those previously configured on Product Master > Inventory Division Tab.

Project:  The Project associated with this line. For auto-project functionality, please review SO Control > Auto-Project Tab.
 

Project Charge Code:  If using Project Charge Codes or Job Code Maintenance, available Charge Code records from the Sales Order Lines Project will be available here. When using Project Charge Code (set to "active on System Configuration record), this is a mandatory field.


Firm:  A Sales Order Line must be ‘Firmed’ for it to be eligible for Sales Order Fulfillment. A firmed Sales Order Line triggers the creation of a Requirement record in the system, which can be used by MRP.

Line Status:  The current status of this Sales Order Line - initially added as Planned (no demands created). Status must be Firm to fulfill the line. Other statuses are Partial Allocated, Allocated, Partial Issue, Issue, Partial Packaged, Packaged, Partial Shipped, and Shipped.


Buttons - Only HV SO Entry UI
 

Save:  Click this button to save a Sales Order Line. 

Save & New:  After inputting any Sales Order Line details and saving, the user can click the ‘Save & New’ button to add a new Sales Order Line to the Sales Order.

Delete:  Click this button to delete the Sales Order Line.

Cancel:  This button clears any details that have been added to the Sales Order Line since the last Save made to the Sales Order Line. 

Clone:  Click this button to clone the existing Sales Order Line, make changes, and click on 'Save' to add this new Sales Order Line to the Sales Order.

New:  Click this button to add a new Sales Order Line to the Sales Order.

For details on the below buttons see Sales Order Line Additional.

  • ATP

  • Commission Detail

  • Component ATP

 

Components:  Refer to Sales Order Line Component for more details.
 

Buttons - HV and Normal SO Entry UIs
 

Product Configurator:  Available for new Sales Order Lines when field Configurable Sales Order Entry Active is checked on SO Control > Configurator Tab. It will launch a Configuration Session and link it to this Sales Order so that when it is ready to export, it will export it automatically to said Sales Order.

Calculate Taxes:  Available when field Enable Avalara Tax Calculation is checked on SO Control > GEO Service Tab. If pressed, it will complete a call-out to Avalara to fetch the most updated taxes for the Sales Order Lines on the Sales Order Header. Both Address of Origination (can be reviewed on Sales Order Header>  Shipping Tab) and Ship-To addresses will need to be valid for Avalara to complete. The updated values (Verified Tax Rate, Verified Tax Amount, and Verified Shipping Tax) can be reviewed on Sales Order Line > Ship-To Settings Tab. Any updates to the Sales Order Line will also automatically fetch Avalara Tax values.

Product Search:  Available for new Sales Order Lines. Allows the user to find Products by filters such as Customer Product Number, Customer Product Description, Rootstock Product Number, Rootstock Product Description, allowing search records to be limited Customer Product. By clicking on any of the hyperlinks on the resulting rows, the Product Master details will be added to the Sales Order Line.
 

Components:  Can be accessed once the Sales Order Line has been saved. For details, see Sales Order Line Components Button.
 

Sales Order Line - Additional tabs


The information and fields contained in the Additional section can not only be accessed for any existing Sales Order Line at any point but also while the new Sales Order Line is being added, in order to edit key settings. Some fields may not be editable depending on the Line Status.

  • HV SO Entry UI:  Click the arrow on the User-added image Additional Section. This will open a set of tabs to further define the Sales Order Line. 

  • Normal SO Entry UI:  Click on the Additional button on the right end of the Line Item row. This will open a Sales Order Line pop-up that contains the same information that is displayed on the Additional section on HV SO Entry UI (uses the Sales Order Line page for line details display and addition).


SEE ALSO
 

Sales Orders Entry - Overview
SO Entry Transition Guide

Settings
Sales Order Line Creation and Management
Sales-Order-Line

Powered by