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.
• Activities:  You can select any or all of your pay activities. 

The report will shows all scaled volume entries, all advance entries, all revenue accruals (based on actual deliveries), and all advance repayments associated with a given block.

The report shows the following columns:

• Transaction Date:  Draws from the "Date Advanced" field or the "Date Repaid" for entries made in the Customer Advances window.  Draws on the ending date of the pay period for the accrued revenue line items.

• Type:  Indicates the type of transaction represented by the particular row of the report.  There are four types of transactions:  SCALE (indicates row entries from the Customer Advances grid where the "Amount" has been left at zero); ADV (indicates row entries from the Customer Advances grid where the "Amount" has a positive value); REPAY (indicates rows from the Customer Advance Repayments Grid); and HAUL (indicates rows from the invoice details table associated wit this block.  There will be one HAUL row for each distinct specie/phase/pay period ending combination where invoice revenue has been calculated for this block). 

• Block:  Indicates the Block associated with the advance activity

• Species:  Indicates the Species (C_PART_5) from the Advance, Repayment, or Invoice Details entries (not shown in the example below)

• Customer:  Customer who issued the advance or repayment.  In the case of a HAUL transaction type, it is the Customer associated with the accrued revenue. (not shown in the example below) 

• Activity:  Pay activity specified on the advance or advance repayment or accrued revenue records.

• Advances Received:  Draws from the "Amount" column entered in the Advances window.  (This column will be blank for REPAY, SCALE, or HAUL transactions).

• Advances Repaid:  Amounts repaid on the advance from the Repayments window.  (This column will be zero for SCALE, ADV, and HAUL transactions.)

• Amount Outstanding:  Balance on the Advances

• Accrued Revenue:  Pulls all revenue owing (from the Invoice Details table) for the activity/species/pay period ending date associated with the particular HAUL transaction represented by the row.

• Scaled Volume:  Pulls from the "Scaled Volume" column entry in the Customer Advances window.  It will be 0 for any transaction type except SCALE transactions.

• Advance Volume:  Volume entered in the Customer Advances windows for ADV transactions.

• Recovery Volume:  Pulls from the Delivered Volume column in the Advance Repayment window.

• Delivered Volume:  Sum of the volume field on the loads associated with the HAUL transactions

• Pay Rate:  Pay Rate used to calculate the accrued revenue for HAUL transactions.  For HAUL transactions, it is a calculated value (Accrued revenue / Delivered Volume).  For ADV transactions, it pulls from the Pay Rate column in the Customer Advances window.

• Conversion (Wt / Vol):  Conversion from Weight / Volume based on the loads underlying the HAUL transactions.

• The invoice calculators must be run in order for the report to show the HAUL transactions

• See the documentation provided here under the Special Features section of our website for more information.

• The date range selection determines the date range for the issuance of advances and the haul transactions (and, of course, the scale entries).  The repayments are all repayments (regardless of date) for the advances that fall within the selected date range.

   

Example Report