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 Page History

« Previous Version 4 Next »

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

Header Section

Toolbar

Toolbar IconsDescription
Grid Layout
Error rendering macro 'excerpt-include' : No link could be created for 'Toolbar Icon - Grid'.
Save
Error rendering macro 'excerpt-include' : No link could be created for 'Save - Record View Header'.

Fields

Field NamesDescription
Base Index ItemDisplays 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 FromDisplays 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 PriceThis 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 PriceThis 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 IconsDescription
Cancel
Error rendering macro 'excerpt-include' : No link could be created for 'Cancel - Global'.
Delete
Error rendering macro 'excerpt-include' : No link could be created for 'Delete - Record View Items Grid'.
Excel
Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Grid'.
New
Error rendering macro 'excerpt-include' : No link could be created for 'New - Grid Item'.
Column HeadersDescription
Amount

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

FactorThis field is for users to enter/select the factor for the calculation.
OperationThis 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.

UOMIdentifies 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

Page Definitions


 Technical Details

Technical Details


Table Names:
dbo.ERPx_MFPriceListFormulaStep
Stored Procedures:
dbo.SPx_MFSEL_PriceListFormulaStepHeader
dbo.SPx_MFSEL_PriceListFormulaStepLine
dbo.SPx_MFSEL_PriceListFormulaStepLineNew
dbo.SPx_MFSEL_PriceListLinkedFormulaOperationLookup
dbo.SPx_MFUpdate_PriceListFormulaStep
  • No labels