使用 Acumatica 17.210.0034 和 API 端点 17.200.001，我正在执行包含自定义字段的 PUT，但数据库中未设置自定义字段值。任何帮助将不胜感激。 插入和更新也会发生同样的事情。已添加数据，但未设置自定义字段值。
放置网址：
http://localhost/acuroyalbay172100034/entity/Default/17.200.001/StockItem?%24custom=InventoryItemExt.UsrSquareFTG%2cInventoryItemExt.UsrDispPerPallet%2cInventoryItemExtension.UsrItemClassCD%2cInventoryItemAMExtension.AMReplenishmentSource%2cInventoryItemAMExtension.AMLotSize%2cInventoryItemAMExtension.AMMaxOrdQty%2cInventoryItemAMExtension.AMMinOrdQty%2cInventoryItemAMExtension.AMLowLevel%2cInventoryItemAMExtension.AMMRPItem%2cInventoryItemAMExtension.AMMFGLeadTime%2cInventoryItemAMExtension.AMGroupWindow%2cInventoryItemAMExtension.AMConfigurationID%2cInventoryItemAMExtension.AMReplenishmentSourceOverride%2cInventoryItemAMExtension.AMSafetyStockOverride%2cInventoryItemAMExtension.AMSafetyStock%2cInventoryItemAMExtension.AMMinQtyOverride%2cInventoryItemAMExtension.AMMinQty%2cInventoryItemAMExtension.AMQtyRoundUp
请求正文：
{
"AverageCost": {
"value": 0.0
},
"BaseUOM": {
"value": "EA"
},
"COGSAccount": {
"value": "50000"
},
"COGSSubaccount": {
"value": "CON000"
},
"CurrentStdCost": {
"value": 0.0
},
"DefaultIssueLocationID": {
"value": "R1S1"
},
"DefaultPrice": {
"value": 0.0
},
"DefaultReceiptLocationID": {
"value": "RECEIVING"
},
"DefaultWarehouseID": {
"value": "WHOLESALE"
},
"Description": {
"value": "tonyitem153"
},
"DimensionVolume": {
"value": 0.0
},
"DimensionWeight": {
"value": 0.0
},
"InventoryAccount": {
"value": "12100"
},
"InventoryID": {
"value": "RGTONYIT153"
},
"InventorySubaccount": {
"value": "CON000"
},
"IsAKit": {
"value": false
},
"ItemClass": {
"value": "CONSUMER 200FITNESS"
},
"ItemStatus": {
"value": "Active"
},
"ItemType": {
"value": "Finished Good"
},
"LandedCostVarianceAccount": {
"value": "52400"
},
"LandedCostVarianceSubaccount": {
"value": "CON000"
},
"LastCost": {
"value": 0.0
},
"LastModified": {
"value": "2018-09-11T12:36:15.483-04:00"
},
"LastStdCost": {
"value": 0.0
},
"LotSerialClass": {
"value": "NOTTRACKED"
},
"Markup": {
"value": 0.0
},
"MaxCost": {
"value": 0.0
},
"MinCost": {
"value": 0.0
},
"MinMarkup": {
"value": 0.0
},
"MSRP": {
"value": 0.0
},
"PackagingOption": {
"value": "Manual"
},
"PackSeparately": {
"value": false
},
"PendingStdCost": {
"value": 0.0
},
"POAccrualAccount": {
"value": "20100"
},
"POAccrualSubaccount": {
"value": "CON000"
},
"PostingClass": {
"value": "CON"
},
"PurchasePriceVarianceAccount": {
"value": "52300"
},
"PurchasePriceVarianceSubaccount": {
"value": "CON000"
},
"PurchaseUOM": {
"value": "EA"
},
"ReasonCodeSubaccount": {
"value": "CON000"
},
"SalesAccount": {
"value": "40000"
},
"SalesSubaccount": {
"value": "CON000"
},
"SalesUOM": {
"value": "EA"
},
"StandardCostRevaluationAccount": {
"value": "52110"
},
"StandardCostRevaluationSubaccount": {
"value": "CON000"
},
"StandardCostVarianceAccount": {
"value": "52100"
},
"StandardCostVarianceSubaccount": {
"value": "CON000"
},
"SubjectToCommission": {
"value": false
},
"TaxCategory": {
"value": "TAXABLE"
},
"ValuationMethod": {
"value": "Average"
},
"custom": {
"InventoryItemExt": {
"UsrSquareFTG": {
"type": "CustomDecimalField",
"value": 5.0
},
"UsrDispPerPallet": {
"type": "CustomIntField",
"value": 6
}
},
"InventoryItemExtension": {
"UsrItemClassCD": {
"type": "CustomStringField",
"value": "CONSUMER 200FITNESS"
}
},
"InventoryItemAMExtension": {
"AMReplenishmentSource": {
"type": "CustomStringField",
"value": "Purchase"
},
"AMLotSize": {
"type": "CustomDecimalField",
"value": 0.0
},
"AMMaxOrdQty": {
"type": "CustomDecimalField",
"value": 0.0
},
"AMMinOrdQty": {
"type": "CustomDecimalField",
"value": 0.0
},
"AMLowLevel": {
"type": "CustomIntField",
"value": 0
},
"AMMRPItem": {
"type": "CustomBooleanField",
"value": true
},
"AMMFGLeadTime": {
"type": "CustomIntField",
"value": 0
},
"AMGroupWindow": {
"type": "CustomIntField",
"value": 0
},
"AMConfigurationID": {
"type": "CustomStringField"
},
"AMReplenishmentSourceOverride": {
"type": "CustomBooleanField",
"value": false
},
"AMSafetyStockOverride": {
"type": "CustomBooleanField",
"value": false
},
"AMSafetyStock": {
"type": "CustomDecimalField",
"value": 0.0
},
"AMMinQtyOverride": {
"type": "CustomBooleanField",
"value": false
},
"AMMinQty": {
"type": "CustomDecimalField",
"value": 0.0
},
"AMQtyRoundUp": {
"type": "CustomBooleanField",
"value": false
}
}
}
}
响应：
{
"id": "2299727f-c471-46de-a8ac-9dcfe1a2a09f",
"rowNumber": 1,
"note": null,
"ABCCode": {},
"AutoIncrementalValue": {},
"AverageCost": {
"value": 0
},
"BaseUOM": {
"value": "EA"
},
"COGSAccount": {
"value": "50000"
},
"COGSSubaccount": {
"value": "CON000"
},
"Content": {},
"CurrentStdCost": {
"value": 0
},
"DefaultIssueLocationID": {
"value": "R1S1"
},
"DefaultPrice": {
"value": 0
},
"DefaultReceiptLocationID": {
"value": "RECEIVING"
},
"DefaultWarehouseID": {
"value": "WHOLESALE"
},
"DeferralAccount": {},
"DeferralSubaccount": {},
"Description": {
"value": "tonyitem153"
},
"DimensionVolume": {
"value": 0
},
"DimensionWeight": {
"value": 0
},
"DiscountAccount": {},
"DiscountSubaccount": {},
"ImageUrl": {},
"InventoryAccount": {
"value": "12100"
},
"InventoryID": {
"value": "RGTONYIT153"
},
"InventorySubaccount": {
"value": "CON000"
},
"IsAKit": {
"value": false
},
"ItemClass": {
"value": "CONSUMER 200FITNESS"
},
"ItemStatus": {
"value": "Active"
},
"ItemType": {
"value": "Finished Good"
},
"LandedCostVarianceAccount": {
"value": "52400"
},
"LandedCostVarianceSubaccount": {
"value": "CON000"
},
"LastCost": {
"value": 0
},
"LastModified": {
"value": "2018-09-11T12:56:47.843-04:00"
},
"LastStdCost": {
"value": 0
},
"LotSerialClass": {
"value": "NOTTRACKED"
},
"Markup": {
"value": 0
},
"MaxCost": {
"value": 0
},
"MinCost": {
"value": 0
},
"MinMarkup": {
"value": 0
},
"MSRP": {
"value": 0
},
"PackagingOption": {
"value": "Manual"
},
"PackSeparately": {
"value": false
},
"PendingStdCost": {
"value": 0
},
"POAccrualAccount": {
"value": "20100"
},
"POAccrualSubaccount": {
"value": "CON000"
},
"PostingClass": {
"value": "CON"
},
"PriceClass": {},
"PriceManager": {},
"PriceWorkgroup": {},
"ProductManager": {},
"ProductWorkgroup": {},
"PurchasePriceVarianceAccount": {
"value": "52300"
},
"PurchasePriceVarianceSubaccount": {
"value": "CON000"
},
"PurchaseUOM": {
"value": "EA"
},
"ReasonCodeSubaccount": {
"value": "CON000"
},
"SalesAccount": {
"value": "40000"
},
"SalesSubaccount": {
"value": "CON000"
},
"SalesUOM": {
"value": "EA"
},
"StandardCostRevaluationAccount": {
"value": "52110"
},
"StandardCostRevaluationSubaccount": {
"value": "CON000"
},
"StandardCostVarianceAccount": {
"value": "52100"
},
"StandardCostVarianceSubaccount": {
"value": "CON000"
},
"SubjectToCommission": {
"value": false
},
"TaxCategory": {
"value": "TAXABLE"
},
"ValuationMethod": {
"value": "Average"
},
"VolumeUOM": {},
"WeightUOM": {},
"custom": {
"InventoryItemExt": {
"UsrSquareFTG": {
"type": "CustomDecimalField",
"value": null
},
"UsrDispPerPallet": {
"type": "CustomIntField",
"value": null
}
},
"InventoryItemExtension": {
"UsrItemClassCD": {
"type": "CustomStringField",
"value": null
}
},
"InventoryItemAMExtension": {
"AMReplenishmentSource": {
"type": "CustomStringField",
"value": "Purchase"
},
"AMLotSize": {
"type": "CustomDecimalField",
"value": 0
},
"AMMaxOrdQty": {
"type": "CustomDecimalField",
"value": 0
},
"AMMinOrdQty": {
"type": "CustomDecimalField",
"value": 0
},
"AMLowLevel": {
"type": "CustomIntField",
"value": 0
},
"AMMRPItem": {
"type": "CustomBooleanField",
"value": true
},
"AMMFGLeadTime": {
"type": "CustomIntField",
"value": 0
},
"AMGroupWindow": {
"type": "CustomIntField",
"value": 0
},
"AMConfigurationID": {
"type": "CustomStringField",
"value": null
},
"AMReplenishmentSourceOverride": {
"type": "CustomBooleanField",
"value": false
},
"AMSafetyStockOverride": {
"type": "CustomBooleanField",
"value": false
},
"AMSafetyStock": {
"type": "CustomDecimalField",
"value": 0
},
"AMMinQtyOverride": {
"type": "CustomBooleanField",
"value": false
},
"AMMinQty": {
"type": "CustomDecimalField",
"value": 0
},
"AMQtyRoundUp": {
"type": "CustomBooleanField",
"value": false
}
}
},
"files": []
}
通常，自定义关键字是用于检索记录的参数的一部分，如本帮助文章所示。
- https://help.acumatica.com/(W(4((/主要？ScreenId=ShowWiki&pageid=c5e2f36a-0971-4b33-b127-3c3fe14106ff
如果要为这些字段设置值，则需要先将该字段添加到终结点。
下面是有关如何创建扩展终结点的一些链接：
自定义终结点和终结点扩展
- https://help.acumatica.com/(W(4((/主要？ScreenId=ShowWiki&pageid=c920d9fc-8e81-4f4e-9250-81c6fb979517
自定义字段
- https://help.acumatica.com/(W(4((/主要？ScreenId=ShowWiki&pageid=bd0d8a36-b00b-44c8-bdcd-b2b4e4c86fd0
答案似乎是您必须扩展端点才能使用 PUT 更新数据。 使用包含自定义字段的 GET 数据结构作为集合不起作用。
请求正文的问题在这里：
"custom": {
"InventoryItemExt": {
"UsrSquareFTG": {
"type": "CustomDecimalField",
"value": 5.0
},
"UsrDispPerPallet": {
"type": "CustomIntField",
"value": 6
}
},
...
}
自定义字段集合应具有另一种格式和键。
若要获取实体的正确 json 架构及其自定义字段，可以使用 get request to address http://localhost/acuroyalbay172100034/entity/Default/17.200.001/StockItem/$adHocSchema
它将返回包含自定义字段的 JSON。您可以将其用作请求正文的模板。 另请参阅帮助