Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item quantity verifica...
Microsoft Dynamics GP (Archived)

Item quantity verification

(0) ShareShare
ReportReport
Posted on by Guido Guerrero 100

hello...

 

I'm new in developing for GP10.0... so, forgiveme if i ask some easy things :P

 

I just need a Little help, in my development I need import a sop quote from econnect xml file… but econnect verify the stock of items, and don’t process sop quote because some items don’t have stock… It is normal on sop order (soptype 2) or invoice (soptype 3), but in quote it isn’t.
 
Do you have any idea how to correct this???
 
here is my serialized xml file
 
 <?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">
- <SOPTransactionType>
  <eConnectProcessInfo xsi:nil="true" />
  <taRequesterTrxDisabler_Items xsi:nil="true" />
  <taUpdateCreateItemRcd xsi:nil="true" />
  <taUpdateCreateCustomerRcd xsi:nil="true" />
  <taCreateCustomerAddress_Items xsi:nil="true" />
  <taSopSerial_Items xsi:nil="true" />
  <taSopLotAuto_Items xsi:nil="true" />
- <taSopLineIvcInsert_Items>
- <taSopLineIvcInsert>
  <SOPTYPE>1</SOPTYPE>
  <CUSTNMBR>11111111111111111</CUSTNMBR>
  <DOCDATE>01-04-2012</DOCDATE>
  <LOCNCODE>MATRIX</LOCNCODE>
  <ITEMNMBR>01-046-10-051</ITEMNMBR>
  <UNITPRCE>23.2300</UNITPRCE>
  <XTNDPRCE>23.2300</XTNDPRCE>
  <QUANTITY>1.0000</QUANTITY>
  <ITEMDESC>AAAAAAAAAAAAAAAAAAAAAAAAAAAA</ITEMDESC>
  </taSopLineIvcInsert>
- <taSopLineIvcInsert>
  <SOPTYPE>1</SOPTYPE>
  <CUSTNMBR>11111111111111111</CUSTNMBR>
  <DOCDATE>01-04-2012</DOCDATE>
  <LOCNCODE>MATRIX</LOCNCODE>
  <ITEMNMBR>01-046-10-119</ITEMNMBR>
  <UNITPRCE>20.8700</UNITPRCE>
  <XTNDPRCE>20.8700</XTNDPRCE>
  <QUANTITY>1.0000</QUANTITY>
  <ITEMDESC>VVVVVVVVVVVVVVVVVVVVVVVVVVVV</ITEMDESC>
  </taSopLineIvcInsert>
- <taSopLineIvcInsert>
  <SOPTYPE>1</SOPTYPE>
  <CUSTNMBR>11111111111111111</CUSTNMBR>
  <DOCDATE>01-04-2012</DOCDATE>
  <LOCNCODE>MATRIX</LOCNCODE>
  <ITEMNMBR>01-042-43-004</ITEMNMBR>
  <UNITPRCE>24.3900</UNITPRCE>
  <XTNDPRCE>24.3900</XTNDPRCE>
  <QUANTITY>1.0000</QUANTITY>
  <ITEMDESC>ZZZZZZZZZZZZZZZZZZZZZZZZZZZZ</ITEMDESC>
  </taSopLineIvcInsert>
- <taSopLineIvcInsert>
  <SOPTYPE>1</SOPTYPE>
  <CUSTNMBR>11111111111111111</CUSTNMBR>
  <DOCDATE>01-04-2012</DOCDATE>
  <LOCNCODE>MATRIX</LOCNCODE>
  <ITEMNMBR>11-020-10-004</ITEMNMBR>
  <UNITPRCE>48.9500</UNITPRCE>
  <XTNDPRCE>48.9500</XTNDPRCE>
  <QUANTITY>1.0000</QUANTITY>
  <ITEMDESC>YYYYYYYYYYYYYYYYYYYYYYYYY</ITEMDESC>
  </taSopLineIvcInsert>
- <taSopLineIvcInsert>
  <SOPTYPE>1</SOPTYPE>
  <CUSTNMBR>11111111111111111</CUSTNMBR>
  <DOCDATE>01-04-2012</DOCDATE>
  <LOCNCODE>MATRIX</LOCNCODE>
  <ITEMNMBR>01-041-10-073</ITEMNMBR>
  <UNITPRCE>108.5400</UNITPRCE>
  <XTNDPRCE>108.5400</XTNDPRCE>
  <QUANTITY>1.0000</QUANTITY>
  <ITEMDESC>XXXXXXXXXXXXXXXXXXXXXXX</ITEMDESC>
  </taSopLineIvcInsert>
  </taSopLineIvcInsert_Items>
  <taSopLineIvcInsertComponent_Items xsi:nil="true" />
  <taSopTrackingNum_Items xsi:nil="true" />
  <taSopCommissions_Items xsi:nil="true" />
  <taSopLineIvcTaxInsert_Items xsi:nil="true" />
  <taCreateSopPaymentInsertRecord_Items xsi:nil="true" />
  <taSopUserDefined xsi:nil="true" />
  <taSopDistribution_Items xsi:nil="true" />
  <taAnalyticsDistribution_Items xsi:nil="true" />
  <taSopMultiBin_Items xsi:nil="true" />
