Accrual IDs are the unique identifier for Accrual programs.This is a single select lookup that refreshes the page to show the details for the Program selected.

Database Field: ERPx_CPAccrual.AccrualItem

 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. 

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 "Accrual ID is required." will be displayed on Save. This value must be unique. If not, the message "Duplicate Accrual ID's are not allowed." will be displayed on Save. This field is always editable and must be <= 25 characters. 

Database Field: ERPx_CPAccrual.AccrualItem

Identifies the date the Program starts. Tickets with a 'Delivered Date' on or after the 'Start Date' will be evaluated for the Program. This is a date picker that is required. If missing, the message "Start Date is required." will be displayed on Save. This defaults as blank on new records and is always editable. 

Database Field: ERPx_CPAccrual.StartDate

 Identifies the date the Program ends. Tickets with a 'Delivered Date' on or before the '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 Program never ends, but if a date is entered it must be >= the 'Start Date' field. Else the message "End Date must be on or after the Start Date." will be displayed on Save.  

 Database Field: ERPx_CPAccrual.EndDate

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 required and defaults to "No" if unassigned on new Programs. This is always editable.

Database Field: ERPx_CPAccrual.IsInactive

Specifies how Accruals are assigned to 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 CPAssignRulesBy Enumeration Class.

Database Field: ERPx_CPAccrual.AssignRulesByCSVEN

Specifies where the Accrual Rate comes from. This is a single-select standard lookup that is required. It defaults as blank and is always editable. If it is changed, 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 CPAssignRateBy Enumeration Class.

Database Field: ERPx_CPAccrual.AssignRateByEN

Identifies the value used, for each applicable ticket line, for calculating Ticket Accruals. 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. Identifies the values used for determining Ticket Accruals. It can be set to one of the following values:

• % Gross $: The Accrual is calculated by multiplying the ticket items extended amount by the Accrual 'Rate'.
• Delivered Weight: The Accrual is calculated by multiplying the ticket items 'Total Weight' by the Accrual 'Rate'.  This does not convert to the UOM specified.
• Paid Weight: The Accrual is calculated by multiplying the ticket items 'Total Weight' by the Accrual 'Rate' for only line items with a non-zero 'Amount'.  This does not convert to the UOM specified.

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

Database Field: ERPx_CPAccrual.AccrualCalcMethodSK

Identifies the "Default" rate/percentage of the Accrual. This defaults to 0.0000 for new records but is not required to be changed. This field is always editable. The number format of this column is not right. It should be Decimal as this may be a $ Rate or percentage.

 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.

 This only identifies the default rate. However, the actual Rates may be different if the "Assign Rate By" property is not set to "Default Rate".

Database Field: ERPx_CPAccrual.Rate

Identifies the GL Account that is Debited to record the expense side of the Fish Ticket Tax Program paid by the Company. This is a single-select standard lookup that is required if "Company" is selected in the 'Expense For' property. If missing, the message "Company Expense 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 Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.DRAccountSK

Identifies the GL Account that is Credited, to record the liability, for a Fish Ticket Tax. This is a single-select standard lookup that is required. If missing, the message "Tax Liability 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 Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.CRAccountSK

Identifies the name of the Vendor assigned to the transaction or master file. This is set in the Vendor Record View.  This is a single-select standard lookup that is not required. It defaults to blank and is always editable.

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

Database Fields: ERPx_APVendor.VendorName, ERPx_CPAccrual.VendorSK

 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. 

A single select lookup to assign a Crop to the Accrual Program. This is only visible when "Crop" is selected in the 'Assign Rules By' value in the Properties tab.By default, when a new Accrual Program is created, all Crops are assigned. If you want only specific Crops to apply to the Program, click the ‘New’ icon and manually add the Crop(s) that you wish to apply. 

This lookup contains a list of all the records in the Crops Master List.

Database Fields: ERPx_CPCrop.Crop, ERPx_CPAccrualCrop.CropSK

Identifies the tax rate used for calculating the portion of the tax payable by the fisherman. This is a text box that is not required. This field is only enabled and required when "Crop" is selected as the 'Assign Rate By' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable to any amount >= 0.

Database Fields: ERPx_CPAccrual.Rate ERPx_CPAccrualCrop.Rate

 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. 

Identifies the Item, displayed as Item ID: Item Description.  A single select lookup to assign an Item to the Accrual Program. This is only visible when "Item" is selected in the 'Assign Rules By' value in the Properties tab. By default, when a new Accrual Program is created, all Items are assigned. If you want only specific Items to apply to the Program, click the ‘New’ icon and manually add the Item(s) that you wish to apply. 

This lookup contains a list of all the records in the Ticket Items List View.

Database Fields: ERPx_CPItem.ItemDescription, ERPx_CPAccrualItem.ItemSK

Identifies the tax rate used for calculating the portion of the tax payable by the fisherman. This is a text box that is not required. This field is only enabled and required when "Item" is selected as the 'Assign Rate By' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab and is always editable to any amount >= 0.

Database Fields: ERPx_CPAccrual.Rate, ERPx_CPAccrualItem.Rate