Advanced Retail (UK) Ltd
Company Wiki

There are occasions when movements won't have polled from NDS to HO but due to volumes, it might be that over 12k movements are affected.

If the following script is run at both HO and NDS this will export all GUIDs for a given date range:

SELECT guid FROM movements WHERE orig_whse_no = 1 and date_time between '?' and  '?'
AND tran_type IN (2,4,5,6)
UNION
SELECT guid FROM movements WHERE dest_whse_no = 1and date_time between '?' and  '?'
AND tran_type NOT IN (2,4,5,6)
ORDER BY 1

It is then just a case of running a compare in Notepad++. If this isn't installed, use the following installation and copy the unzipped compare plug in (and plugin manager if required) into the notepad++ plugin folder.

https://drive.google.com/file/d/1QkAf8N2d1XqkZ24mboiaHup3c9l2JQSc/view?usp=sharing https://drive.google.com/file/d/1bTV3UlGl6io1emNIcS2t-QFQBD4vDQup/view?usp=sharing https://drive.google.com/file/d/1lwWScGW0pAybo4EEApM8-jFIPbRr6gaa/view?usp=sharing

Once the missing movements have been identified they can be individually repolled from NDS.