Duplicate record error on new quote? 10.1.600.4

Epicor ERP 10
1

We are working on upgrade testing and I’m just wondering if anyone has seen this problem. When trying to create a new quote we get an error, “This is a duplicate entry of an existing record”.

I’ve been on the phone with service, they had me do the 790 conversion (Re-Initialize QuoteHed Customer CustCnt CRMCall POHeader Key Blocks), that didn’t work, we set the initial recorder from 10000 to 100000 (added a 0). That didn’t work. Restarted the app server after those changes still nothing.

Service is still working on it (hopefully) but I thought I would see if anyone else was having this problem. I was thinking of trying a pre-processing method directive to set the quote number (the system doesn’t change it from 0 to a number) just to see if it could kick off the numbering process, but didn’t know if that was a good idea or not.

Brandon

1 Like
2

Have you tried running a trace while creating the new quote, you might be able to see what quote number it is assigning.
Do you know if it is the quote number that is the duplicate or some other record it is trying to create, like a task ID record that would be associated to the quote.
Either way I think the trace might be better than a BPM at first since you will see every method that is called and the data feeding it to look for bad data.
Check your Company config and make sure something didn’t happen to your Starting Quote # field during the upgrade.
I have a feeling for some reason that the issue is probably with the Task Set & Tasks…

3

So I did the trace, I always shows the QuoteNum at 0. I did the same trace in 10.0 in test and I get a return parameter where it gives the next number, but in 10.1 it never gets to that part.

We don’t have any tasks or task ID’s set up anywhere. We don’t use them, so I’m not sure how that would mess things up for a brand new quote…

That’s what I meant to say service had me check, I was in a hurry when I was typing last night.

4

Make Support aware of the trace results, also do you happen to have any BPM’s or anything in quotes? If so, there could be a BPM that didn’t convert right or needs to be recompiled, and since that fails it might be halting further processing.
Can you post the relevant sections of the two traces here?
Creating a new quote most likely is part of Epicor’s automated testing, so I doubt they missed a bug like this.

5

So service called back, they said the same thing about the tasks, but it was related to global alerts being turned on. Ours aren’t so it wasn’t that for us. We have to send them our database for them to check it out.

I attached the txt file of the 10.0 because that one is a lot longer than the 10.1 trace (since it finishes)
10.0 trace working quote save.txt (76.3 KB)

