To insert item description, ItemUnitofmeasure,Item category,Item storage dimension,Item tracking dimension, Module groupid based on Itemid:

To insert item description, ItemUnitofmeasure,Item category,Item storage dimension,Item tracking dimension, Module groupid based on Itemid:

public void modified()
{
    InventTable                         inventTable;
    InventTableModule                   inventTableModule;
    EcoResCategory                      ecoResCategory;
    EcoResProductCategory               ecoResProductCategory;
    EcoResProduct                       ecoResProduct;
    EcoResStorageDimensionGroup         ecoResStorageDimensionGroup;
    EcoResStorageDimensionGroupItem     ecoResStorageDimensionGroupItem;
    EcoResTrackingDimensionGroup        ecoResTrackingDimensionGroup;
    EcoResTrackingDimensionGroupItem    ecoResTrackingDimensionGroupItem;
    InventItemGroupItem                 inventItemGroupItem;
    InventModelGroupItem                inventModelGroupItem;

    super();

    select inventTable where inventTable.ItemId == FCC_BULEstimationLines.OldProductCode;
    FCC_BULEstimationLines.ProductDescription = inventTable.defaultProductName();

    select inventTableModule where inventTableModule.ItemId == FCC_BULEstimationLines.OldProductCode &&
                                   inventTableModule.ModuleType == ModuleInventPurchSales::Purch;
    FCC_BULEstimationLines.UnitOfMeasure = inventTableModule.UnitId;

    select ecoResCategory join ecoResProductCategory
        where ecoResProductCategory.Category == ecoResCategory.RecId
         join ecoResProduct
        where ecoResProduct.RecId == ecoResProductCategory.Product &&
              ecoResProduct.DisplayProductNumber == FCC_BULEstimationLines.OldProductCode;

    FCC_BULEstimationLines.ItemCategory = ecoResCategory.Name;

     //inserting the StorageDimension
    select ecoResStorageDimensionGroup join ecoResStorageDimensionGroupItem
    where ecoResStorageDimensionGroup.RecId ==  ecoResStorageDimensionGroupItem.StorageDimensionGroup &&
          ecoResStorageDimensionGroupItem.ItemId == FCC_BULEstimationLines.OldProductCode &&
          ecoResStorageDimensionGroupItem.ItemDataAreaId == curext();

    FCC_BULEstimationLines.StorageDimension = ecoResStorageDimensionGroup.Name;

    //inserting the TrackingDimension
    select ecoResTrackingDimensionGroup join ecoResTrackingDimensionGroupItem
    where ecoResTrackingDimensionGroup.RecId ==  ecoResTrackingDimensionGroupItem.TrackingDimensionGroup &&
          ecoResTrackingDimensionGroupItem.ItemId == FCC_BULEstimationLines.OldProductCode &&
          ecoResTrackingDimensionGroupItem.ItemDataAreaId == curext();

    FCC_BULEstimationLines.TrackingDimension = ecoResTrackingDimensionGroup.Name;

    //inserting the ItemGroupId
    select ItemGroupId from inventItemGroupItem
        where inventItemGroupItem.ItemId == FCC_BULEstimationLines.OldProductCode &&
              inventItemGroupItem.ItemDataAreaId == curext();
    FCC_BULEstimationLines.ItemGroupId = inventItemGroupItem.ItemGroupId;

    //inserting the ModelGroupId
    select ModelGroupId from inventModelGroupItem
        where inventModelGroupItem.ItemId == FCC_BULEstimationLines.OldProductCode &&
              inventModelGroupItem.ItemDataAreaId == curext();
    FCC_BULEstimationLines.ModelGroupId = inventModelGroupItem.ModelGroupId;
    FCC_BULEstimationLines_ds.refresh();

    //Added by wrexim
    if(FCC_BULEstimationLines.OldProductCode != "")
    {
        FCC_BULEstimationLines_NewProductCode.enabled(false);
    }
    else
     {
         FCC_BULEstimationLines_NewProductCode.enabled(true);
     }
}