Grower Accounting Price Lists can be assigned to Farmers so that new tickets inherit prices. The purpose of this page is to add, edit, and remove these records. Insert excerpt Def - Price List Def - Price List nopanel true
Software Version: 2022.04.22 and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Delete |
| ||||||||
| Help |
| ||||||||
| New |
| ||||||||
| Notes |
| ||||||||
| |||||||||
| Save |
| ||||||||
| Save & Close |
| ||||||||
| Fields | Description | ||||||||
| 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 each Price List applied to. This is auto assigned when the Price List is initially created (based on the option selected from the 'New' icon) and is not editable. The allowable values include: 'Grower Accounting Tickets'. These price lists can only be used on Grower Ticket. Database Field: ERPx_MFPriceListHeader.PriceListClassEN |
Ticket Items Tab
| Toolbar Icons | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||
| Delete |
| ||||||||
| Excel |
| ||||||||
| Group By Show/Hide |
| ||||||||
| Quick Column Filter |
| ||||||||
| New |
| ||||||||
| Saved Layouts |
| ||||||||
| Fields | Description | ||||||||
| Checkbox |
| ||||||||
| Current Price | A calculated field that identifies the current price of the line item. This field updates upon save and is never editable by the user. | ||||||||
| 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. | ||||||||
| End Date | A Calendar control to identify the last effective date of a new price for an Item. This defaults to blank and is not 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 | ||||||||
| Item | A single select lookup to add a new item to the Price List. When the 'New' icon is clicked from the Ticket Items toolbar, a blank row is added to Ticket Items grid allowing the user to add a new item. The lookup includes the list of all 'Active' Ticket 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_CPItem.ItemID - ItemDescription, ERPx_MFPriceListItem.PriceListItemSK | ||||||||
| Next Price | A non-editable text box that identifies the next price waiting to become effective for the line item. This defaults to '0.00' and is never editable by the user. 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. | ||||||||
| Next Price Date Range | Identifies the effective date range for the next (future) 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. | ||||||||
| Price | A text box to enter the new price for the line item. To save a new Price, both a 'Price' and a 'Start Date' must be entered.
Database Field: ERPx_MFPriceListItemHistory.Price | ||||||||
| Price UOM | This field displays a drop-down menu of all units of measure on the selected item's UOM schedule for the user to identify the unit of measure on which the line item's price is based. This field defaults to the value selected in the "Scale Weight UOM" preference and is never editable by the user. Database Field: ERPx_MFPriceListItemHistory.PriceUOMSK | ||||||||
| Start Date | A Calendar control to identify the effective date of a new price for an Item. This defaults to blank and is required. Once a Start 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_MFPriceListItemHistoryPriceEffectiveDateStart |
Users may add a positive, negative, or 0.00 price.Assigned Farmers Tab
| Toolbar Icons | Description |
|---|---|
| Fields | Description |
| Farmer | A read only field to show the names of each Farmer that is assigned to the current Price List. This value is looked up, not stored in the database. |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
| Expand | ||
|---|---|---|
| ||
Technical Details |