I would like to ask for guidance or best-practice recommendations on handling Contracts with Multiple Customers in NetSuite.
Current Setup:
- Contract is configured as a Project Segment.
- We have 1 Mother Contract (e.g., Rental of equipment for 1 year / 365 days).
- The Mother Contract covers 3 different customers, and each customer negotiates their own rental period.
- Each customer issues a PO, and we create a separate Sales Order with its own Contract (i.e., Sub-contract under the same Mother Contract).
Client Concern:
When issuing SOs for each customer, they want to ensure that:
- Total rental days across all 3 customers do not exceed 365 days (shared cap).
- Total Contract Value (CV) also must not exceed the Mother Contract limit.
- System should accumulate usage from all individual customer “sub-contracts.”
- Users need to see remaining balance (days + value) available under the Mother Contract.
Objective:
Looking for a solution or configuration approach where each customer’s individual contract / SO behaves like a sub-contract, and:
- Rental (days & value) is withdrawn from the Mother Contract, and
- Mother Contract shows updated balance after each SO is created.
Questions:
- Is there a standard NetSuite functionality (Project, Project Budgets, Revenue Arrangements, Project Tasks, or Contract Renewals) that supports this shared-capacity model?
- Alternatively, has anyone implemented a customization (custom records + SuiteFlow + SuiteScript) to manage:
- Mother Contract capacity
- Sub-contract usage reservation
- Preventing over-booking beyond 365 days or contract value
- Any recommendations on structuring the data model (Mother Contract > Sub Contract > SO) to ensure accurate tracking and reporting?