Advanced Retail (UK) Ltd
Company Wiki

Ali at Handcross sometimes raises a ticket indicating that that are transfers discrepancies that have been completed but have not been picked up by the job that creates the movements - probably due to it timing out. If this is the case please use the follow steps:

Select the Discrepancy from the traxs web page and note the queue_id from the URL when selected https://handcross.petfamily-branch.co.uk/DiscrepanciesV2/DiscrepanciesSearch.aspx

Use that here

SELECT * FROM [vw_TransferIn_DD_SessionWithAction] WHERE queue_id = ?

From that you can re-run the adjustments for any outstanding lines by getting the session_no value and running

EXEC traxs_TransferIn_DD_Adjustments_Create @session_no = ?

Please note that this should only but done on those Transfer Discrepancies that have been completed!

See as an example - https://advancedretail.freshdesk.com/a/tickets/156547