- <taSopHdrIvcInsert>
  <SOPTYPE>1</SOPTYPE>
  <DOCID>QUOTE.MATRIX</DOCID>
  <LOCNCODE>MATRIX</LOCNCODE>
  <DOCDATE>01-04-2012</DOCDATE>
  <CUSTNMBR>11111111111111111</CUSTNMBR>
  <SUBTOTAL>225.9800</SUBTOTAL>
  <BACHNUMB>COT60</BACHNUMB>
  <CREATETAXES>1</CREATETAXES>
  <CURNCYID>DOLAR</CURNCYID>
  </taSopHdrIvcInsert>
  <taSopToPopLink xsi:nil="true" />
  <taSopUpdateCreateProcessHold xsi:nil="true" />
  <taCreateSOPTrackingInfo xsi:nil="true" />
  <taMdaUpdate_Items xsi:nil="true" />
  </SOPTransactionType>
  </eConnect>
 
Some idea??? what option is wrong??? or which option is missing???

Thanks in advance…
 
Guido Guerrero.
Ecuador
 
PD: Sorry for my poor English…

*This post is locked for comments

  • Aaron Donat Profile Picture
    Aaron Donat on at
    Re: Item quantity verification

    Guido,

    you are trying to create a SOP QUOTE. QUOTE documents have nothing to do with quantity or quantity levels. If you try and integrate the document and it fails...what is the exception getting logged to the eConnect event log?  If it is the same 235 error, then that is the same problem as before and I provided you the code check that is running and returning the error.

    Unless you can provide more details, you are going to need to open a support case so someone can screen share with you and take a look at what you are passing and the exception being returned.  Please integrate the document again that is failing and then attached the exception details that are getting logged.

    Thanks!

  • Guido Guerrero Profile Picture
    Guido Guerrero 100 on at
    Re: Item quantity verification

    Hi Aaron ...

    First, thanks for your time and for help me...

    I have tried your suggestion but it didnt work... i'm still having the same problem... i looked for that items stock and they dont have stock, or customer exceeds its purchase limit :S... i guess that's the problem...

    I dont pass the parameters, because all is calculated automatically, and just need to pass the subtotal... I know it, because some quotes (25%) could be entered... and items had stock and customers didnt exceed its purchase limit...

    sorry if i redund too much...

    thanks in advance...

  • Suggested answer
    Aaron Donat Profile Picture
    Aaron Donat on at
    Re: Item quantity verification

    That is your issue then.  It appears you are not passing in the @I_vDOCAMNT value because the SUM of all those other parmeters to not equal the @I_vDOCAMNT parameter.

    if @I_vSUBTOTAL + @I_vFREIGHT + @I_vMISCAMNT + @I_vTAXAMNT + @I_vFRTTXAMT + @I_vMSCTXAMT - @I_vTRDISAMT <> @I_vDOCAMNT

    begin

    select @O_iErrorState = 235 /* Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc) */ /*SOPNUMBE SOPTYPE*/ /*SUBTOTAL FREIGHT MISCAMNT TAXAMNT FRTTXAMT MSCTXAMT TRDISAMT DOCAMNT*/

    exec @iStatus = taUpdateString

    @O_iErrorState,

    @oErrString,

    @oErrString output,

    @O_oErrorState output

    end

  • Guido Guerrero Profile Picture
    Guido Guerrero 100 on at
    Re: Item quantity verification

    Sorry... i forgot it...

    but it is here:

    Microsoft.GreatPlains.eConnect Version=10.0.0.0

    Microsoft.Dynamics.GP.eConnect

    Sql procedure error codes returned:

    Error Number = 235  Stored Procedure taSopHdrIvcInsert  Error Description = Document amount does not equal (Subtotal+Freight+Misc+TaxAmt+FreightTax+MiscTax-TradeDisc)

    Node Identifier Parameters: taSopHdrIvcInsert                                  

    SOPNUMBE = COTM1-0000771    

    SOPTYPE = 1

    Related Error Code Parameters for Node : taSopHdrIvcInsert                                  

    SUBTOTAL = 225.9800

    FREIGHT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    MISCAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    TAXAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    FRTTXAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    MSCTXAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    TRDISAMT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    DOCAMNT =  Note: This parameter was not passed in, no value for the parameter will be returned.

    <taSopHdrIvcInsert><SOPTYPE>1</SOPTYPE><DOCID>QUOTE.MATRIX</DOCID><LOCNCODE>MATRIX</LOCNCODE><DOCDATE>01-04-2012</DOCDATE><CUSTNMBR>11111111111111111</CUSTNMBR><SUBTOTAL>225.9800</SUBTOTAL><BACHNUMB>COT60</BACHNUMB><CREATETAXES>1</CREATETAXES><CURNCYID>DOLAR</CURNCYID><SOPNUMBE>COTM1-0000771    </SOPNUMBE></taSopHdrIvcInsert>

      at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ExecStoredProcedures(String xml)

      at Microsoft.Dynamics.GP.eConnect.eConnectMethods.eConnect_EntryPoint(String ConnectionString, ConnectionStringType ConnectionType, String sXML, SchemaValidationType ValidationType, String eConnectSchema)

    I have verified that items in orders directly in Dynamics GP,  and dont have stock of that items, and didnt allow me to proceed with the order, but if when i tried to make a quote i can save the quote...

    I check the values and all is correct...

    By econnect xml, i have the same error when i serialized orders and quotes...

    Thanks for your time...

  • Aaron Donat Profile Picture
    Aaron Donat on at
    Re: Item quantity verification

    The error exception being returned back to you would be good for starters.  Do you have the error code being returned and added to the eConnect Event log?

    Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans