Fish Ticket Premiums Record View 3.0

Fish Ticket Premiums Record View 3.0

Premiums are most often used to represent things that increases the price you pay fishermen for their fish but they can also be configured to reduce the amount you pay. Premiums can be configured to be manually added or automated based on business rules.  Manually added premiums can be added to delivery tickets from the multi-select combo box on the Home tab of the delivery ticket. Automatically added premiums are automatically added to delivery tickets when the conditions defined on the premium program record are met. Premiums are automatically added to all the ticket line items that meet the premium conditions. The purpose of this page is to add, edit, remove, and activate/inactive premium programs to be used on Fish Tickets.

Once the premium has been added to the delivery ticket, the rate can be manually edited.

Software Version: 2025.04.21 and newer

Page Header

Header Toolbar

Toolbar IconsDescription
Delete

 Deletes the transaction, batch, or master file record. When clicked, users will be prompted with: "Are you sure you want to delete this record?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

Programs used on a Fish Ticket will not be able to be deleted. The message "This Program is used on a Delivery Ticket and cannot be deleted." will be displayed. Additionally, only the latest version of a program will be allowed to be deleted. If the user selects a prior version of a program to delete, the message "([Program ID]) cannot be deleted because it is not the latest version of this program." will be displayed.

Help Opens the online WIKI help page for the current page. 
New Opens a new blank record for data entry.
Save Saves the changes made to the record. 
Save & Close Saves your changes and closes the page.
FieldsDescription
Program

A non-editable text box to display "[Program ID] - [Description]" of the Premium Program. This defaults to blank for a new Premium Program and is always updated after initial Save. This field is never editable. When users update the value in the 'Program ID' field or the 'Description' field, on Save the Fish Ticket Premiums record view page will refresh to display the updated Premium Program.

Database Field: ERPx_APProgram.APProgramID - ERPx_APProgram.APProgramName

Type

A non-editable text box to display "Premium". This defaults to blank for a new Premium Program and is always updated after initial Save. This field is never editable.

This text box contains the value in the APProgramType Enumeration Class where APProgramType = 1.

Database Field: ERPx_APProgram.APProgramTypeEN

Properties Tab 

Toolbar IconsDescription
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
PropertiesIdentifies the Property that is being set up.
Value A text box or lookup to set the value of the property. Property values are always editable and can be changed at any time, unless otherwise specified. 
Group: Configuration
Program ID

Identifies the short description and unique identifier for Tax, Premium, Charge, Accrual and Sales Program.  This is a text box that is required. It defaults to blank for new records. If not assigned, the message "Program ID is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Program ID's are not allowed for the same Program Type." will be displayed on Save. This field is always editable and must be <= 50 characters. 

Database Field: ERPx_APProgram.APProgramID

Description

Identifies a long description for Tax, Premium or Sales Programs. This is a text box that is required. If not assigned, the message "Description is required." will be displayed on Save. It defaults to blank for new record and duplicate values are allowed. This field is always editable and must be <= 100 characters. 

Database Field: ERPx_APProgram.APProgramName

Class

Identifies the Program Class associated with the Premium record. This is a single-select lookup that is required. If missing, the message "Class is required." will be displayed on Save. It defaults to blank and is always editable.

Program Classes are used to classify programs by 'Program Type' (Tax or Premium) and by Group. Fish Ticket Tax Programs can be grouped as either Borough, City, Observer, State, or Other.

The lookup contains a blank value, the current assigned values and all the records in the Tax & Premium Classes list view with a 'Program Type' of "Premium". 

Database Field: ERPx_APProgram.APProgramClassSK

Landed Date Start

Identifies the date the Program starts. Tickets with a 'Landed Date' on or after the Landed Date Start date will be evaluated for the Program. This is a date picker that is required. If missing, the message "Landed Date Start is required." will be displayed on Save. This defaults as blank on new records and is always editable. Fish Tickets with a Landed Date before the 'Landed Date Start' will not be evaluated for the Premium. Else the message "[Program ID] Version [Version - 1]'s Landed Start and End Dates may not overlap other version of the same Program." will be displayed on Save.

Identifies the date fish or shellfish are off-loaded or trans-shipped from the catcher vessel to the first purchaser. The date of landing is the day off-load is completed. For catcher-processors the land date is the date the product is caught and brought on board. For catcher-seller vessels the land date is the date the product is initially brought into port.

Database Field: ERPx_APProgram.APProgramStart

Landed Date End

Identifies the date the Program ends. Tickets with a 'Landed Date' on or before the Landed Date End date will be evaluated for the Program. This is a date picker that is not required. This defaults as blank and is always editable. A blank value assumes the Premium never ends, but if a date is entered it must be >= the 'Landed Date Start' field. Else the message "Landed Date End must be on or after Landed Date Start." will be displayed on Save.  Fish Tickets with a Landed Date after the 'Landed Date End' will not be evaluated for the the Premium, even if the Premium Program is still Active. Else the message "[Program ID] Version [Version + 1]'s Landed Start and End Dates may not overlap other version of the same Program." will be displayed on Save.

Identifies the date fish or shellfish are off-loaded or trans-shipped from the catcher vessel to the first purchaser. The date of landing is the day off-load is completed. For catcher-processors the land date is the date the product is caught and brought on board. For catcher-seller vessels the land date is the date the product is initially brought into port.  

Database Field: ERPx_APProgram.APProgramEnd

Inactive

Identifies if the record is "Inactive". If inactive (set to "Yes"), it will not be included in look-ups for transactions or other master files. If set to "No" or blank, the record is active and can be freely used. This is a Yes/No lookup that is required. it defaults to "No" and is always editable. This field is not visible until after the record is initially saved.

Database Field: ERPx_APProgram.IsInactive

Group: Assign Rules
How this Program is assigned to Tickets?

Identifies how the Premium Program is assigned to Fish Tickets. This is single-select lookup that is required. If missing, the message "How this Program is assigned to Tickets is required." will be displayed on Save. This defaults to blank and is always editable. It can be set to one of the following values:

  • Auto Assign - All Tickets: This will be auto assigned to all ticket lines that match the Program criteria.
  • Auto Assign - Dock Delivery Tickets: This will be auto assigned to all ticket lines that match the Program criteria and where the 'Dock Delivery' ticket property set to "Yes".
  • Auto Assign - Floating Tickets: This will be auto assigned to all ticket lines that match the Program criteria and where the 'Floating' ticket property set to "Yes". 
  • Manually Assigned: This must be manually assigned to a ticket and if manually assigned will apply to all tickets lines that match the Program criteria. 

This lookup contains the values in the APAssignmentMethod Enumeration Class.

Database Field: ERPx_APProgram.AssignmentMethodEN

Assign Rules By

Specifies how premiums are assigned fish tickets. This is a multi-select lookup where at least one selection is required. If missing, the message "Assign Rules By is required." will be displayed on Save. This field defaults as blank and is always editable. When one or more values are selected, on Save, additional tabs for each of the selected items will be added to the record view.

The Assign Rules By field determines the criteria used to calculate Fish Ticket taxes and premiums for a given Program. One or more of the following values may be selected:

  • Species
  • Ticket Items
  • Stat Areas
  • Gear
  • Chill Type
  • Fishermen
  • Management Programs
  • Site Processed

This lookup contains all the values in the APProgramAssignBy Enumeration Class.

Database Field: ERPx_APProgram.AssignRulesByEN

Assign Rate By

Specifies where the Premium Rate comes from. This is a single-select standard lookup that is required. It defaults to "GLOBAL" and is always editable. If it is changed from "GLOBAL", it must match one of the values in the 'Assign Rules By' Property. If not, the message "Assign Rate By must be assigned by one of the Assign Rules By values." will be displayed on Save.

The Assign Rate By field determines where the 'Rate' on a Fish Ticket Tax or Premium is specified, for a given program. The selection must match one of the values assigned in the 'Assign Rules By' property. The potential values include:

  • GLOBAL: The rate assigned as the Default Rate will be used
  • Species: The rate comes from the rate value on the Species Tab
  • Ticket Items: The rate comes from the rate value on the Ticket_Items Tab
  • Gear: The rate comes from the rate value on the Gear Tab
  • Chill Type: The rate comes from the rate value on the Chill_Type Tab
  • Fishermen: The rate comes from the rate value on the Fishermen Tab
  • Management Programs: The rate comes from the rate value on the Management_Programs Tab
  • Site Processed: The rate comes from the rate value on the Site_Processed Tab

This lookup contains all the values in the APProgramAssignBy Enumeration Class except 'Stat Area' and includes an option for GLOBAL.

Database Field: ERPx_APProgram.AssignmentMethodEN

Default Rate

Identifies the 'Rate' (Tax Amount or Premium Amount) of a Fish Ticket Tax or Premium Program. This rate is used for all Programs with an 'Assign Rate By' property set to "Global". This is also the default rate assigned to all lines on the additional tabs when the 'Assign Rate By' is set to anything other than Global. This is a text box that is required. If missing, the message "Rate is required." will be displayed on Save. It defaults to "0.000000" and is always editable.

(lightbulb) Leaving this as 0.000000 and the 'Assign Rate By' to "GLOBAL" and the 'Calculated On' on anything other than "Fixed Amount" will result in no tax being calculated.

(lightbulb) If the 'Assign Rate By' is anything other than 'GLOBAL" this is only represents the Default Rate. The actual rates may be different. 

Database Field: ERPx_APProgram.Rate

Calculated On

Identifies the value used, for each applicable ticket line, for calculating Fish Ticket Premiums. This is a single-select standard lookup that is required. If missing, the message "Calculated On is required." will be displayed on Save. It defaults to blank and is always editable. It can be set to the following values:

  • Delivered Weight: The ticket line item's ('Weight' * Tax Rate) 
  • Net WeightThe ticket line item's ('Net Weight' * Tax Rate) 
  • Paid WeightThe ticket line item's ('Net Weight' * Tax Rate) but only for applicable ticket items where the Price <>0.00

