Skip to main content

NetSuite Export Errors and How to Resolve Them

  • Updated

Below are some common NetSuite export errors you may see when exporting transactions from Float. Each entry below explains what the error means and how to resolve it.

Please note: You must be an Administrator in Float to export transactions to NetSuite.

If you have any questions or you don’t see the error you’re encountering here, reach out to us at support@floatfinancial.com.

 

Important to resolve export issues

If you haven't already, we recommend migrating to the NetSuite Managed Role before troubleshooting further:

NetSuite Managed Role Migration Guide 

 

Where to see the Export Errors in Float:

Card Transactions:

  1. Transaction Export > Ready to Export
  2. Select the transaction > Required to Export
  3. The export error will be displayed in the "Export Errors" section

Reimbursements:

  1. Reimbursements > Payments or All Reports
  2. Select the report.
  3. The export error will be displayed at the top of the report

Bill Pay:

  1. Bill Pay > Payments or All Bills
  2. Select the bill
  3. The export error will be displayed at the top of the bill

 

Common Export Errors and How to Resolve Them:

Accounting Period has Closed

Accounting Sync has Failed

Invalid Account Type Used

Field 'approvalstatus' does not exist in 'journalentry' record

 

Accounting Period has Closed

How to resolve:

  • Unlock the accounting period in NetSuite (if possible)
  • Manually create the transaction in NetSuite
  • Adjust the posting date

 

Accounting Sync has Failed

This is a general error message that you will see in Settings > Accounting Sync if there has been an issue with the connection between Float and your accounting system.

How to resolve:

  • In Settings > Accounting Sync > Select the "Reconnect" button and follow the prompts to reconnect NetSuite to Float

 

Invalid Account Type Used

This error indicates that the accounts set up in NetSuite are not using the correct account types.

How to resolve:

  1. In NetSuite, open your Clearing Account > Set Account Type to Clearing Account > Set the Type to Bank or Credit
  2. In Float, go to Settings > Accounting Sync > Sync
  3. Go to Bill Pay > Payments or All Bills > Open the bill
  4. Select the "Re-Export" button

 

Field 'approvalstatus' does not exist in 'journalentry' record

This happens when Float's Approval Status setting (Settings > Accounting Sync > Approval Status) is set to Pending, but NetSuite's Journal Entry record isn't set up to receive an approval status.

How to resolve:

Before going into NetSuite to update the Journal Entry approval status, we recommend migrating to the NetSuite Managed Role before troubleshooting further:

NetSuite Managed Role Migration Guide

 

Once complete, retry the card export to see if the new managed role resolved the issue. 

If not, you'll need to fix this error in NetSuite:

  1. In NetSuite:
    • Go to Setup > Accounting > Accounting Preferences > Approval Routing tab, and turn on Require Approvals on Journal Entries
  2. In Float
    • Go to Settings > Accounting Sync and confirm Approval Status is set to Pending
    • Re-export the transaction in Transaction Export > Ready to Export > Select "Export" beside the transaction

For more on how this setting works, see How do NetSuite Exports Work?

Related articles