59.5.4.15 Missing Materials on Scheduled Orders

Report Description

The Missing Materials on Scheduled Orders report permits the generation of a document containing a list of all those order lines scheduled to go on-air on a specific period which either have still not been associated with an asset, have still not been scheduled, or its associated asset has still not been recorded.

Report Filters

All the parameters that permit a detailed report generation have been spread across seven different tabs to allow a more manageable configuration. By default, all filters are disabled (i.e., either blank or unselected); to enable them, it is enough to configure at least one parameter inside. Available filters include:

•Period: Indicate the period from which missing assets will be retrieved; it is possible to select:
Today, plus the next seven days
Next week
Custom dates

•Include...: Select at least one status that will be checked to generate the report; only those order lines meeting this criteria will be retrieved:
Include M - Retrieve all those order lines which have still not been associated with an asset
Include A - Retrieve all those order lines which have still not been scheduled
Include R - Retrieve all those order lines whose associated asset has still not been recorded
Include E - Retrieve all those order lines whose associated asset has expired

 •All assets whose code starts with: Retrieve all those order lines whose code starts with a specific string. For instance, use this filter to retrieve all order lines linked to an asset whose code starts with a "dummy asset" string (i.e. temporarily connected assets).

•Order by Indicate the field to be used as a sorting criterion; available fields are 'scheduled time', 'customer', 'agency' and 'account executive'.

Report Preview

The [Settings] permits configuring the page layout of the outgoing document; once filters and settings have been set, it will be possible to select between displaying a preview using the related [Preview] button or printing the document directly using the [Report] button.

Please note that some reports permit the export of the generated document in the most common formats (pdf, CSV, doc, xls, XML, etc) just by using the [Export] button.
Missing_Materials_on_Scheduled_Orders_previewjpg