ANS-1220 · REVENUE RECOGNITION
How to Fix ‘Bad SQL Statement’ Error in NetSuite Project Revenue Rules
A 'Bad SQL Statement' error can occur in NetSuite Advanced Revenue Management when a user-created project revenue rule conflicts with a system-generated rule during the 'Update Revenue Arrangement and Plans' process.
Short answer
The 'Bad SQL Statement' error in NetSuite Advanced Revenue Management, when using project revenue rules with charge-based billing, occurs when a manually created revenue rule conflicts with a system-generated one. To fix, rename the user-created rule to avoid the naming clash. This enables the system to create its required rule successfully during the 'Update Revenue Arrangement and Plans' process.
Scenario
When implementing NetSuite Advanced Revenue Management, particularly with charge-based billing where revenue rules are defined directly on projects, users may encounter a 'Bad SQL Statement' error. This typically occurs during the initial execution of the 'Update Revenue Arrangement and Plans' process. The error arises if a user has manually created a revenue rule that shares a name with a project revenue rule that NetSuite attempts to generate automatically when creating a revenue element for the first time.
Solution
To resolve the 'Bad SQL Statement' error, follow these steps:
Identify the manually created revenue rule that is causing the naming conflict. This rule would have been created by a user, potentially with a name similar to a system-generated project revenue rule.
Rename the identified user-created revenue rule. For example, if the conflicting rule was named 'Project Revenue Rule', rename it to 'Project Revenue Rule_2' or another unique identifier.
Execute the 'Update Revenue Arrangement and Plans' process again.Upon successful execution, the system will be able to create its required project revenue rule without conflict, and the process will complete as expected.
Expert NetSuite Support
Need help with this NetSuite issue?
Revenue Recognition consulting and configuration support