NetSuite Troubleshooting & FAQ

Error during Posting transactions to NetSuite Expense or Timesheet Invalid Employee or Project/Job?

This issue whenever the employee or Project/Job is no longer active in NetSuite or it got deleted from NetSuite or it got added manually in DATABASICS.

To fix this issue, please check the following:

1. Check if the record exists in NetSuite and active and matches the same record in DATABASICS.

2. Check if the start date or end date of the Job or Employee is outside of the period that a timesheet or expense could be recorded.

Error “Please enter value(s) for Cost Category, Department or Class “ when we insert into NetSuite Time Bill, Expense report or Account Payables (Specific related to Vendors) or Journal Entry?

Please check if you have any fields in the Classification section in the expense report if they are required. By default NetSuite uses classifications from the employee record to default the values whenever a report gets created. If the Classification gets customized to require additional fields to be entered for example Cost Category or Class, DATABASICS cannot post transaction that section, the only transactions DATABASICS could post to is the header and detail transactions record but not the Classification that is handled by NetSuite internal calls.

To fix this issue, there should no required fields on the Classification form in Expense Reports, AP and Journal Entry.

Error “Invalid login attempt”?

“Invalid login attempt” is a generic error thrown by NetSuite when there’s something misconfigured in the authentication headers. The best way to troubleshoot this is to use the “Login Audit Trail” search. From there, you should be able to troubleshoot what went wrong with your parameters. It could be that you entered an extra character or blank space to one of your tokens (which is pretty common) or you’re not generating new timestamp or nonce.

To do this, follow these steps from the Help Guide:

1. Go to Setup > Users/Roles > User Management > View Login Audit Trail.

2. Check the Use Advanced Search box.

3. Click the Results subtab.

4. Add the following fields: Detail, Token-based Access Token Name, and Token-based Application Name.

5. Click Submit.

   The Detail column displays error messages for any token-based authentication logins with a status of Failure.

Error messages related to Authorization in NetSuite

Please check the articles below, and I believe you have access to them: 

• Error Messages for the TBA Authorization Flow

• Generating the Signature for the TBA Authorization Flow

• The Signature for Web Services and RESTlets

• Constructing the Signature for Step Three of the TBA Authorization Flow

Invalid search query. Detailed unprocessed description follows. Your current role does not have permission to perform this action.

Make sure you have access the List to query in the role and also make sure you have SuiteAnalytics added to Reports in Role. This is especially important for custom fields created by the client.

Manage Roles > Edit > Permissions > Reports:

• SuiteAnalytics Workbook

Check the following you will need at least these two permissions:

Manage Roles > Edit > Permissions > Setup:

• Log in using Access Tokens

• REST Web Services

Manage Roles > Edit > Permissions > Reports:

• SuiteAnalytics Workbook

• Open

  

For NetSuite, common errors when posting timesheets and expenses to General Ledger (GL) and Accounts Payable (AP) typically result from incorrect configurations, missing data, or permission issues. Below are the most frequent errors and their solutions.