Error Validating job numbers

Job numbers in MYOB are unique except they treat CAPITAL letters and lower case letters different.

BudgetLink uses MS Access to store jobs and it treats a letter the same regardless of its case.

If you receive an Error Validating job numbers, the following duplicate numbers were found... then the solution is to go into MYOB and locate the offending job number and change it slightly such as adding a - (dash) to the end of if and then run the get data again