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
...
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.
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
Toolbar Icons | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Delete |
| ||||||||
Edit |
| ||||||||
Excel |
| ||||||||
Favorites |
| ||||||||
Grid Layout |
| ||||||||
Help |
| ||||||||
New |
| ||||||||
Fields | Description | ||||||||
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:
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 | ||||||||
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 records, but is required.
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: ERPxERPx_ APProgramSPProgramHeader. CompanyExpenseAccountSKProgramEntitySK | ||||||||
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.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 | ||||||||
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:
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 Save. This 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 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 | ||||||||
Program Class | Identifies 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:
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 | ||||||||
Description | 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 | ||||||||
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 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:
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 in. This 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 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 | ||||||||
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:
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 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 | ||||||||
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:
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 | ||
---|---|---|
| ||
Page Definitions |
...