...

• Check the Path and file field in the load module (FFEM).
• Verify the fuel data file is in the specified location.
• Check the spelling of the fuel data filename.

Anchor
_Toc13032510 _Toc13032510

Anchor
_Toc125892560 _Toc125892560

Anchor
_Toc487792353 _Toc487792353

Reviewing the Load Summary Report

During the load process, the data transaction file will be read and fuel data in the specified date and time range will be loaded. A Load Summary report is provided afterwards—RTA recommends printing or saving this and keeping it on file. The Load Summary report will print a list of exceptions or transactions that were not loaded. Properly loaded transactions are not printed on the Load Summary report. A summary is printed at the end of the Load Summary report showing the number of records processed, records loaded, records rejected, records with special messages, total fuel quantity loaded, and total fuel cost.
Transactions will be loaded, but may require attention or adjustments if:

• Fuel or unit cross-references not found
• Tank not found
• Pump not found
• Fuel type not found
• Product code not found
• Product storage not found

Correct the data loaded (see "Editing Loaded Fuel Transactions") or delete and reload transactions as needed after reviewing the Load Summary report
Transactions will be rejected if:

...

Correct the data in the fuel file and reload transactions as needed after reviewing the Load Summary report. Refer to "Special Load Messages" in Chapter 3 for more information.

Anchor
_Toc13032511 _Toc13032511

Anchor
_Toc125892561 _Toc125892561

Anchor
_Toc487792354 _Toc487792354

Editing Loaded Fuel Transactions

After loading fuel transactions, the next step is to review the transactions and make changes as needed. It is important to not skip this step because the load process does not validate incoming data such as vehicle numbers, pump numbers, meter readings, product codes, fuel quantities, or fuel prices.

...

The fueling date, time, site number, transaction number, card numbers, vehicle number, pump number, fuel quantity, fuel price per gallon, and transaction statuses are displayed in the immediate EFI Transaction window. Review the data displayed to make sure the loaded data is accurate. To edit or view additional information for a particular transaction, double-click the desired record.
This window contains all the information displayed in the previous window. It also contains additional information such as the meter reading, department number, product code, product storage, alternate odometer type, alternate odometer reading, state abbreviation, and state mileage. To view additional information for this transaction, choose Info. To modify the transaction, edit the information as needed and then choose Update. To exit this record without saving any changes, choose Cancel. To delete this transaction, choose Delete and then choose Yes to confirm the deletion.
TIP: If you need to edit vehicle numbers, use the date sort instead of the vehicle sort.

Anchor
_Toc13032512 _Toc13032512

Anchor
_Toc125892562 _Toc125892562

Anchor
_Toc487792355 _Toc487792355

Reloading the Data

It may be necessary to reload some or all of the fuel data. We recommend reloading the data only if many transactions did not get loaded or if the data did not get loaded properly the first time. If most of the transactions were loaded correctly and only a few transactions were not loaded, it is better to enter those transactions manually using the Quick Fuel Entry option (FFQ or 212). To reload the data, select the Load Trans option (FFEL) and then specify the starting and ending dates. Transactions that were previously loaded will not be loaded again, even if that data is not correct. If all of the fuel data was loaded improperly the first time (e.g. the prices did not come across with the correct value), delete the bad data before reloading; refer to "Deleting EFI Transactions" in Chapter 3 for more information. Be sure to review the Load Summary report again afterwards.