AR Invoice Export to XML via Service Connect

AMS · April 21, 2021, 9:16am

And no tilde (~) as well?

Ricky90 · April 21, 2021, 10:02am

@AMS Nothing at all just a long string.

AMS · April 21, 2021, 1:45pm

I will need to take a closer look at the data on Epicor and SC side.

What it the table on which you placed the Standard Directive which is calling SC?

Ricky90 · April 21, 2021, 1:56pm

The Standard Directive that is called originally is InvcHead but the Workflow then called ARInvoice.GetByID Method to insert Data into the XML based on the InvoiceNum and Company fields of InvcHead

AMS · April 21, 2021, 1:57pm

So, that address data comes from ARInvoice.GetByID?

AMS · April 21, 2021, 4:48pm

If it is – the lines are separated by line breaks.
It’s a little trickier to split by line breaks, but I think still possible.

Ricky90 · April 21, 2021, 4:51pm

Yes the Address List comes from ARInvoice.GetByID.

Ricky90 · April 23, 2021, 8:48am

@AMS

Is there a way to do the Split by Line Breaks?

Ricky90 · April 27, 2021, 6:08pm

@AMS
I figured that i could use and the Translate Functoid to replace the Line Break with a “~” and from then on use the subString Functoids to split the string.

Thank you so much.

AMS · May 12, 2021, 9:47pm

Great.

Be careful when editing that XSLT conversion in GUI, I saw CR/LF in some of the functoids being lost, at least if they occurred sequentially.
When using translate(…) remember that is performs one-to-one character translation (i.e. it is not a replace(…), but it does not matter if both strings are single-character.

I had an idea which I did not get to try out – to introduce a variable with CR/LF characters and to use it in substring-before/-after by referencing the variable directly from within XSLT, but I did not get to proof it out so far, especially in cases where the XSLT transform is adjusted in GUI later on.