Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Econnect ACTLSHIP problem
Microsoft Dynamics GP (Archived)

Econnect ACTLSHIP problem

(0) ShareShare
ReportReport
Posted on by mc_line 110

  Hi

 

Bellow is my  taSopLineIvcInsert element.

 

I need to insert  a new order (which is done fine) but the problem is that I need the ACTLSHIP field be set to '01/01/1900' which is the default value (I think) for items that has not been shipped.

 

However, it keeps setting it to the current date even though I specify   <FUFILDAT>01/01/1900</FUFILDAT>

 

Please some help?

 

 

     <taSopLineIvcInsert>
        <SOPTYPE>2</SOPTYPE>
        <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
        <CUSTNMBR>45</CUSTNMBR>
        <DOCDATE>2010-09-23</DOCDATE>
        <LOCNCODE>STOCK</LOCNCODE>
        <ITEMNMBR>TEST</ITEMNMBR>
        <UNITPRCE>375.0000</UNITPRCE>
        <XTNDPRCE>750.00</XTNDPRCE>
        <QUANTITY>0</QUANTITY>
        <PRCLEVEL>BASE</PRCLEVEL>
        <TAXAMNT>90.00</TAXAMNT>
        <LNITMSEQ>32768</LNITMSEQ>
        <QTYTBAOR>2</QTYTBAOR>
        <TAXSCHID>S-BCHST</TAXSCHID>
        <PRSTADCD>SHIPPING94</PRSTADCD>
        <FUFILDAT>01/01/1900</FUFILDAT>
        <ACTLSHIP>01/01/1900</ACTLSHIP>
        <ReqShipDate>01/01/1900</ReqShipDate>
        <CURNCYID>Z-US$</CURNCYID>
        <UOFM>each</UOFM>
      </taSopLineIvcInsert>

