Advanced Retail (UK) Ltd
Company Wiki

There was a bug which meant that Transfer Request Responses were not getting removed confusing the staff into resubmitting them. The fix is simply to change the status to '2'

Example tickets:

https://advancedretail.freshdesk.com/a/tickets/136963

select whse_no, * from vw_branchwarehouse where branch_name like '%?%'

select * from transfer_request_response_hdr where sending_whse_no = ? and status = 1

update transfer_request_response_hdr set status = 2 where guid in ('?')