Page Comparison

Identifies the GL Account for the 'Credit' side of the Journal Entry. 

This defaults to (From Item) on new records, indicating that the GL Account is looked up from the Item Master for each item the program applies to as follows:

• For 'Brokerage' Programs - the Item's "Brokerage Accrual (Credit)" Account Type.
• For 'Freight Accrual' Programs - the Item's "Freight Accrual (Credit)" Account Type.
• For 'On Invoice' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Freight Item' on the Item Sets tab, if the program amount is negative.
• For 'Promotion' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Promotion Item' on the Item Sets tab, if the program amount is negative.

This is required for 'Brokerage' and 'Freight Accrual' programs but is not visible or editable for 'On Invoice' or 'Promotion Programs'. If blank, the message "Credit/Accrual Account is required." will be displayed on Save. This field is always editable from the record view for 'Brokerage' and 'Freight Accrual' programs.

This lookup contains a blank value, the current assigned value, a selection for (From Item), and a list of all Active GL Accounts

Linked Database Field: ERPx_SPProgramHeader.CRAccountSK

A lookup to identify the Customer or Vendor that will be paid for each Program with a 'Program Type' of Brokerage (this is not applicable for Freight Accrual, On Invoice, or Promotion Programs). For Brokerage Programs, this defaults as blank on new records, but is required.

• If the 'Settle To' = "AP Invoice - Paid In Full Orders" or "AP Invoice - All Orders" then an AP Vendor must be selected. If blank, the message "Vendor is required." will be displayed on Save. 
• If the 'Settle To' = "AR Credit Memo" then a Customer must be selected. If blank, the message "Customer is is required." will be displayed on Save.

This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' Customers or Vendors, depending on the 'Settle To' value

Linked Database Field: ERPx_SPProgramHeader.ProgramEntitySK

Identifies the GL Account for the 'Debit' side of the Journal Entry. 

This defaults to (From Item) on new records, indicating that the GL Account is looked up from the Item Master for each item the program applies to as follows:

• For 'Brokerage' Programs - the Item's "Brokerage Expense (Debit)" Account Type.
• For 'Freight Accrual' Programs - the Item's "Freight Accrual (Credit" Account Type.
• For 'On Invoice' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Freight Item' on the Item Sets tab, if the program amount is negative.
• For 'Promotion' Programs - the Item's "Sales Account" Account Type, for the Item identified as the 'Promotion Item' on the Item Sets tab, if the program amount is negative.

This is required for 'Brokerage' and 'Freight Accrual' programs but is not visible or editable for 'On Invoice' or 'Promotion Programs'. If blank, the message "Debit/Expense Account is required." will be displayed on Save. This field is always editable from the record view for 'Brokerage' and 'Freight Accrual' programs.

This lookup contains a blank value, the current assigned value, a selection for (From Item), and a list of all Active GL Accounts

Linked Database Field: ERPx_SPProgramHeader.DRAccountSK

The 'Description' property on the Program record. This defaults to blank for new records and is not required but duplicate values are allowed. This field is always editable from the record view and must be <= 200 characters.

The Description is used as a long description/name of the Program.

Linked Database Field: ERPx_SPProgramHeader.Description

A date field to indicate when the Program ends. Programs with an End Date that occurs prior to a Sales Orders Invoice Date will not be evaluated, even if the Program is still Active. This defaults as blank on new records, and is required. If blank, the message "To Date is required." will be displayed on Save. This must must be >= to the Start. If not, the message "The To Date cannot be before the End date" will be displayed on Save.

Linked Database Field: ERPx_SPProgramHeader.EndDate

A hyperlink that shows the value of the 'Program ID'. Clicking on the link opens the record view for the selected Program. 

This defaults from the 'Program Class' and cannot be edited after creation. This field must be <= 15 characters. The 'Program' is made up of two parts, which default from the Program Class on the 'Program Classes' Master File:

• Program Prefix - this is a user defined value that if present will display in front of the 'Next Program ID' value with a space placed between the two values
• Next Program ID - this is a number that auto-increments and is required 

The Program ID is used as a short description and unique identifier of the Program.

Linked Database Field: ERPx_SPProgramHeader.ProgramID

Identifies the value in the 'Class' property of the Sales Program. This defaults to blank for new records but is required. If not assigned, the message "Program Class is required." will be displayed on Save. This field is always editable from the Record View.

The Program Class is used for reporting and to control the Program ID's 

Linked Database Field: ERPx_SPProgram.ProgramClassSK

Identifies 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 from the Record View. 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

Identifies which weight value on the ticket line the Tax is calculated from. This defaults to blank for new records but is required. If not assigned, the message "Calculated On is required." will be displayed on Save. It can be set to the following values:

• % Amount: The calculation for each line item will be ((Ext. Amount + Premiums) * Tax %). The 'Ext. Amount' is calculated as (Price * Weight)
• % Taxable Amount: The calculation for each line item will be (Gross Taxable Amount * Tax %). The 'Gross Taxable Amount' is calculated as ((Tax Price * Weight)+Premiums)
• Delivered Weight: The rate will be multiplied to the 'Weight' value of the ticket item to calculate the Tax Amount.
• Fixed Amount: The tax amount will be manually entered for each ticket item
• Net Weight: The rate will be multiplied to the 'Net Weight' value of the ticket item to calculate the Tax Amount.
• Paid Weight: The rate will be multiplied to the 'Net Weight' value of only applicable ticket items with a Price >0.00 to calculate the Tax Amount.

This field is always editable from the Record View. This lookup contains all the values in the APProgramCalcMethod Enumeration Class.

Linked Database Field: ERPx_APProgram.APProgramCalcMethodEN

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 on the record view. If blank, the message "Company Expense Account is required." will be displayed on Save. This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts

Linked Database Field: ERPx_APProgram.CompanyExpenseAccountSK

Identifies the value in the 'Default Rate' property of the TaxProgram. This defaults to 0.000000 for new records but is not required to be changed. This field is always editable from the Record View. 

 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

Identifies which entity is charged for the Tax. This defaults to blank for new records but is required. If not assigned, the message "Expense For is required." will be displayed on Save. It can be set to one or both the following values:

• Fisherman: The Tax will be deducted from what is owed the Fisherman for the Fish Ticket in order for the Company to pay the tax on behalf of the Fisherman.
• Company: The Tax will be accrued on the Fish Ticket in order for the Company to pay their portion of the tax.

This field is always editable from the Record View. This lookup contains all the values in the APProgramExpenseFor Enumeration Class.

Linked Database Field: ERPx_APProgram.ExpenseForEN

A Yes/No field used to identify if the record is Inactive. If set to 'Yes' then the record is "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then the record is "Active" and can be freely used. 

Linked Database Field: ERPx_APProgram.IsInactive

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 from the record view.

Linked Database Field: ERPx_APProgram.APProgramEnd

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 from the record view.

Linked Database Field: ERPx_APProgram.APProgramStart

Identifies the value in the 'Class' property of the Tax Program. This defaults to blank for new records but is required. If not assigned, the message "Class is required." will be displayed on Save. This field is always editable from the Record View. 

Linked Database Field: ERPx_APProgram.APProgramClassSK

The 'Description' property on the Tax record. This defaults to blank for new records and is required but duplicate values are allowed. If not assigned, the message "Description is required." will be displayed on Save. This field is always editable from the record view and must be <= 100 characters. 

The Program Description is used as a long description/name of the Premium.

Linked Database Field: ERPx_APProgram.APProgramName

Identifies the 'Program Group' assigned to the 'Program Class'. This is a looked up value and can only be changed in the 'Taxes & Premium Classes' master file. The potential values for this include:

• Borough
• City
• Observer
• State
• Other

The values for this field come from the APProgramGroup Enumeration. 

A hyperlink that shows the value of the 'Program ID' property on the Tax record. Clicking on the link opens the record view for the selected Tax. 

This defaults to blank for new records and is required. 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 from the record view and must be <= 50 characters. 

The Program ID is used as a short description and unique identifier of the Tax.

Linked Database Field: ERPx_APProgram.APProgramID

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." will be displayed on Save. This field is always editable from the record view.

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts

Linked Database Field: ERPx_APProgram.CRAccountSK

This value is informational only and always displays as Lbs for Tax program with a Calculated On of either Delivered Weight, Net Weight, or Paid Weight. Edit is not allowed.

Linked Database Field: ERPx_APProgram.UOMSK