Notes on Working with Jobs (Projects) using the SuiteTalk NetSuite API
Table of Contents
Jobs are a confusing part of the NetSuite system. Here’s some notes and resources to help make handling jobs easier:
- Jobs are named Projects in the GUI
- There are two versions of jobs: “standard” and “Advanced Jobs”. They both use the same core job record but change how the data is structured on the customer.
- Jobs have a
kcustomerattribute that is not accessible via SuiteTalk which represents the customer that the job is associated with. This field is accessible via SuiteScript. You could most likely expose this field by creating a formula field on the job record with{kcustomer}as the formula. - There is no
customerfield on the job schema - However, there is a
customerfield on the job search columns. You can use an advanced search to return the customer associated with a job. - If “Project Management” is enabled (aka
ADVANCEDJOBS) theentityreference on the customer is a customer during the edit view, but will switch to be a job reference when the record is saved. - When
ADVANCEDJOBSis disabled thejobreference could be either a customer or a job and thejobfield is not displayed. - The
parentfield on a job can reference a customer. I believe you can have an heirarchy of jobs so it can be possible for theparentto be a job reference. Since thekcustomerfield is not exposed via SuiteTalk the only way to determine the correct customer reference is to walk up the hierarchy.
References: