Setting up Sage 300 in Lightyear

Setting up Sage 300 in Lightyear

Lightyear allows you to export your bills in a pre-set CSV format, which can then be uploaded directly to Sage 300.  

To get started, head to the Accountancy tab in Lightyear > Under Accountancy Software, select Sage 300.  

Once done, you'll need to start importing your settings from Sage. Let's look at these individually

Software Settings

Departments:  You may use departments within Sage to help track of your bills, you may not. if you do, select Yes. This will add the Departments section to the Accounting Software screen where you can upload you departments.  You can then apply departments on a line by line level in Lightyear and set rules to automatically assign Departments.  

Details Setting :   Within Lightyear, you have 3 options related to what is populated in the 'details' field. 
  1. 'Use Nominal Description' -  If you select this option, Lightyear will populate the details section of each individual line with the Description of the relevant nominal code that applies to that line.  This is the Default setting/
  2. 'Do not populate' - This option will leave the Details field empty when you export.  Use this option if you do not want any details information or if you prefer to manually add the details within the CSV export.   
  3. The third option is available in the in-tray.  You will notice a 'details' option in Panel 2.  If you enter text into this field in panel 2, that text will populate on all the lines for the CSV export.

Supplier Accounts

These are your Accounts within Sage, and are used so Lightyear knows which supplier to associate any given bill with. To set up a Supplier Card, you'll be asked for a Supplier Name and an Account Reference. The Supplier Name is just used as an identifier in Lightyear, but the Account Reference would need to be the 3 digit Account Reference code for that supplier within Sage. 

You can edit any of the Supplier Cards by clicking on the Green pencil

You can bulk upload your supplier Accounts via the 'Upload CSV File' Option located above the supplier table.  



Nominal Codes

These are your Nominal Codes, or Nominal Account References, within Sage. Lightyear requires the 3 digit Nominal Code and a description or label to go along with these.
‚Äč

Tax Rates



While you can add as many tax rates to Lightyear as you wish, please note that you will only have one default taxed and one default tax free rate. Enter your Tax Code from Sage (TXX), a description and the rate. Super Simple. The In Use box will be checked by default, so it's ready to use as soon as it's created.

Please note that all the above can be added quickly and easily using Bulk Upload.

And with that, the setup is done! You can now start exporting bills to Sage.




      

    Check out release notes for Q3 2021

     June  July  August 


      • Related Articles

      • Setting up Sage 200 in Lightyear

        Sage 200 Setup Please note - CSV Templates are attached to this article. Please use them when importing information to your Lightyear Account from Sage. Lightyear allows you to export your bills in a pre-set CSV format, which can then be uploaded ...
      • Adept Middleware for Sage 50 advanced import

        Why Should I Use Adept? 1) Import line item detail into Sage 50 2) View currency conversion rates of foreign currency invoices 3) Create new suppliers, when new invoice data is imported 4) Multi company auto recognition upon import Adept is an ...
      • Exporting from Lightyear into Sage 50

        NOTE - SAGE 200 and SAGE 300 have different export formats.  Please reference the respective support material for the version you are using as linked. Once the initial Set Up is done, sending your bill data through to Sage is very easy. Let's take a ...
      • Exporting from Lightyear into Sage 200

        NOTE - SAGE 50 and SAGE 300 have different export formats.  Please reference the respective support material for the version you are using as linked.  Once the initial Set Up is done, sending your bill data through to Sage is very easy. Let's take a ...
      • Exporting From Lightyear into Sage 300

        NOTE - SAGE 50 and SAGE 200 have different export formats.  Please reference the respective support material for the version you are using as linked.  Once the initial Set Up is done, sending your bill data through to Sage is very easy. Let's take a ...