Error Messages Returned from accountsIQ Upon Export

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 error - you will see a warning message with information like the below, directing you to view the document's Activity History.



Here are some of the most common errors Lightyear receives, presented in [brackets]:

Failed to export invoice [Line 1 TAX_CODE_IS_NULL]

A Tax Code needs to be set on each line on the bill. 

Return the bill to Approvals, and select a Tax Code for the line giving the error message.

You should now be able to export to accountsIQ.

Failed to export invoice [The specified stock GL account code does not exist or is not a Posting account. Please create it first before attempting to use it.]

The chosen GL code in Lightyear either does not exist in accountsIQ, or is set to a Control account in the General Ledger.

If it does not exist, it will need to be created.

If it is set to a Control account, you can either change it to Posting, or select another GL code in Lightyear.

Failed to export invoice [No Service Item found. Please select a service item from the dropdown in Accountancy Software Settings]

You have not selected a Default Service Item during the account setup. Go to Accountancy Software > Accountancy Software Settings, and under Default Service Item, select from the dropdown.



      

    Check out release notes for Q3 2021

     June  July  August 


      • Related Articles

      • Troubleshooting MYOB Error Messages

        [[BusinessEvent_DateOccurred_InLockPeriod; DateOccurred:(PurchaseEvent); BusinessEvent_DateOccurred_InLockPeriod; InventoryDateOccurred:(PurchaseEvent)]] Translation: Locked Period in MYOB If you are trying to export to a locked period, you will be ...
      • Troubleshooting Xero Error Messages

        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 Xero.  However, there are occasions when the  Export fails and Lightyear displays the reason for the error ...
      • Exporting from Lightyear to AccountsIQ

        From the Signed Off tab in Lightyear, select the invoices you want to export and press the Export to accountsIQ button. Any invoices that you have selected will be exported to accountsIQ.  Once exported, these invoices can be found under the relevant ...
      • AccountsIQ Integration Setup Guide

        Connecting to accountsIQ Setting up and connecting Lightyear to accountsIQ is a quick and easy process. From the left hand ribbon, head over to Settings > Acounting Software > Select accountsIQ > Connect. A popup will display asking for a User Key ...
      • 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 ...