| Description |
* Issue
** Odometer inconsistencies
* Requirements
** On Invoice Primary Grouping
*** #1 When no starting odometer prior incorrect Odometer readings are carrying forward into the total miles field of the next grouping
*** #2 - Add "Avg. MPG" before Tran # in Footer Totals
**** Calculation = Total Miles / Qty of Products set to yes for include in MPG
*** #3 Starting Odometer is wrong for Single Cards when Primary Sort = Vehicle
**** These transactions would not have a vehicle # assigned
**** When Primary Sort = Vehicle and Vehicle is Null (Single Card) then we should be finding the last odometer for the same Card #
* Steps
** Generate Invoice Report for Customer using CF Item with and without MPG Calculation
** Verify MPG and Odometer Calculations
Notes:
Vehicle ODOM not calculating correctly on on vehicles. unless secondary sort = none
Even then some vehicles in invoice all have the same total Miles, when no starting ODOM
Possible if starting ODOM is blank use First trans as starting ODOM?
If starting ODOM and total miles can be calculated also calculate average miles for vehicle See attached reports for sample of where/how to place average.
!pastedImage_d128695_0.png|height=111,width=674!
|