web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :

X++ code to display intra-class and inter-class conversions of a product in AX 2012.

Chaitanya Golla Profile Picture Chaitanya Golla 17,225

       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

IntraConversion.png

INTER-CLASS CONVERSION

InterConversion.png

Output:

ConverOutput.png

Regards,

Chaitanya Golla

Comments

*This post is locked for comments