Export Batch Details

The FRV process enables the calculation and editing of the final residual value of a vehicle at any time during an agreement's lifecycle

New FRV values are required to be calculated automatically by the system using CAP data as a basis.

The remaining Depreciation would then be spread over the rest of the contract, using the following calculation:

Remaining Monthly Depn = Current NBV (Net Book Value) - New FRV / Remaining periods.

A new Final Residual Value (FRV) is may be recalculated at the following stages of an agreement:

1. At Quotation stage
2. At Contract Start
3. AT AN (ANNUAL) FRV REVIEW
4. When a contract is informally extended

There are two very important factors to be taken into consideration when the FRV is being calculated.

1. Safety factor application

   The system offers the facility to apply a safety factor % reduction to CAP valuations at all points where the CAP valuation is called. These points are as follows:

• At initial quote stage
• At contract start
• At FRV review
• At informal extension.
• At transfer to VSB

2. Manual Adjustment

   The system offers the facility to apply and record manual adjustments made to the quoted FRV. The manual adjustment is created at either quotation or contract upload and then remains with the vehicle throughout its life and taken into account whenever the FRV is recalculated.

• The adjustment cannot be changed at any revaluation stage.

The Export Batch Details option is a function that is part of the Annual FRV Review process. Annual FRV review is something of a misnomer as this process should be carried out at least on an annual basis but may be performed quarterly or monthly. An FRV Review Batch is generated using the Create Review Batch option. The Export Batch Details option is then used to generate a file to the local PC drive of all Live contracts that meet the export selection criteria containing the following field values:

1. CRM Registration Number
2. Fleet Registration Number
3. Vehicle master Record - Fleet Model Description
4. Vehicle Master Record - Vehicle Description
5. CRM Vehicle Record status
6. Daily Rental Details - Currently At Location
7. Daily Rental Details - Currently Owned Location
8. Daily rental Details - DR Group
9. Fleet Agreement status
10. Fleet current agreement number
11. Fleet current agreement end date (before Extension)
12. Vehicle master record - registration date
13. Vehicle Master Record Current Odometer
14. Vehicle Master Record - Date Odometer Entered
15. Fleet Agreement Lease Type
16. Market User vehicle field - Date to Dealer
17. CRM User Vehicle Field - Date In stock
18. CRM User Vehicle Field - Date Sold
19. Vehicle Master Record - status Code
20. Vehicle Master Record Magic number
21. Vehicle Master Record Variant Details
22. Vehicle disposal Record - Date sold
23. Fleet Agreement - annual Contract distance
24. FRV Obtained from CAP lookup (Exceptions - shown as Zero if a value not obtained)
25. Review Type: Either AUTO or MAN

The resulting output file name format is as follows: REVUUUDDMMYYYY.CSV

Where REV = Annual Review, UUU = User ID and DDMMYY = Date stamp of when file was produced.

What do you want to do?

• View the Export Batch Details form
• View the full FRV process

See also:

• Create Review Batch process
• Automatic Update process
• Import FRVs process

To access the Export Batch Details:

1. From the Master Menu, select the Contract Administration option and Company required.

   The Contract Administration Menu is displayed.

2. Select the Administration Options option.

   The Administration Options Menu is displayed.

3. Select the FRV Options option.

   The FRV Review menu is displayed.

4. Select the Export Batch Details option

Export Batch Details form

This form is divided into four parts that are as follows:

Title Bar

In addition to displaying the form name the Title Bar displays other useful identification criteria and buttons.

Menubar and Toolbar

• File

• Help

Menu	Icon	Description
File > Exit		Exits the Export Batch Details form without processing. The ALT F4 shortcut is an alternative way of exiting the form.
File > Process		Generates a file for vehicles on the live fleet meeting the selection criteria to the local PC drive containing the above field values. The output file naming convention is as follows: REVUUUDDMMYYYY.CSV. Agreements are only processed if: the vehicle record has a matching Review date; the Proposed FRV falls under one of the selected categories (see below) i.e. ALL, Calculated FRV or Zero FRV; the FRV under review field (generated via the previous Create Review Batch process) is set to YES.
Help >		Provides online access to context sensitive help for the current application using the default browser.

Export Batch Details Dialogue Box

Review Date: A Start of Month date to signify when the FRV change was effective from.

Export Selection Status: Enables the export file to be filtered on selection criteria. This currently has the following options:

1. All
2. Calculated. Exports those contracts with a calculated proposed FRV.
3. Zero FRV. Exports those contracts without a proposed FRV