The purpose of this page is to add, edit, remove, and activate/inactive Tax Programs used on Fish Tickets. Insert excerpt Def - Fish Ticket Tax Def - Fish Ticket Tax nopanel true
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||
Grid Layout |
| ||||||||
Help |
| ||||||||
New |
| ||||||||
Save |
| ||||||||
Fields | Description | ||||||||
Program | Displays the "[Program ID] - [Description]" of the Fish Ticket Tax Program. This is editable by editing either the Program ID or Program Description properties. Database Field: ERPx_APProgram.APProgramID - ERPx_APProgram.APProgramName | ||||||||
Type | Display the 'Program Type'. This is not editable and displays as "Tax". This text box contains the value in the APProgramType Enumeration Class where APProgramType = 2. Database Field: ERPx_APProgram.APProgramTypeEN |
...
Toolbar Icons | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||||||||||
Fields | Description | ||||||||||||||||
Properties |
| ||||||||||||||||
Value |
| ||||||||||||||||
Group: Configuration | |||||||||||||||||
Program ID |
Linked Database Field: ERPx_APProgram.APProgramID | ||||||||||||||||
Description |
Database Field: ERPx_APProgram.APProgramName | ||||||||||||||||
Class | Identifies the Program Class associated with the Tax 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.
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 "Tax". Linked Database Field: ERPx_APProgram.APProgramClassSK | ||||||||||||||||
Landed Date Start |
Database Field: ERPx_APProgram.APProgramStart | ||||||||||||||||
Landed Date End |
Database Field: ERPx_APProgram.APProgramEnd | ||||||||||||||||
Inactive |
Database Field: ERPx_APProgram.IsInactive | ||||||||||||||||
Group: Assign Rules | |||||||||||||||||
How this Program is assigned to Tickets? | Identifies how the Tax Program is assigned to Fish Tickets. This is a non-editable single-select lookup that is required. It defaults to "Auto Assign - All Tickets" and is never editable. This field is not visible until after the record is initially saved. This lookup containsthe values in the APAssignmentMethod Enumeration Class where APAssignmentMethod = 1. Database Field: ERPx_APProgram.AssignmentMethodEN | ||||||||||||||||
Expense For | Identifies who is being charged for the Tax. This is a multi-select lookup where at least one selection is required. If missing, the message "Expense For is required." will be displayed on Save. This defaults to blank and is always editable. It can be set to one or both the following values:
This lookup contains all the values in the APProgramExpenseFor Enumeration Class. Database Field: ERPx_APProgram.ExpenseForEN | ||||||||||||||||
Assign Rules By | Specifies how taxes 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.
This lookup contains all the values in the APProgramAssignBy Enumeration Class. Linked Database Field: ERPx_APProgram.AssignRulesByEN | ||||||||||||||||
Assign Rate By | Specifies where the Tax 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.
This lookup contains all the values in the APProgramAssignBy Enumeration Class except 'Stat Area' and includes an option for GLOBAL. Linked Database Field: ERPx_APProgram.AssignmentMethodEN | ||||||||||||||||
Default Rate |
Database Field: ERPx_APProgram.Rate | ||||||||||||||||
Calculated On |
This lookup contains all the values in the APProgramCalcMethod Enumeration Class. Database Field: ERPx_APProgram.APProgramCalcMethodEN | ||||||||||||||||
Group: Accounting | |||||||||||||||||
Fisherman Expense GL Account |
| single-select load on demand lookup ...A non-editable single-select standard lookup | to specify the GL Account that is Debited to record the fisherman expense portion of a Tax Program for a Fish Ticket Itemthat is required. This defaults to "FISHERMAN SETTLEMENT ACCRUAL ACCOUNT" and is never editable. This value is not stored in the database. | ||||||||||||||
Company Expense GL Account |
| load on demand lookup ... A single-select lookup to specify the GL Account that is Debited to record the company expense portion of a Tax program for a Fish Ticket Item. This defaults as blank on new records, but standard lookup that is required if "Company" is selected in the 'Expense For' property. If | blankmissing, the message "Company Expense Account is required." will be displayed on Save. | This field This defaults as blank and is always editable. | This The lookup contains a list of all the 'Active' GL Accounts. Database Field: ERPx_APProgram.CompanyExpenseAccountSK | ||||||||||||
Tax Liability GL Account |
| load on demand lookup ... A single-select lookup to specify the GL Account that is Credited, to record the liability, when the Tax is assigned to a Fish Ticket Item. This defaults as blank on new records, but is required. If blank, the message "Tax Liability GL Account is required.standard lookup that is required. If missing, the message "Tax Liability GL Account is required." will be displayed on Save. | This field This defaults as blank and is always editable | from the record view. | This The lookup contains a list of all the 'Active' GL Accounts. Database Field: ERPx_APProgram.CRAccountSK | ||||||||||||
Payable To |
This lookup should only include Vendors with a Vendor Type EN of 1. It should be the same as the lookup to assign a Vendor to an AP Invoice. It should be the same as the lookup to assign a Vendor to an AP Invoice Tom, I believe you wrote this note. However, this lookup is currently displaying all fishermen as well. Do you want me to open a dev item on it? This lookup contains a list of all the 'Active' Fishermen, Tenders, Fishermen & Tenders and Vendors. Database Field: ERPx_APProgram.VendorSK | ||||||||||||||||
Payable Frequency | Identifies how often you pay the Tax. This is for information only. This is a text box | ... A text box to specify how often the tax is paid. This field that is not required. It defaults to blank | , is never required and is always editable. | Database Field: ERPx_APProgram.VendorSK |
Species Tab
This tab will only be visible if "Species" is selected in the 'Assign Rules By' property.
Toolbar Icons | Description | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Excel |
| |||||||||||
Delete |
| |||||||||||
New |
| |||||||||||
Fields | Description | |||||||||||
Checkbox |
| |||||||||||
Company Expense GL Account |
| load on demand lookup ... A single-select lookup to specify the GL Account that is debited for the company expense when a Fish Ticket line item is a specific Speciestandard lookup that is not required. This field is only enabled when "Species" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is | not required, but always editable. | This The lookup contains a list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 1 | ||||||||
Company Rate |
A text box to specify the tax rate for the Company for a specific Specie. This field is only enabled when "Species" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab, but the field is always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160. Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 1 | |||||||||||
Fisherman Expense GL Account |
A non-editable text box to display the GL Account that is debited to record a fisherman expense when a Fish Ticket line item is a specific Specie. This field only displays a value when "Species" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The field defaults to "Fisherman Settlement Accrual Account", is required and is never editable. This field is not stored in the database. | |||||||||||
Fisherman Rate |
A text box to specify the tax rate for the Fisherman for a specific Specie. This field is only enabled when "Species" is selected as the 'Assign Rate By' value and "Fisherman" is selected as the 'Expense For' value in the Properties tab. The Rate defaults to the 'Default Rate' value entered in the Properties tab, but the field is always editable. If the tax is configured to be an expense for a Company and a Fisherman, then the default rate is divided between the company and the fisherman and the company rate is rounding up and the fisherman rate is rounding down. E.g. a default rate 1.654321 would default the company rate to 0.827161 and the fisherman rate to 0.827160. Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 1 | |||||||||||
Specie | Identifies the Specie that the Tax Program applies to. This is a text box ... A single-select lookup to specify Species that are applicable to the Tax Program. By default, when a new Tax Program is created, all Species are assigned. If you want only specific Species to apply to the Tax Program, click the ‘New’ icon and manually add the Specie(s) that you wish to apply. This field defaults as blank on new records, but is required to save a line item. This field is not editable after initial Save. 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 | |||||||||||
Tax Liability GL Account |
| load on demand lookup ... A single-select lookup to specify the GL Account that is Credited to record the liability when the Tax is assigned to a specific Speciestandard lookup that is not required. This field is only enabled when "Species" is selected as the 'Assign Rate By' value in the Properties tab. The GL Account defaults to the 'Tax Liability GL Account' value selected in the Properties tab. This field is | not required, but always editable. | This The lookup contains a list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 1 | ||||||||
Total Rate | Identifies the Total Rate of the Tax. This is a calculated field ... , calculated as the sum of the 'Fisherman Rate' and the 'Company Rate'. A non-editable text box to display the Total Rate per Specie, which is calculated as the sum of the Fisherman Rate and the Company Rate for the Specie. This field is never editable. This field is a calculated field and not stored in the database. |
Ticket_Items Tab
This tab will only be visible if "Ticket Items" is selected in the 'Assign Rules By' property.
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Company Expense GL Account |
A single-select lookup to specify the GL Account that is debited for the company expense when a Fish Ticket line item is on a sales order. This field is only enabled when "Ticket Items" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is not required, but always editable. This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 6 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 6 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 6 | ||||||||
Tax Liability GL Account |
This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 6 | ||||||||
Ticket Item |
This lookup contains a list of all the 'Active' Fish Ticket Items. Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 6 | ||||||||
Total Rate |
|
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Company Expense GL Account |
Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 3 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 3 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 3 | ||||||||
Stat Area |
This lookup contains a list of all the 'Active' records in the Stat Areas Master List. Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 3 | ||||||||
Tax Liability GL Account |
Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 3 | ||||||||
Total Rate |
|
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Company Expense GL Account |
A single-select lookup to specify the GL Account that is debited for the company expense for specific Gear associated with a Fish Ticket. This field is only enabled when "Gear" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is not required, but always editable. This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 2 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 2 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 2 | ||||||||
Gear |
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 | ||||||||
Tax Liability GL Account |
This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 2 | ||||||||
Total Rate |
|
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Chill Type |
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 | ||||||||
Company Expense GL Account |
A single-select lookup to specify the GL Account that is debited for the company expense for specific Chill Types associated with a Fish Ticket. This field is only enabled when "Chill Type" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is not required, but always editable. This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 7 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 7 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 7 | ||||||||
Tax Liability GL Account |
This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 7 | ||||||||
Total Rate |
|
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Company Expense GL Account |
A single-select lookup to specify the GL Account that is debited for the company expense for a specific Fisherman, Fisherman & Tender or Tender associated with a Fish Ticket. This field is only enabled when "Fishermen" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is not required, but always editable. This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 4 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 4 | ||||||||
Fisherman |
This lookup contains a list of all the 'Active' records in the Fishermen & Tenders list view. Database Field: ERPx_APProgramEntity.EntitySK where ERPx_APProgramEntity.ProgramEntityEN = 4 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 4 | ||||||||
Tax Liability GL Account |
This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 4 | ||||||||
Total Rate |
|
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Company Expense GL Account |
A single-select lookup to specify the GL Account that is debited for the company expense for specific Management Programs associated with a Fish Ticket. This field is only enabled when "Management Programs" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is not required, but always editable. This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 5 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 5 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 5 | ||||||||
Management Program |
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 | ||||||||
Tax Liability GL Account |
This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 5 | ||||||||
Total Rate |
|
...
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Excel |
| ||||||||
Delete |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
Checkbox |
| ||||||||
Company Expense GL Account |
A single-select lookup to specify the GL Account that is debited for the company expense for specific Sites where a Fish Ticket was processed. This field is only enabled when "Site Processed" is selected as the 'Assign Rate By' value and "Company" is selected as the 'Expense For' value in the Properties tab. This field defaults to the 'Company Expense GL Account' value selected in the Properties tab. This field is not required, but always editable. This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.ExpenseAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 8 | ||||||||
Company Rate |
Database Field: ERPx_APProgramEntity.CompanyRate where ERPx_APProgramEntity.ProgramEntityEN = 8 | ||||||||
Fisherman Expense GL Account |
| ||||||||
Fisherman Rate |
Database Field: ERPx_APProgramEntity.FishermanRate where ERPx_APProgramEntity.ProgramEntityEN = 8 | ||||||||
Site |
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 | ||||||||
Tax Liability GL Account |
This lookup contains list of all the 'Active' GL Accounts. Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 8 | ||||||||
Total Rate |
|
...