Hello,

Thanks again for helping out with this.  I also added another variable to the code lines 39-43, it is basically just another if statement based on the previous ones you provided.  Here is the code as it stands today:

public with sharing class CommissionHelper{
    
    /**
    * @description This method is used to calculate the commission against each commissionable user
    **/
    public static void calculateCommission(Map<Id,Commissionable_User__c> newMap){
        
        Set<String> divisionIds = new Set<String>();
        Set<Id> productIds = new Set<Id>();

        for(Id comUser : newMap.keySet()){
            if(newMap.get(comUser).Commissionable_User_Division__c != null){
                divisionIds.add(newMap.get(comUser).Commissionable_User_Division__c);
            }
            if(newMap.get(comUser).ProductId__c != null){
                productIds.add(newMap.get(comUser).ProductId__c);
            }
        }

        Map<String,List<Incentive_Plan__c>> divisionIncentivePlansMap = getIncentivePlansByDivision(divisionIds);
        Map<Id,List<Incentive_Product__c>> productIncentiveProductsMap = getIncentiveProductsByProduct(productIds);

        List<Commission__c> commissionRecordsForInsert = new List<Commission__c>();

        for(Commissionable_User__c comUser : newMap.values()){
            Incentive_Plan__c theIncentivePlan = (divisionIncentivePlansMap.containsKey(comUser.Commissionable_User_Division__c) ? divisionIncentivePlansMap.get(comUser.Commissionable_User_Division__c)[0] : null);
            Incentive_Product__c theIncentiveProduct = (productIncentiveProductsMap.containsKey(comUser.ProductId__c) ? productIncentiveProductsMap.get(comUser.ProductId__c)[0] : null);

            if(theIncentivePlan != null && theIncentiveProduct != null){
                Commission__c newCommission = new Commission__c( Commission_User_ID__c = comUser.Id, earn_date__c = date.today(), Incentive_Plan__c = theIncentivePlan.Id, CommissionSpiff__c = theIncentivePlan.Spiff__c);

                if(theIncentiveProduct.Division__c == comUser.Commissionable_User_Division__c){
                    newCommission.Percent__c = theIncentiveProduct.Intradivisional_Percentage__c;
                    }
                    else
                    {
                    newCommission.Percent__c = theIncentivePlan.of_Commissionable_Price__c;
                    }
                    if(theIncentiveProduct.Division__c != comUser.Commissionable_User_Division__c){
                    newCommission.Percent__c = theIncentiveProduct.Interdivisional_Percentage__c;
                    }else
                    {
                    newCommission.Percent__c = theIncentivePlan.of_Commissionable_Price__c;
                }
                commissionRecordsForInsert.add(newCommission);
            }
        }

        insert commissionRecordsForInsert;
    }

    /**
    * @description This method is used provide a map of incentive plans by division
    **/
   private static Map<String,List<Incentive_Plan__c>> getIncentivePlansByDivision(set<String> divisionIds){
        Map<String,List<Incentive_Plan__c>> divisionIncentivePlansMap = new Map<String,List<Incentive_Plan__c>>();

        List<Incentive_Plan__c> incentivePlansList = [select Id, Spiff__c, of_Commissionable_Price__c, Division__c from Incentive_Plan__c where Division__c in :divisionIds];

        for(Incentive_Plan__c incentivePlan : incentivePlansList){
            List<Incentive_Plan__c> plans = (divisionIncentivePlansMap.get(incentivePlan.Division__c) != null ? divisionIncentivePlansMap.get(incentivePlan.Division__c) : new List<Incentive_Plan__c>());
            plans.add(incentivePlan);
            divisionIncentivePlansMap.put(incentivePlan.Division__c,plans);
        }

        return divisionIncentivePlansMap;
    }

    /**
    * @description This method is used provide a map of incentive products by product
    **/
    private static Map<Id,List<Incentive_Product__c>> getIncentiveProductsByProduct(set<Id> productIds){
        Map<Id,List<Incentive_Product__c>> productIncentiveProductsMap = new Map<Id,List<Incentive_Product__c>>();



        List<Incentive_Product__c> incentiveProductsList = [select Id, Intradivisional_Percentage__c, Interdivisional_Percentage__c, Division__c, Incentive_Plan__c, Product__c From Incentive_Product__c Where Product__c in :productIds];

        for(Incentive_Product__c incentiveProduct : incentiveProductsList){
            List<Incentive_Product__c> products = (productIncentiveProductsMap.get(incentiveProduct.Product__c) != null ? productIncentiveProductsMap.get(incentiveProduct.Product__c) : new List<Incentive_Product__c>());
            products.add(incentiveProduct);
            productIncentiveProductsMap.put(incentiveProduct.Product__c,products);
        }

        return productIncentiveProductsMap;
    }

}