Hello,
I want to update my db from 3.3.0 to 3.3.1b.
a) Looking at http://www.adempiere.com/wiki/index.php/Migration points me to the repository. Tried to checkout via svn results in a checkout of contributuion ?! directory.
Anyone has a hint how to load these scripts ?
b) As there is a postgresql directory, do I have to use the scripts inside this dir or the scripts in 330-331b as I'm using postgresql ?
c) Is it possible to change the order/invoice etc numbers ? Using a system with 2xxxxx for orders, 3xxxxx for offers and 1xxxxx for invoices and want to keep this numbering.
Thanks in advance
Christoph
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
b) you only need the scripts from the postgresql directory. I apply them via pgAdminIII but there is a script/ant task somewhere to do this automaticly.
c) yes you can change the numbering - go to Performance Analysys -> Accounting Rules -> Document Type
here you can see all existing document types like Purchase Order etc. If the 'Document is Number Controlled' checkbox is checked then you will have a Document Sequence field (a dropdown). Rightclick and zoom to the Document Sequence window (Performance Analysys -> Accounting Rules -> Document Sequence). Here you can change the current next value, the increment and you can add prefix and or suffix for your order/invoice.. numbers.
Regards,
Karsten
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello,
I want to update my db from 3.3.0 to 3.3.1b.
a) Looking at http://www.adempiere.com/wiki/index.php/Migration points me to the repository. Tried to checkout via svn results in a checkout of contributuion ?! directory.
Anyone has a hint how to load these scripts ?
b) As there is a postgresql directory, do I have to use the scripts inside this dir or the scripts in 330-331b as I'm using postgresql ?
c) Is it possible to change the order/invoice etc numbers ? Using a system with 2xxxxx for orders, 3xxxxx for offers and 1xxxxx for invoices and want to keep this numbering.
Thanks in advance
Christoph
Hi Christoph,
a) checkout with the svn tool of your choice.. I use tortoise - http://tortoisesvn.tigris.org/
b) you only need the scripts from the postgresql directory. I apply them via pgAdminIII but there is a script/ant task somewhere to do this automaticly.
c) yes you can change the numbering - go to Performance Analysys -> Accounting Rules -> Document Type
here you can see all existing document types like Purchase Order etc. If the 'Document is Number Controlled' checkbox is checked then you will have a Document Sequence field (a dropdown). Rightclick and zoom to the Document Sequence window (Performance Analysys -> Accounting Rules -> Document Sequence). Here you can change the current next value, the increment and you can add prefix and or suffix for your order/invoice.. numbers.
Regards,
Karsten