My Oracle Support Banner

E1: 42: Commissions in Sales FAQ (P42460/P42110/P42100/P42120/P4210/R42800) (Doc ID 1491642.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

JD Edwards EnterpriseOne Sales Order Processing - Version XE and later
JD Edwards EnterpriseOne Sales Order Entry - Version XE and later
JD Edwards EnterpriseOne Sales Order Management - Version XE and later
JD Edwards EnterpriseOne CRM Sales Order Entry
Information in this document applies to any platform.


 This document contains a list of frequently asked questions on Commissions in Sales Order Processing functionality.

 For details regarding the setup and functionality, please see document "E1: 42: Commissions in Sales (P42460/P42110/P42100/P42120/P4210/P42101/R42800)" (Doc ID 625496.1)

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 Question 1: Is it possible to set up a three-tiered commission structure including a Salesperson (Commission Code 1), a Territory Manager (Commission Code 2) and a Regional Manager?
 Question 2: Is there a way to accrue commissions based on an accumulation of the order totals over the course of a year rather than by sales order? For example, a salesperson might earn 5% commission on the first $5000 in sales. Once sales reach $10,000, the salesperson begins to earn 6% commission.
 Question 3: How is the Commission Currency Code used in P42110?
 Question 4: The Sales Rep Name is not displaying in the Customer Master Commission Lookup, P42140. Why?
 Question 5: There are multiple sales person address numbers who are paid commission, but only one of these is designated as the primary sales person responsible for the account. Is there any way in the EnterpriseOne software to designate one particular sales person address as the "primary" sales person responsible on a sales order?
 Question 1: How can sales commissions be calculated?  
 Question 2: When are commissions calculated?
 Question 3: Why are commissions calculated incorrectly when data is imported from Excel into detail lines in sales order entry?
 Question 4: Prior to the sales order moving to status 999, commissions information can be viewed via the Detail Commissions row exit from within the Sales Order Detail Revisions screen. Why is it that once the SO has reached the 999 status, no lines appear in the Detail Revision screen?
 Question 5: When adding a sales detail line, such as freight or miscellaneous line, at the time of Ship Confirm (P4205) the appropriate commissioned Sales Rep information is not attached to the new detail line. When the same line is manually added to the sales order commission information is attached to the new line. Why isn’t commission information written at Sales Update (R42800) for the new lines added at time of Ship Confirm (P4205)?
 Question 6: The user wants to use the Commission Code 1 (CMC1) field in the Customer Master file to record the salesperson responsible for a sale. If a salesperson is aligned to numerous customer accounts and the employee leaves the company, there will be numerous updates needed when the customer accounts are assigned to a new address book record. Is there a task in EnterpriseOne that automates this turnover issue?
 Question 7: Is there a report to list the data in P42120? Is there a batch or interactive program to start payment of sales commissions?
 Question 8: Is there some way that users can view all OPEN orders (SO, CO, SD) by SalesPerson 1 (alias CMC1, or SLM1 in earlier releases)?
 Question 9: Is it possible to pay salesmen a flat amount of commission, regardless of the value of the order or the number of parts sold?
 Question 10: When attempting to add new commissions setup in P42110 for a sales rep group that is already defined in P42100 and UDC 42/RS, Error 0037 Address Number Invalid is displayed from E1 Release 9.1. Why is this same error not displayed on older E1 releases 8.12 and earlier?
 Question 11: Can you use two groups assigned to Customer Billing Instructions P03013 Commission Lookup and have both assigned to the header and detail commissions (F42160 Commission Look Up table) at SO Entry P4210? 
 Question 12: Where can you see if the invoice for a sales order associated with a Sales rep is open or not? Paid or not?
 Sales Order Entry (P4210) / (P42101)
 Question 1: How does the commission information default from the sales order header to detail? What happens to lines that are already on a sales order vs. new lines?
 Question 2: Why is the error message “Salesperson Code Not in Constants” (ID 0418) displayed when entering a sales order?
 Question 3: Can the Sales Rep be assigned by the Sold To instead of the Ship To?
 Question 4: How can we record zero commission amounts or  minimal commission amounts?
 Question 5: How can commissions be applied for Credit Orders?
 Question 6: When changes are made to a sales order that has advanced preferences applied, they are reverted afterwards, why?
 Sales Commission Preferences
 Question 1: When setting up sales commissions using Advanced Preferences, one needs to set up two salespeople. Salesperson 1 has effective dates of 1/01/2006 - 12/31/2012. Salesperson 2 has effective dates of 10/1/2007 - 09/30/20010.  How can this be set up so that salesperson 2 will not receive commissions on orders that were entered prior to 10/1/2007?   
 Question 2: Why aren’t commissions set up using Advanced Preference Sales Commissions defaulting into the sales order?
 Question 3: Customer is using preference profiles to calculate commissions and would like to group the items based on category codes defined in the item branch plant (UDC 41/9 or 41/S4). Is there any way to resolve the preference by using category codes at the item level?
 Question 4: When using the Commissions Advanced Preference in conjunction with an Advanced Pricing discount using an Adjustment Control Code 6 (Print on Invoice - Detached) adjustment, the discount amount is not factored into the amount of commissions calculated. Is there a way to subtract commissions for the discount amount when using an Adjustment Control Code 6 adjustment?
 Question 5: Which date on the sales order is compared to the effective/expiration date to determine whether or not Advance Preference Commission should be applied?
 Sales Commission Integration
 Question 1: Does the Sales Commission System Integrate with the EnterpriseOne Accounts Payable System?
 Question 2: Does the Sales Commission System Integrate with the EnterpriseOne Payroll System?
 Question 3: Does the Sales Commission System Integrate with the EnterpriseOne Advanced Pricing System?
 Question 1: Beginning with release 8.9, the alias SLSM (Salesperson 1) and SLCM (Salesperson Commission 1) moved from Sales Order Detail (F4211), Sales Order Detail History (F42119), and Sales Order Ledger (F42199) . Where is this information stored?
 Question 2: Beginning with release 8.9, commission information is no longer stored in the Sales Order Detail (F4211) and Sales Order History (F42119) tables. The commission amount field (SCCOMA) stored in the Sales Commissions table (F42005) table is still needed. Where is the commission amount stored?
 Question 3: During an upgrade from Xe to a current release, commission information in the history tables F42019 and F42119 is not loaded into the Commission Header (F42150) and Commission Detail (F42160) tables.  How can historical information be converted to the new tables?
 Question 4: Is there a way to tie a commission line in Sales Commission (F42005) to an Invoice Number?  The client is requesting a monthly commission report. They would like to know the invoice number associated with the commission line(s) in the Sales Commission (F42005) table.  Sales Commission (F42005) provides the sales person number, commission amounts, items, and date invoiced.
 Question 5: After SO entry, why do the values in Order Suffix SFXO field not match in F4211 and F42160?
 Question 6: Is there an interactive application to add records to F42005?  The processing option to update the table was not active when sales update was run over a couple orders.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.