Hi Steve,
There has to be sufficient demand for the item to have it appear on the report. Here are some facts about the report.
1. The demand quantity is built from the item2hist ptdqtysls?? by summing the history records together.
2. It then determines the Dailyavgdemand (the average daily demand based on the ptdqtysls?? in the itemhist.
3. It also looks at the PO lead time
4. If the available is sufficient enough to cover the lead time, then reorder quantity is not populated and the item is left off of the report as the supply is sufficient as of now based on the average demand.
You could test this by setting a high value into the ptdqtysls10 for this item / site in the item2hist using query. Then rerun the report. You can see the Dailyavgdemand value in the PO04740_wrk while the report is running.
Try putting a value in the ptdqtysls10, run the report and look at the work table value. Close the report and update the ptdqtysls10 to maybe half that amount, rerun the report and look at the value. You should see the dailyavgdemand values changing between the two reports.
Also let me know if you have anything populated on the Options tab of the report.
Let me know what you find.