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 our
    Product Blog Series
    to stay up to date

      • Related Articles

      • Netsuite Integration Setup Guide

        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 ...

      • 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 ...

      • Sending Product Code and Quantity from Lightyear to NetSuite

        If you want the extracted Product Code and Quantity on bills and credit notes to export into your NetSuite account, you will need to configure NetSuite to accept it first. Keep in mind, Lightyear currently only writes to two forms in Netsuite, the ...

      • 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 Bill and Purchase Order Matching

        Do you use POs in NetSuite? Would you like your POs in NetSuite to automatically link to the bill and close when the bill is exported from Lightyear? Our new custom SuiteBundle may be just what you’re looking for! What is a SuiteBundle? A SuiteBundle ...