Saturday, May 18, 2019

Release Product Variants


static void OGSReleaseProductVariants(Args _args)
{

    EcoResProduct  ecoResProduct;
    //InventTable inventTable;
    InventDimCombination inventDimCombination;
    CompanyId compId;
    int success, errors;

    //Enter the company code where you want to release variants
    compId = 'alma';

    changeCompany(compId)
    {
        while select ecoResProduct
            //exists join inventTable
            notExists join inventDimCombination where
            //inventTable.ItemId == ecoResProduct.DisplayProductNumber &&
            ecoResProduct.DisplayProductNumber == inventDimCombination.ItemId
        {
            try
            {
                EcoResProductReleaseManagerBase::releaseProduct(ecoResProduct.RecId,
                                            CompanyInfo::findDataArea(compId).RecId);
                success++;
            }
            catch
            {
                errors++;
                continue;
            }
        }
    }
    info(strFmt("Complete: %1 records success, %2 errors/skipped",success,errors));
}

No comments:

Post a Comment