This Blog is specially for AXapta Developers. Here you can find help about your technical or function issues. In this blog I shared my exp with AX.
static void SIBOMwithNoActiveVersion(Args _args){ BOMTable bomTable; BOMVersion bomVersion; int nmbr, i; boolean printOnly = false; ; SetPrefix('BOMs without any active version'); Nmbr = 0; while select bomTable notexists join bomVersion where bomVersion.Active == NoYes::Yes && bomVersion.BOMId == bomTable.BOMId { nmbr++; info(strfmt("%1 %2, %3, %4, %5, %6, %7", nmbr, bomTable.BOMId, bomTable.Name, bomVersion.ItemId, bomVersion.Name, bomVersion.Active ),"", SysInfoAction_TableField::newBufferField(bomTable, fieldnum(bomTable, BOMId))); }}