Error Messages Returned from QuickBooks Online
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 Quickbooks Online. 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 the document's Activity History.
Business Validation Error: The transaction needs to be in the same currency as the A/R and A/P accounts you use
In your Quickbooks Online account, check the Vendor for this invoice. Make sure the Vendor is set up to use the same currency the Invoice being exported is in. For example, if the invoice is in GBP and the supplier AUD, this error will occur.
Business Validation Error: Transactions can have only one foreign currency at a time
It's likely your Quickbooks Online account does not support multi-currency transactions or the currency of the invoice being exported. Please ensure the assigned Currency on the invoice should also be the same in your QuickBooks account. Please note that a Quickbooks Online customer/supplier can only have one currency.
Invalid Reference Id : Names element id xxx not found
This will occur when a Supplier Card has been created in Lightyear where one already exists in Quickbooks Online. You will need to delete the existing supplier card(s) and go to Accountancy > Supplier Cards > Import Suppliers from Quickbooks Online. Then in your Suppliers, edit this supplier and add in the Accounting Supplier.
Required parameter VendorRef is missing in the request
The Supplier selected in Lightyear will not have an Accounting Supplier. Head over to your Supplier list (truck icon on the left), click Edit on the Supplier and 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.
The GL Code/Account on a line item is set as a Creditor/Accounts Payable Type within QuickBooks Online.
You will need to change the GL Code on the line in order to export.
If the GLs all look correct, check your Rounding GL Code in Lightyear (Accountancy > GL Codes) and check if that is a Creditor/Accounts Payable type. If yes, please change 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
The currency may not be received correctly by QuickBooks Online.
Try sending this document back to Review/Approvals tab. Above Unit Price/Amount re-select your currency and Save.
Sign Off the document and try to export again.
Check out our
to stay up to date
Related Articles
Error Messages Returned from iplicit 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 iplicit. However, there are occasions when the export fails and Lightyear displays the reason for the error ...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 ...Error Messages Returned from Sage Business Cloud 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 Sage Business Cloud. However, there are occasions when the export fails and Lightyear displays the reason ...Error Messages Returned from Microsoft Dynamics Business Central 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 Business Central. However, there are occasions when the Export fails and Lightyear displays the reason for ...Disconnecting from QuickBooks Online
Disconnecting from QuickBooks Online There may be instances where you might need to disconnect your QuickBooks Online file. Sometimes a refresh in connection is required, you might have connected to the wrong file if you have access to multiple files ...