The Product Book Reconciliation Report lists by location and tank number the total fuel receipts, in/out transfers and any adjustments done to equal the current balance.
In the Report Prompts area enter the From and To Periods. In
the filters area enable any fields you would like to use for filtering
the data to be included on the report. Note that selecting a field for
a filter does not cause that field to appear on the report. It becomes
a search filter only to qualify which records are included. The fields
that appear on the report are shown below. To save your parameters for
repeated use enter a Parameter File Name under the report title and click
on Save Parameters.
Click on Schedule to run your report. Select your Run Interval and any associated Dates and Times. Next define your Output Destination options, save them if desired and click on Schedule. A Report Schedule Confirmation screen will appear with the Job Number Id and other output information. Proceed to the Report Bin to retrieve and view the report when it's completed.
Database Tables |
Data Fields/Columns |
Grouping/Sorting |
|
|
|
Calendar Days |
Location |
Group 1 |
| Company_Main | Tank No |
Defaults to Location |
F_Prod_Loc |
Product No |
Group 2 |
F_Prod_Transact_V |
Product Type | Defaults to Tank Number |
F_Tank_Hist |
Fiscal Period | Sort By |
Fiscal_Cal |
Effective Date | Defaults to Fiscal period |
Loc_Gen |
Fuel Receipts/Transfers In | |
Prod_Gen |
Transfers Out | |
|
Adjustments | |
|
Unit/Indirect Issues | |
|
Balance | |
|
Cumulative Balance |
For more information refer to the Anatomy of an M5 Report and the FleetFocus M5 Reports Guide.
NOTE: To view a list of System Flags and Role Privileges that may impact this screen, hover over the screen title in M5 to display the bubble help/tooltip. At the bottom of the bubble help/tool tip, there is a Settings hyperlink. Click that hyperlink to display the list of flags and privileges.
Additional training and technical documents on this subject may be available in the Resource Files area.