*This post is locked for comments

  • mc_line Profile Picture
    mc_line 110 on at
    Re: Re: Re: Re: Re: Re: Econnect ACTLSHIP problem

     Nope, I am not providing ReqShipDate .

     

    This my full xml

     

     

     

    '<?xml version="1.0"?>
    <eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <RMCustomerAddressType>
        <eConnectProcessInfo xsi:nil="true" />
        <taRequesterTrxDisabler_Items xsi:nil="true" />
        <taCreateCustomerAddress_Items>
          <taCreateCustomerAddress>
            <CUSTNMBR>45</CUSTNMBR>
            <ADRSCODE>SHIPPING94</ADRSCODE>
            <CNTCPRSN>ji valdez</CNTCPRSN>
            <ADDRESS1>3510 wellington avenue</ADDRESS1>
            <COUNTRY>Canada</COUNTRY>
            <CITY>surrey</CITY>
            <STATE>British Columbia</STATE>
            <ZIPCODE>v4p3k4</ZIPCODE>
            <PHNUMBR1>11111</PHNUMBR1>
          </taCreateCustomerAddress>
          <taCreateCustomerAddress>
            <CUSTNMBR>45</CUSTNMBR>
            <ADRSCODE>BILLING93</ADRSCODE>
            <CNTCPRSN>ji valdez</CNTCPRSN>
            <ADDRESS1>3530 wellington avenue</ADDRESS1>
            <COUNTRY>Canada</COUNTRY>
            <CITY>surrey</CITY>
            <STATE>British Columbia</STATE>
            <ZIPCODE>v4p3k4</ZIPCODE>
            <PHNUMBR1>11111</PHNUMBR1>
          </taCreateCustomerAddress>
        </taCreateCustomerAddress_Items>
      </RMCustomerAddressType>
      <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>2</SOPTYPE>
            <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
            <CUSTNMBR>45</CUSTNMBR>
            <DOCDATE>2010-09-23</DOCDATE>
            <LOCNCODE>STOCK</LOCNCODE>
            <ITEMNMBR>CM</ITEMNMBR>
            <UNITPRCE>375.0000</UNITPRCE>
            <XTNDPRCE>375.00</XTNDPRCE>
            <QUANTITY>0</QUANTITY>
            <PRCLEVEL>BASE</PRCLEVEL>
            <TAXAMNT>45.00</TAXAMNT>
            <LNITMSEQ>16384</LNITMSEQ>
            <QTYTBAOR>1</QTYTBAOR>
            <SLPRSNID>EPI VISION</SLPRSNID>
            <TAXSCHID>S-BCHST</TAXSCHID>
            <PRSTADCD>SHIPPING94</PRSTADCD>
            <FUFILDAT>01/01/1900</FUFILDAT>
            <ACTLSHIP>01/01/1900</ACTLSHIP>
            <ReqShipDate>01/01/1900</ReqShipDate>
            <CURNCYID>Z-US$</CURNCYID>
            <UOFM>each</UOFM>
          </taSopLineIvcInsert>
          <taSopLineIvcInsert>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
            <CUSTNMBR>45</CUSTNMBR>
            <DOCDATE>2010-09-23</DOCDATE>
            <LOCNCODE>STOCK</LOCNCODE>
            <ITEMNMBR>CMS</ITEMNMBR>
            <UNITPRCE>375.0000</UNITPRCE>
            <XTNDPRCE>750.00</XTNDPRCE>
            <QUANTITY>0</QUANTITY>
            <PRCLEVEL>BASE</PRCLEVEL>
            <TAXAMNT>90.00</TAXAMNT>
            <LNITMSEQ>32768</LNITMSEQ>
            <QTYTBAOR>2</QTYTBAOR>
            <SLPRSNID>EPI VISION</SLPRSNID>
            <TAXSCHID>S-BCHST</TAXSCHID>
            <PRSTADCD>SHIPPING94</PRSTADCD>
            <FUFILDAT>01/01/1900</FUFILDAT>
            <ACTLSHIP>01/01/1900</ACTLSHIP>
            <ReqShipDate>01/01/1900</ReqShipDate>
            <CURNCYID>Z-US$</CURNCYID>
            <UOFM>each</UOFM>
          </taSopLineIvcInsert>
        </taSopLineIvcInsert_Items>
        <taSopLineIvcInsertComponent_Items xsi:nil="true" />
        <taSopTrackingNum_Items xsi:nil="true" />
        <taSopCommissions_Items xsi:nil="true" />
        <taSopLineIvcTaxInsert_Items>
          <taSopLineIvcTaxInsert>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
            <CUSTNMBR>45</CUSTNMBR>
            <LNITMSEQ>16384</LNITMSEQ>
            <SALESAMT>1125.00</SALESAMT>
            <TAXDTLID>S-BCHST</TAXDTLID>
            <STAXAMNT>45.00</STAXAMNT>
          </taSopLineIvcTaxInsert>
          <taSopLineIvcTaxInsert>
            <SOPTYPE>2</SOPTYPE>
            <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
            <CUSTNMBR>45</CUSTNMBR>
            <LNITMSEQ>32768</LNITMSEQ>
            <SALESAMT>1125.00</SALESAMT>
            <TAXDTLID>S-BCHST</TAXDTLID>
            <STAXAMNT>90.00</STAXAMNT>
          </taSopLineIvcTaxInsert>
          <taSopLineIvcTaxInsert>
            <SOPTYPE>2</SOPTYPE>
            <TAXTYPE>1</TAXTYPE>
            <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
            <CUSTNMBR>45</CUSTNMBR>
            <SALESAMT>25.00</SALESAMT>
            <FRTTXAMT>3.00</FRTTXAMT>
            <TAXDTLID>S-BCHST</TAXDTLID>
          </taSopLineIvcTaxInsert>
        </taSopLineIvcTaxInsert_Items>
        <taCreateSopPaymentInsertRecord_Items>
          <taCreateSopPaymentInsertRecord xsi:nil="true" />
          <taCreateSopPaymentInsertRecord xsi:nil="true" />
        </taCreateSopPaymentInsertRecord_Items>
        <taSopUserDefined>
          <SOPTYPE>2</SOPTYPE>
          <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
          <USRTAB03>No</USRTAB03>
          <USERDEF1>4111111111111111</USERDEF1>
          <USERDEF2>1/2012</USERDEF2>
          <USRDEF03>SADA DSA SA</USRDEF03>
          <USRDEF04>11111</USRDEF04>
        </taSopUserDefined>
        <taSopDistribution_Items xsi:nil="true" />
        <taAnalyticsDistribution_Items xsi:nil="true" />
        <taSopMultiBin_Items xsi:nil="true" />
        <taSopHdrIvcInsert>
          <SOPTYPE>2</SOPTYPE>
          <DOCID>STDORD-2</DOCID>
          <SOPNUMBE>WEB_ORDER_13</SOPNUMBE>
          <ORIGNUMB>0</ORIGNUMB>
          <TAXSCHID>BCHST</TAXSCHID>
          <FRTSCHID>BCHST</FRTSCHID>
          <SHIPMTHD>FedEX Express Shipping</SHIPMTHD>
          <TAXAMNT>135.00</TAXAMNT>
          <LOCNCODE>STOCK</LOCNCODE>
          <DOCDATE>2010-09-23</DOCDATE>
          <FREIGHT>25.00</FREIGHT>
          <CUSTNMBR>45</CUSTNMBR>
          <CUSTNAME>ji vald</CUSTNAME>
          <CSTPONBR>Web Order Number : 13</CSTPONBR>
          <ShipToName>ji valdez</ShipToName>
          <ADDRESS1>3032 wellington avenue</ADDRESS1>
          <CNTCPRSN>ji valdez</CNTCPRSN>
          <FAXNUMBR>111111</FAXNUMBR>
          <CITY>Montreal</CITY>
          <STATE>British Columbia</STATE>
          <ZIPCODE>11111</ZIPCODE>
          <COUNTRY>Canada</COUNTRY>
          <PHNUMBR1>11111</PHNUMBR1>
          <SUBTOTAL>1125.00</SUBTOTAL>
          <DOCAMNT>1288.00</DOCAMNT>
          <BACHNUMB>ORDERS</BACHNUMB>
          <PRBTADCD>BILLING93</PRBTADCD>
          <PRSTADCD>SHIPPING94</PRSTADCD>
          <FRTTXAMT>3.00</FRTTXAMT>
          <ORDRDATE>2010-09-23</ORDRDATE>
          <PYMTRMID>PREPAID- VISA/MC</PYMTRMID>
          <CURNCYID>Z-US$</CURNCYID>
        </taSopHdrIvcInsert>
        <taSopToPopLink xsi:nil="true" />
        <taSopUpdateCreateProcessHold xsi:nil="true" />
        <taCreateSOPTrackingInfo xsi:nil="true" />
        <taMdaUpdate_Items xsi:nil="true" />
      </SOPTransactionType>
    </eConnect>'

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    Re: Re: Re: Re: Re: Econnect ACTLSHIP problem

    Hello,

    Is your xml shows

    <ReqShipDate></ReqShipDate> ?

    Try not to use ReqShipDate and check.

    Thanks

    Sandip

  • mc_line Profile Picture
    mc_line 110 on at
    Re: Re: Re: Re: Re: Econnect ACTLSHIP problem

    Not sure what the 'GP Web Services' are

    I am integrating  eConnect to our website so that orders can be pushed directly without having a person manually copy them.

  • Bron Profile Picture
    Bron 2 on at
    Re: Re: Re: Re: Econnect ACTLSHIP problem

    What is your development environment?

    Are you using GP Web Services and eConnect together?

    Or are you just using eConnect runtime with a custom type application?

  • mc_line Profile Picture
    mc_line 110 on at
    Re: Re: Re: Econnect ACTLSHIP problem

    Hi

     

    Thanks for your replies.

     

    I have tried to leave it blank but it  still inserts all dates (FUFILDAT, ACTLSHIP,ReqShipDate) as current date (2010-09-23 00:00:00.000).

     

    I have also tried to insert the ReqShipDate field at the SOP header blank.  However, it wills till be inserted as the current date.

     

     

    I am setting all items as back ordered (<QTYTBAOR>2</QTYTBAOR>) so that someone in sales can allocate it them. So it does not even make sense that the fullfilled date is the current date

     

     

     

     

     

     

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,267 on at
    Re: Re: Econnect ACTLSHIP problem

    Bron is right ReqShipDate is not required field you can leave it blank. Here is Link for eConnect SOP Header

     http://msdn.microsoft.com/en-us/library/bb625314.aspx

     

    Thanks

    Sandip

  • Bron Profile Picture
    Bron 2 on at
    Re: Econnect ACTLSHIP problem

    Hi -

    In my experience with creating sales orders via eConnect you do not have to supply that date.......have you tried creating an order without it? The SQL object should default in the '01/01/1900'...........

    Just a thought........Good Luck

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans