Skip to main content
InSource Solutions

NetSuite : Creating Projects

Creating Projects 

Purpose:
Details the proper steps to creating a project from a sales order (SO).
Steps
1. When an email is received from order entry to create a project the following should be included: SO #, Opp #, proposal and purchase order
2. Navigate to sales order in NetSuite and use the status to determine if you can proceed with project creation. To determine the status of the sales order, there will be an indication next to the SO title.
a. Pending Billing or Pending Fulfillment indicates you can move forward with creation.

clipboard_e2b3bcb0a1dc716b018ea1ba2d62aed91.png

clipboard_ef9ac3716230419886f8283d1b287fbb2.png


b. Pending approval indicates you need to contact accounting to understand the reason the SO is on hold.

clipboard_ea7cc16ac5c119a910496744dc07f0030.png


3. If moving forward with project creation, go to sales order in NetSuite and edit

clipboard_e55ce30bc811af48d5e1399e85f96466d.png


4. Next to the project box, there is a + sign, click the + sign.

clipboard_e1b0636e26bcb42ced27bcbe9d457feb5.png


5. A new window will open with the project template. Fill out as much information as possible, some fields may be mandatory. (Mandatory fields can be identified with a * next to the field name, auto generated fields are BOLD)
    a. Project Name-match the title of the proposal
    b. Project Type-Technical Services
    c. Customer PO-Found on customer's purchase order
Note: Customer PO field will show “Error code” until first save of the project record.

clipboard_eedd7582cccb0a3bf713e6d75c1ac5f92.png
    d. Status-Set to 3a - Awarded - PO Received
    e. Account Executive-AE responsible for account
    f. Executive Alert Summary-copy scope from the proposal
    g. Under the Financial tab, Billing Type-Charge Based
    h. Under the Financial tab, Billing Schedule-Daily

clipboard_ee5b60626c84b737e6016d6cb45bf85d3.png


6. Save the project.
7. Return to the sales order window. The new project number should be visible. Click Save on the sales order.

clipboard_e5e9700c92d14526025c2a9c75827fd11.png


8. Navigate to Box.com → Client Folders → Customer Name → Projects
(create directory if necessary) Customer Name = End User on Sales Order
9. Create a new folder for the project. The naming methodology should be Project Number-Project Name (i.e. 10838-Nucor-Upgrade Services)
10. Navigate to Box.com → Client Folders → zzz Generic Structure → Projects
Copy the appropriate structure inside the folder based on the complexity of the project
    a. 99999-Project Name (Large Project)
    b. 99999-Project Name (Small Project)
11. Paste in the newly created project structure
12. Copy the proposal and email into the folder ~Proposal & Estimate.
13. Go back to NetSuite and open the project.
14. Under the Schedule tab, Projects tasks will be generated upon first save of the project.
    • If the estimate workbook was used to quote the project, the project should be setup to mirror the milestones and tasks.
    • Tasks should be uniquely named for each project. When the same task name is used for multiple milestones, a prefix should be added to the task name to indicate which milestone it belongs to. This is critical for timesheet entry and reporting.
    • Tasks auto generated: Project Management, PM, Milestone, Task upon first save of project record

clipboard_e8b01fa2d8512406cfe2740d518c6818a.png
15. Financial
    a. Setup up the rules for:
        i. Fixed fee rules
            1. Manual costs for commissions
        ii. Time-Base rules
            1. Filtering with travel time vs. service time
            2. No manual costs for commissions
            3. Note: If using resource-based rules, must have anyone assigned to the project in the rules.
        iii. Expense-Based rules
            1. Description of planned expenses
**MindTouch articles detailing fixed fee and time-based rules still in development**

clipboard_e623d02c58933a8d11bb8725db7e6470e.png
16. Budget → click Edit on project to enter project information
    a. Cost
        i. Use calculated when possible as this helps verify the schedule that was entered under the milestones and tasks.

clipboard_e1c57ee2b534ca98c1c0d2cec82f2390e.png
    b. Billing
        i. For Fixed price projects, use the calculated values when possible. This helps to verify the information entered under the financial information.
        ii. For T&E projects, it may not be possible to use the calculated as resource assignments may not be made yet.

clipboard_e2ee3628a6777887cedbed063683656e8.png
17. Relationship
    a. Enter primary contact from the proposal. As you type, if the contact is properly associated with the customer, the contact will appear.
    b. Under Role, chose “Primary Contact”
    c. Click the Attach button to assign the contact to the project.
    d. Confirm with account executive of the customer this is the best point of contact.

clipboard_eb35ba43d2aad7c9708289a502db20a5b.png
18. Box Content
    a. Create bookmark to project directory created in step 8 above.
**Refer to Creating a Bookmark in box article**

clipboard_eab01ace580c3a61e00f7f6bbc73ce12d.png
19. Click save on project.
20. Click Set Baseline Button just under the project name.

clipboard_e29afaa3917faf57c15a375d4dddcffef.png
21. Email about project team about the setup. Include:
    1. Order Entry-
        a. Ask to refresh the SO. Once SO is refreshed, can trigger ARO milestones for billing.
        b. Verify any software and hardware materials are ordered and ask for tracking information. Request licenses be added to the project folder.
        c. Including a hyperlink to the project folder in Box is helpful.
    2. People assigned to work on the project
        a. Let them know created, assigned, and ensure time tracking/scope understanding.
        b. Including a hyperlink to the project folder in Box is helpful.
    3. Account Executive
        a. Informs them project is created and someone should be contacting them shortly to discuss sales to delivery transition items.
22. Project Preferences
Once the sales order line items have been refreshed from the project, the Use Allocated Time for Forecast preference needs to be checked on the project
        a. Edit the project
        b. Navigate to preferences tab
        c. Check Use Allocated Time for Forecast
        d. Save

clipboard_ef0708408591129a75b8156851ffb0999.png

  • Was this article helpful?