I try to modify based on your summary report. This final combination would be easy for everyone to understand, clearly and simple. The criteria is focus only item which is over 20 days since the order was placed to ADC. The report will reflect the comparison the current month versus last month which you can select by item or amount. If you want to analyze the detail of those outstanding items, you can narrow down by store by the right side table which provides the detail of each parts including the salesman so you can capture this report sending to respective person. No need to be worry anything, you are the media to report their performance. Do take the blames or bad mood from anyone to yourself. Please use this report to work, you can just update the database of this month and last month sheet in next time. The report will automatically catch up the number themselves.
Please feel free to come over to me if you have any questions.