Mike, Leah, Thanks for your input. I ran the same tests and received the same results. The issue we will have is the + sign. The 2 applications receiving the data won't handle it without changes in their processing. We're trying to make this transition as transparent as we can to them. We are going to try saving the data into a stored value and manipulating it from there ( if it's > 1 do this , < 1 do this) and see what we can come up with.
Steve Joyce Software Engineer III EDI Technical Support 508-894-7284 ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Leah Halpin Sent: Friday, September 07, 2007 12:24 PM To: Mike Rawlins; [email protected] Subject: Re: [EDI-L] TLE Mapping Workbench Mike, You are correct, the numeric will allow an optional leading minus sign. I did a couple of tests because I was curious. If the target app field is defined as signed, you get a + when positive values - when negative values, plus intermediate zeroes to fill the length of your field and no decimal. If you go with defining the app field as alphanumeric you get the negative sign and the two places to the right of the decimal (no plus sign when positive). If you define the app field as numeric you get no sign, no decimals and leading zeroes to fill your field. Results are pretty much the same if the standard is changed to decimal number, except you don't get the decimal when the app field is AN and you do get all the numbers to the right of the decimal if the app field is signed or not signed numeric. Steve, I'd suggest that you check how your TLE application field is defined, do some testing and check your output file (before you feed it to your actual application) and see what result you're getting. The issue may lie in your application, not in TLE. Good Luck, Leah ----- Original Message ---- From: Mike Rawlins <[EMAIL PROTECTED] <mailto:mcr2%40rawlinsecconsulting.com> > To: [email protected] <mailto:EDI-L%40yahoogroups.com> Sent: Friday, September 7, 2007 11:11:26 AM Subject: Re: [EDI-L] TLE Mapping Workbench The X12 numeric data type allows an optional leading minus sign for negative numbers, so you should not have to change anything to receive a negative number. I don't recall off the top of my head and don't have Workbench in front of me, but I believe that you can define signed and unsigned fields in the target application. I would make sure that your target field is defined as signed. If it is and if your result isn't coming through as negative when doing a straight mapping, then you've probably encountered a bug. ------------ --------- --------- --------- -- Michael C. Rawlins, Rawlins EC Consulting www.rawlinsecconsul ting.com Leah Halpin wrote: > Steve, > Just a quick look at the standards in workbench shows that the G3301 is a numeric field with implied decimal at 2 places (N2). I'd say you need to change this to a real number field "decimal number" in order to be able to receive the negative sign. If you're not getting the decimal in the data, you'll need to account for that in your mapping once you switch from the implied decimal designator to the real number. I'm slightly surprised you're not getting an error with the neg sign in the data. > > Good Luck, > Leah > > ----- Original Message ---- > From: Steve Joyce <steven.joyce@ shaws.com> > To: [EMAIL PROTECTED] com > Sent: Friday, September 7, 2007 8:00:33 AM > Subject: [EDI-L] TLE Mapping Workbench > > > > > > > > > > > > > > We are in the process of transitioning to TLE Mapping Workbench > > 6.0.3..6 and have come across an issue mapping negative numbers. We > > have the ability to use the 880 4010 invoice transaction to receive > > credits. The G33 total quantity is sent as a negative number as is the > > G1701, line item quantity. If they are received as a negative number > > the sign drops off causing the number to be passed as a positive. I've > > tried all the commands offerd in TLE but have had no success in mapping > > the negative number. Has anyone run into this situation and if so, how > > did you work around it? Any help would be greatly appreciated. > > Thnks, > > Steve > > > > > > > > > > > > > > > <!-- > > #ygrp-mkp{ > border:1px solid #d8d8d8;font- family:Arial; margin:14px 0px;padding: 0px 14px;} > #ygrp-mkp hr{ > border:1px solid #d8d8d8;} > #ygrp-mkp #hd{ > color:#628c2a; font-size: 85%;font- weight:bold; line-height: 122%;margin: 10px 0px;} > #ygrp-mkp #ads{ > margin-bottom: 10px;} > #ygrp-mkp .ad{ > padding:0 0;} > #ygrp-mkp .ad a{ > color:#0000ff; text-decoration: none;} > --> > > > > <!-- > > #ygrp-sponsor #ygrp-lc{ > font-family: Arial;} > #ygrp-sponsor #ygrp-lc #hd{ > margin:10px 0px;font-weight: bold;font- size:78%; line-height: 122%;} > #ygrp-sponsor #ygrp-lc .ad{ > margin-bottom: 10px;padding: 0 0;} > --> > > > > <!-- > > #ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg table {font-size:inherit; font:100% ;} > #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height: 1.22em;} > #ygrp-text{ > font-family: Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0;} > #ygrp-tpmsgs{ > font-family: Arial; > clear:both;} > #ygrp-vitnav{ > padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;} > #ygrp-vitnav a{ > padding:0 1px;} > #ygrp-actbar{ > clear:both;margin: 25px 0;white-space: nowrap;color: #666;text- align:right; } > #ygrp-actbar .left{ > float:left;white- space:nowrap; } > .bld{font-weight: bold;} > #ygrp-grft{ > font-family: Verdana;font- size:77%; padding:15px 0;} > #ygrp-ft{ > font-family: verdana;font- size:77%; border-top: 1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom: 10px;} > > #ygrp-vital{ > background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;} > #ygrp-vital #vithd{ > font-size:77% ;font-family: Verdana;font- weight:bold; color:#333; text-transform: uppercase; } > #ygrp-vital ul{ > padding:0;margin: 2px 0;} > #ygrp-vital ul li{ > list-style-type: none;clear: both;border: 1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > font-weight: bold;color: #ff7900;float: right;width: 2em;text- align:right; padding-right: .5em;} > #ygrp-vital ul li .cat{ > font-weight: bold;} > #ygrp-vital a{ > text-decoration: none;} > > #ygrp-vital a:hover{ > text-decoration: underline; } > > #ygrp-sponsor #hd{ > color:#999;font- size:77%; } > #ygrp-sponsor #ov{ > padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;} > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px;margin:0; } > #ygrp-sponsor #ov li{ > list-style-type: square;padding: 6px 0;font-size: 77%;} > #ygrp-sponsor #ov li a{ > text-decoration: none;font- size:130% ;} > #ygrp-sponsor #nc{ > background-color: #eee;margin- bottom:20px; padding:0 8px;} > #ygrp-sponsor .ad{ > padding:8px 0;} > #ygrp-sponsor .ad #hd1{ > font-family: Arial;font- weight:bold; color:#628c2a; font-size: 100%;line- height:122% ;} > #ygrp-sponsor .ad a{ > text-decoration: none;} > #ygrp-sponsor .ad a:hover{ > text-decoration: underline; } > #ygrp-sponsor .ad p{ > margin:0;} > o{font-size: 0;} > .MsoNormal{ > margin:0 0 0 0;} > #ygrp-text tt{ > font-size:120% ;} > blockquote{margin: 0 0 0 4px;} > .replbq{margin: 4;} > --> > > > > > > > > > > ____________ _________ _________ _________ _________ _________ _ > Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games. > http://get.games. yahoo.com/ proddesc? gamekey=monopoly herenow > > [Non-text portions of this message have been removed] > > > > ... > Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> > > Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. > Yahoo! Groups Links > > > > > <!-- #ygrp-mkp{ border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;} #ygrp-mkp hr{ border:1px solid #d8d8d8;} #ygrp-mkp #hd{ color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10p x 0px;} #ygrp-mkp #ads{ margin-bottom:10px;} #ygrp-mkp .ad{ padding:0 0;} #ygrp-mkp .ad a{ color:#0000ff;text-decoration:none;} --> <!-- #ygrp-sponsor #ygrp-lc{ font-family:Arial;} #ygrp-sponsor #ygrp-lc #hd{ margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;} #ygrp-sponsor #ygrp-lc .ad{ margin-bottom:10px;padding:0 0;} --> <!-- #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} #ygrp-mlmsg table {font-size:inherit;font:100%;} #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} #ygrp-mlmsg pre, code {font:115% monospace;} #ygrp-mlmsg * {line-height:1.22em;} #ygrp-text{ font-family:Georgia; } #ygrp-text p{ margin:0 0 1em 0;} #ygrp-tpmsgs{ font-family:Arial; clear:both;} #ygrp-vitnav{ padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} #ygrp-vitnav a{ padding:0 1px;} #ygrp-actbar{ clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;} #ygrp-actbar .left{ float:left;white-space:nowrap;} ..bld{font-weight:bold;} #ygrp-grft{ font-family:Verdana;font-size:77%;padding:15px 0;} #ygrp-ft{ font-family:verdana;font-size:77%;border-top:1px solid #666; padding:5px 0; } #ygrp-mlmsg #logo{ padding-bottom:10px;} #ygrp-vital{ background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} #ygrp-vital #vithd{ font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-trans form:uppercase;} #ygrp-vital ul{ padding:0;margin:2px 0;} #ygrp-vital ul li{ list-style-type:none;clear:both;border:1px solid #e0ecee; } #ygrp-vital ul li .ct{ font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;pa dding-right:.5em;} #ygrp-vital ul li .cat{ font-weight:bold;} #ygrp-vital a{ text-decoration:none;} #ygrp-vital a:hover{ text-decoration:underline;} #ygrp-sponsor #hd{ color:#999;font-size:77%;} #ygrp-sponsor #ov{ padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} #ygrp-sponsor #ov ul{ padding:0 0 0 8px;margin:0;} #ygrp-sponsor #ov li{ list-style-type:square;padding:6px 0;font-size:77%;} #ygrp-sponsor #ov li a{ text-decoration:none;font-size:130%;} #ygrp-sponsor #nc{ background-color:#eee;margin-bottom:20px;padding:0 8px;} #ygrp-sponsor .ad{ padding:8px 0;} #ygrp-sponsor .ad #hd1{ font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-hei ght:122%;} #ygrp-sponsor .ad a{ text-decoration:none;} #ygrp-sponsor .ad a:hover{ text-decoration:underline;} #ygrp-sponsor .ad p{ margin:0;} o{font-size:0;} ..MsoNormal{ margin:0 0 0 0;} #ygrp-text tt{ font-size:120%;} blockquote{margin:0 0 0 4px;} ..replbq{margin:4;} --> __________________________________________________________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+ki ds&cs=bz <http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+k ids&cs=bz> [Non-text portions of this message have been removed] ----------------------------------------- This email, including any attachments, is for the designated recipient(s) only and may contain confidential, proprietary, and/or legally privileged information. If you are not a designated recipient, or have received it in error, please notify the sender and destroy it and all attachments and copies immediately, without distributing, disclosing, or using it in any manner. [Non-text portions of this message have been removed] ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
