Smartview External adding New Company
This is a known issue that is scheduled to be fixed in a future version. In the meantime, you can run the following script in your DYNAMICS database to fix it.
insert into SV10100
(USERID, CMPANYID, External_Access, Default_Company)
select C.* from
(select USERID, CMPANYID, 0 as External_Access, 0 as Default_Company from
(select USERID from SV10000) A cross join (select CMPANYID from SY01500) B) C
left join SV10100 on SV10100.USERID = C.USERID and SV10100.CMPANYID = C.CMPANYID
where SV10100.USERID is null
Thanks for the reply…after some sql tracing and the such, i had figured out that was the problem and manually updated that table.
If you would like to submit an answer or comment, please sign in to the eOne portal.