Add Location ID to Existing Selector (LotSerialNbr) in Sales Order Line Detail

The selector is working but when I try to prepare the invoice I get an error like this

An error occurred during processing of the field Lot/Serial Nbr. value 1000001002 Error: Lot/Serial Nbr. '1000001002' cannot be found in the system.

but my selector works fine

this is my code any help would be much appreciated:

using System;
using System.Collections;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
using System.Text;
using PX.Common;
using PX.Data;
using PX.Objects.AP;
using PX.Objects.AR;
using PX.Objects.CA;
using PX.Objects.CM;
using PX.Objects.CR;
using PX.Objects.CS;
using PX.Objects.DR;
using PX.Objects.EP;
using PX.Objects.GL;
using PX.Objects.IN;
using PX.Objects.PM;
using PX.Objects.PO;
using PX.Objects.TX;
using POLine = PX.Objects.PO.POLine;
using POOrder = PX.Objects.PO.POOrder;
using PX.CarrierService;
using PX.Concurrency;
using CRLocation = PX.Objects.CR.Standalone.Location;
using PX.Objects.AR.CCPaymentProcessing;
using PX.Objects.AR.CCPaymentProcessing.Common;
using PX.Objects.AR.CCPaymentProcessing.Helpers;
using PX.Objects.AR.CCPaymentProcessing.Interfaces;
using ARRegisterAlias = PX.Objects.AR.Standalone.ARRegisterAlias;
using PX.Objects.AR.MigrationMode;
using PX.Objects.Common;
using PX.Objects.Common.Discount;
using PX.Objects.Common.Extensions;
using PX.Objects.IN.Overrides.INDocumentRelease;
using PX.CS.Contracts.Interfaces;
using Message = PX.CarrierService.Message;
using PX.TaxProvider;
using PX.Data.DependencyInjection;
using PX.Data.WorkflowAPI;
using PX.LicensePolicy;
using PX.Objects.Extensions.PaymentTransaction;
using PX.Objects.SO.GraphExtensions.CarrierRates;
using PX.Objects.SO.GraphExtensions.SOOrderEntryExt;
using PX.Objects.SO.Attributes;
using PX.Objects.Common.Attributes;
using PX.Objects.Common.Bql;
using OrderActions = PX.Objects.SO.SOOrderEntryActionsAttribute;
using PX.Objects.SO.DAC.Projections;
using PX.Data.BQL.Fluent;
using PX.Data.Localization;
using PX.Data.Reports;
using PX.Objects.IN.DAC.Accumulators;
using PX.Data.BQL;
using PX.Objects.SO.Standalone;
using PX.Objects;
using PX.Objects.SO;

namespace PX.Objects.SO
{
  public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
  {
    #region Event Handlers
     [PXMergeAttributes(Method = MergeMethod.Append)]
        [PXCustomizeSelectorColumns(
            typeof(INLotSerialStatus.lotSerialNbr),
            typeof(INLotSerialStatus.siteID),
            typeof(INLotSerialStatus.locationID),
            typeof(INLotSerialStatus.qtyOnHand),
            typeof(INLotSerialStatus.qtyAvail),
            typeof(INLotSerialStatus.expireDate))]
         [PXSelector(typeof(Search2<INLotSerialStatus.lotSerialNbr,
                    InnerJoin<INLocation, On<INLotSerialStatus.locationID, Equal<INLocation.locationID>>,
                    InnerJoin<INSiteLotSerial, On<INLotSerialStatus.inventoryID, Equal<INSiteLotSerial.inventoryID>,
                        And<INLotSerialStatus.siteID, Equal<INSiteLotSerial.siteID>,
                        And<INLotSerialStatus.lotSerialNbr, Equal<INSiteLotSerial.lotSerialNbr>>>>>>,
                    Where<INLotSerialStatus.inventoryID, Equal<Current<SOLineSplit.inventoryID>>,
                        And<INLotSerialStatus.siteID, Equal<Current<SOLineSplit.siteID>>,
                        And<INLotSerialStatus.qtyOnHand, Greater<decimal0>>>>,
                    OrderBy<Asc<INLotSerialStatus.locationID, Asc<INLotSerialStatus.lotSerialNbr>>>>),
                    typeof(INLotSerialStatus.lotSerialNbr),
                    typeof(INLotSerialStatus.siteID),
                    typeof(INLotSerialStatus.locationID),
                    typeof(INLotSerialStatus.qtyOnHand),
                    typeof(INLotSerialStatus.qtyAvail),
                    typeof(INLotSerialStatus.expireDate))]
        protected virtual void SOLineSplit_LotSerialNbr_CacheAttached(PXCache sender)
        {
            // No implementation needed, just attach the attributes.
        }

    #endregion
  }
}