This lookup contains all the values in the APProgramCalcMethod Enumeration Class where APProgramCalcMethod = 2,3,5.

Database Field: ERPx_APProgram.APProgramCalcMethodEN

Group: Accounting
Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is a single-select lookup that is required.  If missing, the message "Premium Expense GL Account is required." will be displayed on Save. This defaults as blank and is always editable.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgram.DRAccountSK

Chill_Type Tab 

This tab will only be visible if "Chill Type" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Chill Type

Identifies the Chill Type that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Chill Types are assigned. If you want only specific Chill Types to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Chill Type(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' records in the Chill Type Master List.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 7

Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This field is only enabled when "Chill Type" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 7

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Chill Type" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 7

Fishermen Tab 

This tab will only be visible if "Fishermen" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Fisherman

Identifies the Fisherman, Fisherman & Tender or Tender that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Fishermen, Fishermen & Tenders, and Tenders are assigned. If you want only a specific Fisherman, Fisherman & Tender or Tender to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Fisherman, Fisherman & Tender or Tender that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' Fishermen, Fishermen & Tenders and Tenders.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 4

Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is single-select standard lookup that is not required. This field is only enabled when "Fishermen" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 4

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Fishermen" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 4

Gear Tab 

This tab will only be visible if "Gear" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Gear

Identifies the Gear that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Gear are assigned. If you want only specific Gear to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Gear that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' records in the Gear Master List.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 2

Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is single-select standard lookup that is not required. This field is only enabled when "Gear" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 2

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Gear" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 2

Management_Programs Tab 

This tab will only be visible if "Management Program" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Management Program

Identifies the Management Program that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Management Programs are assigned. If you want only specific Management Programs to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Management Program(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' records in the Management Programs Master List.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 5

Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is single-select standard lookup that is not required. This field is only enabled when "Management Programs" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 5

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Management Programs" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 5

Site_Processed Tab 

This tab will only be visible if "Site Processed" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is single-select standard lookup that is not required. This field is only enabled when "Site Processed" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 8

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Site Processed" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 8

Site

Identifies the Site that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Sites are assigned. If you want only specific Sites to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Site(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' records in the Sites list view.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 8

Species Tab 

This tab will only be visible if "Species" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is single-select standard lookup that is not required. This field is only enabled when "Species" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 1

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Species" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 1

Specie

Identifies the Specie that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Species are assigned. If you want only specific Species to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Specie(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' records in the Species Master List.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 1

Stat_Areas Tab 

This tab will only be visible if "Stat Areas" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is a non-editable text box that is not required. The value for this field is saved from the 'Premium Expense GL Account' value selected in the Properties tab, but is not displayed and is not enabled in the Stat Area grid.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 3

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a non-editable text box that is not required. The value for this field is saved from the 'Default Rate' value entered in the Properties tab, but is not displayed and is not enabled in the Stat Area grid.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 3

Stat Area

Identifies the Stat Area that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Stat Areas are assigned. If you want only specific Stat Areas to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Stat Area(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' Stat Areas.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 3

Ticket_Items Tab

This tab will only be visible if "Ticket Items" is selected in the 'Assign Rules By' property.

Toolbar IconsDescription
Add Item Adds a blank line in the grid to allow for data entry. If a valid Item ID is entered, the line will be saved. If not, the 'Item Lookup' window will open allowing users to search for the Item.
Column Filter Show/Hide Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Excel

Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. 

Group By Show/Hide Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total. 
Quick Column Filter Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Remove Items Removes the selected line(s). When clicked, you are prompted with the message "Are you sure you want to delete n item(s)? Okay or Cancel". This cannot be done on transactions with a Status of 'Approved', Ready to Post', 'Posted', 'Closed', 'Void', or 'Replaced'.
Saved Layouts Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).  Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected.  

Please note that existing saved grid layouts will display the Filter Row as hidden by default.

FieldsDescription
CheckboxUsed to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Premium Expense GL Account

Identifies the GL Account that is Debited to record the expense side when the Premium is assigned to a Fish Ticket Item. This is single-select standard lookup that is not required. This field is only enabled when "Ticket Items" is selected as the 'Assign Rate By' value in the Properties tab. This field defaults to the 'Premium Expense GL Account' value selected in the Properties tab and is always editable.

The Account can be easily added or updated using the quick replacement feature, for information on how this works please see this FAQ.

The lookup contains a list of all the 'Active' GL Accounts.

Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 6

Rate

Identifies the premium rate for a specific line on a Premium Program. This is a text box that is not required. This field is only enabled when "Ticket Items" is selected as the 'Assign Rate By' in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable. If the field is enabled and left blank, it will default to "0.000000" on Save.

Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 6

Ticket Item

Identifies the Fish Ticket Item that the Premium Program applies to. This is a single-select standard lookup that is required to save a line item. By default, when a new Premium Program is created, all Fish Ticket Items are assigned. If you want only specific Fish Ticket Items to apply to the Premium Program, click the ‘Add Item’ icon and manually add the Fish Ticket Item(s) that you wish to apply. This field defaults as blank and is editable.

This lookup contains a list of all the 'Active' Fish Ticket Items.

Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 6

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details