Delete

Help

New

• Fish Ticket Price List: To be used on Fish Tickets.

• Fisherman Sale & Tender Resale: To be used on Fisherman Sale and Tender Resale transactions.

Notes

Print

Save

Save & Close

Fields

Description

Currency

A single select lookup to identify the Currency of the Price List. This is required and defaults from the Currency setup as the 'Home Currency' on the Company → Preferences page and is never editable. 

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_MFPriceListHeader.CurrencySK 

Description 

A text box to add/edit the name (long description) of the Price List. This is required but does not have to be unique. If missing, the message "Description is required." will be displayed on Save. This defaults to blank and must be <= 50 characters. This is always editable.

Database Field: ERPx_MFPriceListHeader.Description

Inactive

A Yes/No lookup to indicate whether or not the price list is inactive. This defaults to "No", is required, and can be edited at any time.

Database Field: ERPx_MFPriceListHeader.IsInactive

Price List

A text box to add/edit the unique name of the Price List. This is required and must be unique. If missing, the message "Price List is required." will be displayed on Save. This defaults to blank and must be <= 25 characters. This is always editable.

Database Field: ERPx_MFPriceListHeader.PriceListID

Price List Class

Identifies the type of transactions that the Price List applies to. This defaults from the selection made when the 'New' icon was selected. It is required and never editable. The values include:

• Fish Ticket

• Fisherman Sale

This lookup contains the values in the MFPriceListClass Enumeration Class where EnumerationValue = 2, 3

Database Field: ERPx_MFPriceListHeader.PriceListClassEN

Add Item

This button is disabled until the record is created and the header is saved with the required fields.

Column Filter Show/Hide

Excel

Group By Show/Hide

Quick Column Filter

Remove Items

This button is disabled until the record is created and the header is saved with the required fields.

Saved Layouts

Fields

Description

Checkbox

Condition

Identifies the Condition for the Fish Ticket Item, displayed as [Condition ID] - [Condition Description]. This is informational only and is not editable.

Database Fields: ERPx_APCondition. ConditionID + ERPx_APCondition. ConditionDescription, ERPx_APDeliveryTicketItem.ConditionSK, ERPx_APDeliveryTicketItem.DeliveryTicketItemSK, ERPx_MFPriceListItem.ItemSK

Current Price

A textbox that identifies the current price of the line item. This updates upon save and is never editable by the user. This is calculated by looking up the Item's Price List History and finding the Price that is currently effective.

Database Fields: ERPx_MFPriceListItemHistory.Price, ERPx_MFPriceListItem.PriceListItemSK, ERPx_MFPriceListHeader.PriceListSK

Current Price Date Range

Identifies the effective date range for the current price of the line item. This defaults to blank but updates upon save and is never editable by the user.  This is a calculated field that is not stored in the database.

Database Fields: ERPx_MFPriceListItemHistory.PriceEffectiveDateStart, ERPx_MFPriceListItemHistory.PriceEffectiveDateEnd, ERPx_MFPriceListItem.PriceListItemSK, ERPx_MFPriceListHeader.PriceListSK

Current Tax Price

A textbox that identifies the current 'Tax Price' of the line item. This updates upon save and is never editable by the user. This is calculated by looking up the Item's Price List History and finding the Tax Price that is currently effective.

Database Fields: ERPx_MFPriceListItemHistory.TaxPrice, ERPx_MFPriceListItem.PriceListItemSK, ERPx_MFPriceListHeader.PriceListSK

Disposition

Identifies the 'Disposition' for the Fish Ticket Item, displayed as [Disposition ID] - [Disposition Description]. This is informational only and is not editable.

Database Fields: ERPx_APDisposition. DispositionID + ERPx_APDisposition.Description, ERPx_APDeliveryTicketItem.DispositionSK, ERPx_APDeliveryTicketItem.DeliveryTicketItemSK, ERPx_MFPriceListItem.ItemSK

End Date

A date picker to assign the last effective date for the item price This defaults to blank and is conditionally required based on the "Require Item Price End Date" Sales Order preference. Once an 'End Date' is entered and saved, it will refresh to blank, allowing for a new entry, and either the 'Current Price Date Range' or the 'Next Price Date Range' field will be updated with the Start Date and End Date previously entered and saved, depending on if the dates entered are current or in the future.

Database Field: ERPx_MFPriceListItemHistory.PriceEffectiveDateEnd

Grade

Identifies the Grade of the Fish Ticket Item, displayed as [Grade ID] - [Grade Description]. This is informational only and is not editable.

Database Fields: ERPx_APGrade. GradeID + ERPx_APGrade. GradeDescription, ERPx_APDeliveryTicketItem.GradeSK, ERPx_APDeliveryTicketItem.DeliveryTicketItemSK, ERPx_MFPriceListItem.ItemSK

Item

A single select lookup to add a new item to the Price List. When the 'New' icon is clicked from the toolbar, a blank row is added to grid allowing the user to add a new item. The lookup includes the list of all 'Active' Items displayed as [ItemID] - [Item Description]. This defaults to blank but is required to save a line item. This is not editable after Save.

Database Fields: ERPx_APDeliveryTicketItem.ItemID - GeneratedItemDescription, ERPx_MFPriceListItem.PriceListItemSK

Next Price

A textbox that identifies the next price of the line item. This updates upon save and is never editable by the user. This is calculated by looking up the Item's Price List History and finding the Price that will be effective after the current price is no longer effective. This will only have a value if prices have been entered with a 'Start Date' in the future. This is a calculated field and is not stored in the database.

Database Fields: ERPx_MFPriceListItemHistory.Price, ERPx_MFPriceListItem.PriceListItemSK, ERPx_MFPriceListHeader.PriceListSK

Next Price Date Range

Identifies the effective date range for the next price of the line item. This defaults to blank but updates upon save and is never editable by the user.  This is a calculated field that is not stored in the database.

Database Fields: ERPx_MFPriceListItemHistory.PriceEffectiveDateStart, ERPx_MFPriceListItemHistory.PriceEffectiveDateEnd, ERPx_MFPriceListItem.PriceListItemSK, ERPx_MFPriceListHeader.PriceListSK

Next Tax Price

A textbox that identifies the next Tax Price of the line item. This updates upon save and is never editable by the user. This is calculated by looking up the Item's Price List History and finding the Tax Price that will be effective after the current price is no longer effective. This will only have a value if a Tax Price has been entered with a 'Start Date' in the future. This is a calculated field and is not stored in the database.

Database Fields: ERPx_MFPriceListItemHistory.TaxPrice, ERPx_MFPriceListItem.PriceListItemSK, ERPx_MFPriceListHeader.PriceListSK

Price

A textbox to enter the new price for the line item. To save a new Price, both a 'Price' and a 'Start Date' must be entered. 

 Users may add a positive, negative, or 0.00 price.

Database Field: ERPx_MFPriceListItemHistory.Price

Price UOM

A single select lookup to identify the Price UOM for the item. This defaults from the 'Weight UOM' Fisherman Accounting Preference, is required, and is not editable after the initial save. If missing, the line item will not be added on Save. The lookup only contains an option for Lbs.

Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK

Sold Condition

Identifies the Condition the Fish Ticket Item was sold in, displayed as [Condition ID] - [Condition Description]. This is informational only and is not editable.

Database Fields: ERPx_APCondition. ConditionID + ERPx_APCondition. ConditionDescription, ERPx_APDeliveryTicketItem.SoldConditionSK, ERPx_APDeliveryTicketItem.DeliveryTicketItemSK, ERPx_MFPriceListItem.ItemSK

Specie

Identifies the ID and Description of the Specie assigned to the Ticket Item, displayed as [Specie ID] - [Specie Description]. This is informational only and is not editable.

Database Fields: ERPx_APDeliveryTicketLine.DeliveryTicketItemSK, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APSpecie.SpecieID +  ERPx_APSpecie.SpecieName, ERPx_APDeliveryTicketItem.SpecieSK, ERPx_APDeliveryTicketItem.DeliveryTicketItemSK, ERPx_MFPriceListItem.ItemSK

Start Date

A date picker to assign the effective date for the item price This defaults to blank and is required. Once an 'End Date' is entered and saved, it will refresh to blank, allowing for a new entry, and either the 'Current Price Date Range' or the 'Next Price Date Range' field will be updated with the Start Date and End Date previously entered and saved, depending on if the dates entered are current or in the future.

Database Field: ERPx_MFPriceListItemHistory.PriceEffectiveDateEnd

Tax Price

A textbox to enter the new Tax Price for the line item. To save a new Tax Price, a 'Price', 'Tax Price' and a 'Start Date' must be entered. 

 Users may add a positive, negative, or 0.00 price.

Database Field: ERPx_MFPriceListItemHistory.Price

UOM Schedule

A textbox to show the 'UOM Schedule' assigned to the Price List Item. This defaults on Save, if required, and is never editable. 

Database Fields: ERPx_IMUOM.UOMID, ERPx_IMItem.UOMScheduleSK, ERPx_MFPriceListItem.PriceListItemSK