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

Version 1 Next »

Price Lists are used to store a group of Items with pre-defined prices and effective dates. Inventory Price Lists can be assigned to Transfer Transaction Class(es) so that new transfer transactions default the correct prices for insurance purposes. The purpose of this page is to add, edit, and remove these records. 

Page Header

Toolbar IconsDescription
CancelCancels the current unsaved changes when in edit mode.
Delete

Deletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

(lightbulb) A price list can only be deleted, if it has not been assigned to a Transaction.

Grid Layout
Error rendering macro 'excerpt-include' : No link could be created for 'Toolbar Icon - Grid'.
NewAllows the user to create a new master file record or transaction by opening a blank record view page. This icon is always enabled. 
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. 
SaveSaves the changes made to the record. 

(lightbulb) It is only necessary to click the Save button when a change is detected on the page. When a change has been made, a ‘ + ‘ character is displayed prior to the page name in the page title bar (light blue bar in the upper left corner of the page). Clicking Save reloads the page.

Header Fields

Field NamesDescription
Currency ID

This field displays a drop-down menu for the user to identify the currency for the price list. This field is required and is not editable after saving. 

Description

This field displays a text box for the user to describe the price list. This field is required and can be edited at any time.

Inactive

This field displays a drop-down menu with the options "Yes" and "No" for the user to determine whether or not the price list is inactive. This field defaults to "No", is required, and can be edited at any time.

Price List

This field displays a text box for the user to enter the name of the price list. This field is required and can be edited at any time.

Price List Class

This field defaults to "Transfer" and is never editable.

Price List Type

This field defaults to "Standard" and is never editable.

Prices Include Freight CostThis field defaults to "No" and is never editable. 

Grid Toolbar

Toolbar IconsDescription
DeleteDeletes the selected line(s) from the transaction or master file. This icon is only enabled for transactions with a Status of 'New'.
Excel Clicking the Excel toolbar icon exports the current contents of the grid to an Excel file that is automatically downloaded. The contents that export are only those currently visible. If the grid is filtered, only the filtered contents will be exported. 
NewAdds new blank lines in the grid section to allow for data entry.

Grid: Transfer Class

Column HeadersDescription
Transfer ClassThis field displays a drop-down menu to assign a Transfer Class to the price list. The price list will be applied only to the transfer classes assigned to the price list. One or more transfer classes can be assigned to the price list, however each class cannot be assigned to multiple price lists.

Grid: Transfer Items

Column HeadersDescription
Current Price

This field displays a read-only text box that identifies the current price of the line item. This field defaults to blank but updates upon save and is never editable by the user.

Current Price Date Range

This field displays a read-only text box that identifies the effective date range for the current price of the line item. This field defaults to blank but updates upon save and is never editable by the user.  

End DateThis field displays a text box for the user to enter the last effective day for the entered price of the line item. The field defaults to blank and it is not required. Once the End Date is entered and the record is saved, the field updates to blank to allow a new entry and the Current Price Date Range or the Next Price Date Range is updated accordingly depending if the start date entered is in the future or not.
Item

This field displays a drop-down menu of all active inventory items configured in the system (Inventory > Items) to assign transfer items to the price list. This field defaults to blank and the item is required to save a line item. The field is always editable when the grid section is in edit mode (clicking New from the grid toolbar switches the grid into the edit mode).

(lightbulb) Multiple inventory transfer items can be assigned to the same price list.

Next Price

This field displays a read-only text box that identifies the next price waiting to become effective for the line item. This field defaults to blank and is never editable by the user.

Next Price Date Range

This field displays a read-only text box that identifies the next effective date range for the line item price. This field defaults to blank and is never editable by the user.

Price

This field displays a text box for the user to enter the new price for the line item. This field is always editable when the grid is in edit mode (clicking New from the grid toolbar switches the grid into the edit mode). The price entered in this field will become effective once the Start Date has been reached. This field defaults to blank.

(lightbulb) Users may add items to price lists that do not have a price, for example, 0.00. 

Price UOM

Displays the price unit-of-measure. 

Start DateThis field displays a text box that defaults to blank for the user to enter the first effective day for the pride of the line item. This field is required. Once a Start Date is entered and saved, the Start Date field is updated to blank, allowing for a new entry and either the Current Price Date Range or the Next Price Date Range field is updated with the Start Date and End Date previously entered and saved, depending on if the dates entered are current or in the future.
UOM ScheduleDisplays the unit of measure schedule for the line item. This field defaults from the Item selection upon save and is read-only. 

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details


Table Names:
dbo.ERPx_IMTransactionClassPriceList
dbo.ERPx_MFPriceListHeader
dbo.ERPx_MFPriceListItem
Stored Procedures:
dbo.SPx_MFIns_PriceListHeader
dbo.SPx_MFUpd_PriceListHeader
dbo.SPx_MFUpd_PriceListItem
  • No labels