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.
Sales Programs are only applicable for Sales Invoices but not Quick Sales transactions.
Software Version: 2019.09.03 and newer
| Table of Contents | ||
|---|---|---|
|
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 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.
...
The purpose of this page is to add, edit, remove, and activate/inactive these records.Insert excerpt Def - Sales Program Def - Sales Program nopanel true
Sales Programs are only applicable for Sales Orders, Price Adjustments, and Returns. They are not used with Quick Sales transactions.
Software Version: 2022.06.16 and newer
| Table of Contents | ||
|---|---|---|
|
Page Header
| Toolbar Icons | Description | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||
| Delete |
| ||||||||||||||||||||||||||||||||||||||||
| Edit |
| ||||||||||||||||||||||||||||||||||||||||
| Excel |
| ||||||||||||||||||||||||||||||||||||||||
| Favorites |
| ||||||||||||||||||||||||||||||||||||||||
| Group By Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||
| Help |
| ||||||||||||||||||||||||||||||||||||||||
| New |
| ||||||||||||||||||||||||||||||||||||||||
| Notes |
| ||||||||||||||||||||||||||||||||||||||||
| Quick Column Filter |
| ||||||||||||||||||||||||||||||||||||||||
| Refresh |
| ||||||||||||||||||||||||||||||||||||||||
| Saved Layouts |
| ||||||||||||||||||||||||||||||||||||||||
| Fields | Description | ||||||||||||||||||||||||||||||||||||||||
| Checkbox |
| ||||||||||||||||||||||||||||||||||||||||
Accrual Account |
Database Field: ERPx_SPProgramHeader.CRAccountSK | ||||||||||||||||||||||||||||||||||||||||
| Description | Identifies the Description (program name) associated with the Program ID. This is not required, and duplicate values are allowed. This is editable from the Sales Program Record View. Database Field: ERPx_SPProgramHeader.Description | ||||||||||||||||||||||||||||||||||||||||
End | Identifies the Date the program ends. This is required and is editable from the Sales Program Record View. 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. Database Field: ERPx_SPProgramHeader.EndDate | ||||||||||||||||||||||||||||||||||||||||
Expense Account |
Database Field: ERPx_SPProgramHeader.DRAccountSK | ||||||||||||||||||||||||||||||||||||||||
| Inactive |
Database Field: ERPx_SPProgramHeader.Inactive | ||||||||||||||||||||||||||||||||||||||||
Payee | Identifies the Name and ID of the Customer or Vendor that will be paid for the Program, displayed as [Customer/Vendor Name] ([Customer/VendorID]). This is not editable after the initial save and is required for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Database Field: ERPx_SPProgramHeader.ProgramEntitySK | ||||||||||||||||||||||||||||||||||||||||
| Program Class | Identifies the Class the program is assigned to. This is not editable after the initial save and is required.
Database Field: ERPx_SPProgram.ProgramClassSK | ||||||||||||||||||||||||||||||||||||||||
Program ID |
Database Field: ERPx_SPProgramHeader.ProgramID | ||||||||||||||||||||||||||||||||||||||||
| Program Rate Currency |
Database Field: ERPx_SPProgramHeader.CurrencySK | ||||||||||||||||||||||||||||||||||||||||
| Program Type | Identifies the Type of Program. This is required and not editable after the initial save. The Types of Programs include
| ||||||||||||||||||||||||||||||||||||||||
| Settle To | Identifies how the Program will be settled (paid). This is not editable after the initial save and is required for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Accrual programs add journal lines to the Journal Entry that is created when the sales invoice, price adjustment, or return is posted and On Invoice programs add line item to sales orders, price adjustments, and returns that are included in the Journal Entry that is created when they post. The available options include:
Database Field: ERPx_SPProgramHeader.SettlementFrequencySK | ||||||||||||||||||||||||||||||||||||||||
Settlement Frequency | Identifies how often the Program is settled. This is informational only (does not drive any functionality) and is always editable from the Sales Program Record View for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Accrual programs add journal lines to the Journal Entry that is created when the sales invoice, price adjustment, or return is posted and On Invoice programs add line item to sales orders, price adjustments, and returns that are included in the Journal Entry that is created when they post. Database Field: ERPx_SPProgramHeader.SettlementFrequencySK | ||||||||||||||||||||||||||||||||||||||||
Start | Identifies the date the program starts. This is required and is editable from the Sales Program Record View. Programs with a Start Date that occur after a Sales Orders Invoice Date will not be evaluated. Database Field: ERPx_SPProgramHeader.EndDate |
Related Topics
| Expand | ||
|---|---|---|
| ||
Page Definitions |
...