|
Revenue by Destination, Summary (#114)
|
|
Why:
You are
looking for a report that will show you revenues associated with load tickets
delivered to each of your destinations.
Focus:
Focus of Report is to provide a summary listing, by 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, Detailed that shows revenue detail by load.
Selection Window:
The selection window allows you to filter the report by:
- Date Range: You can either select a pay period, or you can simply enter the start and end date directly into the selection criteria window. The Period selection is merely a short-cut for entering a date range, so you can always edit the start 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. 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.
- 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
- Contract: The revenue contract for the loads
- Activity: Activity for which revenue was received
- Load Count: Count of loads delivered (based on the sum of the load
count field in the load ticket window)
- Net Weight: Net (Gross less Tare) load weight
- Volume: Volume of the loads in units as specified on the block
- Pay Weight: Pay units used for calculating revenue (Be aware that
this number will be misleading if you receive revenue from two different pay
bases to the same mill -- e.g., both MBF and Tons -- because this column
will be summing "apples & oranges" in that case.)
- Revenue: Revenue amount
Key Notes:
- The report only includes revenues from loads (not revenue from hourly
charge-outs)
- If you are configured to enter the revenue from your load tickets manually
(as are most users in the U.S.), the revenue must be entered before this
report will be meaningful. If you are configured to rely on the values
calculated by The Logger's Edge (as are most users in Canada), this report
will reflect the calculated revenue values, so the invoice calculators must
be run for this report to be meaningful.
Report:
Example:
This 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 loads are paid twice for two different
activities -- e.g. stump-to-truck and trucking -- two rows will be shown for
each destination/block combination.
Example Report