Before you can pull data from NetSuite to NSPB, a user with an Administrator role must first set a file encryption password. This encrypts the CSV files that contain the Saved Search results.
To set the file encryption password:
- Go to Planning & Budgeting > Setup > File Encryption Password
- Enter a new password
- Click Save
Take note of the following password requirements:
- Has exactly 16, 24, or 32 characters.
- Contains one or a combination of the following character types:
- Uppercase alpha characters (A, B, ... Z)
- Lowercase alpha characters (a, b, ... z)
- Numbers (1, 2, 3, 4, 5, 6, 7, 8, 9, 0)
- Non-alphanumeric ASCII characters, for example !@#$%^&*.:;-'`”/\+?_|=()[]{}<>
An error message will be returned if the password is not compliant. See below example message:
Notes:
- This is a one-off task and will only need to be set up or changed at specific circumstances.
- If you have already properly set up the file encryption password but you are still encountering the error: "SPLIT_FILE_ERR : Planning & Budgeting file encryption password missing or invalid." during NSPB data load, there could be other configurations that are not correctly set up. NSPB Sync also returns this error message for other unidentified issues not related to file encryption password. In this case, you may reach out to NetSuite Support for further assistance.
You can check SuiteAnswers ID: 92111 for reference.
Make sure to follow the New to NetSuite category to be notified when new articles are posted.
