Here is how I completed it. Make a custom scenario. Place a red archery range in the top corner, surrounded by petards. Then, place 6 berry bushes, surround them with villagers (I had 90 vils total), and put a mill beside each group. Then save it. Go to SP, set map style to custom scenario, and select your map. Choose Franks for the berry bonus, gather all the berries, then blow up the archer range to win. That should work for you, it worked for me yesterday. Other than that, I’m not sure what your problem is.
Keep in mind that yellow fruit Bushes are not the same as red berry bushes, so play on maps that includes the red berry bushes, the reason why it don’t count is, the fruit Bushes have a different ID in the game data