Ensure accurate date and time formatting for seamless data communication with NetSuite.
Date Format: 'M/D/YYYY'
Time Format: hh:mm AM/PM
For Date Format: a. Log in to NetSuite. b. Navigate to Setup > General preferences > Company c. Verify the date format under the Date/Time Format section.
For Time Format: a. Log in to NetSuite. b. Navigate to Setup > General preferences > Company c. Verify the time format under the Date/Time Format section.
Date Format:
Check the default NetSuite date format, 'M/D/YYYY.'
If changed, share the updated format with the HotWax integrations team.
Ensure the HotWax integrations team adjusts the date format in CSV imports for entities like sales orders, cash sales, and inventory adjustments.
Time Format:
Confirm the default NetSuite time format is 'hh:mm AM/PM.'
If modified, update all export map/reduce SuiteScripts.
Ensure these adjustments align with the client's last run date-time data.
By following these steps, you can easily check and verify the NetSuite date and time formats, ensuring accurate communication with the HotWax integrations layer and seamless data handling in export processes.
Efficiently set up SFTP for seamless data transfer with NetSuite.
From the Home dashboard, select the Setup link located in the top-right corner. Under the "Custom" section, choose SFTP Configuration and click the New function.
In the "SFTP Servers" section, click the "New SFTP Server" button.
Choose the "Preferred SFTP Configuration" form by default. Complete the details in the CUSTOM FORM.
Setting up a default directory is required for the SFTP connection to work. Please obtain this from the system admin team.
SFTP GUID
Unique identifier for the SFTP configuration in NetSuite.
Yes
SFTP SERVER
The address or domain of the SFTP server.
Yes
USER ID
The username associated with the SFTP user.
Yes
PORT
The port number used for SFTP communication (default is 22).
Yes
HOST KEY
Authentication key provided by the SFTP server.
Yes
DEFAULT FILE DIRECTORY
The default directory on the SFTP server for file operations. Example: /home/-sftp/netsuite/
Yes
TEST FILE FOR SFTP CONNECTION
A sample file used to test the connection with the SFTP server.
No
TEST DOWNLOAD FOLDER ID
Identifier for the folder used in testing download operations.
No
REPORT DATE TIMEZONE
Timezone setting for reporting purposes.
No
RETRY FILES FOLDER ID
Identifier for the folder where retried files are stored.
No
SCRIPT ID
Identifier for any associated scripts or automation.
No
After entering the required details, click the "Save" button.
Ask the administration team to generate an RSA private key for the SFTP server in PEM format and they will share a file containing the generated key with you.
Navigate to Setup > Company.
Click on "Keys."
Select "Create New" and name the file "sftp-private-key."
Provide a random ID.
Go to the "File" segment and upload the PEM file received.
Wait for the upload process to complete.
Save the configuration.
Now, in the ID column, you will find the generated key (e.g., custkey999) representing the SFTP GUID.
To enable SFTP communication, it is necessary to define SFTP locations where NetSuite will put the required files in the specified format. To set up these SFTP locations, you can go ahead and execute a SuiteScript added below in NetSuite, which will generate the necessary locations on the SFTP server.
Effortlessly set up SuiteCloud Development Framework (SDF) in NetSuite with step-by-step instructions.
From the Home dashboard, go to the Customization tab in the main menu.
Choose SuiteBundler > Search & Install Bundles > List.
Click on the New button.
Enter the unique name for the bundle: SFTP Connection Tool - Password GUID and press enter.
Instantly view the new bundle in the search results.
Click on the result SFTP Connection Tool - Password GUID to access the Bundles detail page.
Click on the Install button (both Install buttons are functionally identical).
Confirm the installation.
Search for your bundle and observe its status; if it's pending, patiently wait.
If necessary, navigate through pages to check the installation progress.
Discover how to set up SuiteCloud Development Framework (SDF) in NetSuite with this comprehensive guide.
The SuiteCloud Development Framework (SDF) is a robust tool empowering developers to craft and deploy customizations for NetSuite accounts.
Before developers can leverage the SuiteCloud Development Framework (SDF) for development within a targeted NetSuite account, specific features must be activated by an account administrator. These features establish the essential infrastructure for SDF to function effectively. Follow the steps outlined in the official documentation for enabling SDF features.
In addition to administrator-level configurations, developers intending to utilize SDF with a NetSuite role must undergo additional setup. This ensures developers have the necessary permissions and access for effective use of SDF capabilities. For detailed instructions on setting up a developer role for SDF, refer to Oracle's documentation.
It's essential to note that these configurations require active involvement from developers. Therefore, thoroughly review and follow the provided documentation to ensure the successful establishment of SuiteCloud Development Framework capabilities within the NetSuite environment.
Follow this checklist to complete the integration: