Kashflow Invoice Transfer Error Messages

The error messaged below are specific to KashFlow 

If you have a problem transferring invoices from MagManager to KashFlow,  A failed transfer message may appear on screen or you can check the API logs for details of the transfer error.

You can access the API logs by going to the main settings page > Under Settings > Select API Logs > You can sort the order by clicking on the up/down arrows in the column headers.

 1 - Failed to insert invoice: XXXXX - An error occurred while inserting invoice. Please check that the transaction lock is not enabled on the account.

Cause: A transaction Lock Date has been set on your KashFlow account

Solution: Refer to the link below as if transaction locking is enabled you won't be able to edit any invoices, receipts or payments on or before the transaction locking date.
https://www.kashflow.com/support/kb/transaction-locking/

In Kashflow go to Settings > Advanced Settings > Tick the box for Transaction Locking > Enter in the date to lock transactions up to > Click Update.

2 - Failed to insert invoice: XXXXX - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

Cause: This is a timeout error on the Kashflow API, probably their server was too busy to handle the request.

Solution: Try transferring the invoice again > Go back to the API Logs and search for the invoice number > If sucessful it should look like this, showing Invoice Created: xxxxx in the Result column.

3 - Failed to insert customer: XXX s Error: String or binary data would be truncated. A valid Contact list must contain one and only one primary Contact The statement has been terminated.

Cause: Kashflow failed to add a new client.  The API reports an issue with the data and it being truncated. After checking the fields on the client record, the problem in this example was the website address contained 195 characters - more than the Kashflow API allows.

 https://www.TheCompanyName.co.uk/?utm_source=google&utm_medium=cpc&utm_campaign=ppc_google&utm_content=core-brand_extended-retirement&gclid=EAIaIQobChMInMmV45Or8QIVS7TVCh0uxgqmEAAYASAAEgI4D_D_BwE

The website address was likely copy as pasted into MagManager.

Solution: The website field needed to be updated to - https://www.TheCompanyName.co.uk

4 - Failed to insert invoice: XXXXX - No customer code provided Parameter name: customerCode

Cause: This is a KashFlow API issue.

Solution:  No action required, as it resolved itself the next day and the invoices were transferred over successfully.