calendar circle image
back to knowledgebase

I receive errors when trying to download Invoices or Orders with SageLink. SageLink crashes or I am getting the messages: 'failed validation test', 'the order at position x has no Customer ID value', 'Response is not of type text/xml" or some other error.

Updated: 23 May 2022 06:19:31 SageLink for OpenCRM::

The order at position "x" has no customer id value

This is usually down to one of two things:

  • Companies with missing Sage references
  • No Company linked to the invoice

Companies with missing Sage references

To resolve:

  • Edit the company, search for the correct Sage reference and link....
  • If no relevant Sage reference found, the company should have been assigned a reference by OpenCRM
  • Going to the following URL will populate all companies with Sage references where they are missing. Be warned that this is a global update, so, if there are companies that ARE in sage, but aren't linked with the correct reference, the company in OpenCRM will get a reference that doesn't match and this will cause a duplicate when transferring through to sage, so use with caution!
  • http://yoursystem.opencrm.co.uk/index.php?module=Utilities&action=updatesageaccountrefs

Invoices with no company linked

  • Sage requires a company to be linked to an invoice. You cannot create an invoice in Sage without a company, so SageLink will give a validation error if you try to download an invoice without a company linked. When dealing with individual end users, there are two options:
  • Use a single parent "holding company" and link this to all invoices where no company is relevant
  • Create a company record for the contact using the contact details as the company name

Troubleshooting Other "Failed Validation Tests"
Please contact us for assistance.

Sage Link is Crashing
Please contact us for assistance.

Rate This Article
  • 1 star
  • 2 star
  • 3 star
  • 4 star
  • 5 star
Feedback and Comments
captcha code  


You may also be interested in: