|
Trucks, Deliveries (#601)
|
|
Why:
You need a listing of the deliveries made by each truck.
Focus:
Focus of Report is to show detailed deliveries for each truck, on a
load-by-load basis. Load attributes include date/time in and out of the
yard, destination, truck type (configuration) and weights (gross, tare, net).
- Report covers all loads delivered by each truck, including the weights and
volumes of the loads. No payment detail is reported.
- The report shows the average yard times, weights and volumes for loads delivered by
truck or date.
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.
- Note: for report information that is based on load tickets, the report uses the Date Out (not the Date In).
- Truck. You can select any or all of your Trucks. The second
column shows the truck description and owner's name in parentheses.
- The "Summary Data" option generates a summary version of the
report with only subtotals and totals.
- The "Only Print Raw Data" option generates a report with the
report detail, but with no subtotals or totals.
- Sort by: The report can be sorted first by date (See Example Report
1) and then by truck or first by truck and then by date (See Example Report
2).
Detailed Description:
The selection criteria determine the date range and trucks that appear in
the report. The report is based on your loadslip entries.
The report shows the loads delivered by each truck. There are subtotals
for each truck/date combination, a subtotal for each truck, and a total for all
loads from all trucks.
For each load, the columns are:
- Date: Date of the load
- Truck Code: Truck code (number) for the load
- Ticket: Load ticket number
- Time In: Entry time of the truck into the yard
- Time Out: Exit time of the truck out of the yard
- Truck No: Truck number
- Truck Type: Truck type (or configuration) code for the truck.
- Destination: Destination of the load
- Gross: Gross (full) truck weight
- Tare: Tare (empty) truck weight.
- Net: Net (Gross less Tare) truck weight
- Volume: Volume of the load. The unit of measure for the
volume is based on the unit of measure identified for the block
when it was setup.
Key Notes:
- The report treats 'split' loads as individual loads. The report does not use the load count field on the load slip.
- The report does not differentiate between header 'H' and detail 'D'
records
- No running of calculators is required
Report:
Example 1: Shows the report where the loads are sorted first by date, and then by truck for each date.
|
Example Report 1 |
|
|
 |
|
|
|
|
Example 2: Shows the report where the loads are sorted first by truck, and then by date for each truck.
|
Example Report 2 |
|
|
 |
|
|
|
|
Example 3: Shows the summary view of the report where only the subtotals for loads on a day-by-day basis are shown.
|
Example Report 3 |
|
|
 |
|
|
|
|
Example 4: Shows the summary view of the report where only the subtotals for loads on a truck-by-truck basis are shown.
|
Example Report 4 |
|
|
 |
|
|
|
|