Sales Programs are used to automate the calculation of accruals that will be settled at a later date (Brokerage, Rebate, and Off Book programs), charges and/or discounts that need to show on a customer invoice (On Invoice programs), and expense/accruals that need to post with the sales transaction (Accrual programs). The purpose of this page is to add, edit, remove, and activate/inactive these records.

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

Page Header

Toolbar Icons	Description
Column Filter Show/Hide	Toggles between displaying and hiding a filter row in the grid under the column headers. The filter row will be displayed by default if the Quick Column Filter is also implemented in the page. When enabled, this will allow users to type in text to filter by a specific column.
Delete	Deletes 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!}
Edit	Opens the selected record for editing. If a record is not selected, the page will either not open or will open the first record (depending on how the page was coded).
Excel	Exports the contents of the grid 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, or excluded columns, only the contents in the grid 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. Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
Group By Show/Hide	Toggles between displaying and hiding a row in the grid above the column headers to enable grouping by one or more column(s). Once displayed, users may drag and drop column headers to group by a specific column. Once the grid is grouped by a column(s), a subtotal footer row will display in the grouping for columns that have a page footer total.
Help	Opens the online WIKI help page for the current page. 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 available options include: Accrual Brokerage Off Book On Invoice Rebate
Notes	Opens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled.
Quick Column Filter	Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text.
Refresh	Re-queries the contents of the grid/page based on the Search Options or the default values for grids that do not support Search Options. This ONLY re-queries the contents of columns that are currently visible, if you add a new column the contents will be empty until you click 'Refresh' again.
Saved Layouts	Displays the column layout lookup and related icons. This tool allows users to select a previously saved layout, create a new layout, save changes to a layout, forget/delete a layout and/or assign a saved layout as the default for the page. Once changes are made to the layout, such as columns are added or removed, the user can click the Save Layout icon and save the changes to the column layout. The visibility of the Filter Row is also saved with a saved layout. The new layout can also be set as the default. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific). Default layouts can be removed by clicking the 'Set as Default' button again when the current default layout is selected. Please note that existing saved grid layouts will display the Filter Row as hidden by default.
Fields	Description
Checkbox	Used to select one or more records to perform an action, such as Mass Update, More Actions, or Delete.
Accrual Account	The GL Account that is Credited to record the liability from a (positive amount) Sales Program. This is required and editable from the Sales Program Record View for Accrual, Brokerage, Off Book, and Rebate Programs. 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	The GL Account that is Debited to record the expense from a (positive amount) Sales Program. This is required and editable from the Sales Program Record View for Accrual, Brokerage, and Rebate Programs. Database Field: ERPx_SPProgramHeader.DRAccountSK
Inactive	Identifies if the record is "Inactive". If inactive (set to "Yes"), it will not be included in look-ups for transactions or other master files. If set to "No" or blank, the record is active and can be freely used. This is a Yes/No value that is required and is editable from the Sales Program Record View. 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. Program Classes are used to classify and group programs by Program Type: Brokerage, On Invoice, Accrual, Rebate, and Off Book. Database Field: ERPx_SPProgram.ProgramClassSK
Program ID	Identifies the short description and unique identifier for Tax, Premium, Charge, Accrual and Sales Program. Clicking on the link opens the record view for the selected Program. This is not editable after the initial save. Program IDs are the unique identifier for Sales Programs. Database Field: ERPx_SPProgramHeader.ProgramID
Program Rate Currency	Identifies the 'Currency' that Program Amounts are calculated in. This is required and not editable after the initial save. Programs can only be applied to sale transactions where the Customer Currency and the Program Currency match. 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 Accrual: Accrual programs use Sales Transactions to automate rule-based journal entries that are included with the Sales transaction's Journal Entry and are not visible to the customer. They can be used for rule-based delivered freight, royalties, and other taxes that are paid for by the company. Brokerage: Brokerage programs use sales transactions to account for and store the details of an expense that will be paid to a vendor in the future. The expense and accrual entries are included with the Sales transaction's Journal Entry and the details are added to the Broker Balance sub-ledger. When Brokerage programs are 'Settled', AP Invoices are created to debit the accrual account and credit the Vendor's Accounts Payable account. This moves the sub-leger balance from the Broker to the Vendor. Off Book: Off Book programs use Sales Transactions to automate rule-based entries to an Off Book sub-ledger. These balances can be paid (to a customer or vendor) in the future or written off. These programs do not impact the General Ledger when the Sales transaction is posted, and they are not visible to the customer. They only impact the General Ledger when they are Settled. When they are 'Settled', AP Invoices or AR Credit Memos are created to debit the programs assigned 'Expense Account' and credit the Vendor's Accounts Payable or Customer's Accounts Receivable account. This moves the sub-leger balance from the Broker to the Vendor. These are often used to keep a tally of money that can be used for food shows and other marketing activities. Balances that are written off have no impact on the General Ledger. On Invoice: On Invoice programs automate adding additional line items to Sales Transactions (i.e., Promotional Discounts, Sales Tax, or rule-based Freight charged to a customer). These line items are included with the Sales transaction's Journal Entry and are visible to the customer. Rebate: Rebate programs use sales transactions to account for and store the details of an expense that will be paid to a vendor or credited to a customer in the future. The expense and accrual entries are included with the Sales transaction's Journal Entry and the details are added to the Rebate Balance sub-ledger. When Rebate programs are 'Settled', AP Invoices or AR Credit Memos are created to debit the accrual account and credit the Vendor's Accounts Payable or Customer's Accounts Receivable account. This moves the sub-leger balance from the Rebate to the Vendor/Customer. Open Rebates balances can also be applied to open sales transactions when applying payment receipts.
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: AP Invoice - Paid In Full Orders: Sales Invoices that have been paid in full will be considered eligible for Settlement to the Payee assigned to the Program. AP Invoice - All Orders: Sales Invoices that have been posted, regardless of payment status will be considered eligible for Settlement to the Payee assigned to the Program. AR Credit Memo: Sales Invoices that have been posted, regardless of payment status will be considered eligible for Settlement as an AR Credit Memo for the Payee assigned to the Program. 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

NorthScope

Programs List View

Page Header

Related Topics

Page Definitions

Technical Details