Prolecto Labs

Prolecto Labs' mission is to drive continuous innovation to solve NetSuite.

Our mission is to drive continuous innovation to solve NetSuite.

Prolecto Accelerator Templates are pre-built to solve tough NetSuite problems. Our consultants tailor them to fit your business - bridging gaps, streaming workflows, and enhancing system capabilities.

Prolecto Commission/Royalty Engine

Installs the Prolecto Commission/Royalty engine which allows users to set up rate cards and filter to generate commission and royalty obligation records from other transactions.


 https://840889.app.netsuite.com/core/media/media.nl?id=7306615&c=840889&h=9S_dDdQ_rQWUSWpzDAe1Xlv2PxRVHj_O02z8meCdzUZ01T34&_xt=.svg-Prolecto Commission/Royalty Engine

Accelerator Templates are included as part of Prolecto client engagements and are not sold individually.

Become a Client ⟶


Prolecto client requests
Prolecto Commission/Royalty Engine

What It Does

The Prolecto Commission/Royalty Engine supports the setup of rate cards to generate commission and royalty obligation records from other transactions.

Why It Matters

With complete control over processing logic, complex incentive commission systems can be natively tracked and managed in NetSuite without worries for ongoing recurring or transaction charges. The tool is offered without transaction or recurring license charges.

Related Articles

• Fundamentals for Driving NetSuite Commissions and Royalties

Understand what is needed to successfully drive commissions and royalties in a NetSuite database driven application.

• Learn How to Eliminate Royalty Tracking Spreadsheet Inefficiencies with a NetSuite-Based Engine

Learn how CFOs and Controllers are eliminating risk and reducing overhead by adopting a license-free, fully integrated royalty engine inside NetSuite without ongoing subscriptions.

• Overcome NetSuite Commission and Royalty Challenges

Solve your NetSuite commission and royalties with an adaptable framework.

• Drive NetSuite Commissions based on Cost Instead of Revenue

Understand how you can drive NetSuite commissions based on costs versus revenue.

• NetSuite Driven Commissions – Your Way

Learn how you can take control and extend NetSuite to meet your specific commission payout challenge.

• NetSuite Transaction Line References Between Invoices and Commissions

Learn the reporting considerations when linking NetSuite invoices with commissions.

• Understand Fundamental Record Structures to Support NetSuite Commission Tracking and Reporting

Learn about key record structures to help track and report on commissions in NetSuite.

Implementation Details

Led by practice: Accounting, supported by Technology team.

Other Data

Build ID 148

Accelerator Versions

Version: 20231027.RC

Enhancements to sublist views for payment linkages.

Version: 20230821.RC

  • Revisions from 20230601
  • Use of grossamount vs. amount on the line to help distinguish from net.

Version: 20230720.RC

  1. Minor refinement

Version: 20230601.RC

  1. New “Gross Revenue” commission basis (independent of discounts).
  2. Option to use Reversing Obligations when Required.
  3. Feature to prevent the bundle from being updated without intention. 

Version: 20230331.RC

Updated logic to show which obligation lines were paid/applied to handle cases where one obligation is completely applied to another obligation.

Version: 20230110.RC

Fixed queries used by payout tool to only include obligations which were not already paid.

Version: 20221118.RC

  1. Add several filters for qualifications, including a check box that makes these work in reverse.
  2. Added support for checkbox-type fields in custom filters.

Version: 20220929.RC

If Payee can’t be determined (eg no sales rep on the source transaction), don’t create an obligation record.

Version: 20220908.RC

  • Refinements for app.setting logic

Version: 20220831.RC

  • Support a single rate card that works for all sales reps
  • Added support to drive commissions based on vendor bills

Version: 20220718.RC

  • Support for defaulting subsidiary from source transaction
  • Enhance logic for deleting associated obligation records when source transaction is deleted. 

Version: 20220523.RC

  • Enhanced for Script Deployment references
  • Button on rate card to reevaluate all related transactions leveraging map/reduce utilities from the central library
  • Enhancements for various date formatting checks. 

Version: 20220426.RC

Enhancement to handle CLASSES and DEPARTMENTS intelligently.

Version: 20220328.RC

New Transaction field to avoid commission calculation which is especially useful after updates to prevent healing (delete/recreate) algorithm from running

Version: 20220311.RC

Pass a representation of the rate to the transaction plug-in that it can be dynamically enhanced, as required, to meet more complex commission/royalty scenarios.

Version: 20220221.RC

  1. Referenced usage guide in menu
  2. Fixed issue with NetSuite presentation of lineuniquekey values on newly created records.

Version: 20220209.RC


Minor refinements.

Version: 20220207.RC

When creating vendor bills and credits to clear an obligation, reference together.

Version: 20220202.RC

  1. Supporting scripts to turn obligations into related vendor bills.
  2. Reverse Selection Exclusion filters.
  3. Expose mechanism to have custom client script exclude the transaction from obligation treatment.

Version: 20211217.RC

Revisions for connection to source transactions to see on agings.

Version: 20211201.RC

Minor refinements.

Version: 20211123.RC

First revision for two client implementations

All Accelerator Templates are available exclusively to the Prolecto client community.