See also:
These procedures are part of Vehicle Multi-Currency Menu in Manufacturer Systems. They assume you are familiar with standard, Sales Ledger- and Vehicle Stockbooks functionality.
When deposits are taken in foreign currency against a vehicle that will be sold in foreign currency, it is normal practice to re-value these deposits to take account of movements in the exchange rate. This re-valuation process either increases, or decreases, the local-currency equivalent value in base currency. The opposite posting goes to unrealised currency gains/losses.
Note: Deposit re-valuation only takes place for deposits that attract VAT. It is totally dependent on Additional deposit postings.
The system takes the corresponding exchange rate of every currency to perform the re-valuation process.
The field, STATUS, in SL.depos is checked by the system to ascertain whether re-valuation is possible. All deposits with the following statuses will not be re-valued:
What Do You Want to Do?
Note: The standard SL program in SL Miscellaneous Options does not re-value the deposits.
This form is displayed when you click Sales Ledger on the Autoline Master Menu, then [Company] > Miscellaneous options > Revalue deposits. It enables you to re-value deposits.
Details:
Currency code
: Select a currency code from the drop-down list, to re-value all deposits for that currency in relation to the exchange rate based on the selected date.
The available currencies in the list are populated from the field CURRCODE in the table X3.MS.vmctc. Only currencies marked Sale or Both are used for this list.
If you leave this blank, all available currencies in the X3.MS.vmctc table that are marked Sale or Both, are re-valued.
The deposits held in foreign currency will be re-valued to the current exchange rate taken from the foreign-currency exchange-rate table.
Exchange rate date
: The exchange-rate date entered is used to determine the relevant effective date from the Exchange rates table for that currency. This date can be set to any date except the future.
Exchange rate: Exchange rate of the selected currency. If a blank currency code is selected, an exchange rate of 0 (zero) is displayed but the latest exchange rate of deposit is used.
Buttons:
Process: Triggers re-valuation. When re-valuation has been processed, the Process button is disabled, and you cannot re-value again. To re-value again, exit the interface, and access it again.
Report: Displays a report showing changes made during the revaluation, with the option to print.
Note: The Print option on the report interface prints only the report and not daybooks.
Exit: Returns you to the SL Miscellaneous Options menu.
Help: Displays online help about the program, including this page.
Note: Before you use the program, you must ensure that the Autoline system is set up correctly. This is normally carried out by, or on advice from, an Autoline consultant. Consultants should refer to the handover document. It is imperative that E8/5304 (Additional deposit postings) be installed for the accounts to be updated as required. Revalue base currency deposits parameter in Manufacturer systems > X3 > Vehicle multi-currency > Multi currency parameters > [Enter VSB Company number] must be set to allow re-valuation of base-currency deposits. Ensure deposits that attract VAT are set in Nominal Ledger > System maintenance > System parameters > Deposit VAT code. If this is left blank, the system uses deposits that do not attract VAT.
Note: This program can also be run in Timed Operations. When the timed operation is run, all currency codes are re-valued (based on certain criteria) to their respective exchange rates taken from the foreign-currency exchange-rate table.
The following are examples with explanations of the two scenarios for deposit re-valuation:
(Example 1): To re-value a 'vat-able', base-currency deposit attached to a vehicle in foreign currency:
On the Autoline Master Menu, click Sales ledger > Take deposits.
Enter the deposit against a base-currency account (Header tab), and enter a date of 16/01/2012 (Details tab).
Exit Sales Ledger module to Manufacturer systems > X3 > Vehicle multi-currency > Exchange rates. Note the exchange rate that would apply for that date for EUR.
The applicable exchange rate for 16/01/2012 is 0.2 We will attach this deposit to a foreign-currency(EUR) vehicle.
Attach the deposit to a new foreign-currency (EUR) vehicle (Vehicle details group box on the Take Deposits form), then click the Process toolbar button 
.
Verify the deposit has been allocated to a foreign-currency vehicle in Vehicle Administration (Sales currency field on the Identity tab), and check the base- and foreign-currency values on the Finance Details tab (Display Currency field and Trade-in details group box).
Very high-priority users can view the following tables: the X3 MS Multi-currency deposit file and the X3 MS New vehicle multi-currency file, the currency value (CURRVAL) in the SL depos file in the SL ADVANCED SYSTEM ADMIN Menu, and the currency value (CURRVAL) in the SL trans[actions] file.
Note to System Administrators: For system maintenance and security purposes, the content and function of these tables require an access priority of 9. Information regarding Priority 9 functions is normally restricted. If you require assistance, please contact Autoline Software Support.
Now we can re-value the deposits as follows:
Return to Sales Ledger > [Company] > Miscellaneous options > Revalue deposits.
The Deposit Currency Revaluation form is displayed.
Click Process.
The following message is displayed:
Deposits have been revalued. The number of deposits processed is [1] /OK
Click OK.
The deposit values are updated in the file in base.
The rate applicable for the current date 16/01/2013 is 0.8
SL deposit (SL.depos) – CURRVAL is now 125 - that is: (100 divided by 0.80)
SL transaction (SL.trans) – CURRVAL is now 125 - that is: (100 divided by 0.80)
MS X3 Multi currency deposit record (X3.MS.vmcdp)
EXRATER - 0.8
CURRVALR - 125.00
MS X3 Multi currency new vehicle record (X3.MS.vmcnv)
DEPAMT - 125
DEPROE - 0.8
The Multi-currency deposit log record has been created.
(Example 2) To re-value a foreign-currency deposit attached to a vehicle in foreign currency:
On the Autoline Master Menu, click Sales ledger > Take deposits.
Enter the deposit against a foreign-currency EUR currency account (Header tab).
Enter a date of 07/02/2012 (Details tab).
Exit Sales Ledger module to Manufacturer systems > X3 > Vehicle multi-currency > Exchange rates. Note the exchange rate that would apply for that date for EUR.
The applicable exchange rate for 07/02/2012 is 0.2 We will attach this deposit to a foreign-currency(EUR) vehicle.
Attach the deposit to a new vehicle (Vehicle details group box on the Take Deposits form), then click the Process toolbar button .
Print the daybook, view on the View Document form, then verify the deposit has been allocated to a EUR vehicle (Sales currency field on the (Sales currency field on the Identity tab) in Vehicle Administration, and also Display Currency field/Trade-in Details group box on the Finance Details tab).
Very high-priority users can view the following tables: the X3 MS Multi-currency deposit file and the X3 MS New vehicle multi-currency file.
Note to System Administrators: For system maintenance and security purposes, the content and function of these tables require an access priority of 9. Information regarding Priority 9 functions is normally restricted. If you require assistance, please contact Autoline Software Support.
Check the SL account details on the Transactions tab in Display Accounts.
The A/c Total in this case is 1200 Euros.
The Details-1 tab shows the figures.
Now we will do the revaluation, as follows:
Return to Sales Ledger > [Company] > Miscellaneous options > Revalue deposits.
The Deposit Currency Revaluation form is displayed.
Click Process.
The following message is displayed:
Deposits have been revalued. The number of deposits processed is [1] /OK
Click OK then exit the interface to print the SL daybooks.
The deposit values are updated in the files. The rate applicable for the current date 07/02/2013 is 0.8
View the Multi-Currency Exchange Rates form.
The applicable currency exchange rate is now .80 This means the deposit rate has changed from 0.2 to 0.8.
Initial conversion 1200 multiplied by .2 = 240
Revalue 1200 multiplied by .8 = 960
Difference = 960 ̶ 240 = 720
This means there is a base UKL difference of 720 that needs to be posted.
Check the SL account again.
Looking at the detail on the Transaction Detail form, we now see the extra 720 in Amount paid. Close the form.
Clicking the Allocations... button, we see the re-valued base value of 720 on the Allocated Payments form. Close the form.
Check the daybook print on the View Document form, for the values.
The Multi-currency deposit log record has been created.
View the vehicle in the Finance Details tab in Vehicle Administration (Display Currency field/Trade-in Details group box).
The foreign-currency values have not changed.
The base value has changed - in this case, to 800.
Now invoice the vehicle.
See also: Print Options
Print NL, PL, and SL, daybooks.
Look at the SL account > Transactions tab.
The Details-1 tab shows the amounts with the re-valued deposit.
All deposit revaluations are logged in the Multi-currency re-valuation log file.
When a re-valuation has been performed on deposits, the Report button can be clicked to see a report about deposit changes. The data is sourced from the revaluation log table. When viewing the report, you can send the report to the currently selected printer. The format of the print is the same as its display in the report form. The report only displays changed data. If the base value has not changed, the report will show no base values. If the foreign value has not changed, the report will show no foreign values. The posted amount (if a base change was made and posted), will also be displayed in the report.
Note: The Print option on the report interface prints only the report and not daybooks.
If base postings have been made during the revaluation, the daybooks for the current terminal are printed when you exit the re-valuation interface. Printing the daybooks is not optional, and must be done when exiting the interface. After the daybooks have been printed upon exit, a prompt is given either to continue exiting the interface, or to re-print the daybooks. When re-valuation is performed via End of Day, the daybooks will be printed automatically if base amount changes have been posted.