That trip was a turning point , but in the end the government of Botswana sealed the deal to make " The No. 1 Ladies ' Detective Agency " on location and not in a Johannesburg back lot , contributing $ 5 million to finance it .