Thanks for trying, but no suggestions helped. I opened a ticket with
Harbinger and they are sending me "the latest and greatest" outbound
translator release in hopes that it fixes the problem. If not, I have to
send them all my information so they can recreate the problem on their side.
If your interested I can keep you informed. Let me know if you are.
_____________________________________________________
EDI-Mike
Michael Taylor
EC Specialist
Banctec - Corporate Information Systems
(972)982-2815
-----Original Message-----
From: Martin Reiser <[EMAIL PROTECTED]> at Internet
Sent: Wednesday, November 01, 2000 11:27 AM
To: [EMAIL PROTECTED] at Internet
Subject: RE: Harbinger TLE 4.2 Mapping Question
The way to solve this in TLE is to multiply the total price by 100, divide
the result by the unit price, then divide that result by 100. It's the way
we worked out this in our TLE.
total price * 100 = answer1
answer1 / unit price = answer2
answer2 / 100 = desired result
-----Original Message-----
From: Mojica William-FWM008 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 11:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Harbinger TLE 4.2 Mapping Question
I think this may help.
I have had some issues like that, try playing with the different
type of numeric. There is Decimal, Explicit, implied.. You may need to
change the TYPE of the field where you put the final value of your
calculation, or Change all three. (process of elimination).
I hope this works, Good Luck
WDM
-----Original Message-----
From: Taylor, Mike P. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 11:00 AM
To: [EMAIL PROTECTED]
Subject: Harbinger TLE 4.2 Mapping Question
Harbinger TrustedLink Sun/Informix 4.2.1.120
I am experiencing a rounding error. SAP passes me a line item total price of
2067.00 and a quantity of 4.000. I save them in store fields converting them
to
numeric. I then use the compute command to divide the line item total price
by
the quantity to get the unit price. When Harbinger divides it gets 517.00,
it
should be 516.75. How do I get Harbinger to produce a real number after
dividing? I tried manipulating the SAP application definition to make them
real
instead of alpha-numeric, but it didn't help.
_____________________________________________________
EDI-Mike
Michael Taylor
EC Specialist
Banctec - Corporate Information Systems
(972)982-2815
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
=======================================================================
To signoff the EDI-L list, mailto:[EMAIL PROTECTED]
To subscribe, mailto:[EMAIL PROTECTED]
To contact the list owner: mailto:[EMAIL PROTECTED]
Archives at http://www.mail-archive.com/edi-l%40listserv.ucop.edu/
