X++ code to display intra-class and inter-class conversions of a product in AX 2012.
Views (2151)
Hi,
Below job/code helps us find the intra-class and inter-class conversions setup on product at the path: Organization administration > Setup > Units > Unit conversions.
static void CG_ProductConversions(Args _args)
{
InventTable inventTable;
UnitOfMeasureConversion unitOfMeasureConversion;
UnitOfMeasure fromUnitOfMeasure, toUnitOfMeasure;
while select itemid from InventTable
where inventTable.ItemId == "XYZ" //Specify ItemId here
join Factor, Numerator, Denominator, innerOffset, outerOffset, Rounding, product, FromUnitOfMeasure, ToUnitOfMeasure from unitOfMeasureConversion
where unitOfMeasureConversion.Product == InventTable.Product
join Symbol,UnitOfMeasureClass from fromUnitOfMeasure // FromUnit
where fromUnitOfMeasure.RecId == unitOfMeasureConversion.FromUnitOfMeasure
join Symbol,UnitOfMeasureClass from toUnitOfMeasure //ToUnit
where toUnitOfMeasure.RecId == unitOfMeasureConversion.TOUNITOFMEASURE
{
// IntraClass Conversion
if (FromUnitOfMeasure.UnitOfMeasureClass == toUnitOfMeasure.UnitOfMeasureClass)
{
info(strFmt("IntraClass: Product: %1, Factor: %2, FromUnit: %3, ToUnit: %4", InventTable.ItemId, unitOfMeasureConversion.Factor, fromUnitOfMeasure.Symbol, toUnitOfMeasure.Symbol));
info(strFmt("Formula: %1", unitOfMeasureConversion.displayQuickFormula()));
}
// InterClass Conversions
else
{
info(strFmt("InterClass: Product: %1, Factor: %2, FromUnit: %3, ToUnit: %4", InventTable.ItemId, unitOfMeasureConversion.Factor, fromUnitOfMeasure.Symbol, toUnitOfMeasure.Symbol));
info(strFmt("Formula: %1", unitOfMeasureConversion.displayQuickFormula()));
}
}
}
Input:
INTRA-CLASS CONVERSION
INTER-CLASS CONVERSION
Output:
Regards,
Chaitanya Golla

Like
Report
*This post is locked for comments