NetSuite Export Errors, Tips and Tricks

NetSuite Export Errors, Tips and Tricks

Lightyear Error Messages ... found on the Activity thread of the bill in question

Failed to export invoice [The total cannot be negative.]

Reason for Error - NetSuite requires documents with a value of < 0 to be a credit note, not a negative bill/invoice. 
Solution - If you are getting this error message, return the bill/invoice to the Review tab, then change the document type to one of the credit note types (as shown below), click Save, then sign off on the document once again.  The document should now export to NetSuite without issue




Failed to export invoice [Invalid entity reference key xxx.]

Reason for Error -  The entity (supplier/vendor) you are trying to send a bill to in NetSuite is either Inactive in NetSuite, or is perhaps not shared in NetSuite with the subsidiary that you connected this Lightyear account through to.
Solution - in NetSuite, and make the entity (supplier/vendor) active or available for the subsidiary, then try to re-export from Lightyear.

Failed to export invoice [Invalid customform reference key 50.]

Reason for Error -  Lightyear writes bills to the standard default forms in NetSuite (for bills, form 50).  This error is telling Lightyear that the form in Inactive.
Solution - in NetSuite, make Form 50 active again.

Failed to export invoice [Invalid account reference key XXX for subsidiary X.]

Reason for Error - The GL code is not shared in NetSuite with the subsidiary that you connected this Lightyear account through to.
Solution - in NetSuite, make the GL code XXX available to the subsidiary, then try to re-export from Lightyear.





      

    Check out release notes for Q2 2021



      • Related Articles

      • How does my data appear in NetSuite?

        Where to find your bills in NetSuite Once you've exported your bills from Lightyear into Netsuite, head over to Transactions > Payables > Enter Bills > List in NetSuite to bring up the list of bill records.  Here, you'll be able to search or click ...
      • Error Messages Returned from accountsIQ Upon Export

        Lightyear has a ton of built in validation checks to ensure the data is correct in Lightyear before trying to send the bill and information to accountsIQ. However, there are occasions when the export fails and Lightyear displays the reason for the ...
      • Connecting to Netsuite

        Make sure you're logged into Netsuite as an admin There's quite a few steps required to get your Netsuite integration up and running, but this is only a one time set up and will not need to be completed again unless you wish to connect another ...
      • Netsuite Tax Groups

        Will Lightyear allow you to import Tax Groups from Netsuite? Yes. Lightyear can indeed work with Tax Groups from Netsuite. This can be done however, you will need to contact Lightyear Support to activate this setting.  Please contact support with a ...
      • Sending a URL from Lightyear to NetSuite

        If you want to have your NetSuite files receive and present the URL linking back to the image file in Lightyear, you will need to configure NetSuite to accept it. Lightyear sends the URL in a field called _lightyear (Note: Netsuite will auto the ...