The Excess/Under Calculation Tab is used to calcualte the excess and under mileage splits within the Excess and Under Due routines in Fleet System Management.
To access the Terminations System Parameters Excess/Under Calculation Tab:
From the Master Menu, select the Terminations option and Company required.
The Terminations Menu is displayed.
Select the System Maintenance option.
The System Maintenance Menu is displayed.
Select the System Parameters option
Select the Excess/Under Calculation Tab
The System Parameters Excess/Under Calculation Tab is displayed.
The following fields are displayed:
Excess/Under Basis: Use the 
to select one of the current available options which are as follows:
Rental: Any termination charges that are types 3 or 4, split XSM charge by rental ratio per profi record (i.e. System totals in the ratio of Finance/Maint/Ins rental split). Charge Types:- 1 ET Charge, 2 ET Charge non VAT, 3 Excess mile, 4 Under distance, 5 Other Charges, 6 Extra Days, 7 Pooled Excess, 8 Pooled Under. Source codes used in the rental split are as follows: E,G,J,N,H,x,K,k,O,Q,j, or n
Product: Charge types 3 & 4 are split per FM Product. The Split ratio is used by the first Vat assumption, with the balance used by the second VAT assumption.
Excess miles pro-rate: This parameter is used in conjunction with the Excess/under calculation options in the Excess/Under Menu.
Excess/Under Basis: A checkbox which, if unticked, denotes that system will calculate the estimated distance based on: Total Actual miles – Start odometer. (If Actual miles data is not available the system estimates as if the parameter was set to Yes). If ticked then the system calculates the estimated distance based on the average actual mileage to date : (Miles to date / Days to date ) * ( next XS date – Start date).
Use Annual Excess Method: A checkbox which, if ticked, denotes that the excess mileage calculations are done annually, using the Raise Excess charges option on the Excess/Under Calculations Menu. All of the following parameters are activated when this flag is ticked.
Last odo cut-off (weeks): Exclude vehicles with last odo reading before this date i.e. today – weeks.
Exc advance period: Advances the next invoice date by this value.
Pooled max credit (Scania Specific): Percentage of annual mileage to use as a maximum credit i.e. only for Under mileage calcs.
Excess/under credit value (Scania Specific): If ticked the system uses this percentage of Excess(1) as the under value. If unticked then the system uses the Normal method of calculation and incorporates the Excess miles prorate parameter (the Normal method being : Actual miles to date - Contractual miles to date).
Excess CR: NL Credit expense code for annual excess method.
Excess DR: NL Debit expense code for annual excess method.
Under CR: NL Credit expense code for annual excess method.
Under DR: NL Debit expense code for annual excess method.
Note: For pooled vehicles the next invoice date is based on the Next Pooled date not the Next excess date. The Annual method does not incorporate the Excess miles prorate parameter. Annual contractual miles is used regardless of the number of weeks in the system parameter and only works effectively if the number of weeks field is set to 52. This can be illustrated with an example: Excess/under miles = ANNUAL COnTRAct miles – (todate actual – last to date actual).
Use variable free excess: This option is only used with the XSDUE routine. If ticked the system applies the percentage adjustment (per Variable free excess) to the Annual contractual mileage, to calculate the FREE excess miles.
Variable free excess: The percentage used to calculate the FREE miles. If the excess exceeds the FREE miles allowance then all of the excess miles are chargeable. e.g. Contractual Annual miles = 12000. Free excess = 10%. Allowance = 1200. If actual excess = 1199, then pay nothing. If actual excess = 1201, then pay for 1201 miles.
Note: The Excess Distance Charges routine can be found in the Contract Administration Invoicing Procedures menu. Vehicles are only included in this routine if the Include in XS/Under parameter is ticked on the FM Lease type record. The calculation method for the Excess Distance Charges uses the following calc method: Excess/under miles = ANNUAL contract miles – (todate actual – last to date actual). It is not influenced by the Prorata Excess/under miles = ANNUAL Contract miles – (todate actual – last to date actual).
Force Excess Review: This works exclusively with the Excess Distance Charges routine. If ticked then both the Review Mileage and Review Value fields are activated. Any vehicles on the list, produced by the Excess Distance Charges routine are highlighted (but not omitted from process) if the value or mileage (whichever is populated) exceeds the system parameter values.
Review Value: Any vehicles on the list produced by the Excess Distance Charges routine are highlighted (but not omitted from process) if the value exceeds this value.
Review Mileage: Any vehicles on the list produced by the Excess Distance Charges routine are highlighted (but not omitted from process) if the mileage exceeds this value.
Only show chargeable values: A checkbox which, if ticked, denotes that the system will only show chargeable items i.e. preclude FREE XS records or vehicles with zero XS calcultion. If unticked, then all items are displayed.
Prorata assessment tolerance:
