What data goes to Netsuite?

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 onto the bill you're looking for and you will be able to see the bill record in detail.

What does the data look like in NetSuite?

Follow the above and you will be able to view the details of the record including your bill details, descriptions, line amounts, GL codes, Tax codes etc.

Note: You can also set up some custom fields to send to NetSuite which will need some configuration set up as outlined below. 
  1. Lightyear sends the URL of the document in a field called custbody_lightyear.  See here for set up guidance
  2. The PO number is in the custbody_lightyearponumber field.  See here for set up guidance


Click to enlarge






      

    Check out release notes for Q2 2021



      • Related Articles

      • How does my data appear in MYOB?

        Where to find your bills in MYOB  Once you've exported your bills from Lightyear into MYOB, head over to your Purchases > Purchases Register to bring up the list of bill records.  Here, you'll be able to search or click onto the bill/s you're looking ...
      • 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 ...
      • 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 ...
      • 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 ...