-
Importing partner commissions?
Does anyone use the commissions import feature to import PARTNER commissions? I ask because.... -- The Import button is on the Transactions > Commissions > Authorize Partner Commissions page, but the Help system only refers to importing employee commissions (and when you click the Import button, you get the popup with a…
-
How to resolve an issue about not seeing the paycheck history in the Employee Center?
Is anyone else having an issue of not seeing the paycheck history in the Employee Center? This is happening in both standard and customized employee center roles.
-
SuiteAnalytics column negative scale issue
Hey, I'm using ODBC connection and NetSuite2.com and running the following sql to columns metadata: received: TABLE_NAME; COLUMN_NAME; DATA_TYPE; TYPE_NAME; OA_LENGTH; OA_PRECISION; OA_SCALE itemBinQuantity; onhand; 8; DOUBLE; 8; 38; -127 ItemFulfillmentPackage; packageweight; 8; DOUBLE; 8; 20; -127 Can anyone please…
-
CTE query with ODBC
Hi, I am trying to query Netsuite via (excel) ODBC to find sales order number associated to Credit Memo. Since most of our Credmem are created from invoices (but sometimes are more complicated), I am trying to create a recursive SQL query but it doesn't work and I wonder if it is the ODBC connector that prevents it ? Or my…
-
Pay Terminated Employees After Termination/Release Date
Hello, Occasionally we need to pay employees a severance. Senario: Employee is officially terminated on 1/22/2022 Employee needs to be paid until 3/22/2022 Payroll processing will not pull in that employee once the termination/release date is prior to the last paid date. We use the onboarding/offboarding plans so the…
-
Commission is not calculating
I have went to Setup-Sales -Sales Managment and made sure commission is set tup: Set up both Employee schedule: And Set up Commission Plan and assigned the sales rep to each: But when I go to transaction-commission-approve or even Individual employee commission..it is blank.Nothing is being calculated...
-
Update Commission Schedules
Is there any way to update a commission schedule using CSV Import or Mass Update?
-
Commissions - odd situation
How could the following be setup in Netsuite? 2 different commission plans are offered to employees. Each is based on a different calculation of sales. Our thought is we can put one value in the ASA field and the other in a custom line item field. Could this work for creating the employee commission schedule in Netsuite?…
-
Setting Up an Employee for Commission Payments
Setting Up an Employee for Commission Payments To make commission payments to an employee, you must create a commission earning item and add it to the record of each employee to whom you want to pay a commission. [h=3]Note: An administrator must turn on the Payroll feature before setting up an employee for commission…
-
0% Commission Rate with Quota Tier Advancement Only
Hi, Can anyone shed some light on the following use case. We have a Primary Rep assigned to an Opportunity (Invoice) and in certain situations we'll also have a Secondary Rep assigned. The Primary Rep should receive full commission payout based on their Commission Schedule and Quota Credit to be placed within the proper…
-
Commission set-up?
Hi, Can anyone please help with how to set up these commissions in NetSuite? We base our employees commission on the gross profit of the sales order. The commission is paid once the invoice has been paid. This can be a difference of months. Also there are different brackets for commission so depending on what business was…
-
Commission on Profitability per Transaction Total
We are looking to change our commission criteria from a "Per Transaction Line Item" to "Per Transaction Total" but we would still like to categorize the commissions by departments. This appears to be a limitation within NetSuite as the "Categorized By:" drop-down is not available when selecting "Per Transaction Total".…
-
Multiple commissions and quotas
Our sales team have multiple targets that contribute to their commissions. e.g. New sales target (sales from new customers) Reoccurring sales target (sales from existing customers) New accounts setup Each KPI has 3 tiers (achieving, exceeding, blowing away) which carry differing weights/values We have set these up using…
-
Commission on Quota for Partners
I have a customer who commissions their partners based on a quota. I see the "Commission on Quota" option is available for employee commission schedules, but not for partner commission schedules. Why would this feature not be made available to partner commission schedules as well as employee commission schedules? Is there…
-
Commissions on Revenue
Is it possible to setup a schedule so that a rep only receives commission when Revenue is recognized for deferred sales?
-
Linear (Target Factor) Commission Defect w/ Quota?
We had a Netsuite rep tell us that there's a defect with trying to setup a commission schedule based on quota w/ the following settings: Commission on: Quota (Sales Amount) per: Quarterly (fiscal year) Categorized by: blank Eligible Amount: Billings Calculation Scale: Linear Rate: Target Factor Target Amount: $1000 If % of…
-
Marginal Commissions on Transaction Total
We've got a need to do marginal commissions on a per-transaction (ASA) and not per-quota basis. Our company is hoping to do: X% on the first $Y of each SO X-1% on the rest of the balance. I know we can do marginal on Quota, but we need this on a transactional level. Can it be done? For example: 5% on first $25k 3% on the…
-
Paid on Collections
If you check Eligible Amount > Collection, and check 'Commission eligible on Invoices paid in full only' what happens if we issue a credit memo, due due cancellation? Basically my question is would the commission module interpret the invoice balance zero-ing out as, the invoice was paid in full and therefore pay commission…
-
Commission to calculate costs derived from purchases, for travels,marketing etc. - best practices?
As the subject states, we are looking for a way to handle commissions using the incentive compensation module. 1. Sales get commission based on sales - this is fine. 2. Sales get commission based on sales - (minus) their costs that are registered in the form of purchase orders. Are there any best practices around this? We…
-
Work Calendar As Period
Can you use the work calendar to set the YTD period in commission plans?
-
Modifying Commission Amounts in Partner Commissions programatically
Hello, I need to be able to import a CSV to update the commissions for a Partner in the Partner Commissions module, WITHOUT clearing other commissions that are scheduled for the transactions in the CSV import. Currently I have to go through and do it manually by editing the "Amount" for each line of each transaction. I…
-
Partner Commission Schedule
Hi, We are trying to set up a partner commission schedule to be calculated on sales per calendar year, however the system only has options to set up partner commission on sales per fiscal year. In our scenario, we are an Australian company, so out fiscal year starts in July, however the commissions from our partners are…
-
Calculating on deposit
We want to pay commissions on bookings when the sales order has a fully paid deposit against it and the sales order is pending fulfillment. We have scenarios where an order may not have a fully paid deposit when it is pending fulfillment but when it is shipped. The pending fulfillment and fully paid deposit take multiple…
-
Any way to get a quantity based quota?
I am hoping someone familiar with alternate sales amount and quotas could help? My client sells wireless phones. We've assigned a class to each type by OS, ie a main class of "All Wireless Phones", and then "All Wireless Phones : iOS", "All Wireless Phones : Android", "All Wireless Phones : Blackberry", etc. My goal is to…
-
Several commissions schedules per employee
Hello, I have the advanced commission module. We would like to do the following. For orders placed in the first 60 days as a new customer - Schedule A would be applied For orders placed after the customer is 90 days old - Schedule B would be applied. - These are just sales reps not managers (i know there is some things you…
-
Estimated Commission not taking in schedules based on Period?
Hi, Been playing around with the commission schedules a bit but I am slightly stuck with getting estimated commissions to display properly. I noticed that when running the report "Estimated commission" it mentions that this report was decommissioned in 2011. The Estimated Commissions Report will be decommissioned in…
-
Kits not Calculating on Commissions
We are using the NetSuite Commission module and have noticed that all Kit Sales are not showing up on the Commission Overview reports and are not being included in the commission calculations at all. We have the Kits set up to calculate profit from the Individual items in the Kits but these Sales are missing from the…
-
Sales comission on current payments only.
I´m trying to built a comission plan on Netsuite that´s based on collections, but should take under consideration only invoices paid on time. Meaning, if sale invoice is created and paid on time, sales rep gets X% if paid after 90 days but less 120, then y%, and if paid after 120 days Z%. Created the schedule but is based…
-
Commissions Reports: Visibility of Gross Profit & Sales Team Member %
I am doing the normal hunt-and-peck in reports to try to find the fields I want in commission reports. First, there seem to be two types of reports with the following tables: 1. Commissions Overview + Sales Rep 2. Paid Commissions + Sales Rep I am trying to figure out how to have the following fields appear on either…
-
Alternate Sales Amount & Commissions on Billings?
Looking for some help as we seemed to have hit a bit of a standstill in our exploration of commissions schedules and alternate sales amounts. We have been trying to work on using the built-in fields for commissions purposes, and moving off of calculating permissions on average cost, rather on item defined costs. We set…