ZenDesk Reference #:5184775

Description: The Supplier Maintenance Team has reached out to us as they have a supplier that is able to login to our supplier site services.bgrs.ca however they are stating that the supplier is not being prompted for their renewal acknowledgement for the new term December 2022 to November 2023.

Troubleshooting:

-- search for supplier using email addresss. Here we see cont_status of I - Inactive
select * from contact where cont_email='mary.stallwood@kw.com'

-- search status of contact using cont_uid. Here we see code_type C221. This code is for when supplier was disabled
select * from cont_code where cont_uid='49685'

--search supplier using cont_uid. Here we can grab the ID which will be used in the next table as the ID # is unique for each supplier
select * from BGRS_SupplierUsers where cont_uid='49685'

-- search table using the ID 4821 as SupplierUserID. Here we see that is "IsReactivationRequired" & "IsRenwalRequiredd" set to 0 which equals to no
select * from BGRS_SupplierUsersContact where SupplierUserId='4821'

Solution:

Since the Supplier has a "Cont_Status" equal to inactive of course the supplier will not be prompted to renew their association to the BGRS TPSP Supplier Network.

To reactive the user and enable the renewal prompt we need to set "IsReactivationRequired" & "IsRenwalRequiredd" set to 1 which equals to yes.

use servicengine
begin tran
update BGRS_SupplierUsersContact set IsReactivationRequired='1', IsRenewalRequired='1'
-- select * from BGRS_SupplierUsersContact
where id='4865' and SupplierUserId='4821'
IF @@ERROR <> 0 or @@rowcount <> 1
BEGIN
ROLLBACK TRAN
RETURN
END
Commit tran

Once the script is applied advise the BGRS Supplier team to advise the Supplier that they will need to login to services.bgrs.ca twice.  Once to reactivate their account on the TPSP Supplier Network.  Log out and log back in and at this point the supplier will be prompted to acknowledge the renewal for the current term Nov 2022 to Dec 2033