Naming series reset issue

For clues and answers check these - inspect the database etc
Sales invoice naming series problem