Drop Shipment a valid PO is required

MattSpotts · September 10, 2020, 8:07pm

I am trying this from a fresh drop shipment, no lines no other POs

bboes · September 11, 2020, 1:07pm

A screen shot of the Sales Order release screen and the PO entry release screen would be helpful

MattSpotts · September 11, 2020, 3:06pm

They both match. I am not sure it is anything to do with the data we see rather I think there is a flaw with the data we don’t see.

ckrusen · September 11, 2020, 3:37pm

Have you run a trace?

Launch the Drop Ship form, and enter the PO Num - DO NOT hit TAB yet
Enable tracing and clear the log
Back in the Drop Ship form, tab out of the PO num field. Hit Okay on the error message(s).
Back in the Trace window, click View Log.
Copy the contents and paste them here. The pasted text with 3 ticks ``` on a line by themselves, and 3 more after, the pasted text . This will format them for easier reading.

MattSpotts · September 11, 2020, 3:42pm

<tracePacket>
  <businessObject>Erp.Proxy.BO.DropShipImpl</businessObject>
  <methodName>GetPOInfo</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>System.Void</returnType>
  <localTime>9/11/2020 11:40:04:2323952 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="171" roundTrip="106" channel="0" bpm="0" other="65" />
  <retries>0</retries>
  <parameters>
    <parameter name="ds" type="Erp.BO.DropShipDataSet">
      <DropShipDataSet xmlns="http://www.epicor.com/Ice/300/BO/DropShip/DropShip" />
    </parameter>
    <parameter name="poNum" type="System.Int32"><![CDATA[106363]]></parameter>
    <parameter name="vendorNum" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="purPoint" type="System.String"><![CDATA[]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.Lib.BOReaderImpl</businessObject>
  <methodName>GetRows</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>System.Data.DataSet</returnType>
  <localTime>9/11/2020 11:40:14:4897900 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="49" roundTrip="28" channel="20" bpm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="serviceNamespace" type="System.String"><![CDATA[Ice:BO:Company]]></parameter>
    <parameter name="whereClause" type="System.String"><![CDATA[Company = 'TEST']]></parameter>
    <parameter name="columnList" type="System.String"><![CDATA[ESEURL,ESENotificationSourceID]]></parameter>
  </parameters>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.Lib.BOReaderImpl</businessObject>
  <methodName>GetRows</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>System.Data.DataSet</returnType>
  <localTime>9/11/2020 11:40:14:5396941 AM</localTime>
  <threadID>1</threadID>
  <executionTime total="29" roundTrip="28" channel="0" bpm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="serviceNamespace" type="System.String"><![CDATA[Ice:BO:UserFile]]></parameter>
    <parameter name="whereClause" type="System.String"><![CDATA[UserID = 'mspotts']]></parameter>
    <parameter name="columnList" type="System.String"><![CDATA[ESEUserID,ESEPassword,DomainName,OSUserId]]></parameter>
  </parameters>
</tracePacket>

Doug.C · September 11, 2020, 3:52pm

Is mspotts an authorized buyer for the PO?

ckrusen · September 11, 2020, 3:54pm

Is this in your Test DB?

Any customizations or BPM’s?

Your trace shows DropShip.GetPOInfo being called, then two calls to BOReader.GetRows.

My trace shows calls of:

BO.DropShip.GetPOInfo
BO.Vendor.GetList
BO.DropShip.BuildShipToCustList
BO.DropShip.ChangeDropShipHeadShipToCustNum
BO.DropShip.BuildShipToList
BO.DropShip.GetShipToAddressMultiKey

MattSpotts · September 11, 2020, 3:58pm

I will check the customizations and the bpms but i don’t believe there are any. the additional calls you see are after the get po info which is where my trace errors out.

MattSpotts · September 11, 2020, 3:58pm

authorized user for the buyer yes

ckrusen · September 11, 2020, 4:00pm

Try running the Trace again with the options “Write Full dataset” and “Write Response Data” selected, and re-post.

MattSpotts · September 11, 2020, 4:14pm

<tracePacket>
  <businessObject>Ice.Proxy.BO.ReportMonitorImpl</businessObject>
  <methodName>GetRowsKeepIdleTime</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>Ice.Tablesets.ReportMonitorTableset</returnType>
  <localTime>9/11/2020 12:02:24:5343751 PM</localTime>
  <threadID>13</threadID>
  <executionTime total="82" roundTrip="23" channel="0" bpm="0" other="59" />
  <retries>0</retries>
  <parameters>
    <parameter name="whereClauseSysRptLst" type="System.String"><![CDATA[((PrintDriver='TEXT' AND (AutoAction='PRINT' OR AutoAction='PREVIEW')) OR (PrintDriver='CRYSTAL' AND (AutoAction='PRINT' OR AutoAction='AUTOPRT' OR AutoAction='PREVIEW' OR AutoAction='AUTOPRV')) OR (PrintDriver='EPIFIN' AND (AutoAction='PRINT' OR AutoAction='PREVIEW')) OR (PrintDriver='BARTENDER' AND (AutoAction='AUTOPRT' OR AutoAction='AUTOPRV')) OR (PrintDriver='EDI' AND AutoAction<>'') OR (PrintDriver='SSRS' AND (AutoAction='PREVIEW' OR AutoAction='PRINT') AND LastAction='SSRSREADY')) AND WorkStationID='UMIW10L01 1']]></parameter>
    <parameter name="pageSize" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="absolutePage" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="morePages" type="System.Boolean"><![CDATA[False]]></parameter>
  </parameters>
  <returnValues>
    <returnParameter name="returnDS" type="Ice.BO.ReportMonitorDataSet">
      <ReportMonitorDataSet xmlns="http://www.epicor.com/Ice/300/BO/ReportMonitor/ReportMonitor" />
    </returnParameter>
    <returnParameter name="morePages" type="System.Boolean"><![CDATA[False]]></returnParameter>
  </returnValues>
</tracePacket>

<tracePacket>
  <businessObject>Erp.Proxy.BO.DropShipImpl</businessObject>
  <methodName>GetPOInfo</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>System.Void</returnType>
  <localTime>9/11/2020 12:02:28:5040547 PM</localTime>
  <threadID>1</threadID>
  <executionTime total="82" roundTrip="42" channel="37" bpm="0" other="3" />
  <retries>0</retries>
  <parameters>
    <parameter name="ds" type="Erp.BO.DropShipDataSet">
      <DropShipDataSet xmlns="http://www.epicor.com/Ice/300/BO/DropShip/DropShip">
        <DropShipHead>
          <Company>TEST</Company>
          <PackSlip></PackSlip>
          <PONum>0</PONum>
          <VendorNum>0</VendorNum>
          <PurPoint></PurPoint>
          <ShipToNum></ShipToNum>
          <ReceivedShipped>false</ReceivedShipped>
          <EntryPerson>mspotts</EntryPerson>
          <EntryDate>2020-09-10T00:00:00-04:00</EntryDate>
          <ReceivePerson></ReceivePerson>
          <ReceiptDate>2020-09-10T00:00:00-04:00</ReceiptDate>
          <ShipViaCode></ShipViaCode>
          <TrackingNumber></TrackingNumber>
          <APInvoiced>false</APInvoiced>
          <ARInvoiced>false</ARInvoiced>
          <ShipmentPackNum>0</ShipmentPackNum>
          <ReceiptPackSlip></ReceiptPackSlip>
          <ShipComment></ShipComment>
          <ReceiptComment></ReceiptComment>
          <ChangedBy></ChangedBy>
          <ChangeTime>0</ChangeTime>
          <CustNum>0</CustNum>
          <BTCustNum>0</BTCustNum>
          <BTConNum>0</BTConNum>
          <Plant>MfgSys</Plant>
          <ShipToCustNum>0</ShipToCustNum>
          <SysRevID>0</SysRevID>
          <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
          <AddrList></AddrList>
          <ShipToAddrList></ShipToAddrList>
          <ShipToNumName></ShipToNumName>
          <BillAddr></BillAddr>
          <BitFlag>0</BitFlag>
          <CustNumBTName></CustNumBTName>
          <CustNumCustID></CustNumCustID>
          <CustNumName></CustNumName>
          <PurPointZip></PurPointZip>
          <PurPointAddress2></PurPointAddress2>
          <PurPointPrimPCon>0</PurPointPrimPCon>
          <PurPointCountry></PurPointCountry>
          <PurPointAddress3></PurPointAddress3>
          <PurPointCity></PurPointCity>
          <PurPointAddress1></PurPointAddress1>
          <PurPointName></PurPointName>
          <PurPointState></PurPointState>
          <ShipToCustNumBTName></ShipToCustNumBTName>
          <ShipToCustNumCustID></ShipToCustNumCustID>
          <ShipToCustNumName></ShipToCustNumName>
          <ShipViaCodeDescription></ShipViaCodeDescription>
          <ShipViaCodeWebDesc></ShipViaCodeWebDesc>
          <VendorNumAddress1></VendorNumAddress1>
          <VendorNumVendorID></VendorNumVendorID>
          <VendorNumCity></VendorNumCity>
          <VendorNumState></VendorNumState>
          <VendorNumCurrencyCode></VendorNumCurrencyCode>
          <VendorNumAddress3></VendorNumAddress3>
          <VendorNumAddress2></VendorNumAddress2>
          <VendorNumDefaultFOB></VendorNumDefaultFOB>
          <VendorNumName></VendorNumName>
          <VendorNumZIP></VendorNumZIP>
          <VendorNumTermsCode></VendorNumTermsCode>
          <VendorNumCountry></VendorNumCountry>
          <RowMod>A</RowMod>
        </DropShipHead>
      </DropShipDataSet>
    </parameter>
    <parameter name="poNum" type="System.Int32"><![CDATA[106363]]></parameter>
    <parameter name="vendorNum" type="System.Int32"><![CDATA[0]]></parameter>
    <parameter name="purPoint" type="System.String"><![CDATA[]]></parameter>
  </parameters>
  <paramDataSetChanges>
    <paramDataSet name="ds" useDataSetNbr="0">
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="Company"><![CDATA[TEST]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PackSlip"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PONum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPoint"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToNum"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ReceivedShipped"><![CDATA[False]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="EntryPerson"><![CDATA[mspotts]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="EntryDate"><![CDATA[9/10/2020 12:00:00 AM]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ReceivePerson"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ReceiptDate"><![CDATA[9/10/2020 12:00:00 AM]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipViaCode"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="TrackingNumber"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="APInvoiced"><![CDATA[False]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ARInvoiced"><![CDATA[False]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipmentPackNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ReceiptPackSlip"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipComment"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ReceiptComment"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ChangedBy"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ChangeTime"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="CustNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="BTCustNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="BTConNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="Plant"><![CDATA[MfgSys]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToCustNum"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="SysRevID"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="SysRowID"><![CDATA[00000000-0000-0000-0000-000000000000]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="AddrList"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToAddrList"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToNumName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="BillAddr"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="BitFlag"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="CustNumBTName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="CustNumCustID"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="CustNumName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointZip"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointAddress2"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointPrimPCon"><![CDATA[0]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointCountry"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointAddress3"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointCity"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointAddress1"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="PurPointState"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToCustNumBTName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToCustNumCustID"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipToCustNumName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipViaCodeDescription"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="ShipViaCodeWebDesc"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumAddress1"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumVendorID"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumCity"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumState"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumCurrencyCode"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumAddress3"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumAddress2"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumDefaultFOB"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumName"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumZIP"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumTermsCode"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="VendorNumCountry"><![CDATA[]]></changedValue>
      <changedValue tableName="DropShipHead" rowState="Added" rowNum="0" colName="RowMod"><![CDATA[A]]></changedValue>
    </paramDataSet>
  </paramDataSetChanges>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.Lib.BOReaderImpl</businessObject>
  <methodName>GetRows</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>System.Data.DataSet</returnType>
  <localTime>9/11/2020 12:02:31:9025739 PM</localTime>
  <threadID>1</threadID>
  <executionTime total="57" roundTrip="36" channel="21" bpm="0" other="0" />
  <retries>0</retries>
  <parameters>
    <parameter name="serviceNamespace" type="System.String"><![CDATA[Ice:BO:Company]]></parameter>
    <parameter name="whereClause" type="System.String"><![CDATA[Company = 'TEST']]></parameter>
    <parameter name="columnList" type="System.String"><![CDATA[ESEURL,ESENotificationSourceID]]></parameter>
  </parameters>
  <returnValues>
    <returnParameter name="result" type="System.Data.DataSet">
      <NewDataSet>
        <Company>
          <ESEURL></ESEURL>
          <ESENotificationSourceID></ESENotificationSourceID>
        </Company>
      </NewDataSet>
    </returnParameter>
  </returnValues>
</tracePacket>

<tracePacket>
  <businessObject>Ice.Proxy.Lib.BOReaderImpl</businessObject>
  <methodName>GetRows</methodName>
  <appServerUri>net.tcp://epicorserver/ERP10/</appServerUri>
  <returnType>System.Data.DataSet</returnType>
  <localTime>9/11/2020 12:02:31:9604236 PM</localTime>
  <threadID>1</threadID>
  <executionTime total="29" roundTrip="28" channel="0" bpm="0" other="1" />
  <retries>0</retries>
  <parameters>
    <parameter name="serviceNamespace" type="System.String"><![CDATA[Ice:BO:UserFile]]></parameter>
    <parameter name="whereClause" type="System.String"><![CDATA[UserID = 'mspotts']]></parameter>
    <parameter name="columnList" type="System.String"><![CDATA[ESEUserID,ESEPassword,DomainName,OSUserId]]></parameter>
  </parameters>
  <returnValues>
    <returnParameter name="result" type="System.Data.DataSet">
      <NewDataSet>
        <UserFile>
          <ESEUserID></ESEUserID>
          <ESEPassword></ESEPassword>
          <DomainName>GC</DomainName>
          <OSUserID>mspotts</OSUserID>
        </UserFile>
        <UserComp />
      </NewDataSet>
    </returnParameter>
  </returnValues>
</tracePacket>

ckrusen · September 11, 2020, 4:21pm

Did you check the “Write Response Data” box too?

Your trace data doesn’t have a <returnValues> ... </returnValues> section in the DropShip.GetPOInfo packet.

MattSpotts · September 11, 2020, 4:22pm

yes. I did. I believe there is no response data because it is failing at the getpo info and nothing is being returned.

ckrusen · September 11, 2020, 4:29pm

Is it any PO, or just this one?

FWIW - I can enter a PO Num for a PO that does not have any Drop Ship lines, and the form populates the Summary sheet just fine. Even does that if I enter a PO Num for a closed PO.

MattSpotts · September 11, 2020, 4:31pm

just this one that’s what’s perplexing. It’s like the PO doesn’t exist but it clearly does.

ckrusen · September 11, 2020, 4:35pm

I’ve had PO’s act strange when the Duplicate PO Function was used, and one of the lines referenced a sales order (like a Buy To Order line). When the duplication process ran it copied all the referenced info, like the order num and line num the original PO was for. And now I had two PO’s referencing the same BTO line. Normally you can’t do that. If you try it manually it stops you. But when it was created via the Duplicate PO process, it doesn’t do those checks.

MattSpotts · September 11, 2020, 4:53pm

That would make sense except Drop shipments don’t store the order information the sales order does.

ckrusen · September 11, 2020, 4:56pm

But they store info that links to it. This it what was giving us errors on PO’s that were made by duping on that had a BTO (which like Drop Ship, only holds the Order and Line ).

Jonathan · September 11, 2020, 5:48pm

Check the database anyway there might be a conflicting record there.

select * from Erp.DropShipDtl where VendorNum = 0 and PurPoint = ‘’ and PackSlip = ‘’ and Company = ‘TEST’

EDIT: Changed PONum with PurPoint

MattSpotts · September 11, 2020, 5:54pm

That returned a row