Find product attributes and values for an item in AX 2012 via X++
This is for AX 2012 but probably works for D365, I'm not sure. Give it a shot.
It literally takes an item id and gives you the attributes and values in those attributes. Pretty straight forward
static void DAXGetProductAttributes(Args _args)
{
EcoResProductAttributeValue ecoResProductAttributeValue;
EcoResAttribute ecoResAttribute;
EcoResValue ecoResValue;
ItemId itemId = 'A10021'; // This is a sample Item Id
InventTable inventTable = InventTable::find(itemId);
while select RecId from ecoResProductAttributeValue
where ecoResProductAttributeValue.Product == inventTable.Product
join Name from ecoResAttribute
where ecoResAttribute.RecId == ecoResProductAttributeValue.Attribute
join ecoResValue
where ecoResValue.RecId == ecoResProductAttributeValue.Value
{
info(strFmt("%1 - %2 - %3", InventTable.ItemId, ecoResAttribute.Name, ecoResValue.value()));
}
}
与本文相关的文章
- 更新后 Dynamics 365 财务和运营字段丢失 / Dynamics 365 Finance and Operations field missing after update
- D365商业对 Adyen支付和服务连接器的考虑进行修改 / D365 Commerce making changes to Adyen payment and service connector considerations
- Solved: D365 Fields automatically populating on form errantly – Due to a Chrome addin/已解决:D365 字段自动错误地填充到表单上——由 Chrome 插件引发
- D365全屏模式,适用于现代POS(MPOS)/ D365 Full screen mode for Modern POS (MPOS)
- Dynamics 365 / AX 2012 现代/企业版POS’速度扫描’功能 / Dynamics 365/AX 2012 Modern/Enterprise POS ‘Speed Scanning’ feature
- Microsoft 365、Dynamics 365、Office 365 品牌和术语 / Microsoft 365 vs Dynamics 365 vs Office 365 terminology and branding (hopefully) explained