web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

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

I have the same question (0)
  • 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,306 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 4 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,306 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 4 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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans