Create Product Variant using X++

How to create a product variant with Dimensions provided  

ecoResDistinctProductVariant        ecoResDistinctProductVariant;
    EcoResProductVariantDimensionValue  EcoResProductVariantDimensionValue;
    RefRecId                                   ecoResDistinctProductVariantRecId;
    EcoResProductReleaseManagerBase     releaseManager;
    container productDimensions;


//Create a container to hold dimension values
productDimensions = EcoResProductVariantDimValue::getDimensionValuesContainer(ConfigurationName,
                                                                                        Size,
                                                                                        ColorId,
                                                                                        InventStyleId);
//Create Product search name

ecoResDistinctProductVariant.DisplayProductNumber = EcoResProductNumberBuilderVariant::buildFromProductNumberAndDimensions(
                                                                   EcoResProduct::find(InventTable.Product).productNumber(),
                                                                    productDimensions);

//Create Product variant with Product and dimensions provided

    ecoResDistinctProductVariantRecId = EcoResProductVariantManager::createProductVariant(InventTable.Product,ecoResDistinctProductVariant.DisplayProductNumber,productDimensions);

//Find newly created Product Variant
    ecoResDistinctProductVariant = ecoResDistinctProductVariant::find(ecoResDistinctProductVariantRecId);
//Now release the Product variant
    releaseManager = EcoResProductReleaseManagerBase::newFromProduct(ecoResDistinctProductVariant);
    releaseManager.release();



Hope this will help u guys :)

create Product master by using X++ , AX 2012

Following code to create Product master by using X++
static void ProductCreate(Args _args)
{

EcoResProductService erProdSvc;
EcoResEcoResProduct EcoResProd;
EcoResEcoResProduct_Product_Master ProdMast;
EcoResEcoResProduct_Translation Translation;
EcoResEcoResProduct_Identifier Identifier;
EcoResEcoResProduct_ProductDimGroup ProdDimGroup;

//Initialize the service object
erProdSvc = EcoResProductService::construct();
EcoResProd = new EcoResEcoResProduct();
ProdMast = new EcoResEcoResProduct_Product_Master();

//ProdDimGroup = new EcoResEcoResProduct_ProductDimGroup();
//Newly created and initialize prodMast
ProdMast.parmDisplayProductNumber("IDB-PM002");
ProdMast.parmProductType(EcoResProductType::Item);
ProdMast.parmSearchName("IDB Product Master 1");


//Create a new translation object:
Translation = ProdMast.createTranslation().addNew();

Translation.parmDescription("IDB product Master");
Translation.parmLanguageId("en-us");
Translation.parmName("IDB Product Master 1");
Identifier = ProdMast.createIdentifier().addNew();

Identifier.parmProductNumber("IDB-PM002");
ProdDimGroup = ProdMast.createProductDimGroup().addNew();
ProdDimGroup.parmProduct("IDB-PM001");
ProdDimGroup.parmProductDimensionGroup("Col");


ProdMast.parmVariantConfigurationTechnology(EcoResVariantConfigurationTechnologyType::PredefinedVariants);
EcoResProd.createProduct().add(ProdMast);

erProdSvc.create(EcoResProd);

} 

Lookup for RealEdit Control in Ax2012

Lookup for RealEdit Control in Ax2012

we cant build the lookup for RealEdit control by using SysLookup functionality for that we have to customize the SysTableLookup class method performFormLookup()
Add the case for switch for handling the FormRealControl.
FormRealControl     callingRealControl;


 case classNum(FormRealControl):
            callingRealControl = callingControl;
            callingRealControl.performFormLookup(this.formRun());
            break;

Function DimensionValidation::validateByTree has been incorrectly called.

While Creating General Journal using X++ , we faced this error:
Function DimensionValidation::validateByTree has been incorrectly called.

First let us go through , why we are getting this :

This error is coming because we are passing the account and offset account in wrong manner to LedgerJournalTrans . The field OffsetLedgerDimension and LedgerDimension are of type :
DimensionDynamicAccount , so before passigng the Account to these field , we need to convert the account to correct type . How to do it:

For non ledger account(Bank, customer ..............) , we do have the API :
DimensionStorage::getDynamicAccount(A/cNo ,LedgerJournalACType::Bank);

we need to pass this AS :

LedgerJournalTrans .LedgerDimension  = DimensionStorage::getDynamicAccount(Hedging_table.AccountID,LedgerJournalACType::Bank);

There you go.......

But what to do with Ledger Account , you still can not pass these account directly as well .

Well there is one more API which can help us :

LedgerJournalTrans .getLedgerDimensionForLedgerType(Ledger A/c,jourTrans.Company);
LedgerJournalTrans .LedgerDimension  = 
LedgerJournalTrans .getLedgerDimensionForLedgerType(Ledger A/c,jourTrans.Company);



Please put your comment ,if you find it helpful or looking for some more info......


Thanks,

Inventory Dimension enable /disable based upon item selected

Inventory Dimension enable /disable based upon item selected

Hi Friends, Well we have seen a no of times we face the issue to have  the correct Inventory dimension field enabled/disabled based upon Item selected . How to achieve this :

1.       Add below declaration in your class declaration of form

         public class FormRun extends ObjectRun

        {

          InventDimCtrl_Frm       inventDimFormSetup;

        }

2.       Add below piece in form’s Init method :

public void init()

{

    element.updateDesign(InventDimFormDesignUpdate::Init);

}

3.       Add below method :

InventDimCtrl_Frm inventDimSetupObject()

{

    return inventDimFormSetup;

}

4.   Add below method :

void updateDesign(InventDimFormDesignUpdate mode)

{

    inventDimParm   inventDimParmVisible;

    inventDimParm   inventDimParmEnabled;

    switch (mode)

    {

        case InventDimFormDesignUpdate::Init          :

        case InventDimFormDesignUpdate::LinkActive    :

            if (!inventDimFormSetup)

            {

                inventDimFormSetup  = InventDimCtrl::newFromForm(element);

            }

            inventDimFormSetup.parmSkipOnHandLookUp(true);

            if (element.args().dataset() == tableNum(datasource))

            {

                inventDimParmVisible = EcoResProductDimGroupSetup::newItemId(Item_Adjustment.ItemId).inventDimParmActiveDimensions();

            }

            else

            {

                inventDimParmVisible.initProductDimensionsAllGroups();

            }

            inventDimFormSetup.parmDimParmVisibleGrid(inventDimParmVisible);

            break;

        case InventDimFormDesignUpdate::Active        :

            inventDimFormSetup.formActiveSetup();

            inventDimParmEnabled = EcoResProductDimGroupSetup::newItemId(datasource.ItemId).inventDimParmActiveDimensions();

            inventDimParmEnabled.InventLocationIdFlag = true;

            inventDimFormSetup.parmDimParmEnabled(inventDimParmEnabled);

            inventDimFormSetup.formSetControls(true);

            //inventDimFormSetup.

            break;

        case InventDimFormDesignUpdate::FieldChange   :

            inventDimFormSetup.formActiveSetup();

            inventDimParmEnabled = EcoResProductDimGroupSetup::newItemId(datasource.ItemId).inventDimParmActiveDimensions();

            inventDimFormSetup.parmDimParmEnabled(inventDimParmEnabled);

            //inventDimFormSetup.

            inventDimFormSetup.formSetControls(true);

            break;

        default :

            throw error(strfmt("@SYS54195",funcname()));

    }

}

5.       Add below lines in Active method of DS :

public int active()

{

    int ret;

    ret = super();

    element.updateDesign(InventDimFormDesignUpdate::Active);

   

    return ret;

}

6      Add below line in ItemId’s modified method :

element.updateDesign(InventDimFormDesignUpdate::FieldChange);

Well you are ready to go :

 PS : You want to enable\ disable one particular  Dimension field irrespective  of Item selected , how to do : 

Simple put the corresponding flag true or false as

inventDimParmEnabled.InventLocationIdFlag = true;

Hope this will help you guys   J

Hide Enum values in Form Control

Hide Enum values in Form Control :

Well there are various situations where you  want to show only subset of Enum values :

How to do it :

Well add below , In Class declaration of form

public class FormRun extends ObjectRun

{

    SysFormEnumComboBox         sysFormEnumComboBox;

    Set                         enumSet;// = new Set(Types::Enum);

}

Add below piece of code in Form’s init method :

public void init()

{

    enumSet= new Set(Types::Enum);

    enumSet.add(Enum::A);

    enumSet.add(Enum::B);

    enumSet.add(Enum::C);

    enumSet.add(Enum::D);

   

    sysFormEnumComboBox  = sysFormEnumComboBox::newParameters(element,element.controlId(formControlStr(Form,control)),enumNum(enum),enumSet);

    super();

  

}

Well, Please have a deep look on second Argument ,which is control ID.

Disable/Enable button based upon records available in List page

Disable/Enable button based upon records available in List page .

I created a new List page , and was surprised that even though there is no record available in List page ,

Edit and Edit in Grid buttons are enabled , which lead to issues:

 

So what is  solution for this :

Simple  set the”NeededRecords”  property of button to “yes”.

Implement Catch Weight

Implement Catch Weight in New Form 


Before Starting Implementation , Let us have a Quick Look on this functionlaity 
You often use catch weight products in industries where products can vary slightly by weight or size, or both, such as the food industry. Catch weight products use two units of measure – an inventory unit and a catch weight unit. The inventory unit is the unit of measure in which the product is weighed and invoiced. The catch weight unit is the unit in which the inventory transactions are performed, such as sold, received, transferred, picked, and shipped. The nominal quantity represents the conversion between the catch weight unit and the inventory unit. Minimum and maximum quantities represent the allowed interval in which the inventory quantity can vary.

Now go for Implementation :

1 . Create a new class Extend with PdsCWFormCtrl_Std

            Override the method as required.

2. In table create two fields : Qty and PdsCWQty

3. Add display method to table :

public display PdsCWUnitId pdsCWUnitId()

{

    return PdsCatchWeight::cwUnitId(this.ItemId);

}

4.In Classdeclaration of Form   add below line :

PdsCWFormCtrl                       cwFormCtrl;

 5.In init method of Form :

        if (#PdsCatchWeightEnabled)

        {

            cwFormCtrl = yourclass::newFromForm(element);

            cwFormCtrl.initPre();

        }

       

        super();

    if (cwFormCtrl)

    {

        cwFormCtrl.parmBuffer(YourTable);

        cwFormCtrl.initPost();

    }

    6.In init method of Datasource add :

public void init()

{

    super();

    if (cwFormCtrl)

    {

        cwFormCtrl.dataSourceInitPost(YourTable);

    }

   

}

\

7.Override the Validatewrite of DS :

public boolean validateWrite()

{

    boolean ret;

    ret = super();

    if (cwFormCtrl)

    {

        ret = cwFormCtrl.dataSourceValidateWrite() && ret;

    }

   

    return ret;

}

8.Override the Active method of DS

if (cwFormCtrl)

    {

        cwFormCtrl.dataSourceActivePost();

    }

9.Override the modified of ItemId and QTY as

           

  if (cwFormCtrl)

    {

        cwFormCtrl.fieldModified(fieldnum(WO_line, ItemId));

    }

"Error executing code: The field with ID '60001' does not exist in table 'RetailStoreTable'."

error : "Error executing code: The field with ID '60001' does not exist in table 'RetailStoreTable'."

Hi I got this error , when I was trying to update data in RetailStore table.To my surprise this field id was not added to RetailStore Table , then why system was checking for this field id : I debugged further and then found that there is one table : RetailConnCreateActionsByField , which is holding these values together : Table RetailStore mapped with fieldId 60001 , hence system was forced to check this field .

Solution : Remove this entry from Table J.

Will be back 

Open AX 2012 in dev environment

Every time , when you open AX 2012 , you need to press CTRL +D , to open the development work space, 

what if you want to open the Development work space directly , Its very simple ,Just go to properties of shortcut of AX 2012 and update the Target values by adding -development , :) 

Get all dimensions available in AX for any given Environment

How to get all dimensions available in any environment , the below job will help us
static void getAllDimension(Args _args)
{
    Counter         idx;
    Dimension       dimension;
    DimensionCode   dimensionCode;
    str             name;
    ;
    for (idx = 1; idx <= dimof(dimension); idx++)
    {
        dimensionCode = Dimensions::arrayIdx2Code(idx);
        name = enum2str(dimensionCode);
        // if (name == 'B') ...
        info(strfmt("%1: %2", idx, name));
    }
}

Request for the permission of type 'SqlStatementExecutePermission' failed.

While running one Job , where I was trying to execute one SQL statement in AX, I got the below stack trace :


Request for the permission of type 'SqlStatementExecutePermission' failed.
(S)\Classes\SqlStatementExecutePermission\demand
(S)\Classes\Statement\executeQuery
(C)\Jobs\test - line 21

So what is the solution for this , Very simple , we need to run this job on Server , So now how to do it :

here is solution , create a menu item of type action, give the object type as Job ,and object name , and set the property Run on as" Server ".

There you go , Problem solved  :) 

Get Database size using X++

How to get size of Database being used by AX ,below job can help you :



static void GetDBSize(Args _args)
{
LoginProperty loginProp;
ODBCConnection conn;
Resultset resultSet, resultSetCount;
Statement statement1, statement2;
str test;
real s;
SysSQLSystemInfo   systemInfo =  SysSQLSystemInfo::construct();

;

 test = strfmt( "SELECT size FROM sys.master_files where name = '%1'",systemInfo.getloginDatabase()  );
loginProp = new LoginProperty();

loginProp.setServer(systemInfo.getLoginServer());
loginProp.setDatabase(systemInfo.getloginDatabase());

conn = new ODBCConnection(loginProp);

statement1 = conn.createStatement();
resultSet = statement1.executeQuery(test);

while (resultSet.next())
{
s = str2int(resultSet.getString(1));
s = s*8 /1024;
info(strfmt("%1  MB",s));
}
}