Georgia Timber Tax

You need a tabulation of the stumpage paid by tract. This report is similar to Report #319 (Georgia Timber Tax), but provides a tabulation by tract instead of by county.

Focus:

Focus of Report is to summarize stumpage payments (paid on a per unit basis, not on a lump sum basis) for each tract, by landowner for a given date range.

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).
Tract. You can select one or multiple tracts at a time to run this report. If you select multiple tracts, the report will provide one panel of information per tract.

Detailed Description:

The report shows stumpage payments made to each landowner on a given tract for the Pay Activity "Stumpage." The reports includes only payments associated with load tickets (not miscellaneous, hourly, or other payments.)

The report determines which load tickets are associated with a given tract based on the tracts selected.

The columns are:

Tract: Shows the Tract associated with the stumpage payments. The county for the tract is shown in parentheses beneath the tract name.
Owner: The owner to which the stumpage is paid.
Product: This column shows the distinct products for which stumpage payments were made in each county (and to each landowner). (Note that Product relates to C_PART_5 in the database tables.) The numeric values in this column are the volumes in the load ticket volume field associated with each product within that county/landowner. (Note that the unit of measure will be in whatever base is selected in the Tract Setup wizard as the Volume Measure. For most users in GA, this measure will be in tons, so the report label is hard-coded to tons.)
Species: There will be one column for each distinct specie for which stumpage payments were made. (Note that Species relates to C_PART_4 in the database tables.) Again, the numeric values are the volumes in the load ticket associated with each specie.
Total: This column shows the total volumes and $ across all species for that tract and landowner.

The report has totals by tract, as well as a grand total across all selected tracts.

Key Notes

The report includes only stumpage payments that are issued on a load-by-load basis. It does not include payments made on a lump sum basis.
The report is hard-coded to pick up payments where the pay activity code is "STUMPAGE." No other abbreviations/codes will work.
The report draws from data stored in the Vendor Statement Details table. Thus, the calculators must be up to date before you run this report.
The report makes no distinction between header and detail tickets.
The tons that are reported are adjusted 'net' tons -- meaning tons after deduction of for cull (if cull is deducted).

Loads, Georgia Timber Tax, by Tract (#320)

Why:

Focus:

Selection Window:

Detailed Description:

Key Notes

Report:

Example:

	Example Report