blob: b5631b283983753e6374a4d7f45e970ca1aa0946 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
Upgrading from version 1.6 to 1.8
1. make a backup copy of your databases and SQL-Ledger, just in case!
$ cd /usr/local/www/sql-ledger
$ pg_dump database > db.out
$ tar cvf ~/sql-ledger.tar .
2. install SQL-Ledger over top of your old installation
$ cd /usr/local/www
$ tar zxvf sql-ledger-1.8.0.tar.gz
3. change the tables to the new layout
$ cd sql-ledger/sql
$ psql database < upgrade-1.6-1.8.sql
4. copy the new master templates to your template directory
$ cd ../templates
$ cp Default-email_purchase_order.html your_template_dir/email_purchase_order.html
$ cp Default-purchase_order.html your_template_dir/purchase_order.html
$ cp Default-email_sales_order.html your_template_dir/email_sales_order.html
$ cp Default-sales_order.html your_template_dir/sales_order.html
5. Two new accounts were hopefully added to your chart of accounts
One account for Foreign Exchange Gains and one for
Foreign Exchange Losses
edit and change to suit your COA. You can safely change
the account number too.
6. Edit your preferences
In field 'Stylesheet' enter -> sql-ledger.css
Stylesheet is in the css directory
Add your foreign currencies in the Currencies field
The first currency in the list is your default
i.e CDN:USD:EUR:YEN
If you used a nativecurr than it should be listed in the
new currencies field.
7. <%nativecurr%> has changed to <%currency%>
edit all your templates and change nativecurr to currency
8. I also added four more variables which can be used in your templates.
<%contact%>, <%shiptocontact%>, <%shiptophone%>, <%shiptofax%>
9. Nameing convention for templates has changed from an
underscore to a minus sign. If you designed your own
master templates rename the templates from
industry_invoice.html to industry-invoice.html,
industry_packing_list.html to industry-packing_list.html, etc.
The minus sign is used to separate the name and list them in
the setup screen.
This change only applies to the master templates in the
templates root directory NOT the individual templates which
are used by users.
It looks more than it really is. Steps 1 to 4 are important,
the rest is for fine tuning and info.
|
