Product Commercial Issue Journal

 

The Product Commercial Issue Journal is a listing by vendor and entry date showing the issue date, the unit or account, the employee ID, vendor location, the quantity issued and cost details.  The meter readings are also shown including a flag if the reading was in error.

 

In the Report Prompts area select the Group and Sort By options if desired. 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

 

 

 

Emp_Main

Entry Date

Group 1

F_Comm_Prod_Chg

Issue Date

    User Selection

Loc_Gen

Unit/Account

Group 2

Prod_Gen

Emp ID

    User Selection

Vendor

Vendor-Location

Sort By

Udc_Main

Prod No

    User Selection
 

Issue Qty

 
 

Unit Price

 

 

Total Cost w/Markup

 

 

Meter1

 

 

Meter2

 

 

Meter Flags

 

 

User ID  

 

For more information see Anatomy of an M5 Report and the FleetFocus M5 Fuel 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.