To change the base currency:
- On the P6 EPPM physical media or download:
- Browse to \Database\scripts\common.
- Copy this script to a local drive:
For Microsoft SQL Server: ss_set_currency.sql
- If you copied the script from the physical media, turn off the script's read-only attribute.
Since files on physical media are read-only, this attribute turns on when you copy a file from a CD or DVD.
- In Windows Explorer, right-click the file.
- Choose Properties.
- Clear the Read-Only option.
- Open the script for editing and locate the line containing v_new_base_currency: = ‘USD’
- Replace USD with the currency short name of your choice.
- Save your changes and run the modified script.