|
Deliveries by Destination (#116)
|
|
Why:
You are looking for a report that will provide total load counts and volumes
delivered to each mill from each block. You may want to see only
summary data, or you may want to see load-by-load detail.
Focus:
Focus of Report is to show detailed deliveries from each block to each
destination, on a load-by-load basis (or on a summarized basis). The
report shows weights and volumes, but no payment detail.
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.
- Block. You can select any or all of your Blocks
- Destination. You can select any or all of your Destinations
- 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 Block and then
Destination (the default, see Example Report 1), or by Destination first and
then Block ( see Example Report 3)
Detailed Description:
The selection criteria determine the date range and blocks and destinations that appear in
the report. The report is based on your loadslip entries.
The report shows the loads delivered from each block, grouped by the
destination of the load. There are subtotals for each block/destination
combination, a subtotal for each block, and a total for all loads from all
blocks.
For each load, the columns are:
- Block: Source block of the load
- Destination: Destination of the load
- Date: Date of 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)
- Load Attribute columns: Columns for load attributes, such as
Species, Sort, Process, Stratum, etc. (based on C_PART_4 and 5)
- Gross: Gross (full) truck weight
- Tare: Tare (empty) truck weight.
- Net: Net (Gross less Tare) truck weight
- Volume: Volume of the load (from the volume field on the load slip). The unit of measure for the
volume is based on the production reporting unit of measure identified for the source block
when it was setup.
Key Notes:
Key Notes:
- Because the report has no payment data, it can be run prior to running
the calculators.
- The report picks up loads whose Date_Out is within the date range
selected.
- The load counts show the sum of the load count field on the load ticket
for the loads displayed in the report.
Report:
Example One - Detailed View Sorted by Block/Destination:
Example Report 1
Example Two - Summary View Sorted by Block/Destination:
Example Report 2
Example Three - Detailed View Sorted by Destination, then Block:
Example Report 3
