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 6 Next »

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

Page Header

Toolbar IconsDescription
DeleteDeletes the selected record(s). When clicked, users will be prompted with: "Are you sure you want to delete the selected records?". Click "OK" to confirm, or "Cancel" to return without deleting. 

WARNING: Records cannot be recovered once they are deleted!

EditOpens the selected record for editing. If a record is not selected, the page will not open.
ExcelExport the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. 
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 LayoutOpens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

New

Allows users to select the type of transaction or record they want to add. The list contains: 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 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 in. This defaults to blank for new records but is required. If not assigned, the message "Program Rate Currency is required." will be displayed on Save. This field is 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_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



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels