Xero - pre-existing Xero company IDs require clearing

Xero - pre-existing Xero company IDs require clearing

--Problem: Xero ID could not be matched. Khaos Control support should clear this redundant Xero company ID from the database (XERO_EXPORTED for company record)
--Statement to confirm entries for company record
select * from xero_exported where source_type = 5 and source_id in (select company_id from company where company_code = 'AURORA')

--Statement to remove the entries (Will be regenerated)
/*delete from xero_exported where xexported_id =
(select min(xexported_id) from xero_exported where source_type = 5 and source_id in (select company_id from company where company_code = 'AURORA'))*/

    • Related Articles

    • Xero Integration Guide

      Integrating with Xero Introduction This guide details the steps required to enable and configure your Xero Integration in Khaos Control Cloud in order to start exporting information to your Xero account. There are help videos in the different ...

    • Stopping Pre-payments being Sent to Xero

      Question/Problem How do you stop the prepayment part of the order that appears in Xero from being exported? Resolution/Solution [Accounts | Accounts Synchronisation]. Click Edit. For the option "Don`t Export Payments" Enable the Toggle. Toggle ...

    • Xero API Limit

      Overview Our Accounts integrations with Xero has certain limitations on the API. Many of these limitations are imposed on us by Xero. Notes/Caveats The Xero API has a call limit of 5000 per day with no more than 60 in any one minute. Each invoice ...

    • Using an Integrated Accounts Package with KCC

      Introduction When integrated with an accounting package (Quickbooks or Xero) there are some processes that must be performed in order for your accounting software to syncronise with KCC. Some processes must be performed within your accounts package ...

    • Xero - API limit reached

      Only 60~ calls can be made to the Xero API per minute.