Sign in
Microsoft.com
 
Resources for IT Professionals
 
 
 
Resources for IT Professionals > Dynamics Forums > GP > econnect GP10 taIVCreateUOFMScheduleLine does not import in decimal places on EQUOMQTY?
Ask a questionAsk a question
Search Forums:
 

Questioneconnect GP10 taIVCreateUOFMScheduleLine does not import in decimal places on EQUOMQTY?

  • Monday, July 06, 2009 7:27 AMGreg Kowieski Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Has Code
    Sign In to Vote
    0
    Sign In to Vote
    Here is my Xml at the econnect.Entry_point:

     <?xml version="1.0" encoding="utf-8" ?> 
- <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <IVCreateUOFMScheduleType>
  <eConnectProcessInfo xsi:nil="true" /> 
  <taRequesterTrxDisabler_Items xsi:nil="true" /> 
- <taIVCreateUOFMScheduleLine_Items>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Hour</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>1</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Day</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>7.5</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Week</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>37.5</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
- <taIVCreateUOFMScheduleLine>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UOFM>Month</UOFM> 
  <EQUIVUOM>Hour</EQUIVUOM> 
  <EQUOMQTY>232.5</EQUOMQTY> 
  <UOFMLONGDESC>Used for Conversions</UOFMLONGDESC> 
  </taIVCreateUOFMScheduleLine>
  </taIVCreateUOFMScheduleLine_Items>
- <taIVCreateUOFMScheduleHeader>
  <UOMSCHDL>Conv-001</UOMSCHDL> 
  <UMSCHDSC>Conversion</UMSCHDSC> 
  <BASEUOFM>Hour</BASEUOFM> 
  <UMDPQTYS>2</UMDPQTYS> 
  </taIVCreateUOFMScheduleHeader>
  </IVCreateUOFMScheduleType>
  </eConnect>

    As you can see, my data has the decimal places indicated, e.g., <EQUOMQTY>232.5</EQUOMQTY>.
    But look at the results I get from this import, (no errors from econnect either):
    select * from iv40201 a
	join iv40202 b on a.uomschdl = b.uomschdl
	where a.uomschdl = 'conv-001'
    Results:
    CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Hour     	16384	Hour     	1.00000	1.00000	Used for Conversions                                                                                                                                                                                                                                           	45
CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Day      	32768	Hour     	7.00000	7.00000	Used for Conversions                                                                                                                                                                                                                                           	46
CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Week     	49152	Hour     	37.00000	37.00000	Used for Conversions                                                                                                                                                                                                                                           	47
CONV-001   	Conversion                     	826.00000	Hour     	3	44	CONV-001   	Month    	65536	Hour     	232.00000	232.00000	Used for Conversions                                                                                                                                                                                                                                           	48
    Should I report this as an "Issue" and where would I report it?  <== Trick question...  BTW, apparently, this doesn't go into the forum I'm trying to put it in, so can someone please move it to: Microsoft Developer Network > Forums Home > Dynamics GP
    Greg Kowieski The World On-Line
    • Edited byGreg Kowieski Monday, July 06, 2009 7:32 AMxml input screwed up. did it over.
    • Moved byDavidJennawayMVPMonday, July 06, 2009 9:42 AMThread relates to GP, not CRM (From:CRM Development)
    •