Header and Detail total mismatch

[Former Member]

Hi All,

I have file to proxy scenario, and i am using XSLT mapping for source to Traget mapping,

Here, I add all amounts in details and compare it to Header amount, issue is that although the totals are matching i am still getting total mismatch error.

The number have 2 decimal places.

This is the code that i am using:

<xsl:if test="format-number(number($vInvoice),'#.00') != format-number(sum(a:MT_PaymentData/RecordSet/RecordLineItem/LineItemAmount),'#.00')">

<xsl:value-of select="string('AmtMisMatch ')"/>

</xsl:if>

Pls advice,

XIer

[former_member194786 · Accepted solution]

Hi,

Did you try to use it in your mapping? I mean import the zip in your Interface Mapping and try to execute it there.And see if you are getting the wrong output still. Even i was getting the wrong output in the XMLSPY for my code. But when i implemented the same code in mapping it worked fine.

Regards,

Sanjeev.

[Former Member]

Self resolved..

[Former Member]

hi,

as u mentioned header and detail mismatch, XSLT mapping is used pls check with filed sizes and filed types this may lead to error and chk in xi server rather thanXML SPY .

if find useful pls do the req

thanx

sampath

[Former Member]

Self resolved