Numeric value conversion into Exponential in EDI 810

[Former Member]

Hi All,

we are doing PI Mapping for invoice(810). In EDI message type there is one filed D_610 in S_TDS segment which is to be mapped to a numeric value.

Our mapping works fine when data passed to this field is less that 6 digits it is getting converted into Exponential terms (For Ex- amount 15133800 is getting converted into 1.51338E7) because of this we are getting following error: "SEEBURGER BICXIADAPTER --- CONVERSION ERROR ---Error: [Error:ID=3036;LEVEL=3] FieldData testDefaultTypes(): numeric Field ISA.GS.ST.TDS:610#2 is not a number ! DESCRIPTION: FieldData Warning: you have entered somthing else than a numeric value in the numeric Field [not specified]."

Can anybody please suggest what is the solution for this? Please note that when amount is less mapping is working fine.

Thanks in advance.

Regards,

Atul

[i812848]

Hi Atul,

the specification for that field is:

REF ELE ID NAME ATTRIBUTES

01 610 Amount M/Z N2 1/15

02 610 Amount O/Z N2 1/15

N2 indicates numeric value with implied two decimal positions.

So please truncate or round the value to 2 digits in the PI Mapping.

Check out the other Mappings for the non standard UDF. I am sure there are some.

Best regards,

ilka

[Former Member]

HI Atul

Whats the function you have used for this mapping. Check weather the field is having length limitations.

Thanks

Gaurav