Below are the traces from the 10.1 system. No BPM’s running on Quote Update. Or QuoteHed table.

    <tracePacket>
      <businessObject>Erp.Proxy.BO.QuoteImpl</businessObject>
      <methodName>Update</methodName>
      <appServerUri>net.tcp://epicor10-1/ERP10-1/</appServerUri>
      <returnType>System.Void</returnType>
      <localTime>6/20/2017 10:24:41:9666740 AM</localTime>
      <threadID>1</threadID>
      <executionTime total="128" roundTrip="119" channel="0" bpm="3" other="6" />
      <retries>0</retries>
      <parameters>
        <parameter name="ds" type="Erp.BO.QuoteDataSet">
          <QuoteDataSet xmlns="http://www.epicor.com/Ice/300/BO/Quote/Quote">
            <QuoteHed>
              <Company>RAPAT</Company>
              <QuoteNum>0</QuoteNum>
              <CustNum>2960</CustNum>
              <EntryDate>2017-06-20T00:00:00-05:00</EntryDate>
              <PrcConNum>0</PrcConNum>
              <QuoteComment></QuoteComment>
              <DueDate>2017-07-20T00:00:00-05:00</DueDate>
              <Quoted>false</Quoted>
              <Reference></Reference>
              <CheckOff1>false</CheckOff1>
              <CheckOff2>false</CheckOff2>
              <CheckOff3>false</CheckOff3>
              <CheckOff4>false</CheckOff4>
              <CheckOff5>false</CheckOff5>
              <Expired>false</Expired>
              <FlwAlrtSnt>false</FlwAlrtSnt>
              <DueAlrtSnt>true</DueAlrtSnt>
              <CurrencyCode>USD</CurrencyCode>
              <ExchangeRate>1</ExchangeRate>
              <LeadRating></LeadRating>
              <TerritoryID>USA</TerritoryID>
              <TaskSetID>Quote</TaskSetID>
              <CurrentStage>LEAD</CurrentStage>
              <ParentQuoteNum>0</ParentQuoteNum>
              <ActiveTaskID></ActiveTaskID>
              <LastTaskID></LastTaskID>
              <ReasonType></ReasonType>
              <ReasonCode></ReasonCode>
              <ConfidencePct>0</ConfidencePct>
              <DiscountPercent>0</DiscountPercent>
              <ShipToNum></ShipToNum>
              <ShpConNum>0</ShpConNum>
              <QuoteClosed>false</QuoteClosed>
              <ShipViaCode></ShipViaCode>
              <MktgCampaignID>LOCAL</MktgCampaignID>
              <MktgEvntSeq>1</MktgEvntSeq>
              <CallTypeCode></CallTypeCode>
              <PONum></PONum>
              <TermsCode>8</TermsCode>
              <Ordered>false</Ordered>
              <ApplyOrderBasedDisc>false</ApplyOrderBasedDisc>
              <AutoOrderBasedDisc>false</AutoOrderBasedDisc>
              <HDCaseNum>0</HDCaseNum>
              <BTCustNum>2960</BTCustNum>
              <LockRate>false</LockRate>
              <ChangedBy></ChangedBy>
              <ChangeTime>0</ChangeTime>
              <ReadyToCalc>false</ReadyToCalc>
              <ExportRequested></ExportRequested>
              <Rounding>0</Rounding>
              <DocRounding>0</DocRounding>
              <Rpt1Rounding>0</Rpt1Rounding>
              <Rpt2Rounding>0</Rpt2Rounding>
              <Rpt3Rounding>0</Rpt3Rounding>
              <RateGrpCode>CONV</RateGrpCode>
              <QuoteAmt>0</QuoteAmt>
              <DocQuoteAmt>0</DocQuoteAmt>
              <Rpt1QuoteAmt>0</Rpt1QuoteAmt>
              <Rpt2QuoteAmt>0</Rpt2QuoteAmt>
              <Rpt3QuoteAmt>0</Rpt3QuoteAmt>
              <UseOTS>false</UseOTS>
              <OTSName></OTSName>
              <OTSAddress1></OTSAddress1>
              <OTSAddress2></OTSAddress2>
              <OTSAddress3></OTSAddress3>
              <OTSCity></OTSCity>
              <OTSState></OTSState>
              <OTSZIP></OTSZIP>
              <OTSResaleID></OTSResaleID>
              <OTSTaxRegionCode>MN</OTSTaxRegionCode>
              <OTSContact></OTSContact>
              <OTSFaxNum></OTSFaxNum>
              <OTSPhoneNum></OTSPhoneNum>
              <OTSCountryNum>0</OTSCountryNum>
              <ShipToCustNum>2960</ShipToCustNum>
              <InPrice>false</InPrice>
              <WorstCsPct>0</WorstCsPct>
              <BestCsPct>0</BestCsPct>
              <DemandContractNum>0</DemandContractNum>
              <DemandHeadSeq>0</DemandHeadSeq>
              <EDIReady>false</EDIReady>
              <EDIQuote>false</EDIQuote>
              <EDIAck>false</EDIAck>
              <OutboundQuoteDocCtr>0</OutboundQuoteDocCtr>
              <DemandProcessTime>0</DemandProcessTime>
              <LastTCtrlNum></LastTCtrlNum>
              <LastBatchNum></LastBatchNum>
              <AutoPrintReady>false</AutoPrintReady>
              <DocTotalSATax>0</DocTotalSATax>
              <DocTotalTax>0</DocTotalTax>
              <DocTotalWHTax>0</DocTotalWHTax>
              <Rpt1TotalSATax>0</Rpt1TotalSATax>
              <Rpt1TotalTax>0</Rpt1TotalTax>
              <Rpt1TotalWHTax>0</Rpt1TotalWHTax>
              <Rpt2TotalSATax>0</Rpt2TotalSATax>
              <Rpt2TotalTax>0</Rpt2TotalTax>
              <Rpt2TotalWHTax>0</Rpt2TotalWHTax>
              <Rpt3TotalSATax>0</Rpt3TotalSATax>
              <DeclaredAmt>0</DeclaredAmt>
              <Rpt3TotalTax>0</Rpt3TotalTax>
              <DeclaredIns>false</DeclaredIns>
              <Rpt3TotalWHTax>0</Rpt3TotalWHTax>
              <DeliveryConf>1</DeliveryConf>
              <DeliveryType></DeliveryType>
              <DocOnly>false</DocOnly>
              <TaxRegionCode>MN</TaxRegionCode>
              <DropShip>false</DropShip>
              <TotalSATax>0</TotalSATax>
              <ExtCompany></ExtCompany>
              <TotalTax>0</TotalTax>
              <GroundType></GroundType>
              <TotalWHTax>0</TotalWHTax>
              <Hazmat>false</Hazmat>
              <ICPONum>0</ICPONum>
              <Linked>false</Linked>
              <LockQty>false</LockQty>
              <NotifyEMail></NotifyEMail>
              <NotifyFlag>false</NotifyFlag>
              <OTSCustSaved>false</OTSCustSaved>
              <OTSSaveAs></OTSSaveAs>
              <OTSSaveCustID></OTSSaveCustID>
              <OverrideCarrier>false</OverrideCarrier>
              <OverrideService>false</OverrideService>
              <RefNotes></RefNotes>
              <ResDelivery>false</ResDelivery>
              <SatPickup>false</SatPickup>
              <ServAlert>false</ServAlert>
              <ServAuthNum></ServAuthNum>
              <ServHomeDel>false</ServHomeDel>
              <ServInstruct></ServInstruct>
              <ServPhone></ServPhone>
              <ServRef1></ServRef1>
              <ServRef2></ServRef2>
              <ServRef3></ServRef3>
              <ServRef4></ServRef4>
              <ServRef5></ServRef5>
              <ServRelease>false</ServRelease>
              <ServSignature>false</ServSignature>
              <VoidQuote>false</VoidQuote>
              <ApplyChrg>false</ApplyChrg>
              <ChrgAmount>0</ChrgAmount>
              <COD>false</COD>
              <TotalDiscPct>0</TotalDiscPct>
              <TotalExpected>0</TotalExpected>
              <TotalGrossValue>0</TotalGrossValue>
              <TotalMiscAmt>0</TotalMiscAmt>
              <TotalPotential>0</TotalPotential>
              <TotalWorstCs>0</TotalWorstCs>
              <DocTotalBestCs>0</DocTotalBestCs>
              <DocTotalDiscount>0</DocTotalDiscount>
              <DocTotalDiscPct>0</DocTotalDiscPct>
              <DocTotalExpected>0</DocTotalExpected>
              <DocTotalGrossValue>0</DocTotalGrossValue>
              <DocTotalMiscAmt>0</DocTotalMiscAmt>
              <DocTotalPotential>0</DocTotalPotential>
              <DocTotalWorstCs>0</DocTotalWorstCs>
              <Rpt1TotalBestCs>0</Rpt1TotalBestCs>
              <Rpt1TotalDiscount>0</Rpt1TotalDiscount>
              <Rpt1TotalDiscPct>0</Rpt1TotalDiscPct>
              <Rpt1TotalExpected>0</Rpt1TotalExpected>
              <Rpt1TotalGrossValue>0</Rpt1TotalGrossValue>
              <Rpt1TotalMiscAmt>0</Rpt1TotalMiscAmt>
              <Rpt1TotalPotential>0</Rpt1TotalPotential>
              <Rpt1TotalWorstCs>0</Rpt1TotalWorstCs>
              <Rpt2TotalBestCs>0</Rpt2TotalBestCs>
              <Rpt2TotalDiscount>0</Rpt2TotalDiscount>
              <Rpt2TotalDiscPct>0</Rpt2TotalDiscPct>
              <Rpt2TotalExpected>0</Rpt2TotalExpected>
              <Rpt2TotalGrossValue>0</Rpt2TotalGrossValue>
              <Rpt2TotalMiscAmt>0</Rpt2TotalMiscAmt>
              <Rpt2TotalPotential>0</Rpt2TotalPotential>
              <Rpt2TotalWorstCs>0</Rpt2TotalWorstCs>
              <Rpt3TotalBestCs>0</Rpt3TotalBestCs>
              <Rpt3TotalDiscount>0</Rpt3TotalDiscount>
              <Rpt3TotalDiscPct>0</Rpt3TotalDiscPct>
              <Rpt3TotalExpected>0</Rpt3TotalExpected>
              <Rpt3TotalGrossValue>0</Rpt3TotalGrossValue>
              <Rpt3TotalMiscAmt>0</Rpt3TotalMiscAmt>
              <Rpt3TotalPotential>0</Rpt3TotalPotential>
              <Rpt3TotalWorstCs>0</Rpt3TotalWorstCs>
              <TotalBestCs>0</TotalBestCs>
              <TotalDiscount>0</TotalDiscount>
              <CODAmount>0</CODAmount>
              <CODCheck>false</CODCheck>
              <CODFreight>false</CODFreight>
              <LOQPrepressText></LOQPrepressText>
              <LOQNewPageOnQuoteLine>false</LOQNewPageOnQuoteLine>
              <LOQBookPCFinishing>false</LOQBookPCFinishing>
              <LOQBookPCPaper>false</LOQBookPCPaper>
              <LOQBookPCPress>false</LOQBookPCPress>
              <LOQBookPCPlates>false</LOQBookPCPlates>
              <LOQVariations>false</LOQVariations>
              <AEPLOQType></AEPLOQType>
              <LOQPrepressStyle></LOQPrepressStyle>
              <QuoteCSR></QuoteCSR>
              <DueHour></DueHour>
              <SysRevID>0</SysRevID>
              <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
              <ECCConfirmed>false</ECCConfirmed>
              <ECCConfirmedBy></ECCConfirmedBy>
              <ECCMsgType></ECCMsgType>
              <ECCWebReady>false</ECCWebReady>
              <ECCQuoteNum></ECCQuoteNum>
              <ECCCmmtRef></ECCCmmtRef>
              <ECCComment></ECCComment>
              <ECCStatus></ECCStatus>
              <ECCCmmtRefSK></ECCCmmtRefSK>
              <ExternalCRMQuote>false</ExternalCRMQuote>
              <ExternalCRMQuoteID></ExternalCRMQuoteID>
              <ExternalCRMOrderID></ExternalCRMOrderID>
              <ECCSalesRepID></ECCSalesRepID>
              <Tax>0</Tax>
              <DocTax>0</DocTax>
              <Rpt1Tax>0</Rpt1Tax>
              <Rpt2Tax>0</Rpt2Tax>
              <Rpt3Tax>0</Rpt3Tax>
              <HdrTaxNoUpdt>false</HdrTaxNoUpdt>
              <AvailBTCustList>100010`Same as Sold To</AvailBTCustList>
              <BestCsPctCalc>0</BestCsPctCalc>
              <BTCustomerName>Same as Sold To</BTCustomerName>
              <ChangeDescription></ChangeDescription>
              <CheckOffLabel1></CheckOffLabel1>
              <CheckOffLabel2></CheckOffLabel2>
              <CheckOffLabel3></CheckOffLabel3>
              <CheckOffLabel4></CheckOffLabel4>
              <CheckOffLabel5></CheckOffLabel5>
              <Conclusion></Conclusion>
              <ConName></ConName>
              <CurrencySwitch>false</CurrencySwitch>
              <CurrentStageDesc>Lead</CurrentStageDesc>
              <CustAllowOTS>true</CustAllowOTS>
              <CustOnCreditHold>false</CustOnCreditHold>
              <DaysOpen>0</DaysOpen>
              <DiscountPercentCalc>0</DiscountPercentCalc>
              <DocTaxAmt>0</DocTaxAmt>
              <DocTotalQuote>0</DocTotalQuote>
              <dspBTCustID></dspBTCustID>
              <EmailAddress></EmailAddress>
              <EnableOrderBasedDisc>false</EnableOrderBasedDisc>
              <ExpectedCsPct>0</ExpectedCsPct>
              <FaxNum></FaxNum>
              <FOB></FOB>
              <FOBDescription></FOBDescription>
              <HasQuoteLines>false</HasQuoteLines>
              <LogChanges>false</LogChanges>
              <OrderDiscount>0</OrderDiscount>
              <OrderPONum></OrderPONum>
              <OrderShipVia></OrderShipVia>
              <OrderTerms></OrderTerms>
              <OTSSaved>false</OTSSaved>
              <OTSShipToNum></OTSShipToNum>
              <PhoneNum></PhoneNum>
              <PreventQQChange>true</PreventQQChange>
              <RateLabel>Exchange Rate</RateLabel>
              <Rpt1TaxAmt>0</Rpt1TaxAmt>
              <Rpt1TotalQuote>0</Rpt1TotalQuote>
              <Rpt2TaxAmt>0</Rpt2TaxAmt>
              <Rpt2TotalQuote>0</Rpt2TotalQuote>
              <Rpt3TaxAmt>0</Rpt3TaxAmt>
              <Rpt3TotalQuote>0</Rpt3TotalQuote>
              <SalesRepCode>HESTD</SalesRepCode>
              <SalesRepName></SalesRepName>
              <ShipToAddrList>Walk-In Customer~  ~USA</ShipToAddrList>
              <TaxAmt>0</TaxAmt>
              <TotalQuote>0</TotalQuote>
              <WorseCsPctCalc>0</WorseCsPctCalc>
              <AddrList>Walk-In Customer~  ~USA</AddrList>
              <BaseCurrencyID>USD</BaseCurrencyID>
              <BaseCurrSymbol></BaseCurrSymbol>
              <BTAddressList>Walk-In Customer~  ~USA</BTAddressList>
              <BTCustID>100010</BTCustID>
              <BitFlag>0</BitFlag>
              <ActiveTaskTaskDescription></ActiveTaskTaskDescription>
              <CurrencyDocumentDesc></CurrencyDocumentDesc>
              <CurrencyCurrencyID>USD</CurrencyCurrencyID>
              <CurrencyCurrName>USD</CurrencyCurrName>
              <CurrencyCurrDesc>USD</CurrencyCurrDesc>
              <CurrencyCurrSymbol></CurrencyCurrSymbol>
              <CustomerAllowShipTo3>false</CustomerAllowShipTo3>
              <CustomerBTName></CustomerBTName>
              <CustomerCustID>100010</CustomerCustID>
              <CustomerName>Walk-In Customer</CustomerName>
              <CustomerCheckDuplicatePO>false</CustomerCheckDuplicatePO>
              <HDCaseDescription></HDCaseDescription>
              <LastTaskTaskDescription></LastTaskTaskDescription>
              <MktgCpgnCampDescription>Local Sources</MktgCpgnCampDescription>
              <MktgEventEvntDescription>Quote</MktgEventEvntDescription>
              <OTSCountryNumDescription></OTSCountryNumDescription>
              <OTSTaxRegionCodeDescription>MINNESOTA 6.875%</OTSTaxRegionCodeDescription>
              <RateGrpDescription>Conversion</RateGrpDescription>
              <ReasonDescription></ReasonDescription>
              <ResponseCallTypeDesc></ResponseCallTypeDesc>
              <ShipToBTName></ShipToBTName>
              <ShipToCustID>100010</ShipToCustID>
              <ShipToName>Walk-In Customer</ShipToName>
              <ShipViaWebDesc></ShipViaWebDesc>
              <ShipViaDescription></ShipViaDescription>
              <TaskSetTaskSetDescription>Quote</TaskSetTaskSetDescription>
              <TaskSetWorkflowType>CRM</TaskSetWorkflowType>
              <TaxRegionTaxConnectCalc>false</TaxRegionTaxConnectCalc>
              <TaxRegionDescription>MINNESOTA 6.875%</TaxRegionDescription>
              <TermsDescription>NET 30</TermsDescription>
              <TerritoryTerritoryDesc>USA</TerritoryTerritoryDesc>
              <XbSystCalcQuoteTax>false</XbSystCalcQuoteTax>
              <RowMod>A</RowMod>
            </QuoteHed>
            <TaxConnectStatus>
              <Company>RAPAT</Company>
              <ETCOffline>true</ETCOffline>
              <ErrorMessage></ErrorMessage>
              <TCStatus>false</TCStatus>
              <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
              <RowMod>U</RowMod>
            </TaxConnectStatus>
          </QuoteDataSet>
        </parameter>
        <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
          <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
            <BpmData>
              <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
            </BpmData>
          </ContextDataSet>
        </parameter>
      </parameters>
      <paramDataSetChanges>
        <paramDataSet name="ds" useDataSetNbr="0">
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Company"><![CDATA[RAPAT]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="QuoteNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustNum"><![CDATA[2960]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="EntryDate"><![CDATA[6/20/2017 12:00:00 AM]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="PrcConNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="QuoteComment"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DueDate"><![CDATA[7/20/2017 12:00:00 AM]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Quoted"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Reference"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOff1"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOff2"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOff3"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOff4"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOff5"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Expired"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="FlwAlrtSnt"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DueAlrtSnt"><![CDATA[True]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencyCode"><![CDATA[USD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExchangeRate"><![CDATA[1]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LeadRating"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TerritoryID"><![CDATA[USA]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaskSetID"><![CDATA[Quote]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrentStage"><![CDATA[LEAD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ParentQuoteNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ActiveTaskID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LastTaskID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ReasonType"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ReasonCode"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ConfidencePct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DiscountPercent"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipToNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShpConNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="QuoteClosed"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipViaCode"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="MktgCampaignID"><![CDATA[LOCAL]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="MktgEvntSeq"><![CDATA[1]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CallTypeCode"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="PONum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TermsCode"><![CDATA[8]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Ordered"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ApplyOrderBasedDisc"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="AutoOrderBasedDisc"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="HDCaseNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BTCustNum"><![CDATA[2960]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LockRate"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ChangedBy"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ChangeTime"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ReadyToCalc"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExportRequested"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rounding"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocRounding"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1Rounding"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2Rounding"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3Rounding"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="RateGrpCode"><![CDATA[CONV]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="QuoteAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocQuoteAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1QuoteAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2QuoteAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3QuoteAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="UseOTS"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSName"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSAddress1"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSAddress2"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSAddress3"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSCity"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSState"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSZIP"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSResaleID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSTaxRegionCode"><![CDATA[MN]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSContact"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSFaxNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSPhoneNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSCountryNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipToCustNum"><![CDATA[2960]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="InPrice"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="WorstCsPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BestCsPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DemandContractNum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DemandHeadSeq"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="EDIReady"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="EDIQuote"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="EDIAck"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OutboundQuoteDocCtr"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DemandProcessTime"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LastTCtrlNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LastBatchNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="AutoPrintReady"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalSATax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalWHTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalSATax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalWHTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalSATax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalWHTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalSATax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DeclaredAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DeclaredIns"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalWHTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DeliveryConf"><![CDATA[1]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DeliveryType"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocOnly"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaxRegionCode"><![CDATA[MN]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DropShip"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalSATax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExtCompany"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="GroundType"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalWHTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Hazmat"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ICPONum"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Linked"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LockQty"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="NotifyEMail"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="NotifyFlag"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSCustSaved"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSSaveAs"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSSaveCustID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OverrideCarrier"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OverrideService"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="RefNotes"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ResDelivery"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="SatPickup"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServAlert"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServAuthNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServHomeDel"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServInstruct"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServPhone"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServRef1"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServRef2"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServRef3"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServRef4"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServRef5"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServRelease"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ServSignature"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="VoidQuote"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ApplyChrg"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ChrgAmount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="COD"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalDiscPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalExpected"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalGrossValue"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalMiscAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalPotential"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalWorstCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalBestCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalDiscount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalDiscPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalExpected"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalGrossValue"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalMiscAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalPotential"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalWorstCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalBestCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalDiscount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalDiscPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalExpected"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalGrossValue"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalMiscAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalPotential"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalWorstCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalBestCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalDiscount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalDiscPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalExpected"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalGrossValue"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalMiscAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalPotential"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalWorstCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalBestCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalDiscount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalDiscPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalExpected"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalGrossValue"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalMiscAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalPotential"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalWorstCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalBestCs"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalDiscount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CODAmount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CODCheck"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CODFreight"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQPrepressText"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQNewPageOnQuoteLine"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQBookPCFinishing"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQBookPCPaper"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQBookPCPress"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQBookPCPlates"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQVariations"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="AEPLOQType"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LOQPrepressStyle"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="QuoteCSR"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DueHour"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="SysRevID"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="SysRowID"><![CDATA[00000000-0000-0000-0000-000000000000]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCConfirmed"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCConfirmedBy"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCMsgType"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCWebReady"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCQuoteNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCCmmtRef"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCComment"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCStatus"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCCmmtRefSK"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExternalCRMQuote"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExternalCRMQuoteID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExternalCRMOrderID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ECCSalesRepID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Tax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1Tax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2Tax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3Tax"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="HdrTaxNoUpdt"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="AvailBTCustList"><![CDATA[100010`Same as Sold To]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BestCsPctCalc"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BTCustomerName"><![CDATA[Same as Sold To]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ChangeDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOffLabel1"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOffLabel2"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOffLabel3"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOffLabel4"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CheckOffLabel5"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Conclusion"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ConName"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencySwitch"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrentStageDesc"><![CDATA[Lead]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustAllowOTS"><![CDATA[True]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustOnCreditHold"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DaysOpen"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DiscountPercentCalc"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTaxAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="DocTotalQuote"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="dspBTCustID"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="EmailAddress"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="EnableOrderBasedDisc"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ExpectedCsPct"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="FaxNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="FOB"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="FOBDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="HasQuoteLines"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LogChanges"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OrderDiscount"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OrderPONum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OrderShipVia"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OrderTerms"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSSaved"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSShipToNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="PhoneNum"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="PreventQQChange"><![CDATA[True]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="RateLabel"><![CDATA[Exchange Rate]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TaxAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt1TotalQuote"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TaxAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt2TotalQuote"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TaxAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="Rpt3TotalQuote"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="SalesRepCode"><![CDATA[HESTD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="SalesRepName"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipToAddrList"><![CDATA[Walk-In Customer~  ~USA]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaxAmt"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TotalQuote"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="WorseCsPctCalc"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="AddrList"><![CDATA[Walk-In Customer~  ~USA]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BaseCurrencyID"><![CDATA[USD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BaseCurrSymbol"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BTAddressList"><![CDATA[Walk-In Customer~  ~USA]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BTCustID"><![CDATA[100010]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="BitFlag"><![CDATA[0]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ActiveTaskTaskDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencyDocumentDesc"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencyCurrencyID"><![CDATA[USD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencyCurrName"><![CDATA[USD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencyCurrDesc"><![CDATA[USD]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CurrencyCurrSymbol"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustomerAllowShipTo3"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustomerBTName"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustomerCustID"><![CDATA[100010]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustomerName"><![CDATA[Walk-In Customer]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="CustomerCheckDuplicatePO"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="HDCaseDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="LastTaskTaskDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="MktgCpgnCampDescription"><![CDATA[Local Sources]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="MktgEventEvntDescription"><![CDATA[Quote]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSCountryNumDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="OTSTaxRegionCodeDescription"><![CDATA[MINNESOTA 6.875%]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="RateGrpDescription"><![CDATA[Conversion]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ReasonDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ResponseCallTypeDesc"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipToBTName"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipToCustID"><![CDATA[100010]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipToName"><![CDATA[Walk-In Customer]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipViaWebDesc"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="ShipViaDescription"><![CDATA[]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaskSetTaskSetDescription"><![CDATA[Quote]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaskSetWorkflowType"><![CDATA[CRM]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaxRegionTaxConnectCalc"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TaxRegionDescription"><![CDATA[MINNESOTA 6.875%]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TermsDescription"><![CDATA[NET 30]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="TerritoryTerritoryDesc"><![CDATA[USA]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="XbSystCalcQuoteTax"><![CDATA[False]]></changedValue>
          <changedValue tableName="QuoteHed" rowState="Added" rowNum="0" colName="RowMod"><![CDATA[A]]></changedValue>
          <changedValue tableName="TaxConnectStatus" rowState="Modified" rowNum="0" colName="ETCOffline"><![CDATA[True]]></changedValue>
          <changedValue tableName="TaxConnectStatus" rowState="Modified" rowNum="0" colName="RowMod"><![CDATA[U]]></changedValue>
        </paramDataSet>
      </paramDataSetChanges>
    </tracePacket>

    <tracePacket>
      <businessObject>Ice.Proxy.BO.ReportMonitorImpl</businessObject>
      <methodName>GetRowsKeepIdleTime</methodName>
      <appServerUri>net.tcp://epicor10-1/ERP10-1/</appServerUri>
      <returnType>Ice.Tablesets.ReportMonitorTableset</returnType>
      <localTime>6/20/2017 10:24:43:2133125 AM</localTime>
      <threadID>13</threadID>
      <executionTime total="18" roundTrip="17" channel="0" bpm="0" other="1" />
      <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='BRANDONA-XI15 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>
      <serverTrace>
        <Op Utc="2017-06-20T15:24:43.2001733Z" act="Ice:BO:ReportMonitor/ReportMonitorSvcContract/GetRowsKeepIdleTime" dur="7.2197" cli="192.168.11.134:64193" usr="banderson" machine="EPICOR10-1" pid="10264" tid="10" xmlns="" />
      </serverTrace>
    </tracePacket>

    <tracePacket>
      <businessObject>Ice.Proxy.BO.SysMonitorTasksImpl</businessObject>
      <methodName>GetBallonRowsKeepIdleTime</methodName>
      <appServerUri>net.tcp://epicor10-1/ERP10-1/</appServerUri>
      <returnType>Ice.Tablesets.SysMonitorTasksTableset</returnType>
      <localTime>6/20/2017 10:24:43:2313301 AM</localTime>
      <threadID>13</threadID>
      <executionTime total="14" roundTrip="12" channel="0" bpm="0" other="2" />
      <retries>0</retries>
      <parameters>
        <parameter name="whereClauseSysTask" type="System.String"><![CDATA[history = true and startedon > 06/19/2017 and  SubmitUser = 'banderson']]></parameter>
        <parameter name="whereClauseSysTaskLog" type="System.String"><![CDATA[]]></parameter>
        <parameter name="pageSize" type="System.Int32"><![CDATA[0]]></parameter>
        <parameter name="absolutePage" type="System.Int32"><![CDATA[1]]></parameter>
        <parameter name="morePages" type="System.Boolean"><![CDATA[False]]></parameter>
        <parameter name="CallContext" type="Ice.Bpm.Context.ContextDataSet">
          <ContextDataSet xmlns="http://www.epicor.com/Ice/300/Bpm/Context">
            <BpmData>
              <SysRowID>00000000-0000-0000-0000-000000000000</SysRowID>
            </BpmData>
          </ContextDataSet>
        </parameter>
      </parameters>
      <returnValues>
        <returnParameter name="returnDS" type="Ice.BO.SysMonitorTasksDataSet">
          <SysMonitorTasksDataSet xmlns="http://www.epicor.com/Ice/300/BO/SysMonitorTasks/SysMonitorTasks">
            <SysTask>
              <SysTaskNum>312701</SysTaskNum>
              <TaskDescription>Re-initialize the Key Block</TaskDescription>
              <TaskType>Process</TaskType>
              <StartedOn>2017-06-19T22:02:47.233-05:00</StartedOn>
              <EndedOn>2017-06-19T22:02:47.387-05:00</EndedOn>
              <SubmitUser>banderson</SubmitUser>
              <TaskStatus>COMPLETE</TaskStatus>
              <Company>RAPAT</Company>
              <AgentID>systemagent</AgentID>
              <AgentSchedNum>0</AgentSchedNum>
              <AgentTaskNum>0</AgentTaskNum>
              <RunProcedure>Erp.Internal.Conversion.CVXA0081.dll</RunProcedure>
              <InitiatorSource>Agent</InitiatorSource>
              <ActivityMsg></ActivityMsg>
              <History>true</History>
              <TaskNote></TaskNote>
              <LastActivityOn>2017-06-19T22:02:47.387-05:00</LastActivityOn>
              <UserPIDInfo></UserPIDInfo>
              <ProcessID></ProcessID>
              <IsSystemTask>false</IsSystemTask>
              <SysRevID>130282474</SysRevID>
              <SysRowID>d1a67700-10db-421e-aaf9-bfca13153d71</SysRowID>
              <ErrorMsg></ErrorMsg>
              <BitFlag>0</BitFlag>
              <RowMod></RowMod>
            </SysTask>
            <SysTask>
              <SysTaskNum>312704</SysTaskNum>
              <TaskDescription>Re-initialize the Key Block</TaskDescription>
              <TaskType>Process</TaskType>
              <StartedOn>2017-06-19T22:06:41.087-05:00</StartedOn>
              <EndedOn>2017-06-19T22:06:41.137-05:00</EndedOn>
              <SubmitUser>banderson</SubmitUser>
              <TaskStatus>COMPLETE</TaskStatus>
              <Company>RAPAT</Company>
              <AgentID>systemagent</AgentID>
              <AgentSchedNum>0</AgentSchedNum>
              <AgentTaskNum>0</AgentTaskNum>
              <RunProcedure>Erp.Internal.Conversion.CVXA0081.dll</RunProcedure>
              <InitiatorSource>Agent</InitiatorSource>
              <ActivityMsg></ActivityMsg>
              <History>true</History>
              <TaskNote></TaskNote>
              <LastActivityOn>2017-06-19T22:06:41.137-05:00</LastActivityOn>
              <UserPIDInfo></UserPIDInfo>
              <ProcessID></ProcessID>
              <IsSystemTask>false</IsSystemTask>
              <SysRevID>130282922</SysRevID>
              <SysRowID>5a82ee29-4996-4e72-b93e-6cb4690108dc</SysRowID>
              <ErrorMsg></ErrorMsg>
              <BitFlag>0</BitFlag>
              <RowMod></RowMod>
            </SysTask>
          </SysMonitorTasksDataSet>
        </returnParameter>
        <returnParameter name="morePages" type="System.Boolean"><![CDATA[False]]></returnParameter>
      </returnValues>
      <serverTrace>
        <Op Utc="2017-06-20T15:24:43.2157996Z" act="Ice:BO:SysMonitorTasks/SysMonitorTasksSvcContract/GetBallonRowsKeepIdleTime" dur="7.447" cli="192.168.11.134:64194" usr="banderson" machine="EPICOR10-1" pid="10264" tid="10" xmlns="" />
      </serverTrace>
    </tracePacket>
6

So I’m just throwing this out here, no idea if it has anything to do with this.
So number sequencing is not exactly a centralized thing yet in Epicor, meaning they seem to track and work out the next sequence number different ways. They seem to be trying to centralize this but things are still scattered. In 10.0 you can find Sequence controls in the follwoing tables/fields:

Erp.XaSyst.StartOrderNum, StartPONum, etc (Per company)
Erp.EQSyst.StartQuoteNum (Per company quotes)
Ice.SysSequence (global other sequences)

I’m just wondering if you compare the contents of these tables (and their fields) if you will see any difference between them. Maybe they moved the Erp.EQSyst records into another table?

Another thought is that with Users there is an ERP and an ICE table (one is user and one is SysUser or something like that) and some columns are duplicated and sometimes the data contained in each is not the same and can cause issues similar to this with user accounts depending on how a given method is checking for the value.

Here’s a thought, try to create a quote, not from Quote Entry but from Customer Tracker via the Actions menu or the CustID Open With context menu, wonder if that will work any differently… kinda doubt it though.

7

Good thought, (I didn’t even know you could do that, good to know) but it still pops up the same screen and the same error pops up. Bummer.

The ERP tables are in 10.1, looks like they are set correctly. The Ice.SysSequence table I did not see in the BAQ designer.

Not sure what else to do with that info.

8

Ha! I think I found where the Last QuoteNum is stored and you can check it with a BAQ!
The table is ERP.KeyLast and it’s pretty small so you don’t need to set any Criteria.
Look for RelatedToFile = QuoteHed and the Last Value column is what it should be looking at to determine the next QuoteNum.
From what I can tell it should try to use that value +1.
See what that value is and then check and see if you have a QuoteHed record with that value (or from looking at the SQL trace, there are tons of other tables that may also have that value and cause it to fail.)
I’m curious what you find.

-Rick
www.getaligned.solutions

9

It’s blank! Our live one in E10.0 is not.

I’ll have to get DMT going for 10.1 and see if I can DMT the file in. or make an UBAQ to copy/paste some stuff in there.

Looks like you may be on to something. I’ll let you know if I can get it to work.

10

Well I’ve already exhausted what I know. I don’t know how to get the method into the UBAQ (it doesn’t suggest anything) and I guess I’m not surprised. I didn’t see anything for that table in DMT tool either.

I did pass along the message to service so I hope that will get them to see if that’s what they think the problem is.

Brandon

11

Not that you would want to do this with your live system, but since this test and to keep your testing going you could use ssms to edit the number and keep moving.

1 Like
12

While not supported and not recommended for a production environment, the field could be updated with an SQL Update statement.
Support will probably provide you with a data fix that will correct this.

I just checked the Conversion Workbench that has several conversion programs to fix different issues and I found conversion 1310 in 10.0 that reads to do the same as the 790 you already ran… wonder why they are different numbers?

Either way, I think you have identified the root cause to Support, now they just have to replicate it and ask for the data fix.

13

Yeah, support originally told me 1310 and I said it wasn’t there, and she checked and said that it changed to 790.

Thanks for the help.

I’ll probably just wait for service to give us the data fix. Quotes aren’t really necessary to keep testing the rest of the system, since I don’t need a quote to make an order to complete quote to cash (minus the quote)

Except… I wonder if we are going to have problem with PO numbers and customer numbers, because those things were in that table too.

Off to do some more testing…

14

Interesting, I made a new PO, and the PO part of that table populated so there is something in there now for that. I made a new HDCase in case entry, and that line populated. I made a new customer and it looks like they got rid of CustNum in that table because new customer works fine without adding a line in that table.

Looks like just new quote is the issue.

1 Like
15

I work with Brandon and we are still having this problem.

I added a record to the ERP.KeyLast table through ssms but no change. We sent our database to Epicor and they couldn’t replicate the problem.

I created a new database, copied the most recent backup from our live 10.0.700.4 database, ran all the upgrades and now get the same error. So this can’t be related to the database. Can it be corruption in the Epicor install? Any thoughts on how to track down the problem file?

16

Try taking a look at the contents of the erp.KeyBlock table.
I wonder if something is corrupted or missing there.
KeyBlock seems to set the range and KeyLast seems to keep track of the last key.
If there is something wrong with the QuoteNum keyblock record (or missing) that may cause the function that generates the next QuoteNum to fail to zero?

How long has Epicor Support had your DB?

17

But then wouldn’t support get the same result from our database?

Database was uploaded last Friday and they responded yesterday. I sent them the same information I posted here and they agree that since they can’t replicate the problem that it is probably install related instead of data related.

18

I guess that would depend on what conversions they are running,
I would be looking for differences in the installation and DB restore & conversions being ran between them and you.
It is a very odd problem that would be related the the installation.

I have had issues before with the documented installation process and how Epicor Support Services actually does the installations. I’ve had cases where I followed the steps exactly and it doesn’t work, I then pay for an Epicor installation consultant, and they follow a different procedure, when I ask about the difference and they say that it’s a missing step and they don’t know why it was missing.
It’s frustrating, double check your install process aligns with the documentation and hold them to their documentation.

From what was posted earlier, I would say that some thing in your installation process is blanking our the ERP.KeyLast.LastValue column for your QuoteHed and perhaps the ERP.KeyBlock record as well. Or I guess it could be the BO method that looks up, generates and updates the QuoteNum is not firing (check security, make sure you don’t have any locked .dll’s?) and as a result the value is stuck at a default of 0 would be my guess.

19

Thanks for your continued help Rick. On our original database the QuoteHed record didn’t show up in the ERP.KeyLast table. In the new DB I created, it has a QuoteHed line with BlockLastValue = 11611 which is the correct last quote number. Yet I still get the error.

Digging back through the installation instructions as suggested. May just setup another virtual server and walk through the steps again. Good practice.

20

I setup a new virtual 2016 server with SQL 2016, installed 10.1.600.5, restored from our live 10.0.700.4 db, ran all the upgrades and get the same error!!! Is there somewhere I can download the Training DB to see if I get the same error? I don’t see it on EpicWeb.