Merging Territories

I am getting the following error when I try to merge 2 territories "Cannot proceed. There are records with missing territories. Please call support.".

I have checked all the tables that there are no missing territories but still the message appears.

Parents
  • 0

    Marcia

    You are going to have to check whether there are any records with a mismatched territory.

    select * from company where Comp_SecTerr in (select terr_territoryid from Territories);

    select * from company where Comp_SecTerr not in (select terr_territoryid from Territories);

Reply
  • 0

    Marcia

    You are going to have to check whether there are any records with a mismatched territory.

    select * from company where Comp_SecTerr in (select terr_territoryid from Territories);

    select * from company where Comp_SecTerr not in (select terr_territoryid from Territories);

Children
No Data