Daily Distribution Report

Daily Distribution Report

This is for Newsagencies Only
The Daily Distribution Report shows totals for titles that are on run lists, putaways and subagent orders.
This can be used to calculate quantities required to fulfill orders.

Generating the Report

From the main screen of Retailer, click on Reports at the top, then Newsagency and Daily Distribution Report.
The following options can be set for the report.

Report options:
  1. Date for the report - This is used to select the week that the report gathers information from.
  2. Exclude run list totals - Ticking this box will exclude quantities that are on run lists.
  3. Combine runlists by run type - This option will combine runs of the same type.
  4. Exclude (average) sales from report - Hides the sales line that shows average sold for the titles.
  5. Show subagents only - Report will only show titles that subagents have on order.

Subagent quantities to include:
  1. Standing orders - Will show quantities based on the subagents standing order (what they ordered).
  2. Delivered quantities - Will show quantities that were actually delivered.
  3. Nett total (Delivered quantities - Returns) - Will show quantities that were sold by the subagent.
  4. Include direct drop totals - Used to include or exclude orders that are set to direct drop
Titles to appear on reports:
You can select whether to report on all titles or specific titles in this section.
If you choose to select specific titles, click Selected Stock Items, and then click Add item at the bottom to add titles to the list.
Click on a title in the list and click Remove item, to remove from the list. Only items in the list will be reported on.

Reading the Report

The report will divide the different titles into separate columns (along the top).
It will then show the numbers grouped by the type of order - e.g. Home deliveries, Putaways, Subagent orders
A total for each type will be shown.
  1. Total Ordered - total number of this title ordered across the different order types.
  2. Sales / Average Sales - average number of this title sold on the selected day of the week.
  3. Total Required - The sum of the total ordered, and total sales to estimate how many will be needed to supply.
  4. Supply - The total of this title received (Invoice Arrival / Express Arrival).
  5. Variance - The difference between how much has been received in Supply, and how much is needed for Total Required.

Exporting the Report

You can export the report to either a PDF document or Excel spreadsheet by using the Preview button and following the below steps:

  1. PDF - Click on the red PDF button at the top of the report and choose your save destination.
  2. Excel spreadsheet - Click on the Print button at the top left. Tick 'Print to File' and select 'Xlsx Data File'. Click on the three dots button to choose your save destination. Click OK to save the file.