Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Table of Contents
typeflat

Page Header

...

  • Brokerage
  • Freight Accrual
  • On Invoice
  • Promotions

...

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

...

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

...

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

...

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

...

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

...

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

...

Sales Programs are used to automate the calculation and general ledger accruals for Brokerage programs, automate general ledger accruals for delivered freight programs, and to charge/credit sales invoices for Promotions and other Off Invoice programs. 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

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV
Delete - LV
nopaneltrue
Edit
Insert excerpt
Edit - Global
Edit - Global
nopaneltrue
Excel
Insert excerpt
Excel - Global
Excel - Global
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout
Grid Layout
nopaneltrue
Help
Insert excerpt
Help - Global Icon
Help - Global Icon
nopaneltrue
New

Insert excerpt
New - Multi-Select
New - Multi-Select
nopaneltrue
 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 'ActiveSettle To' GL Accountsvalue

Linked Database Field:

 ERPx

ERPx_

APProgram

SPProgramHeader.

CompanyExpenseAccountSK

ProgramEntitySK

Default RateDebit Value

Identifies the value in GL Account for the 'Default RateDebit' property side of the TaxProgramJournal Entry

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 ClassIdentifies the value in the 'Class' property of the Tax Program

(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 From 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

Program Rate Currency

A single select standard lookup to identify the Currency the Program is stated inThis defaults to blank for new records but is required. If not assigned, the message "Class Program Rate Currency is required." will be displayed on Save. This field is always editable from the Record View. not editable after the initial Save. Programs can only be applied to sale transactions where the Customer Currency and the Program Currency match.

This lookup contains a blank value and all the System Currencies that are open to the current Company.

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

Program Type

A system assigned value, from the Program Class, that identifies the Type of Sales Program. The options include: Brokerage, Freight Accrual, On Invoice, and Promotion. This is not editable

Settle Frequency

A lookup to identify how often the Program is settled. This defaults to "Invoice" for all Freight Accrual, On Invoice, and Promotion programs and is not editable. This defaults to blank and is required for Brokerage programs. If missing, the message "Frequency is required." will be displayed on Save.

A Settle Frequency of "Invoice" means that the program is fully accrued for and charged when the Sales Invoice is Posted. All other options are only used for internally information and do not impact any functionality.

For Brokerage Programs, this field is always editable from the record view.

This lookup contains all the values in the SPSettlementFrequency Enumeration Class except "Invoice".

Linked Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Settle To

A lookup to identify who the Program is settled to. This defaults to "Invoice" for all Freight Accrual, On Invoice, and Promotion programs and is not editable. This defaults to 'AP Invoice - Paid In Full Orders' for Brokerage programs but is only editable prior to the initial Save.

The 'Settle To' identifies whether the entity receiving payment or credit is a Customer or AP Vendor and for AP Vendors also identifies your intention for which Invoice should be included. The available options include:

  • "AP Invoice - Paid In Full Orders" - An AP Vendor will be paid when the Program is settled and by default, only Sales Invoices that have been paid in Full will be considered eligible for Settlements
  • "AP Invoice - All Orders" - An AP Vendor will be paid when the Program is settled and by default, Invoices with an open balance will also be considered eligible for Settlements
  • "AR Credit Memo" - A credit memo will be issues to the Customer that is assigned to the Program when it is settled.

This lookup contains all the values in the SPSettlementMethod Enumeration Class except "Invoice".

Linked Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Start

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

Linked Database Field: ERPx_SPProgramHeader.EndDate

Related Topics



Expand
titlePage Definitions

Page Definitions


...