|
Report: Revenue by Destination, Detailed
|
|
Focus:
Focus of Report is to provide a detailed listing, by load and activity, of
the revenue you have received by destination mill. The report also shows
subtotals by block. This report is a companion report to the report Blocks,
Revenue by Destination, Summary that summarizes revenue by destination and
block.
- Includes all loads
- The system can be configured one of two ways: (1) Load revenue is
calculated when the invoice calculator is run; and (2) Load revenue is
entered manually as settlements are received. In case (1), the
invoices calculator must first be run for this report to be
meaningful. In case (2), you must manually enter your load revenue in
order for this report to be meaningful.
Selection Window:
The selection window allows you to filter the report by:
- Date/Time. You can directly ender a date/time range for the start
and end dates for your report. If you leave the end time blank, the
program will assume you want the entire day for the end date. In the
example below, the start date/time is 8/1/2004 00:00:00 (a blank is assumed
to be time 00:00:00) and the end date/time is 8/15/2004 00:00:00.
Because the end date time is blank (or 00:00:00), the program assumes you
want the whole day of the 15th and makes the end date/time 8/16/2004
00:00:00. In the selection query, the program returns records
whose start date/time is greater than OR equal to the start/date time and strictly
less than the end date/time. You do not need to select a period
-- this selection is merely used to facilitate the entry of the state and
end dates. If you select a period, you can always edit the state and
end dates to be any date you choose. For example, you can pick a
period defined as 8/1/2004 to 8/12/2004, and then extend the end date by
three days to 8/15/2004.
- Destination: You can select any or all of your destinations.
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
Detailed Description:
The report shows payments due for each load on an activity-by-activity basis. The
columns are:
- Destination: The destination of the load
- Block Code: Source Block of the load
- Date: Date of the load
- Ticket: Load ticket number
- Contract: The revenue contract for the load
- Activity: Activity for which revenue was received
- Net Weight: Net (Gross less Tare) load weight
- Pay Weight: Pay units used for calculating revenue
- Rate: Pay Rate used for calculating revenue
- Revenue: Revenue amount
Report:
Example One:
Example Report 1 shows the report. The report groups loads by
destination and then by block, providing a subtotal for each block and a
total for each destination. There is also a grand total for all
destinations. Note that when a load is paid twice for two different
activities -- e.g. stump-to-truck and trucking -- two rows will be shown for
each load.
Example Report 1
Example Two:
Key Notes:
