This help topic should be read in conjunction with Foreign-Currency Values on Vehicle Costs via PL and SL.
See also:
Note: Only VSB vehicles at account-status Consigned or Adopted can be re-valued. (Customising is not possible in this respect.)
In markets where vehicles are stocked in a ‘hard’ foreign currency, there is a requirement to re-value the vehicle stock, from the historical exchange rate at which the vehicles were originally purchased, to the current effective exchange-rate. Where there are changes, this alters the base-currency values of the stock affected, the opposite side of which is posted, either as a provision in the Balance Sheet, or as an adjustment to Profit and Loss.
This process affects both New- and Used, foreign-currency-valued vehicles.
The postings will be different for vehicles not owned by the dealer (Consigned) as opposed to vehicles owned by the dealer (Adopted).
This process would normally be run at the end of the month, before finalising the monthly accounts. However, it could be run at another time if there were an extra-ordinary movement in the exchange rate and particular reason to run it.
If the process is run mid-month, your dealership or business might need to choose which vehicles are to be included.
Parameters required for vehicle re-valuation include Nominal accounts to post the re-valuation totals to, and also default filters.
Warning: Before you use this program, you must ensure that the Autoline system is correctly set up. This is normally done by, or on advice from, an Autoline consultant. Consultants should refer to handover documents for FS/17341 and FS/16648. Vehicle Revaluation Parameters specify criteria for vehicles to be re-valued and which mnemonics/accounts are to be used for posting the differences. These parameters must be set up correctly for the re-valuation process.
Expanded vehicle multi-currency parameters hold information for vehicle re-valuation.
To edit the vehicle multi-currency parameters:
(Click Manufacturer systems > X3 from the Autoline Master Menu then Vehicle multi-currency > Multi currency parameters.)
The re-valuation parameters are defined on the Vehicle Revaluation tab.
You can define the progress codes that vehicles must have when being re-valued.
You can select analysis codes for both new- and used vehicles. When re-valuing vehicle costs, the analysis code of the specification lines is validated against this parameter to see whether the line is to be re-valued. Analysis codes are loaded from VS.adesc, and codes l, d, f, 5, 6, and 7, are added to the top of the list.
Manually entered analysis codes are validated, and invalid analysis codes are removed from the list. Manually entered codes are always sorted having l, d, f, 5, 6 and 7 first (and in that order), and then other selected codes in alphabetical order. Entered codes that are invalid are removed from the entered text.
Note: We advise that the correct posting mnemonics be selected to ensure that the correct vehicle accounts are debited with the re-valuation amounts. The posting mnemonics are used to derive the Nominal accounts that are to be debited with re-valuation amounts. Only balance-sheet posting types can be used.
For each mnemonic drop-down 
, the list of mnemonics is sourced from VS-posting-mnemonic descriptions (VS.ptmdt). Only mnemonics that either have a blank posting-type, or a posting type of B (Balance sheet), can be used. The Consignment and Adoption mnemonics for new vehicles are loaded from VS.ptmdt where the vehicle type is set to either blank or N. The Adoption mnemonics for used vehicles are loaded from VS.ptmdt where the vehicle type is set to either blank or U.
During re-valuation, the mnemonic is retrieved from the VS detailed posting table, using the vehicle details to derive the NL account that is to be debited with the re-valuation amounts.
The re-valuation accounts are the Nominal Ledger accounts to be credited with the re-valuation amounts. NL Accounts can be entered manually, either including the cost centre or excluding it. If the cost centre is not included, you are prompted to select a cost centre. You can search for NL accounts to use, by clicking the ellipsis.
Note: During re-valuation, the balance-sheet cost-centre mask of the vehicle’s physical location is used to determine the correct credit account. Masks can be viewed from System utilities > Management menu > Locations > Details tab > B/S cost centre mask.
Note: Only VSB vehicles at account-status Consigned or Adopted can be re-valued. (Customising is not possible in this respect.)
To re-value the vehicle stock, from the historical exchange rate at which the vehicles were originally purchased, to the current effective exchange-rate:
Note: Because a significant number of vehicles can be re-valued, we strongly advise locking VSB in Exclusive mode, before re-valuation. Note that this lock is applied to both the fore- and the back-ground processes.
It is safer to lock VSB in Exclusive mode before re-valuation can be carried out. This process is similar to the lock obtained when amending VSB Master Posting Tables. If other users are logged into VSB, a list of these users is displayed, and re-valuation cannot be performed. If no users are logged into VSB, the current VSB company is locked to prevent other users entering VSB.
On the Autoline Master Menu, click Vehicle Stockbooks > Miscellaneous options > Revalue multicurrency vehicles.
When you access the interface, default filters are set. By default, New is selected as the vehicle type, and the first available purchase currency is automatically selected. The currency-rate value cannot be changed, and is sourced from the X3 exchange-rates table. The latest available exchange rate of the currency code is used. Effective date displays the effective date of the purchase currency exchange rate.
Analysis codes are sourced from the revaluation parameters depending on the selected vehicle type. Analysis codes cannot be changed dynamically.
Progress codes are sourced from the re-valuation parameters, and are shared between new- and used vehicles. The progress code selection can be changed dynamically during run-time but the newly selected codes will not be updated back to the revaluation parameters.
Specify any new Revaluation filter criteria, then click Refresh 
on the toolbar to re-load vehicles that match the newly selected criteria.
The Vehicle Revaluation form is displayed.
A list of vehicles is displayed that are to be included in the re-valuation. This displays basic vehicle information and the base-currency adjustments that will be made during the re-valuation.
All vehicles are loaded from either VS.newst or VS.usdst, depending on the selected vehicle type (New or Used respectively). The Prev[ious] Curr[ency] Ex[change] Rate is determined from the vehicle table in Manufacturer Systems (either X3.vmcnv or X3.vmcuv).
The Currency Price column contains a total of all the specification lines and non-recoverable purchase costs, that match the analysis-codes filter defined. Values in this column are shown in the Purchase currency of the vehicles.
The Old Base [Currency] Value column shows the value of the Currency Price column in the system base-currency, using the previous exchange-rate value.
The New Base [Currency] Value column shows the value of the Currency Price column in the system base-currency, using the new exchange-rate as displayed in the Filters group box.
Adjusted Base [Currency] Value displays the new base value minus the old base value.
Vehicles can be selected individually for re-valuation.
To specify which vehicles to include, go to the Revalue? column at the extreme right of the form.
To select or de-select (clear) all vehicles in one step, click the Revalue? column header, to toggle the selections.
Select which vehicles to re-value, then select the Process option from the menu bar or toolbar 
.
This starts the re-valuation.
Note: When running in an End-of-Day timed operation, all vehicles that match filtering criteria from the parameters will be processed.
For new vehicles, the Date in Stock column holds the consignment date of vehicles at C status and the adopted date of vehicles at A status. For used vehicles, the date is retrieved from the purchase invoice date.
Using the analysis codes specified in the parameters, either the base currency (if the analysis code is defined in the parameters) of the vehicle and specification lines will be adjusted and the foreign value will stay unchanged. If the analysis code of the specification line is not in the parameters, the base value remains unchanged, and the foreign value on the vehicle is adjusted. Only changes to base-currency values will be posted.
After the re-valuation, re-valued vehicle costs are stored in the VSB and Manufacturer Systems tables. The values will be posted to the accounts specified in the Revaluation Parameters and logged in both the VSB vehicle log and the re-valuation log in Manufacturer Systems.
When re-valuation has been performed in the foreground, you can view a report about the re-valuation.
To produce a re-valuation report:
After re-valuation, select the Revaluation Report option from the menu bar/toolbar 
The Vehicle Revaluation Report form is displayed. This shows any messages recorded during the re-valuation process.
You can print this report if there are report entries.
The report is sent to the currently selected printer in a similar way to the End-of-Day process.
Re-valuation can be a timed operation.
To run the re-valuation program as a timed operation such as End of Day:
Add the MSX3VRV option to the Timed Operations Schedule.
Note: A VSB company MUST be defined. Two asterisks (**) are not a valid Company selection. Filters cannot be specified per scheduled task, and the values specified in the Re-valuation Parameters will be used as they stand.
All vehicles that match filtering criteria from the parameters, will be processed. All new vehicles that match the pre-set filtering are the first to be re-valued, followed by all Used vehicles.
When re-valuation has been completed in an End-of-Day process, a single log entry is written to the End-of-Day log.
Use the system log file to view the results.
Vehicle re-valuation information is sent to the printer spooler defined in the setup of the timed operation.
Any changes made to vehicle values are logged in two places. These are:
The core VSB log file
The Revaluation log table X3.MS.vmcrl.CC in Manufacturer Systems. (CC being the VS Company.)
The core VS log will record any changes that have occurred on the vehicle after the revaluation and can be viewed from the Vehicle Administrator interface.
The MS Revaluation log table contains the cumulative adjustment amounts in either the CONSVAL or ADOPVAL fields if the vehicle is Consigned or Adopted respectively. The MS re-valuation log can only be viewed via Data Maintenance or via a custom-designed report.
Note to System Administrators: For system maintenance and security purposes, the content and function of some tables require an access priority of 9. Information regarding Priority 9 functions is normally restricted. If you require assistance, please contact Autoline Software Support.
The MS new- or used vehicle record is also updated to hold the new exchange rate, the previous exchange rate, and the date of the last re-valuation. The Consignment Re-valuation and the Adoption Revaluation amounts are also incremented with the new re-valuation amount, depending on the vehicle account-status.
Each specification line that matches the active criteria will be amended to contain the new cost.
Note: Core Autoline currency functionality has previously allowed users with sufficient priority to change the actual cost of a specification line directly (manually), even if the cost has been received from outside. This functionality has been revoked because changing these amounts could introduce mis-aligned account postings. For fixed-cost options, changing the estimated cost field still updates the actual cost.
The actual cost field on the specification lines is updated.
The total adjustment to the base currency of the specification lines that were changed will be posted.
Specification lines that have an analysis code that is NOT in the analysis-codes parameter will NOT have the base currency changed, but will have the foreign value changed in MS tables. Adjustments to the foreign values will not be posted.
When the re-valuation is carried out, the Vehicle Multi-currency Parameters will be used to derive the accounts to be used. The Purchase Ledger journal account set up in VSB parameters will be used as the control account.
The NL debit account will be derived from the mnemonic specified in the Parameters regarding the vehicle type and account status. Using the mnemonic, the Detailed Posting Tables for the current vehicle (depending on posting configurations either at franchise-, model- or variant level), will be inspected to get the NL account.
The NL credit account will be retrieved directly from the Parameters depending on the vehicle type and account status.
Note: When postings are carried out, the balance-sheet cost-centre and balance-sheet expense-code masks of the vehicles' physical location will be used to adjust the debit- and credit accounts. This is the same as the method by which core functionality currently determines the accounts to use for VSB postings.
Purchase Ledger daybooks must be printed manually for transactions to be viewed. No daybooks are printed automatically upon completion of the Revaluation process.