REST Record Not Available error

Epicor ERP 10
,
1

Has anyone come across the “record not available” error in REST? No matter what is tried, trying to call the methods OnChangeOfEngineered and GetQuotedInfo keeps on returning the error. Even using the GetByID and taking the return dataset does not work (after adding the necessary parameters).

Here are the bullet points:

  • The trace is being followed exactly.
  • The user that cannot do it in REST can do it in the application.
  • Checked that the default saved Company/Site for the user were correct.
  • Tried turning off the Prevent Changes in Company Config.

I can’t think of anything else to check or try. Any ideas out there?

2

Are you in the right envionment?

3

Yes! Good one to check though

4

What BO are you using? Can we seen some screenshots of request/response

5

Shoot. I forgot to post the response.

{
  "HttpStatus": 400,
  "ReasonPhrase": "REST API Exception",
  "ErrorMessage": "Quote Detail record not available.",
  "ErrorType": "Ice.BLException",
  "ErrorDetails": [
    {
      "Message": "Quote Detail record not available.",
      "Type": "Error",
      "Table": "QuoteDtl",
      "Program": "Erp.Services.BO.Quote.dll",
      "Method": "OnChangeofEngineered",
      "ColumnNumber": 17,
      "LineNumber": 18323
    }
  ]
}
6

Request

{
"newReadyToQuote": true,
  "ds": {
    "QuoteHed": [
      {
        "Company": "GTR",
        "QuoteNum": 90064,
        "CustNum": 55,
        "EntryDate": "2021-04-13T00:00:00",
        "PrcConNum": 0,
        "QuoteComment": "",
        "DueDate": "2021-04-13T00:00:00",
        "Quoted": false,
        "DateQuoted": null,
        "ExpirationDate": null,
        "FollowUpDate": null,
        "Reference": "",
        "CheckOff1": false,
        "CheckOff2": false,
        "CheckOff3": false,
        "CheckOff4": false,
        "CheckOff5": false,
        "Expired": false,
        "FlwAlrtSnt": false,
        "DueAlrtSnt": true,
        "CurrencyCode": "BASE",
        "ExchangeRate": 1,
        "LeadRating": "",
        "TerritoryID": "",
        "TaskSetID": "",
        "CurrentStage": "QUOT",
        "ParentQuoteNum": 0,
        "ActiveTaskID": "",
        "LastTaskID": "",
        "ExpectedClose": null,
        "ReasonType": "",
        "ReasonCode": "",
        "ConfidencePct": 0,
        "DiscountPercent": 0,
        "ShipToNum": "0001",
        "ShpConNum": 0,
        "QuoteClosed": false,
        "ClosedDate": null,
        "ShipViaCode": "UPS",
        "MktgCampaignID": "",
        "MktgEvntSeq": 0,
        "CallTypeCode": "",
        "PONum": "",
        "TermsCode": "000",
        "Ordered": false,
        "ApplyOrderBasedDisc": false,
        "AutoOrderBasedDisc": true,
        "HDCaseNum": 0,
        "BTCustNum": 55,
        "LockRate": false,
        "ChangedBy": "jkane",
        "ChangeDate": "2021-04-20T00:00:00",
        "ChangeTime": 50101,
        "ReadyToCalc": false,
        "ExportRequested": "",
        "Rounding": 0,
        "DocRounding": 0,
        "Rpt1Rounding": 0,
        "Rpt2Rounding": 0,
        "Rpt3Rounding": 0,
        "RateGrpCode": "MAIN",
        "QuoteAmt": 0,
        "DocQuoteAmt": 0,
        "Rpt1QuoteAmt": 0,
        "Rpt2QuoteAmt": 0,
        "Rpt3QuoteAmt": 0,
        "UseOTS": false,
        "OTSName": "",
        "OTSAddress1": "",
        "OTSAddress2": "",
        "OTSAddress3": "",
        "OTSCity": "",
        "OTSState": "",
        "OTSZIP": "",
        "OTSResaleID": "",
        "OTSTaxRegionCode": "",
        "OTSContact": "",
        "OTSFaxNum": "",
        "OTSPhoneNum": "",
        "OTSCountryNum": 0,
        "ShipToCustNum": 55,
        "InPrice": false,
        "WorstCsPct": 0,
        "BestCsPct": 0,
        "DemandContractNum": 0,
        "DemandHeadSeq": 0,
        "EDIReady": false,
        "EDIQuote": false,
        "EDIAck": false,
        "OutboundQuoteDocCtr": 0,
        "DemandProcessDate": null,
        "DemandProcessTime": 0,
        "LastTCtrlNum": "",
        "LastBatchNum": "",
        "AutoPrintReady": false,
        "DocTotalSATax": 0,
        "DocTotalTax": 0,
        "DocTotalWHTax": 0,
        "Rpt1TotalSATax": 0,
        "Rpt1TotalTax": 0,
        "Rpt1TotalWHTax": 0,
        "Rpt2TotalSATax": 0,
        "Rpt2TotalTax": 0,
        "Rpt2TotalWHTax": 0,
        "Rpt3TotalSATax": 0,
        "DeclaredAmt": 0,
        "Rpt3TotalTax": 0,
        "DeclaredIns": false,
        "Rpt3TotalWHTax": 0,
        "DeliveryConf": 1,
        "TaxPoint": null,
        "DeliveryType": "",
        "TaxRateDate": null,
        "DocOnly": false,
        "TaxRegionCode": "",
        "DropShip": false,
        "TotalSATax": 0,
        "ExtCompany": "",
        "TotalTax": 0,
        "GroundType": "",
        "TotalWHTax": 0,
        "Hazmat": false,
        "ICPONum": 0,
        "Linked": false,
        "LockQty": false,
        "NeedByDate": null,
        "NotifyEMail": "",
        "NotifyFlag": false,
        "OTSCustSaved": false,
        "OTSSaveAs": "",
        "OTSSaveCustID": "",
        "OverrideCarrier": false,
        "OverrideService": false,
        "RefNotes": "",
        "RequestDate": null,
        "ResDelivery": false,
        "SatPickup": false,
        "ServAlert": false,
        "ServAuthNum": "",
        "ServDeliveryDate": null,
        "ServHomeDel": false,
        "ServInstruct": "",
        "ServPhone": "",
        "ServRef1": "",
        "ServRef2": "",
        "ServRef3": "",
        "ServRef4": "",
        "ServRef5": "",
        "ServRelease": false,
        "ServSignature": false,
        "VoidQuote": false,
        "ApplyChrg": false,
        "ChrgAmount": 0,
        "COD": false,
        "TotalDiscPct": 0,
        "TotalExpected": 0,
        "TotalGrossValue": 0,
        "TotalMiscAmt": 0,
        "TotalPotential": 0,
        "TotalWorstCs": 0,
        "DocTotalBestCs": 0,
        "DocTotalDiscount": 0,
        "DocTotalDiscPct": 0,
        "DocTotalExpected": 0,
        "DocTotalGrossValue": 0,
        "DocTotalMiscAmt": 0,
        "DocTotalPotential": 0,
        "DocTotalWorstCs": 0,
        "Rpt1TotalBestCs": 0,
        "Rpt1TotalDiscount": 0,
        "Rpt1TotalDiscPct": 0,
        "Rpt1TotalExpected": 0,
        "Rpt1TotalGrossValue": 0,
        "Rpt1TotalMiscAmt": 0,
        "Rpt1TotalPotential": 0,
        "Rpt1TotalWorstCs": 0,
        "Rpt2TotalBestCs": 0,
        "Rpt2TotalDiscount": 0,
        "Rpt2TotalDiscPct": 0,
        "Rpt2TotalExpected": 0,
        "Rpt2TotalGrossValue": 0,
        "Rpt2TotalMiscAmt": 0,
        "Rpt2TotalPotential": 0,
        "Rpt2TotalWorstCs": 0,
        "Rpt3TotalBestCs": 0,
        "Rpt3TotalDiscount": 0,
        "Rpt3TotalDiscPct": 0,
        "Rpt3TotalExpected": 0,
        "Rpt3TotalGrossValue": 0,
        "Rpt3TotalMiscAmt": 0,
        "Rpt3TotalPotential": 0,
        "Rpt3TotalWorstCs": 0,
        "TotalBestCs": 0,
        "TotalDiscount": 0,
        "CODAmount": 0,
        "CODCheck": false,
        "CODFreight": false,
        "LOQPrepressText": "",
        "LOQNewPageOnQuoteLine": false,
        "LOQBookPCFinishing": false,
        "LOQBookPCPaper": false,
        "LOQBookPCPress": false,
        "LOQBookPCPlates": false,
        "LOQVariations": false,
        "AEPLOQType": "",
        "LOQPrepressStyle": "",
        "QuoteCSR": "",
        "DueHour": "",
        "SysRevID": 227580140,
        "SysRowID": "b10e61b7-3a95-4390-ab8f-66e680cf64f8",
        "ECCConfirmed": false,
        "ECCConfirmedBy": "",
        "ECCMsgType": "",
        "ECCWebReady": false,
        "ECCQuoteNum": "",
        "ECCCmmtRef": "",
        "ECCComment": "",
        "ECCStatus": "",
        "ECCExpirationDate": null,
        "ECCCmmtRefSK": "",
        "ExternalCRMQuote": false,
        "ExternalCRMQuoteID": "",
        "ExternalCRMOrderID": "",
        "ECCSalesRepID": "",
        "Tax": 0,
        "DocTax": 0,
        "Rpt1Tax": 0,
        "Rpt2Tax": 0,
        "Rpt3Tax": 0,
        "HdrTaxNoUpdt": false,
        "ExternalCRMLastSync": null,
        "ExternalCRMSyncRequired": false,
        "TotalClaimsCredit": 0,
        "DocTotalClaimsCredit": 0,
        "Rpt1TotalClaimsCredit": 0,
        "Rpt2TotalClaimsCredit": 0,
        "Rpt3TotalClaimsCredit": 0,
        "TotalClaimsTax": 0,
        "DocTotalClaimsTax": 0,
        "Rpt1TotalClaimsTax": 0,
        "Rpt2TotalClaimsTax": 0,
        "Rpt3TotalClaimsTax": 0,
        "TotalClaimsSATax": 0,
        "DocTotalClaimsSATax": 0,
        "Rpt1TotalClaimsSATax": 0,
        "Rpt2TotalClaimsSATax": 0,
        "Rpt3TotalClaimsSATax": 0,
        "TotalClaimsWHTax": 0,
        "DocTotalClaimsWHTax": 0,
        "Rpt1TotalClaimsWHTax": 0,
        "Rpt2TotalClaimsWHTax": 0,
        "Rpt3TotalClaimsWHTax": 0,
        "AddrList": "T2 Biosystems Inc.~101 Hartwell Ave.~Lexington MA 02421~USA",
        "BaseCurrencyID": "USD",
        "BTCustomerName": "Same as Sold To",
        "ChangeDescription": "",
        "CheckOffLabel1": "",
        "CheckOffLabel2": "",
        "CheckOffLabel3": "",
        "CheckOffLabel4": "",
        "CheckOffLabel5": "",
        "Conclusion": "",
        "ConName": "",
        "CurrencySwitch": true,
        "CurrentStageDesc": "Quote",
        "CustAllowOTS": false,
        "CustOnCreditHold": false,
        "DaysOpen": 8,
        "DiscountPercentCalc": 0,
        "DocTaxAmt": 0,
        "DocTotalQuote": 0,
        "dspBTCustID": "",
        "EmailAddress": "",
        "EnableOrderBasedDisc": false,
        "ExpectedCsPct": 0,
        "FaxNum": "",
        "FOB": "",
        "FOBDescription": "",
        "HasQuoteLines": true,
        "LogChanges": false,
        "OrderDate": null,
        "OrderDiscount": 0,
        "OrderPONum": "",
        "OrderShipVia": "",
        "OrderTerms": "",
        "OTSSaved": false,
        "OTSShipToNum": "",
        "PhoneNum": "781-457-1200",
        "PreventQQChange": true,
        "RateLabel": "",
        "Rpt1TaxAmt": 0,
        "Rpt1TotalQuote": 0,
        "Rpt2TaxAmt": 0,
        "Rpt2TotalQuote": 0,
        "Rpt3TaxAmt": 0,
        "Rpt3TotalQuote": 0,
        "SalesRepCode": "10",
        "SalesRepName": "Steven Puleo",
        "ShipByDate": null,
        "ShipToAddrList": "T2 Biosystems Inc.~101 Hartwell Ave.~Lexington MA 02421~USA",
        "TaxAmt": 0,
        "TotalQuote": 0,
        "WorseCsPctCalc": 0,
        "AvailBTCustList": "TTB`Same as Sold To",
        "BaseCurrSymbol": "BASE",
        "BestCsPctCalc": 0,
        "BTAddressList": "T2 Biosystems Inc.~101 Hartwell Ave.~Lexington MA 02421~USA",
        "BTCustID": "TTB",
        "HasCreditLines": false,
        "IsValidECC": false,
        "EnableHDCaseNum": false,
        "BitFlag": 0,
        "ActiveTaskTaskDescription": "",
        "CurrencyDocumentDesc": "",
        "CurrencyCurrencyID": "USD",
        "CurrencyCurrName": "Dollar",
        "CurrencyCurrDesc": "BASE",
        "CurrencyCurrSymbol": "",
        "CustomerAllowShipTo3": false,
        "CustomerBTName": "",
        "CustomerCustID": "TTB",
        "CustomerName": "T2 Biosystems Inc.",
        "CustomerCheckDuplicatePO": false,
        "HDCaseDescription": "",
        "LastTaskTaskDescription": "",
        "MktgCpgnCampDescription": "",
        "MktgEventEvntDescription": "",
        "OTSCountryNumDescription": "",
        "OTSTaxRegionCodeDescription": "",
        "RateGrpDescription": "Main Rate Type",
        "ReasonDescription": "",
        "ResponseCallTypeDesc": "",
        "ShipToBTName": "",
        "ShipToCustID": "TTB",
        "ShipToName": "T2 Biosystems Inc.",
        "ShipViaWebDesc": "",
        "ShipViaDescription": "UPS",
        "TaskSetTaskSetDescription": "",
        "TaskSetWorkflowType": "",
        "TaxRegionTaxConnectCalc": false,
        "TaxRegionDescription": "",
        "TermsDescription": "Net 30 Days",
        "TerritoryTerritoryDesc": "",
        "XbSystCalcQuoteTax": false,
        "RowMod": "",
        "SecturaFab_c": false,
        "UD_SysRevID": "AAAAAA2Lydo=",
        "UserChar1": ""
      }
    ],
    "QuoteHedAttch": [],
    "QSalesRP": [
      {
        "Company": "GTR",
        "QuoteNum": 90064,
        "SalesRepCode": "10",
        "Name": "Steven Puleo",
        "PrimeRep": true,
        "RepRate": 0,
        "RepSplit": 0,
        "RoleCode": "",
        "ChangedBy": "jkane",
        "ChangeDate": "2021-04-20T00:00:00",
        "ChangeTime": 49267,
        "SysRevID": 227580129,
        "SysRowID": "866c4df7-1cca-470d-b0a6-77f96668505a",
        "OfficePhone": "508-261-2830",
        "HomePhone": "",
        "ReportsTo": "Corinne King",
        "EmailAddress": "",
        "Fax": "",
        "MobilePhone": "",
        "SalesRepTitle": "",
        "BitFlag": 0,
        "QuoteNumCurrencyCode": "BASE",
        "RoleCodeRoleDescription": "",
        "SalesRepCodePerConID": 10,
        "SalesRepCodeName": "Steven Puleo",
        "RowMod": ""
      }
    ],
    "QuoteCnt": [],
    "QuoteCom": [],
    "QuoteDtl": [
      {
        "Company": "GTR",
        "QuoteNum": 90064,
        "QuoteLine": 1,
        "Ordered": false,
        "PartNum": "TestPartDEF",
        "LineDesc": "Test part",
        "RevisionNum": "R01",
        "ProdCode": "ProtoPlu",
        "XPartNum": "",
        "QuoteComment": "",
        "LeadTime": "",
        "Template": false,
        "DrawNum": "",
        "JobComment": "",
        "MfgDetail": true,
        "TaxCatID": "",
        "XRevisionNum": "",
        "CustNum": 55,
        "Quoted": false,
        "Expired": false,
        "WIStartDate": null,
        "WIStartHour": 0,
        "WIDueDate": null,
        "WIDueHour": 0,
        "BasePartNum": "",
        "SellingExpectedQty": 1,
        "SellingExpectedUM": "EA",
        "ConfidencePct": 0,
        "LastUpdate": "2021-04-20T00:00:00",
        "LastDcdUserID": "jkane",
        "DiscountPercent": 0,
        "Discount": 0,
        "DocDiscount": 0,
        "ExpectedRevenue": 0,
        "DocExpectedRevenue": 0,
        "ReqShipDate": null,
        "OrderQty": 0,
        "SellingExpFactor": 1,
        "MultiRel": false,
        "POLine": "",
        "SalesCatID": "",
        "TerritoryID": "",
        "CurrentStage": "QUOT",
        "CreatedFrom": "QUOTE",
        "AnalysisCode": "",
        "PDMObjID": "",
        "LastConfigDate": null,
        "LastConfigTime": 0,
        "LastConfigUserID": "",
        "ConfigUnitPrice": 0,
        "ConfigBaseUnitPrice": 0,
        "BaseRevisionNum": "",
        "PriceListCode": "",
        "BreakListCode": "",
        "PricingQty": 0,
        "ListPrice": 0,
        "DocListPrice": 0,
        "OrdBasedPrice": 0,
        "DocOrdBasedPrice": 0,
        "PriceGroupCode": "",
        "OverridePriceList": false,
        "PricingValue": 0,
        "ExpUnitPrice": 0,
        "DocExpUnitPrice": 0,
        "ExpPricePerCode": "E",
        "MiscQtyNum": 1,
        "Engineer": false,
        "ReadyToQuote": true,
        "KitAllowUpdate": false,
        "KitShipComplete": false,
        "KitBackFlush": false,
        "KitPrintCompsPS": false,
        "KitPrintCompsInv": false,
        "KitPricing": "",
        "KitParentLine": 1,
        "KitQtyPer": 0,
        "DisplaySeq": 1,
        "ProjectID": "",
        "SellingFactorDirection": "D",
        "MakeDirect": false,
        "PhaseID": "",
        "KitFlag": "",
        "KitsLoaded": false,
        "TaxExempt": "",
        "ChangedBy": "jkane",
        "ChangeDate": "2021-04-20T00:00:00",
        "ChangeTime": 50101,
        "OwnershipStatus": "",
        "Rpt1Discount": 0,
        "Rpt2Discount": 0,
        "Rpt3Discount": 0,
        "Rpt1ExpectedRevenue": 0,
        "Rpt2ExpectedRevenue": 0,
        "Rpt3ExpectedRevenue": 0,
        "Rpt1ExpUnitPrice": 0,
        "Rpt2ExpUnitPrice": 0,
        "Rpt3ExpUnitPrice": 0,
        "Rpt1ListPrice": 0,
        "Rpt2ListPrice": 0,
        "Rpt3ListPrice": 0,
        "Rpt1OrdBasedPrice": 0,
        "Rpt2OrdBasedPrice": 0,
        "Rpt3OrdBasedPrice": 0,
        "ExtPriceDtl": 0,
        "DocExtPriceDtl": 0,
        "Rpt1ExtPriceDtl": 0,
        "Rpt2ExtPriceDtl": 0,
        "Rpt3ExtPriceDtl": 0,
        "InDiscount": 0,
        "DocInDiscount": 0,
        "InExpectedRevenue": 0,
        "DocInExpectedRevenue": 0,
        "InListPrice": 0,
        "DocInListPrice": 0,
        "InOrdBasedPrice": 0,
        "DocInOrdBasedPrice": 0,
        "InExpUnitPrice": 0,
        "DocInExpUnitPrice": 0,
        "Rpt1InDiscount": 0,
        "Rpt2InDiscount": 0,
        "Rpt3InDiscount": 0,
        "Rpt1InExpectedRevenue": 0,
        "Rpt2InExpectedRevenue": 0,
        "Rpt3InExpectedRevenue": 0,
        "Rpt1InExpUnitPrice": 0,
        "Rpt2InExpUnitPrice": 0,
        "Rpt3InExpUnitPrice": 0,
        "Rpt1InListPrice": 0,
        "Rpt2InListPrice": 0,
        "Rpt3InListPrice": 0,
        "Rpt1InOrdBasedPrice": 0,
        "Rpt2InOrdBasedPrice": 0,
        "Rpt3InOrdBasedPrice": 0,
        "InExtPriceDtl": 0,
        "DocInExtPriceDtl": 0,
        "Rpt1InExtPriceDtl": 0,
        "Rpt2InExtPriceDtl": 0,
        "Rpt3InExtPriceDtl": 0,
        "WorstCsPct": 0,
        "BestCsPct": 0,
        "WorstCsRevenue": 0,
        "DocWorstCsRevenue": 0,
        "Rpt1WorstCsRevenue": 0,
        "Rpt2WorstCsRevenue": 0,
        "Rpt3WorstCsRevenue": 0,
        "BestCsRevenue": 0,
        "DocBestCsRevenue": 0,
        "Rpt1BestCsRevenue": 0,
        "Rpt2BestCsRevenue": 0,
        "Rpt3BestCsRevenue": 0,
        "KitCompOrigSeq": 0,
        "KitCompOrigPart": "",
        "SmartStringProcessed": false,
        "SmartString": "",
        "LineType": "PART",
        "ContractNum": 0,
        "ContractCode": "",
        "DiscBreakListCode": "",
        "RenewalNbr": 0,
        "DiscListPrice": 0,
        "DemandContractNum": 0,
        "OverrideDiscPriceList": false,
        "DemandContractLine": 0,
        "DemandHedSeq": 0,
        "DemandDtlSeq": 0,
        "ExtCompany": "",
        "ICPOLine": 0,
        "ICPONum": 0,
        "Linked": false,
        "LockPrice": false,
        "LockQty": false,
        "VoidLine": false,
        "Warranty": true,
        "WarrantyCode": "",
        "WarrantyComment": "",
        "GroupSeq": 0,
        "EstimateGUID": "",
        "RFQCurrBaseEst": "",
        "RFQTemplate": "",
        "CreateEstimate": false,
        "Rating": "",
        "EstimateUserID": "",
        "SysRevID": 227580139,
        "SysRowID": "13d8e9f8-95ca-4302-b985-9cd3a902770e",
        "ExternalMES": false,
        "NeedByDate": null,
        "ProcessMode": "S",
        "ECCQuoteNum": "",
        "ECCQuoteLine": 0,
        "ECCCmmtRef": "",
        "ECCComment": "",
        "ContractID": "",
        "PCLinkRemoved": false,
        "TaxRegionCode": "",
        "Tax": 0,
        "DocTax": 0,
        "Rpt1Tax": 0,
        "Rpt2Tax": 0,
        "Rpt3Tax": 0,
        "TaxConnectCalc": false,
        "NoTaxRecalc": false,
        "TotalSATax": 0,
        "DocTotalSATax": 0,
        "Rpt1TotalSATax": 0,
        "Rpt2TotalSATax": 0,
        "Rpt3TotalSATax": 0,
        "EntityUseCode": "",
        "ExternalCRMQuoteLineID": "",
        "ReturnLineType": "",
        "MSRP": 0,
        "DocMSRP": 0,
        "Rpt1MSRP": 0,
        "Rpt2MSRP": 0,
        "Rpt3MSRP": 0,
        "EndCustomerPrice": 0,
        "DocEndCustomerPrice": 0,
        "Rpt1EndCustomerPrice": 0,
        "Rpt2EndCustomerPrice": 0,
        "Rpt3EndCustomerPrice": 0,
        "MFCustNum": 0,
        "MFShipToNum": "",
        "UseOTMF": false,
        "OTMFName": "",
        "OTMFAddress1": "",
        "OTMFAddress2": "",
        "OTMFAddress3": "",
        "OTMFCity": "",
        "OTMFState": "",
        "OTMFZIP": "",
        "OTMFContact": "",
        "OTMFFaxNum": "",
        "OTMFPhoneNum": "",
        "OTMFCountryNum": 0,
        "PromotionalPrice": 0,
        "DocPromotionalPrice": 0,
        "Rpt1PromotionalPrice": 0,
        "Rpt2PromotionalPrice": 0,
        "Rpt3PromotionalPrice": 0,
        "AvailPriceLists": "",
        "DspExpUnitPrice": 0,
        "ECCLineCRQ": 0,
        "EnableDynAttrButton": false,
        "EnablePLM": true,
        "EnableRenewalNbr": false,
        "ExpirationDate": null,
        "HasComplement": false,
        "HasCoParts": false,
        "HasCreditMemo": false,
        "HasDowngrade": false,
        "HasSubstitute": false,
        "HasUpgrade": false,
        "KitChangeParms": false,
        "KitDisable": false,
        "KitFlagDescription": "",
        "KitOrderQtyUOM": "",
        "LineStatus": "",
        "MarkForAddrList": "",
        "MFCustID": "",
        "OrderUM": "",
        "OrderUnitPrice": 0,
        "OrderWorthy": false,
        "PartExists": false,
        "PONum": "",
        "QtyBearing": false,
        "QuantityToOrder": 0,
        "RefreshQty": false,
        "Rpt1BaseExtPrice": 0,
        "Rpt1BaseMiscAmt": 0,
        "Rpt1BasePotential": 0,
        "Rpt1DspDiscount": 0,
        "Rpt1DspExpUnitPrice": 0,
        "Rpt1OrderUnitPrice": 0,
        "Rpt1TotalPrice": 0,
        "Rpt1TotalQuote": 0,
        "Rpt1TotalWHTax": 0,
        "Rpt2BaseExtPrice": 0,
        "Rpt2BaseMiscAmt": 0,
        "Rpt2BasePotential": 0,
        "Rpt2DspDiscount": 0,
        "Rpt2DspExpUnitPrice": 0,
        "Rpt2OrderUnitPrice": 0,
        "Rpt2TotalPrice": 0,
        "Rpt2TotalQuote": 0,
        "Rpt2TotalWHTax": 0,
        "Rpt3BaseExtPrice": 0,
        "Rpt3BaseMiscAmt": 0,
        "Rpt3BasePotential": 0,
        "Rpt3DspDiscount": 0,
        "Rpt3DspExpUnitPrice": 0,
        "Rpt3OrderUnitPrice": 0,
        "Rpt3TotalPrice": 0,
        "Rpt3TotalQuote": 0,
        "Rpt3TotalWHTax": 0,
        "Selected": false,
        "ShipByDate": null,
        "TotalPrice": 0,
        "TotalQuote": 0,
        "TotalWHTax": 0,
        "UpdateReq": false,
        "UseQuoteBOM": false,
        "BaseCurrSymbol": "",
        "BaseExtPrice": 0,
        "BaseMiscAmt": 0,
        "BasePotential": 0,
        "CheckPartDescription": false,
        "CodePLM": false,
        "Conclusion": "",
        "ConfigType": "",
        "Configured": "",
        "CurrencyCode": "BASE",
        "CurrencySwitch": false,
        "CurrSymbol": "",
        "DateQuoted": null,
        "DisableDiscounts": false,
        "DocDspDiscount": 0,
        "DocDspExpUnitPrice": 0,
        "DocExtPrice": 0,
        "DocMiscAmt": 0,
        "DocOrderUnitPrice": 0,
        "DocPotential": 0,
        "DocTotalPrice": 0,
        "DocTotalQuote": 0,
        "DocTotalWHTax": 0,
        "DspDiscount": 0,
        "DspExpectedUM": "EA",
        "RemoveManAdTax": false,
        "BitFlag": 0,
        "AnalysisCdDescription": "",
        "CustomerBTName": "",
        "CustomerName": "T2 Biosystems Inc.",
        "CustomerCustID": "TTB",
        "DiscBreakListCodeListDescription": "",
        "DiscBreakListCodeEndDate": null,
        "DiscBreakListCodeStartDate": null,
        "OTMFCountryDescription": "",
        "PartNumPricePerCode": "",
        "PartNumSalesUM": "",
        "PartNumTrackLots": false,
        "PartNumSellingFactor": 0,
        "PartNumTrackSerialNum": false,
        "PartNumTrackDimension": false,
        "PartNumPartDescription": "",
        "PartNumIUM": "",
        "PriceBreakListDescription": "",
        "PriceGroupDescription": "",
        "ProdCodeDescription": "ProtoPlus",
        "QuoteNumInPrice": false,
        "QuoteNumCurrencyCode": "BASE",
        "SalesCatIDDescription": "",
        "TaxCatIDDescription": "",
        "TaxRegionDescription": "",
        "TaxRegionTaxConnectCalc": false,
        "TerritoryIDTerritoryDesc": "",
        "WarrantyCodeWarrDescription": "",
        "RowMod": "",
        "CertTesting_c": false,
        "ConMin_c": false,
        "FAIR_c": false,
        "ITAR_c": false,
        "Material_c": false,
        "Origin_c": false,
        "Plating_c": false,
        "REACH_c": false,
        "ROHS_c": false,
        "UD_SysRevID": "AAAAAA2LyfQ=",
        "Unique_c": false
      }
    ],
    "QuoteDtlAttch": [],
    "QuoteCoPart": [
      {
        "Company": "GTR",
        "QuoteNum": 90064,
        "QuoteLine": 1,
        "CoPartNum": "TestPartDEF",
        "CoRevisionNum": "R01",
        "PartsPerOp": 1,
        "LbrCostBase": 1,
        "MtlCostBase": 1,
        "PartDescription": "Test part",
        "IUM": "EA",
        "PreventSugg": false,
        "SysRevID": 227265009,
        "SysRowID": "3e795567-22fa-42a4-b9aa-4149a69381b9",
        "PartMasterPart": false,
        "EnablePreventSugg": false,
        "ProcessMode": "S",
        "BitFlag": 0,
        "QuoteLineLineDesc": "Test part",
        "QuoteNumCurrencyCode": "BASE",
        "RowMod": ""
      }
    ],
    "QuoteDtlTax": [],
    "QuoteMsc": [],
    "QuoteQty": [
      {
        "Company": "GTR",
        "QuoteNum": 90064,
        "QuoteLine": 1,
        "QtyNum": 1,
        "OurQuantity": 1,
        "UnitPrice": 0,
        "DocUnitPrice": 0,
        "PricePerCode": "E",
        "MtlBurMarkUp": 0,
        "MaterialMarkUp": 0,
        "SubcontractMarkUp": 0,
        "LaborMarkUp": 0,
        "BurdenMarkUp": 0,
        "MiscCostDesc": "",
        "MiscCost": 0,
        "MiscCostMarkUp": 0,
        "CommissionPct": 0,
        "PercentType": "M",
        "IUM": "EA",
        "SalesUM": "EA",
        "SellingFactor": 1,
        "SellingQuantity": 1,
        "SellingFactorDirection": "D",
        "MarkUpID": "",
        "ChangedBy": "secturafab",
        "ChangeDate": "2021-04-13T00:00:00",
        "ChangeTime": 44364,
        "Rpt1UnitPrice": 0,
        "Rpt2UnitPrice": 0,
        "Rpt3UnitPrice": 0,
        "InUnitPrice": 0,
        "DocInUnitPrice": 0,
        "Rpt1InUnitPrice": 0,
        "Rpt2InUnitPrice": 0,
        "Rpt3InUnitPrice": 0,
        "PriceSource": "",
        "PricePerAdl1000": 0,
        "TotalSellPrice": 0,
        "SysRevID": 227265006,
        "SysRowID": "0301cf48-f945-427e-84e9-9de591d5296a",
        "DocPricePerAdl1000": 0,
        "DocTotalSellPrice": 0,
        "UserChangedUnitPrice": false,
        "CalcProfit": 0,
        "CalcProfitProfit": 0,
        "CalcUnitCost": 0,
        "CalcUnitPriceMarkup": 0,
        "CalcUnitPriceProfit": 0,
        "CalcUPCommMarkup": 0,
        "CalcUPCommProfit": 0,
        "CurrencyCode": "BASE",
        "CurrencySwitch": true,
        "CurrSymbol": "",
        "DisableMtlMarkup": false,
        "MaterialMarkupM": 0,
        "MaterialMarkupP": 0,
        "MiscChrg": "",
        "PriceBurMarkup": 0,
        "PriceBurProfit": 0,
        "PriceLbrMarkup": 0,
        "PriceLbrProfit": 0,
        "PriceMscChrgMarkup": 0,
        "PriceMscChrgProfit": 0,
        "PriceMtlBurMarkup": 0,
        "PriceMtlBurProfit": 0,
        "PriceMtlMarkup": 0,
        "PriceMtlProfit": 0,
        "PricePerFactor": 1,
        "PriceSubMarkup": 0,
        "PriceSubProfit": 0,
        "PriceTotalCommMarkup": 0,
        "PriceTotalCommProfit": 0,
        "PriceTotalMarkup": 0,
        "PriceTotalProfit": 0,
        "QuotedMarkup": 0,
        "QuotedProfit": 0,
        "RollUpCostNeeded": false,
        "TotalBurCost": 0,
        "TotalCommission": 0,
        "TotalCommProfit": 0,
        "TotalCost": 0,
        "TotalLbrCost": 0,
        "TotalMarkup": 0,
        "TotalMtlBurCost": 0,
        "TotalMtlCost": 0,
        "TotalProdBurHrs": 0,
        "TotalProdLbrHrs": 0,
        "TotalProfit": 0,
        "TotalQuotedPrice": 0,
        "TotalSetupBurHrs": 0,
        "TotalSetupLbrHrs": 0,
        "TotalSubCost": 0,
        "WQUnitPrice": 0,
        "BaseCurrSymbol": "",
        "CalcMarkup": 0,
        "CalcMarkupProfit": 0,
        "BitFlag": 0,
        "QuoteLineLineDesc": "Test part",
        "QuoteNumCurrencyCode": "BASE",
        "RowMod": ""
      }
    ],
    "Qtmmkup": [],
    "QtQtyMsc": [],
    "QuoteHedMsc": [],
    "QuoteHedTax": [],
    "HedTaxSum": [],
    "PartSubs": [],
    "TaxConnectStatus": [
      {
        "Company": "GTR",
        "ETCOffline": true,
        "ErrorMessage": "",
        "TCStatus": true,
        "SysRowID": "00000000-0000-0000-0000-000000000000",
        "RowMod": "U"
      }
    ],
    "WhatIfScheduling": [],
    "ExtensionTables": []
  }
}
7

Try putting a "RowMod ": "U" in your QuoteDtl ds

8

I’m gonna say this until I’m blue in the face too; use functions for this stuff vs. raw BO + REST. They are too chatty and complex datasets, and you can really trim it all down if you use Functions with simplified requests/responses and handle the heavy lifting in the function with widgets

9

This is for an integration with another application.

Unbelievable! It’s always the little things that get you. The trace does not show any RowMod having a value. Something to note for the future.

Thanks for your help @Aaron_Moreng

10

Even more reason to use a function!

11

??? You have lost me. If a third party is building an integration to Epicor, how do you use a function?

12

If you’re on 600 (maybe it’s on 500?), you will have Epicor Functions available which allow you to expose a completely custom endpoint with custom request/response and handle the heavy BO work inside the function.
If you’re doing raw Epicor REST, you are at the mercy of very complex datasets and poor orchestration methods available. I did an integration just like you did, but if you can, get yourself upgraded and go for gold with functions. It will simplify your integration tenfold

Then the integration touch points are self documented and don’t need to follow whatever epicor is doing internally (you’ll handle that inside your function) and you can have the integration call generic functions you create to activate an orchestrated series of events in Epicor.

2 Likes
13

Got it. Never thought of that. In the middle of an implementation. Once we clear this and 11 is available, we are going to that.

1 Like
14

1 Like