Scenario:
The user is importing a CSV file that contains dates formatted as DD-Mon-YYYY (Example 29-May-2025), but their NetSuite preferences are set to MM/DD/YYYY. The user then received the following error:
DISPOSAL_USER_ERROR: DISPOSAL_DATE_ERROR: The disposal date format of XX/XX/XXXX is invalid
This error occurs because the format of the disposal date provided in the CSV file does not match the date format set in the user's preferences. The disposal date is a critical field during the asset disposal process, and NetSuite requires that the date format in the CSV file align with the format set in the user's preferences. When there is a mismatch between these formats, the system fails to recognize the date correctly, resulting in an error.
Solution:
To resolve this issue, the user has two options: either modify the date format in the CSV file to match the format set in the user's preferences, or adjust the date format in the user preferences to align with the format used in the CSV file. Below are the detailed steps for both solutions.
- Option A: Modify the Date Format in the CSV File | The user can open the CSV file and adjust the date format used in the file to match the date format set in their NetSuite preferences. For example, if the user’s preference is set to use the MM/DD/YYYY format, the dates in the CSV file should be updated to this format. The user can manually edit the CSV file or use a script or tool to automate the conversion of the date format in the file.
- Option B: Modify the Date Format in the User Preferences | If the user prefers not to modify the CSV file, they can update the date format in their NetSuite user preferences to match the format used in the CSV file. The following steps outline how to change the date format in the user preferences:
- Navigate to the Preferences Settings: The user should begin by navigating to Home > Set Preferences in the NetSuite menu.
- In the Set Preferences page, the user should click on the General tab to access general preference settings. Scroll down to the Formatting section.
- In the Date Format field, the user should select the date format that matches the one used in the CSV file. For example, if the CSV file contains dates formatted as DD-Mon-YYYY (e.g., 29-May-2025), the user should select this format in the Date Format dropdown.
- After selecting the correct date format, the user should click Save to update their preferences.
Hope this helped!
