Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Sales Programs are used to automate the calculation and general ledger accruals for Brokerage, automate general ledger accruals for delivered freight, and to charge/credit sales invoices for Promotions and other Off Invoice charges. The purpose of this page is to add, edit, remove, and activate/inactive these records.

(lightbulb) Sales Programs are only applicable for Sales Invoices but not Quick Sales transactions.

Software Version: 2019.09.03 and newer

Page Header

Toolbar IconsDescription
Delete
Error rendering macro 'excerpt-include' : No link could be created for 'Delete - Global'.
Edit
Error rendering macro 'excerpt-include' : No link could be created for 'Edit - Global'.
Excel
Error rendering macro 'excerpt-include' : No link could be created for 'Excel - Global'.
Favorites Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

Grid Layout
Error rendering macro 'excerpt-include' : No link could be created for 'Grid Layout'.
Help
Error rendering macro 'excerpt-include' : No link could be created for 'Help - Global Icon'.
New

Error rendering macro 'excerpt-include' : No link could be created for 'New - Multi-Select'.
 options for:

  • Brokerage
  • Freight Accrual
  • On Invoice
  • Promotions
FieldsDescription
Credit Value

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

Customer/Vendor

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

Debit Value

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

Description

The 'Description' property on the Program recordThis 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

End

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

Program

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

Program Class

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











Assign Rate By

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

Calculated On

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

Company Expense Account

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 recordsbut 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 SaveThis 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

Default Rate

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. 

(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 'Globally" this is only represents the Default Rate. The actual rates may be different. 

Linked Database Field: ERPx_APProgram.Rate

Expense For

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

Inactive

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

Landed Date End

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 SaveThis field is always editable from the record view.

Linked Database Field: ERPx_APProgram.APProgramEnd

Landed Date Start

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 recordsbut is required. If blank, the message "Landed Date Start is required." will be displayed on SaveThis field is always editable from the record view.

Linked Database Field: ERPx_APProgram.APProgramStart

Program Class

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

Program Description

The 'Description' property on the Tax recordThis 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

Program Group

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. 

Program ID

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

Tax Liability Account

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 recordsbut is required. If blank, the message "Tax Liability GL Account is required." will be displayed on SaveThis 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

UOM

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

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels