Create part rev error

Kinetic ERP
1

Hello,
i got an issue when I tried to create new revision. i don’t know what I give wrong. i got internal error 500. don’t know where is wrong. below is the input parameters for Update method in partsvc.

thanks,

Eddy

{
  "ds": {
    "Part": [
      {
        "Company": "xxxx",
        "PartNum": "TUB45_87_10",
        "SearchWord": "TUB45_87",
        "PartDescription": "TUB45_87",
        "ClassID": "",
        "IUM": "Lb",
        "PUM": "Lb",
        "TypeCode": "M",
        "NonStock": false,
        "PurchasingFactor": 1.0000,
        "UnitPrice": 0.00000,
        "PricePerCode": "E",
        "InternalUnitPrice": 0.00000,
        "InternalPricePerCode": "E",
        "ProdCode": "FGGROUP",
        "MfgComment": "",
        "PurComment": "",
        "CostMethod": "F",
        "UserChar1": "",
        "UserChar2": "",
        "UserChar3": "",
        "UserChar4": "",
        "UserDate1": null,
        "UserDate2": null,
        "UserDate3": null,
        "UserDate4": null,
        "UserDecimal1": 0.00,
        "UserDecimal2": 0.00,
        "UserDecimal3": 0.00000,
        "UserDecimal4": 0.00000,
        "UserInteger1": 0,
        "UserInteger2": 0,
        "TaxCatID": "",
        "InActive": false,
        "LowLevelCode": 0,
        "Method": true,
        "TrackLots": false,
        "TrackDimension": false,
        "DefaultDim": "",
        "TrackSerialNum": false,
        "CommodityCode": "",
        "WarrantyCode": "",
        "PhantomBOM": false,
        "SalesUM": "Lb",
        "SellingFactor": 1.00000000,
        "MtlBurRate": 0.00000,
        "NetWeight": 0.00000,
        "UsePartRev": true,
        "PartsPerContainer": 0,
        "PartLength": 0.00000,
        "PartWidth": 0.00000,
        "PartHeight": 0.00000,
        "LotShelfLife": 0,
        "WebPart": false,
        "RunOut": false,
        "SubPart": "",
        "Diameter": 0.00000,
        "Gravity": 0.00000,
        "OnHold": false,
        "OnHoldDate": null,
        "OnHoldReasonCode": "",
        "AnalysisCode": "",
        "GlobalPart": false,
        "MtlAnalysisCode": "",
        "GlobalLock": false,
        "ISSuppUnitsFactor": 1.00000000,
        "PDMObjID": "",
        "ImageFileName": "",
        "ISOrigCountry": "0",
        "SNPrefix": "",
        "SNFormat": "",
        "SNBaseDataType": "",
        "Constrained": false,
        "UPCCode1": "",
        "UPCCode2": "",
        "UPCCode3": "",
        "EDICode": "",
        "WebInStock": false,
        "ConsolidatedPurchasing": false,
        "PurchasingFactorDirection": "D",
        "SellingFactorDirection": "D",
        "RecDocReq": false,
        "MDPV": 0,
        "ShipDocReq": false,
        "ReturnableContainer": "",
        "NetVolume": 0.00000,
        "QtyBearing": true,
        "NAFTAOrigCountry": "",
        "NAFTAProd": "",
        "NAFTAPref": "",
        "ExpLicType": "",
        "ExpLicNumber": "",
        "ECCNNumber": "",
        "AESExp": "",
        "HTS": "",
        "UseHTSDesc": false,
        "SchedBcode": "",
        "HazItem": false,
        "HazTechName": "",
        "HazClass": "",
        "HazSub": "",
        "HazGvrnmtID": "",
        "HazPackInstr": "",
        "RevChargeMethod": "",
        "RCUnderThreshold": 0.000,
        "RCOverThreshold": 0.000,
        "OwnershipStatus": "",
        "UOMClassID": "Weight",
        "SNMask": "",
        "SNMaskExample": "",
        "SNMaskSuffix": "",
        "SNMaskPrefix": "",
        "SNLastUsedSeq": "",
        "UseMaskSeq": false,
        "NetWeightUOM": "Lb",
        "NetVolumeUOM": "M3",
        "LotBatch": false,
        "LotMfgBatch": false,
        "LotMfgLot": false,
        "LotHeat": false,
        "LotFirmware": false,
        "LotBeforeDt": false,
        "LotMfgDt": false,
        "LotCureDt": false,
        "LotExpDt": false,
        "LotPrefix": "",
        "LotUseGlobalSeq": false,
        "LotSeqID": "",
        "LotNxtNum": 1,
        "LotDigits": 0,
        "LotLeadingZeros": false,
        "LotAppendDate": "",
        "BuyToOrder": false,
        "DropShip": false,
        "IsConfigured": false,
        "ExtConfig": false,
        "RefCategory": "",
        "CSFCJ5": false,
        "CSFLMW": false,
        "GrossWeight": 0.00000,
        "GrossWeightUOM": "Lb",
        "BasePartNum": "",
        "FSAssetClassCode": "",
        "FSSalesUnitPrice": 0.00000,
        "FSPricePerCode": "E",
        "RcvInspectionReq": false,
        "EstimateID": "",
        "EstimateOrPlan": "",
        "DiffPrc2PrchUOM": false,
        "DupOnJobCrt": false,
        "PricingFactor": 0.00000,
        "PricingUOM": "",
        "MobilePart": true,
        "SysRevID": 95801583,
        "SysRowID": "a7c577a0-fe90-4dec-9619-2f90635591de",
        "AGUseGoodMark": false,
        "AGProductMark": true,
        "ISRegion": "",
        "INChapterID": "",
        "PESUNATType": "",
        "PESUNATUOM": "",
        "DEIsServices": false,
        "DEIsSecurityFinancialDerivative": false,
        "DEInternationalSecuritiesID": "",
        "LinkToContract": false,
        "DEIsInvestment": false,
        "DEPayStatCode": "",
        "DEDenomination": "",
        "PartLengthWidthHeightUM": "IN",
        "DiameterUM": "",
        "DiameterInside": 0.00000,
        "DiameterOutside": 0.00000,
        "ThicknessUM": "",
        "Thickness": 0.00000,
        "ThicknessMax": 0.00000,
        "Durometer": "",
        "Specification": "",
        "EngineeringAlert": "",
        "Condition": "",
        "IsCompliant": false,
        "IsRestricted": false,
        "IsSafetyItem": false,
        "CommercialBrand": "",
        "CommercialSubBrand": "",
        "CommercialCategory": "",
        "CommercialSubCategory": "",
        "CommercialStyle": "",
        "CommercialSize1": "",
        "CommercialSize2": "",
        "CommercialColor": "",
        "IsGiftCard": false,
        "PhotoFile": "",
        "PartPhotoExists": false,
        "CommentText": "",
        "PartSpecificPackingUOM": false,
        "ImageID": "",
        "CNSpecification": "",
        "SyncToExternalCRM": false,
        "ExternalCRMPartID": "",
        "ExternalCRMLastSync": null,
        "ExternalCRMSyncRequired": false,
        "PESUNATTypeCode": "",
        "PESUNATUOMCode": "",
        "CNCodeVersion": "",
        "CNTaxCategoryCode": "",
        "CNHasPreferentialTreatment": false,
        "CNPreferentialTreatmentContent": "",
        "CNZeroTaxRateMark": "",
        "SubLevelCode": 0,
        "CreatedBy": "xxxx",
        "CreatedOn": "2023-07-26T10:16:29.543",
        "AttBatch": "N",
        "AttMfgBatch": "N",
        "AttMfgLot": "N",
        "AttHeat": "N",
        "AttFirmware": "N",
        "AttBeforeDt": "N",
        "AttMfgDt": "N",
        "AttCureDt": "N",
        "AttExpDt": "N",
        "DeferManualEntry": false,
        "DeferPurchaseReceipt": false,
        "DeferJobReceipt": false,
        "DeferInspection": false,
        "DeferQtyAdjustment": false,
        "DeferInventoryMove": false,
        "DeferShipments": false,
        "DeferInventoryCounts": false,
        "DeferAssetDisposal": false,
        "DeferReturnMaterials": false,
        "MXProdServCode": "",
        "ChangedOn": "2023-07-26T10:19:58.957",
        "MXCustomsDuty": "",
        "SendToFSA": false,
        "ExternalMESSyncRequired": false,
        "ExternalMESLastSync": null,
        "FSAItem": false,
        "FSAEquipment": false,
        "BOLClass": "",
        "FairMarketValue": 0.00000,
        "SAFTProdCategory": "",
        "AttrClassID": "",
        "LocationIDNumReq": false,
        "LocationTrackInv": false,
        "LocationMtlView": false,
        "LCNRVReporting": false,
        "LCNRVEstimatedUnitPrice": 0.000,
        "MXCustomsUMFrom": "",
        "LocationFormatID": "",
        "IsServices": false,
        "PEDetrGoodServiceCode": "",
        "PEProductServiceCode": "",
        "DualUOMClassID": "",
        "CNProductName": "",
        "CNWeight": 0.00000,
        "CNWeightUOM": "",
        "CNBonded": false,
        "TrackInventoryAttributes": false,
        "DefaultAttributeSetID": 0,
        "AttISOrigCountry": "N",
        "ExternalSchemeID": "",
        "ExternalID": "",
        "CommoditySchemeID": "",
        "CommoditySchemeVersion": "",
        "TrackInventoryByRevision": false,
        "PlanningByRevision": false,
        "CountryNumDescription": "",
        "EnableExpressCheckOut": false,
        "EnableGlobalLock": false,
        "EnableGlobalPart": true,
        "EnableInActive": true,
        "EnableIUM": true,
        "EnableRevCharge": false,
        "EnableSerialNum": false,
        "EnableTrackSerialNum": true,
        "EnableUOMClass": true,
        "ExtCoExist": true,
        "FSAInstallationCost": 0.00000,
        "FSAInstallationRequired": false,
        "FSAInstallationType": "",
        "FSAInstTypeDesc": "",
        "GlbFlag": false,
        "GlbLink": "",
        "GlbTableAllowUpdTrackDim": false,
        "GlbTableAllowUpdTrackLots": false,
        "GlbTableAllowUpdTrackSerial": false,
        "HasOnHandQty": false,
        "IsComponent": false,
        "IsCoPart": false,
        "ISOrigCountryNum": 0,
        "NextGeneratedLotNum": "",
        "PEDetrGoodServiceCodeDesc": "",
        "PEProductServiceCodeDesc": "",
        "PLM": false,
        "PLMEnabled": false,
        "Revision": true,
        "SalesUMDisp": "Lb",
        "SNLeadingZeros": false,
        "SNMaskPrefixLength": 0,
        "SNMaskSuffixLength": 0,
        "SNNumODigits": 0,
        "UpdatePartPlant": false,
        "UpdateSNPartPlant": false,
        "COASegReferences": "",
        "HasMRPPlanningAttribute": false,
        "UpdatePartPlantOverride": false,
        "DEPayStatCodeDescr": "",
        "DEDenominationDescr": "",
        "DefaultBuyerName": "",
        "DefaultPlannerName": null,
        "EnableTrackByRevision": true,
        "BitFlag": 1,
        "AnalysisCdDescription": "",
        "ClassDescription": "",
        "CommodityCodeSuppUnitsUOM": "",
        "CommodityCodeDescription": "",
        "CompanySendToFSA": false,
        "DualUOMClassIDDescription": "",
        "DynAttrValueSetShortDescription": "",
        "DynAttrValueSetDescription": "",
        "FSAssetClassCodeFSAssetClassDesc": "",
        "Mtl_AnalysisCdDescription": "",
        "MXProdServCodeDesc": "",
        "OnHoldReasonCodeDescription": "",
        "ProdCodeDescription": "Finish Good Group",
        "RefCategoryDescription": "",
        "SerialMaskMaskType": 0,
        "SerialMaskDescription": "",
        "TaxCatIDDescription": "",
        "UOMClassIDDescription": "Purchasing UOM for Resin",
        "WarrantyCodeWarrDescription": "",
        "XbSystELIEinvoice": false,
        "RowMod": ""
      }
    ],

    "PartRev": [
      {
        "Company": "xxxx",
        "PartNum": "TUB45_87_10",
        "RevisionNum": "00",
        "RevShortDesc": "00",
        "RevDescription": "",
        "Approved": true,
        "ApprovedDate": "2023-07-26T00:00:00",
        "ApprovedBy": "xxxx",
        "EffectiveDate": "2023-07-26T00:00:00",
        "TLRLaborCost": 0.00000,
        "TLRBurdenCost": 0.00000,
        "TLRMaterialCost": 0.00000,
        "TLRSubcontractCost": 0.00000,
        "TLRMtlBurCost": 0.00000,
        "TLRSetupLaborCost": 0.00000,
        "TLRSetupBurdenCost": 0.00000,
        "LLRLaborCost": 0.00000,
        "LLRBurdenCost": 0.00000,
        "LLRMaterialCost": 0.00000,
        "LLRSubcontractCost": 0.00000,
        "LLRMtlBurCost": 0.00000,
        "LLRSetupLaborCost": 0.00000,
        "LLRSetupBurdenCost": 0.00000,
        "RollupDate": null,
        "DrawNum": "",
        "ECO": "",
        "Method": true,
        "AutoRecOpr": 0,
        "FinalOpr": 0,
        "PDMObjID": "",
        "Configured": false,
        "WebConfigured": false,
        "ShowInputPrice": false,
        "AltMethod": "",
        "AltMethodDesc": "",
        "Plant": "MfgSys",
        "ParentAltMethod": "",
        "UseStaging": false,
        "UseAltRevForParts": false,
        "OwnershipStatus": "",
        "ExtConfig": false,
        "ValRefDes": false,
        "PcGlobalPart": false,
        "PcEntprsConf": false,
        "GlobalRev": false,
        "RoughCutCode": "",
        "RMAInspPlan": "",
        "RMASpecID": "",
        "RMASampleSize": 0.00000000,
        "RMASampleSizePct": 0.00,
        "BasePartNum": "",
        "BaseRevisionNum": "",
        "ConfigID": "",
        "RegenConfig": false,
        "SIValuesGroupSeq": 0,
        "SIValuesHeadNum": 0,
        "ExternalMES": false,
        "SysRevID": 95801581,
        "SysRowID": "97ad2cf4-3aac-4fd0-b82e-8994299ade68",
        "ProcessMode": "S",
        "DefaultConfigPart": false,
        "CoPartsReqQty": 0.00000000,
        "MtlCostPct": 0.00000,
        "LaborCostPct": 0.00000,
        "CoPartsPerOp": 0,
        "CreatedBy": "xxxx",
        "CreatedOn": "2023-07-26T14:16:57.077",
        "ChangedBy": "xxxx",
        "ChangedOn": "2023-07-26T14:19:58.913",
        "ExternalMESSyncRequired": false,
        "ExternalMESLastSync": null,
        "CNCustomsBOM": false,
        "ProcessMfgID": "",
        "ProcessMfgType": "",
        "ProcessMfgDescription": "",
        "UseAdvancedStaging": false,
        "ProcessMfgLastGroupID": "",
        "DisableApproved": false,
        "ECOGroup": "",
        "HasCoParts": false,
        "ParentAltMethodDesc": "",
        "ParentPartNum": "",
        "ParentRevisionNum": "",
        "ProdCode": "",
        "RevStatusAsOfDate": 0,
        "SpecHedDescription": "",
        "vDate": null,
        "vQty": 0.00000000,
        "Class": "",
        "NonStock": false,
        "IsRootNode": false,
        "EngineeringApproved": false,
        "BitFlag": 1,
        "InspPlanDescription": "",
        "PartDescriptionTrackDimension": false,
        "PartDescriptionSellingFactor": 1.00000000,
        "PartDescriptionPartDescription": "TUB45_87",
        "PartDescriptionIUM": "Lb",
        "PartDescriptionTrackLots": false,
        "PartDescriptionPricePerCode": "E",
        "PartDescriptionSalesUM": "Lb",
        "PartDescriptionTrackSerialNum": false,
        "PartDescriptionTypeCode": "M",
        "PcStatusConfigType": "",
        "PlantName": "Wisconsin",
        "RoughCutParamDescription": "",
        "RowMod": ""
      },
      {
        "Company": "xxxx",
        "PartNum": "TUB45_87_10",
        "RevisionNum": "01",
        "RevShortDesc": "01",
        "RevDescription": null,
        "Approved": true,
        "ApprovedDate": "2023-07-28T10:32:44.2753468-04:00",
        "ApprovedBy": "xxxx",
        "EffectiveDate": "2023-07-28T10:32:44.2753468-04:00",
        "TLRLaborCost": 0.0,
        "TLRBurdenCost": 0.0,
        "TLRMaterialCost": 0.0,
        "TLRSubcontractCost": 0.0,
        "TLRMtlBurCost": 0.0,
        "TLRSetupLaborCost": 0.0,
        "TLRSetupBurdenCost": 0.0,
        "LLRLaborCost": 0.0,
        "LLRBurdenCost": 0.0,
        "LLRMaterialCost": 0.0,
        "LLRSubcontractCost": 0.0,
        "LLRMtlBurCost": 0.0,
        "LLRSetupLaborCost": 0.0,
        "LLRSetupBurdenCost": 0.0,
        "RollupDate": null,
        "DrawNum": null,
        "ECO": null,
        "Method": true,
        "AutoRecOpr": 0,
        "FinalOpr": 0,
        "PDMObjID": null,
        "Configured": false,
        "WebConfigured": false,
        "ShowInputPrice": false,
        "AltMethod": null,
        "AltMethodDesc": null,
        "Plant": "MfgSys",
        "ParentAltMethod": null,
        "UseStaging": false,
        "UseAltRevForParts": false,
        "OwnershipStatus": null,
        "ExtConfig": false,
        "ValRefDes": false,
        "PcGlobalPart": false,
        "PcEntprsConf": false,
        "GlobalRev": false,
        "RoughCutCode": null,
        "RMAInspPlan": null,
        "RMASpecID": null,
        "RMASampleSize": 0.0,
        "RMASampleSizePct": 0.0,
        "BasePartNum": null,
        "BaseRevisionNum": null,
        "ConfigID": null,
        "RegenConfig": false,
        "SIValuesGroupSeq": 0,
        "SIValuesHeadNum": 0,
        "ExternalMES": false,
        "SysRevID": 0,
        "SysRowID": "00000000-0000-0000-0000-000000000000",
        "ProcessMode": "S",
        "DefaultConfigPart": false,
        "CoPartsReqQty": 0.0,
        "MtlCostPct": 0.0,
        "LaborCostPct": 0.0,
        "CoPartsPerOp": 0,
        "CreatedBy": "xxxx",
        "CreatedOn": "2023-07-28T10:32:44.2753468-04:00",
        "ChangedBy": "xxxx",
        "ChangedOn": "2023-07-28T10:32:44.2753468-04:00",
        "ExternalMESSyncRequired": false,
        "ExternalMESLastSync": null,
        "CNCustomsBOM": false,
        "ProcessMfgID": null,
        "ProcessMfgType": null,
        "ProcessMfgDescription": null,
        "UseAdvancedStaging": false,
        "ProcessMfgLastGroupID": null,
        "DisableApproved": false,
        "ECOGroup": null,
        "HasCoParts": false,
        "ParentAltMethodDesc": null,
        "ParentPartNum": null,
        "ParentRevisionNum": null,
        "ProdCode": null,
        "RevStatusAsOfDate": 0,
        "SpecHedDescription": null,
        "vDate": null,
        "vQty": 0.0,
        "Class": null,
        "NonStock": false,
        "IsRootNode": false,
        "EngineeringApproved": false,
        "BitFlag": 1,
        "InspPlanDescription": "",
        "PartDescriptionTrackDimension": false,
        "PartDescriptionSellingFactor": 1.00000000,
        "PartDescriptionPartDescription": "TUB45_87",
        "PartDescriptionIUM": "Lb",
        "PartDescriptionTrackLots": false,
        "PartDescriptionPricePerCode": "E",
        "PartDescriptionSalesUM": "Lb",
        "PartDescriptionTrackSerialNum": false,
        "PartDescriptionTypeCode": "M",
        "PcStatusConfigType": "",
        "PlantName": "Wisconsin",
        "RoughCutParamDescription": "",
        "RowMod": "A"
      }
    ]
  }
}
2

Please can you give us some context to what you’re trying to do?

Is the base screen giving you this error? Are you trying to customise something?

Contexts GIFs - Get the best GIF on GIPHY

3

When you get an internal error 500, you can see more details by looking at the event viewer on the server (if you have access to that).

Is RevDescription a required field, seems to be missing in the dataset there…?

Brett

4

Hello,
no, i just open the rest api in the browser and put the value in the parameters fields. and I got internal error 500. but I have found the problem. in the input parameter RevisionNum, it should be blank but I put “01”. this cause the Internal error 500. the debug of Rest api is not easy.
Kinetic doesn’t enable the tracing automatically. I have to go to old Epicor 10 in classic mode and see how the parameter value pass. It is very frustrated. is there a better way to debug Internal error 500 in Kinetic for REST API call?

Regards,

Eddy

5

There is. It is a path chosen by few. Basically, don’t call the REST endpoints directly. Build your own endpoint in Epicor Functions and make all Business Object calls there. This has several benefits:

  • It reduces the number of calls across the network
  • One can add custom error handling
  • It is easier to test with tools like Postman, Swagger, among others.
  • It encapsulates Epicor logic away from the client making upgrades easier since logic isn’t spread out among all of the clients when there are changes to make.

The only exception to this rule would be the BAQSvc which is very reliable.

1 Like