Advanced Retail (UK) Ltd
Company Wiki

Certain Hot keys are dependant on the Branch_group and branch_group_type = 5 (minMaxrequest).

To add to the branch_group use (ticket #37948)

INSERT INTO [branch_group_det] ([branch_group_type],[date_time_updated],[date_time_created],[user_no_created],[user_no_updated],[branch_group],[branch_no],[deleted])VALUES(5,getdate(),getdate(),0,0,2,36,0) -- group

There have been issues (#30985) when the branch group changes or is deleted that the hot keys tableare not reflected by the change as they are not related. In this case use:

-- identify branch_group related hot keys
select * from pos_hotkey_hdr where target_value <> 0

-- delete each hotkey concerned
INSERT INTO dbo.table_deletes
  (table_name, pk_guid, pk_name)
VALUES
  ('pos_hotkey_hdr', 'CC70186A-CB0C-4467-B35A-5956A805C01A', 'guid')

INSERT INTO dbo.table_deletes
  (table_name, pk_guid, pk_name)
 VALUES
  ('pos_hotkey_hdr', '8EFC6D95-1E2C-4EE8-BEBD-9D6D2F705DA5', 'guid')

-- update the hotkey hdr to refresh the change 
update pos_hotkey_hdr set target_value = target_value where guid in (
  'CC70186A-CB0C-4467-B35A-5956A805C01A','8EFC6D95-1E2C-4EE8-BEBD-9D6D2F705DA5')

-- finally the terminal needs to be reloaded
nimbus_ApplicationCommands_ReloadConfig @terminal_id = ? or nimbus_ApplicationCommands_ReloadConfig_all