Exports from Lightyear to QuickBooks Online can fail for a few reasons, most often a dropped connection, invalid integration credentials, a closed accounting period in QuickBooks Online, or a validation error on the bill or invoice. When an export fails, Lightyear displays a warning message with the error reason and directs you to the document's Activity History.
Find your issue
Find the symptom you see, then follow the matching section below.
If you see... | Go to... |
An invoice is stuck and its transaction date falls in a closed accounting period | |
A warning message with an error from QuickBooks Online |
Invoices stuck due to closed accounting periods
If an invoice's transaction date falls within a closed accounting period in QuickBooks Online, the export fails until the period is reopened.
Open the closed accounting period
If your export fails because the invoice date falls within a closed accounting period, reopen the period in QuickBooks Online.
Log in to QuickBooks Online.
Click the gear icon, then click Account and settings.
Click Advanced, then click Accounting.
Update the closing date, then click Save.
Return to Lightyear, then retry the export from the Signed Off tab.
Fix error messages from QuickBooks Online
Lightyear runs built-in validation checks to make sure the data is correct before it sends a bill and its information to QuickBooks Online. If an export still fails, Lightyear displays the reason in a warning message. Find the message below to see its cause and fix.
Business Validation Error: The transaction needs to be in the same currency as the A/R and A/P accounts you use
This error occurs when the Vendor in QuickBooks Online is set up in a different currency than the invoice. For example, if the invoice is in GBP and the supplier is in AUD, this error will occur.
In QuickBooks Online, check the Vendor for this invoice.
Make sure the Vendor is set up to use the same currency as the invoice being exported.
Business Validation Error: Transactions can have only one foreign currency at a time
This error usually means your QuickBooks Online account doesn't support multi-currency transactions, or the currency of the invoice being exported is not set up correctly there.
Make sure the currency assigned to the invoice is the same as the currency in your QuickBooks Online account.
đNote: A QuickBooks Online customer or supplier can only have one currency.
Invalid Reference Id : Names element id [ID] not found
This happens when a Supplier Card has been created in Lightyear where one already exists in QuickBooks Online.
Delete the existing supplier card(s) in Lightyear.
Click Accountancy, then click Supplier Cards.
Click Import Suppliers from Quickbooks Online.
Go to your Suppliers list, edit this supplier, then add the Accounting Supplier.
Required parameter VendorRef is missing in the request
This happens when the Supplier selected in Lightyear does not have an Accounting Supplier.
Click the truck icon on the left to open your Supplier list.
Click Edit on the supplier.
Select an Accounting Supplier from the dropdown menu.
Business Validation Error: You can't use a Creditors account on the detail portion of a Bill.
This happens when the GL Code or Account on a line item is set as a Creditor or Accounts Payable type in QuickBooks Online.
Change the GL Code on the line item so you can export.
If the GL Codes all look correct, check your Rounding GL Code:
Click Accountancy, then click GL Codes.
Check whether the Rounding GL Code is a Creditor or Accounts Payable type.
If it is, change it to another GL Code, or set up a Rounding GL Code within QuickBooks Online.
Currency, ExchangeRate is missing. (code: 2410): The currency and exchange rate are required for transaction in foreign currency
QuickBooks Online may not have received the currency correctly.
Send the document back to the Review/Approvals tab.
Above Unit Price/Amount, re-select your currency, then click Save.
Sign off the document.
Try to export the document again.
Prevent export issues
You can avoid most export issues by checking a few things regularly.
Check that the QuickBooks Online integration is active and connected. Use an admin account to manage the integration, so tokens don't expire or get revoked.
Keep accounting periods open for the dates of the invoices you're exporting.