Friday, February 18, 2022

How to generate inventory dimension from existing dimension with change in some dimension value

   public InventDimId getInventoryDimension(InventDimId _orignalDimId,EcoResItemConfigurationName _configId)

    {

        InventDim inventDim,inventDimLoc;


        inventDim = InventDim::find(_orignalDimId,false);


        select inventDimLoc where inventDimLoc.InventSiteId == inventDim.InventSiteId && inventDimLoc.InventLocationId == inventDim.InventLocationId

                    && inventDimLoc.InventColorId == inventDim.InventColorId && inventDimLoc.InventStyleId == inventDim.InventStyleId

                    && inventDimLoc.InventSizeId == inventDim.InventSizeId && inventDimLoc.configId == _configId

                    && inventDimLoc.inventBatchId == inventDim.inventBatchId && inventDimLoc.inventSerialId == inventDim.inventSerialId && inventDimLoc.LicensePlateId == inventDim.LicensePlateId

                    && inventDimLoc.wMSLocationId == inventDim.wMSLocationId

                    && inventDimLoc.InventStatusId == inventDim.InventStatusId;

        if(!inventDimLoc.RecId)

        {

            inventDimLoc.clear();

            inventDimLoc.InventSiteId       = inventDim.InventSiteId;

            inventDimLoc.InventLocationId   = inventDim.InventLocationId;

            inventDimLoc.InventColorId      = inventDim.InventColorId;

            inventDimLoc.InventStyleId      = inventDim.InventStyleId;

            inventDimLoc.InventSizeId       = inventDim.InventSizeId ;

            inventDimLoc.configId           = _configId;

            inventDimLoc.inventBatchId      = inventDim.inventBatchId;

            inventDimLoc.inventSerialId     = inventDim.inventSerialId;

            inventDimLoc.LicensePlateId     = inventDim.LicensePlateId;

            inventDimLoc.wMSLocationId      = inventDim.wMSLocationId;

            inventDimLoc.InventStatusId     = inventDim.InventStatusId;

        }


        inventDimLoc = InventDim::findOrCreate(inventDimLoc);


        return inventDimLoc.inventDimId;


    }

No comments:

Post a Comment

Sample Dialog Syntax - 1

 class AffiliationAutoAssignment extends RunBaseBatch {     // 1. Class Declaration and Pack variables     #define.CurrentVersion(1)     #de...