Hi there, this is Adam here from Customer Success. Today we are going to take a look an issue that were probably faced by many users on this :
This error means that when transferring the invoice's items, the item name was too long to be stored in Xero. Xero implemented a strict restrictions on the length of the item code at the maximum of 30 characters. There are ways to make sure that it is synced over, but it will require your product's name to be cut off at the 30th character. If you are absolutely fine with that, here is what you can do :
First, I will show you a few screenshots to show why this is happening :
In Step 24 and 26, when it tried to search for the item in Xero, it failed to find for it in Xero. With that, the Workato recipe will create a new item in Xero with the provided data mapping. It will use the product name as the Item Code. If you wish to have your recipe customised, feel free to to do, or you can approach one of us in the customer success team to aid you. We have consultation packages available for heavy modifications, or we can guide you on making simple modifications as well.
^ Note how the Item Code is longer than 30 characters long. We will need to make changes on both Step 24 and 26.
Now go back to the recipe, and look for Step 24 and 26. Insert the following formula into the data pill as shown. Make sure that the formula mode is on. If you're interested in formula modes, check out this article here.
This will encapsulate the data pill to only provide the first 30 characters in that value. Anything that entails the 30th character will be discarded away.