I wish to create a a custom record and child line item records in
salesforce when a new Bill is created in Xero. I need advice on how to create a record and related line items if the Action does not support line items. (The trigger does support line items.) I believe I need to convert each of the Xero Bill line items to a delimited text string? Then when creating the parent record in salesforce, the line item text string should be mapped to a Text field and then use Salesforce workflow to create the line item records from this text string? If this is correct I cannot figure out how to use formatter to create a single text string for all the line items. Any help or other solutions would be much appreciated:
Create custom object line item records in Salesforce
Best answer by xeno
Thanks for your reply Liz, but you have misunderstood the problem.
I wish to take line item data FROM xero bill or invoice and add that TO salesforce. Not the other way around as you have surmised.
Furthermore to ensure you are not inadvertently misleading other community members, I am happy to advise that it IS possible to to extract line item data from salesforce and write this data to Xero!. We have already done this with our own Salesforce org and our new Xero instance. I have posted our solution to another community member who was enquiring about the feasibility of this application.
Regards Mark Riley, Xenogenix Ltd
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.