Load Summary Report

The Load Summary report is automatically generated each time EFI transactions are loaded (FFEL). The Load Summary report is an "exception report"; it prints information for the transactions that were not loaded or transactions that need attention. Transactions that were loaded without any problems are not printed on this report. A summary is included at the end of the Load Summary report. This report should be printed or saved and kept on file until all transactions have been processed and verified for accuracy.
At the bottom of the Load Summary report, the totals show how many transactions were processed and loaded, how many transactions were rejected, and how many of the loaded transactions have special messages that warrant attention. The Pump Summary is also included to provide a quick summary of the fuel cost and quantity dispensed from the pumps. Be sure to compare the computed totals against actual totals (from fuel logs, reports from fueling system, etc.) to validate the loaded data prior to processing the fuel transactions.
The report columns are as follows:

Column Descriptions

Date- Fueling date
Time- Fueling time
Site- Fuel site/fuel island number
Trn# Transaction number
Typ- Transaction type
Crd-1- Driver card number
Crd-2- Vehicle fuel card number
Vehicle # Vehicle number
Pump- Pump number
Prd- Product code
Quantity- Fuel quantity
Price- Fuel price
Odom- Vehicle meter reading
Department # Department number
RVTransaction status; Not applicable for this report
Message-Special messages regarding the transaction

Summary Info/Descriptions

Records: Processed- Total number of fuel transactions in the specified date and time range
Records: Rejected- Number of fuel transactions not loaded
Records: Spcl Msgs- Number of transactions with special messages
Totals: Trans-Added- Total number of fuel transactions loaded
Totals: Quantity- Total fuel quantity loaded
Totals: Total-Cost- Total fuel cost loaded

Pump Summary Info/Descriptions

*An "N" in this column indicates the pump is not on file
Pump- Pump facility and number
Product- Product code and fuel type
Site- Fuel site number where the pump is located
Accm-Trn- Total number of fuel transactions loaded for the pump
Accm-Qty- Total fuel quantity loaded for the pump
Accm-Cost- Total fuel cost loaded for the pump. "***" is printed next to the total fuel cost to flag a potential problem (e.g. fuel price not found)

Special Load Messages

Refer to the following table for the special messages that may be printed on the Load Summary report. It is very important to look over the messages that are printed on the Load Summary report, and take any necessary action in order to avoid potential problems.

Message

Meaning

Actions needed

No F-xref crd

Vehicle EFI fuel cross-reference number not on file

  • Validate vehicle number in fuel data file
  • Validate load facility
  • Review Cross-reference setting in EFI Load Settings (FFEM)
  • Run the EFI fuel cross-reference utility (STVX)

No U-xref crd

Vehicle unit cross-reference number not on file

  • Validate vehicle number in fuel data file
  • Validate load facility
  • Review Cross-reference setting in EFI Load Settings (FFEM)
  • Run the unit cross-reference utility (STVU)

Tnk not found

Pump record found but the attached tank record is not on file

  • Validate tank number in fuel data file
  • Review tank records (MUTM)

Pmp not found

Pump record not on file

  • Validate pump number in fuel data file
  • Review pump records (MUPM)

Fty not found

Fuel type specified in product code not on file

  • Validate fuel type in fuel data file
  • Review product code records (FFEM)
  • Review fuel type records (MUF)

Stg not found

Product storage variable missing in fuel type record

  • Validate fuel type in fuel data file
  • Review fuel type records (MUF)

Pc not found

Product code not on file

  • Validate fuel type in fuel data file
  • Review product code records (FFEM)

Fuel Transfer

Transaction processed as a tank transfer

  • No action needed

Reject Tran

Transaction dropped

  • Refer to additional messages listed with the transaction to determine why the transaction was dropped.

Trans on file

Transaction has already been loaded

  • If you are trying to reload a corrected transaction, delete the existing record first (FFEE, SGFE).