web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Aaron Donat Profile Picture
    Aaron Donat on at

    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!

  • Guido Guerrero Profile Picture
    Guido Guerrero 100 on at

    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...

  • Suggested answer
    Aaron Donat Profile Picture
    Aaron Donat on at

    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

    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...

  • Aaron Donat Profile Picture
    Aaron Donat on at

    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!

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans