Steps to show how it works:

NetSuite Configuration

1. To connect NetSuite with Odoo, collect the following details:
Account ID, Consumer Key, Consumer Secret Key, Access Token, Access Token Secret Key.

2. You can find the Account ID from your NetSuite URL:
https://{AccountID}.app.netsuite.com/

3. Go to Setup → Integrations → Manage Integrations → New and create a new app as shown in the image below.

4. After saving, copy the Consumer Key and Consumer Secret Key. These values are shown only once.

Retrieving Access Token

1. To retrieve the Access Token and Access Token Secret Key, follow the steps below.

2. Go to Setup → Users/Roles → Access Tokens → New.

3. Fill in the required details as shown in the image below.

4. After saving, NetSuite will generate the Access Token and Access Token Secret Key at the bottom of the page. Save these securely as they will not be visible again.

NetSuite Authentication

1. Enter the credentials retrieved from the previous steps.

2. Click on Build Connection to connect NetSuite with Odoo.

Configuring Subsidiaries

1. Create a new company as a subsidiary in Odoo and set the NetSuite ID (Internal ID) here.

2. If you don't use the multi-company feature in NetSuite, set NetSuite ID as 1 and the name of the subsidiary/company as Parent Company.

Switching Subsidiaries

1. Click your company name in the top-right corner of the Odoo interface, as shown in the screenshot.

2. Select the subsidiary you want to switch to by checking its box, and uncheck the currently active subsidiary. Then click Confirm.

3. From now on, any data you sync will be associated with the subsidiary you have just activated.

Custom Date Range

1. Select this option to choose a custom date range and enter the Start Date and End Date.

2. With the custom date range enabled, all records created in NetSuite between the Start Date and End Date will be synced to Odoo.

Field Mapping

1. To import customers, go to Customers and click on Refresh Columns. This will import all commonly used fields that our client uses to sync NetSuite data.

2. Map the fields by clicking on Add a field in the table. Mandatory fields like Name, NetSuite ID, etc., are already mapped in Odoo by default.

NetSuite Fields

1. Select the field in NetSuite that you would like to map against the appropriate field in Odoo.

NetSuite Fields

1. If you are unable to find your desired field, click on Search More and then click New at the bottom of the page. This will create a new NetSuite field in Odoo.

2. This functionality allows the client to map fields and sync data according to their use cases, rather than relying on the technical team to create new NetSuite fields for them.

Odoo Fields

1. Map the Odoo field you want to link. An example is shown in the screenshot below.

2. Ensure the data type of both fields in a single row is the same. For example, a Text field cannot be mapped to a Numerical field, otherwise it will raise a Field Type Mismatch error.

3. To synchronize other data types (Product, Sale Order, Invoice, Payment, etc.), follow the same procedure.

Data Synchronization

1. This is a sample of field mapping for Customer.

2. Once you have mapped all the desired fields, click on Import to synchronize the data.

Queue Based Approach

1. A queue-based system is implemented to manage API access limitations. Tasks are processed in the order they arrive, similar to a line at a store.

2. The system shows different queues, such as the Customer Address Queue, which displays the NetSuite record number and its state (To Be Executed or Done).

3. This approach helps efficiently manage and monitor task processing.

Logger

1. A logger has been incorporated in the module to keep track of any errors or Odoo-side warnings encountered while syncing data from NetSuite to Odoo.