Hi Experts,
I’m looking for some guidance and validation around automating project creation from Sales Orders via scripting.
Current Standard Behavior
In standard NetSuite functionality, we can create project records using the “Create Projects from Sales Transactions” page.
From this page:
- The system lists Sales Order line items that are pending project creation.
- We can select the applicable lines.
- Upon clicking Create Projects, NetSuite:
- Creates Project records.
- Links the created Project to the respective Sales Order line (at line level).
- Ensures proper association between the transaction line and the project for downstream processing (e.g., billing, revenue recognition, reporting).
This works well in the standard process.
My Requirement
I am trying to automate this process. Rather than creating projects from “Create Projects from Sales Transactions” page.
The goal is:
When a Sales Order is approved, a Workflow Action Script should:
- Identify applicable Sales Order lines.
- Create corresponding Project records via scripting.
- Tag/associate the created Project to the relevant Sales Order line (line-level project field).
Essentially, I want to replicate the same outcome as the “Create Projects from Sales Transactions” page, but automatically during Sales Order approval.
My Questions
I would appreciate insights on the following:
- Revenue Recognition Impact
- If I create the Project via script (instead of using the standard “Create Projects from Sales Transactions” page), will there be any impact on:
- Revenue Recognition schedules?
- Revenue arrangements?
- Allocation or forecasting?
- Revenue Calculation / Reporting Risks
- Does the standard “Create Projects from Sales Transactions” process perform any additional behind-the-scenes logic that could affect:
- Revenue elements
- Project revenue rules
- Forecasting
- Billing schedules
- If I bypass that page and create the project directly via script, could I be missing system-level logic?
- Will this behave exactly the same as when the project is created via the standard UI page (Create Projects from Sales Transactions)?
- If I:
- Create the Project record,
- Populate all required fields,
- Set the
job/customerproject field correctly on the Sales Order line.
Experts’ ideas, suggestions, and recommendations are greatly appreciated.
Thank you in advance!