Thanks for the update on this and thank you for clarifying what you already tried on your end. We are grateful for your effort in finding a solution to your concern
As of now, this is the only option we have where we can find transaction history for a particular Item Number in the Sales Reports. I would suggest posting these functions that you would like to see implemented into the system on our MYOB Business/Essentials Idea Exchange board for consideration. Rest assured that the developer's team is monitoring all the feedback and suggestions received from the users. Your feedback will be added to the product roadmap based on feature requests.