The Daily Detail RP Report is not designed to be a report that will work in all circumstances; however some users will find it preferable to the Standard RP Report. Each has its advantages and disadvantages. The Daily Detail report does not "mix" forecasted data with actual data in the same manner that the Standard RP report does, although the report can contain both. Regardless of how the time fences are defined the report will always show production and work orders, purchases, and requisitions. By leaving the time fence days blank or entering a large number such as 999, the report will only show sales orders as opposed to sales forecasts and component demand driven from production or work orders as opposed to demand driven from the master schedule. (Leaving the time fence days blank is actually like setting them to an infinite number)
If the time fence days are set to zero and zero, one would see forecasted sales and component demand driven from the master schedule. If the time fence days are set to, for instance 30, all sales and component data less than 30 days from today will be actual sales orders and production or work order demand. Transactions dated 30 days or more from today will show forecasted sales orders and component demand based on the master schedule. This is different than the Standard RP Report because if the time fence was set to 30 days and you were running it on a day by day basis, it would make a comparison and show the larger of the two numbers (actual sales vs. sales forecasts and master schedule component demand vs. production and work orders component demand) for activity 30 days out. The reason for the change is that the Standard RP Report logic works well when looking at information in terms of weeks or months but not days.
One generally wouldn't run a Standard RP Report on a daily basis and if one did so, it could be a bit fickle, showing large shortages one day and excesses the next. Note: If a Master Schedule has been set up, the Master Schedule Report should be used as opposed to the Daily Detail Report when it comes to finished goods or assemblies as the Daily Detail Report does not include master scheduled assemblies, only their components.