Price List - Linked Item Formula

Price List - Linked Item Formula

Description: The Linked Item Formula page is to edit and add formulas for linked price list items.

[ 1 Header Section ] [ 1.1 Toolbar ] [ 1.2 Fields ] [ 2 Grid Section ] [ 2.1 Toolbar ] [ 3 Related Topics ] [ 3.1 Page Definitions ] [ 3.2 Technical Details ]

Header Section

Toolbar

Toolbar Icons

Description

Toolbar Icons

Description

Grid Layout

Save

Fields

Field Names

Description

Field Names

Description

Base Index Item

Displays the ID and the description of the item that is used as the base item. This field is for informational use only and is not editable. The base index item can be changed on the Linked Price List record view (Items tab).

Base Index Price

Displays the current price of the base item. This field is for informational use only and is not editable. Any edits to the base item price must be done on the base price list record.

Date From

Displays the date the current price of the base item started. This field is for informational use only and is not editable. Any edits to the base item price must be done on the base price list record.

Date To

Displays the date the current price of the base item is valid. This field is for informational use only and is not editable. Any edits to the base item price must be done on the base price list record.

Formula Source

Displays the source of the price list formula. This field is for informational use only and is not editable.

Maximum Price

This field allows users to define the maximum price for the formula. If the calculated price exceeds the maximum price, the maximum price is set as the price for the item. This field is always editable and it is not required.

Minimum Price

This field allows users to define the minimum price for the formula. If the calculated price is lower than the minimum price, the minimum price is set as the price for the item. This field is always editable and it is not required.

Grid Section

Toolbar

Toolbar Icons

Description

Toolbar Icons

Description

Cancel

Delete

Excel

New

Column Headers

Description

Column Headers

Description

Amount

Displays the calculated amount. This is calculated from the Base Index Price and the factor and operation entered. This field is never editable.

Factor

This field is for users to enter/select the factor for the calculation.

Operation

This drop-down menu allows users to select the operation for the price calculation.

Seq

Identifies the sequence of the calculations. This field is not editable.

UOM

Identifies the unit of measure of the price. The UOM defaults to the base item price UOM, but updates to the Factor UOM if UOM Convert is selected as the Operation. This field is not editable.

 

Related Topics

 

 

Page Definitions

 

Technical Details

 

Table Names:

Table Names:

dbo.ERPx_MFPriceListFormulaStep

Stored Procedures:

Stored Procedures:

dbo.SPx_MFSEL_PriceListFormulaStepHeader

dbo.SPx_MFSEL_PriceListFormulaStepLine

dbo.SPx_MFSEL_PriceListFormulaStepLineNew

dbo.SPx_MFSEL_PriceListLinkedFormulaOperationLookup

dbo.SPx_MFUpdate_PriceListFormulaStep