NetSuite cannot read the date or posting period
Compare the saved CSV text with the importing user’s date format and the intended date or period.
The posting period cannot be matched
Message may mention: postingperiod.
What it means
The period value cannot be matched.
Import context: Expense reports.
Check this first
Check the existing period name and whether spreadsheet formatting changed it.
Show the steps
Check dates, periods, and address values
Dates
- Check the importing user's date format in personal preferences.
- Compare the actual CSV text with that format, including the year.
- If the date is ambiguous, establish the intended date from the source. Do not guess whether
04/05is April 5 or May 4. - For a period or time range, verify both ends and any accompanying year or view.
- Recheck the saved file after editing it in a spreadsheet.
Use the first check above for this record type. Their requirements are not interchangeable.
Verify the actual period reference before changing dates or reopening periods. A reference mismatch does not itself establish a closed-period problem.
Documentation checked September 16, 2026.
An effective date is not accepted
Message may mention: effective date.
What it means
The date format doesn't match.
Import context: General imports.
Check this first
Check your preferences.
Show the steps
Check dates, periods, and address values
Dates
- Check the importing user's date format in personal preferences.
- Compare the actual CSV text with that format, including the year.
- If the date is ambiguous, establish the intended date from the source. Do not guess whether
04/05is April 5 or May 4. - For a period or time range, verify both ends and any accompanying year or view.
- Recheck the saved file after editing it in a spreadsheet.
Use the first check above for this record type. Their requirements are not interchangeable.
Documentation checked September 16, 2026.
Amortization dates are reversed or misread
Message may mention: amortization.
What it means
The amortization dates are reversed or misread.
Import context: Journal entries.
Check this first
Check their actual values.
Show the steps
Check dates, periods, and address values
Dates
- Check the importing user's date format in personal preferences.
- Compare the actual CSV text with that format, including the year.
- If the date is ambiguous, establish the intended date from the source. Do not guess whether
04/05is April 5 or May 4. - For a period or time range, verify both ends and any accompanying year or view.
- Recheck the saved file after editing it in a spreadsheet.
Use the first check above for this record type. Their requirements are not interchangeable.
Documentation checked September 16, 2026.
A date produces getFullYear or NaN
Message may mention: getFullYear, NaN.
What it means
A malformed date may be reaching date-processing code.
Import context: Sales orders.
Check this first
Inspect the year and format.
Show the steps
Check dates, periods, and address values
Dates
- Check the importing user's date format in personal preferences.
- Compare the actual CSV text with that format, including the year.
- If the date is ambiguous, establish the intended date from the source. Do not guess whether
04/05is April 5 or May 4. - For a period or time range, verify both ends and any accompanying year or view.
- Recheck the saved file after editing it in a spreadsheet.
Use the first check above for this record type. Their requirements are not interchangeable.
Documentation checked September 16, 2026.
The transaction date is invalid
Message may mention: trandate.
What it means
The transaction date does not match the expected format.
Import context: Transactions.
Check this first
Check the raw value.
Show the steps
Check dates, periods, and address values
Dates
- Check the importing user's date format in personal preferences.
- Compare the actual CSV text with that format, including the year.
- If the date is ambiguous, establish the intended date from the source. Do not guess whether
04/05is April 5 or May 4. - For a period or time range, verify both ends and any accompanying year or view.
- Recheck the saved file after editing it in a spreadsheet.
Use the first check above for this record type. Their requirements are not interchangeable.
Documentation checked September 16, 2026.
Related errors
- Event dates or times are missing or invalid
- Numbers or identifiers changed in the CSV
- NetSuite CSV import says an amount is missing
- The vendor bill total disagrees with its lines
Still stuck?
We can help you work through the file, the mapping, and the NetSuite setup behind the error.
Talk to MySuite