Content Comparison

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". 

Database Field: ERPx_APProgram.APProgramClassSK

A date field to indicate when the Tax Program begins. Fish Tickets with a Landed Date before the 'Landed Date Start' will not be evaluated for the Tax. This defaults as blank on new records, but is required. If blank, the message "Landed Date Start is required." will be displayed on Save. This field is always editable.

Linked Database Field: ERPx_APProgram.APProgramStart

A date field to indicate when the Tax Program ends. Fish Tickets with a Landed Date after the 'Landed Date End' will not be evaluated for the the Tax, even if the Tax Program is still Active. This defaults as blank on new records, and is not required. A blank Landed Date End assumes the Tax never ends but if a date is entered it must be >= the 'Landed Date Start' if not, the message "Landed Date End must be on or after Landed Date Start." will be displayed on Save. This field is always editable.

Linked Database Field: ERPx_APProgram.APProgramEnd

Linked Database Field: ERPx_APProgram.IsInactive

This defaults to blank for new records, but at least one selection is required. If not assigned, the message "Assign Rules By is required." will be displayed on Save.

This field 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

 A single-select lookup to specify where the Tax Rate comes from. This defaults to "GLOBAL" for new records but can be changed. 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. It can be set to the following values:

• 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 field is always editable. 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

A text box to specify the default rate to be used if the 'Assign Rate By' field is set to "GLOBAL". This defaults to 0.000000 for new records and is required. If not assigned, the message "Rate is required." will be displayed on Save. This field is always editable. If the tax is configured to be an expense for the company and the fisherman, the default rate is automatically divided. If this causes the rate to be more than 6 decimals, then the company rate is rounded up and the fisherman rate is rounded down.

 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.

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

Linked Database Field: ERPx_APProgram.Rate

A non-editable single-select lookup to specify the GL Account that is Debited to record the fisherman expense portion of a Tax Program for a Fish Ticket Item. This defaults to "FISHERMAN SETTLEMENT ACCRUAL ACCOUNT" and is never editable. This value is not stored in the database.

 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 is required if "Company" is selected in the 'Expense For' property. If blank, the message "Company Expense Account is required." will be displayed on Save. This field is always editable.

This lookup contains list of all the 'Active' GL Accounts.

Linked Database Field: ERPx_APProgram.CompanyExpenseAccountSK

 A single-select lookup to specify which Fisherman, Tender, Fisherman & Tender or Vendor the Tax is payable to, such as the Vendor associated with the taxing authority. This field defaults to blank, is never required and is always editable. 

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

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

Linked Database Field: ERPx_APProgram.VendorSK

 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 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. 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.

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

 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.

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

 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.

 A single-select lookup to specify the GL Account that is Credited to record the liability when the Tax is assigned to a specific Specie. 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 lookup contains list of all the 'Active' GL Accounts.

Linked Database Field: ERPx_APProgramEntity.LiabilityAccountSK where ERPx_APProgramEntity.ProgramEntityEN = 1