DME XML Tree Invoice Details Issue

[Former Member]

Hello Friends,

I am creating an XML DME tree. Our requirement is to output all invoice details of a vendor payment in separate lines in the DME file.

In the case of 4 invoices the output should look as below.

<Ustrd>Invoice 1 details</Ustrd>

<Ustrd>Invoice 2 details</Ustrd>

<Ustrd>Invoice 3 details</Ustrd>

<Ustrd>Invoice 4 details</Ustrd>

We have created an FM for the same. But the problem is the FM outputs only the last invoice details all the four times.

<Ustrd>Invoice 1 details</Ustrd>

<Ustrd>Invoice 1 details</Ustrd>

<Ustrd>Invoice 1 details</Ustrd>

<Ustrd>Invoice 1 details</Ustrd>

I guess this is a standard scenario and some fix should definitely be there for this. Request your inputs on this.

Thanks

Phani Kiran

[cgilberg]

Hello Phani,

I was looking for a standard solution on the very same requirement but did not find it. Instead, we went for a user exit. This offers you to add some more capabilities to it, for instance checking the actual length of an invoice reference, matching it against the designated field length in the DME tree and eventually adding two or more references into a single field. Other feature: to add into the last field how many additional invoice references were also cleared with the payment but not having enough space in the four fields ("IN12345 +6 more").

Just to give you an idea what you could do with a user exit here.

Best Regards,

Christoph

[cgilberg]

Hi Phani,

for standard solutions, please refer to this thread, it looks very helpful:

Best Regards,

Christoph