Project Tasks Import from Microsoft Project in NetSuite

The Project Tasks Import feature allows users to import project tasks directly from Microsoft Project plans into NetSuite. This functionality enhances project management by enabling convenient data transfer from Microsoft's platform, streamlining project setup within NetSuite.

Import Methods

There are two available methods for importing project tasks:

• Simplified Import Assistant: This legacy tool has limitations and is set to be deprecated in future releases. It may not provide full functionality compared to the other method.
• Standard CSV Import: Recommended for its improved convenience and capabilities, this method allows for more comprehensive data handling.

Importing Project Tasks

When importing project tasks from Microsoft Project, consider the following requirements:

• Project Management Feature: Ensure that the Project Management module is enabled in your NetSuite account.
• Required Permissions: The user must possess the following permissions:
  • Import CSV File
  • Projects (View level or higher)
  • Project Tasks (Create level or higher)
• Pre-requisites in NetSuite:
  • Create a project record in NetSuite to which the tasks can be added. It is vital to set a start date, as the scheduling for all project tasks hinges on this date. Additionally, make sure that any resources listed in Microsoft Project are included in the Projects' Resources subtab.
  • Edit Employee records for all project task resources by checking the Job Resource box on the Human Resources subtab, allowing the import to include assignments.

For detailed instructions on importing, refer to the document on [Importing Project Tasks from Microsoft Project].

Task Designations

When posting task records, note that each record is classified as either a project task or a milestone task:

• If a task record does not include an estimated work value, it is saved as a milestone task.
• Conversely, if it includes estimated work, it is treated as a project task. For more clarity on the difference, review the section on [Project Tasks].

Related Topics

• [Requirements for Project Tasks Imports]
• [Standard CSV Import]
• [Simplified Import Assistant]

Note: For importing CRM tasks, users with the necessary permissions can utilize the Import Assistant found under Setup > Import/Export > Import CSV Records. This is detailed further in the [Tasks Import] section.

Key Takeaways

• Use the Standard CSV Import for enhanced functionality.
• Ensure Project Management is enabled and necessary permissions are granted before importing.
• Set appropriate start dates and resource assignments in NetSuite for accurate task scheduling.

Source: This article is based on Oracle's official NetSuite documentation.