Welcome! This forum has a treasure trove of great info – Scouters helping Scouters! Just a heads up, though - all content, information, and opinions shared on this forum are those of the author, not the BSA.
If something is marked Complete in Scoutbook (green checkmark), it will appear in the Needs Approval report. When a leader Approved the requirement/rank/award, the box turns blue, and it disappears from the Needs Approval report. Once all requirements for a rank or award are marked Complete, and Leader Approved, the award will appear in the Needs Purchasing and Needs Awarding reports. Once it is added to a Purchase Order, it will disappear from the Needs Purchasing report. Once it’s marked Awarded, the check box turns yellow and it disappears from the Needs Awarding report.
As far as not duplicating entries in the logs, that has to be managed through policy, rather than through the software itself. There is not a way to ensure that the same event isn’t entered with two different names in the logs at this time.