[Ledger-smb-devel] Payment date of AR/AP item before open-item creation date

2011-12-31 Thread Erik Huelsmann
Hi, The other day while testing, I was entering a backdated payment. Accidentally, I selected an AR item which hadn't even been created by the date of the posting. The system happily cleared the item. However, I think that's wrong: I think the payment should have landed on the overpayments accoun

Re: [Ledger-smb-devel] 1.3: 1099 reports?

2011-12-31 Thread Nigel Titley
On 31/12/11 07:55, Chris Travers wrote: > On Fri, Dec 30, 2011 at 10:13 PM, John Locke wrote: >> id | role_name| acl_type | node_id >> -++--+- >> 560 | lsmb_freelockco__tax_form_save | allow| 226 >> (1 row) > > I

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Nigel Titley
On 31/12/11 15:40, Nigel Titley wrote: > On 31/12/11 11:26, Nigel Titley wrote: >> On 31/12/11 10:23, Nigel Titley wrote: >>> On 31/12/11 09:50, Chris Travers wrote: >>> Ok now we are getting somewhere. What username are you using to set up the database? It must be a database s

Re: [Ledger-smb-devel] Possible Add-on?

2011-12-31 Thread Chris Bennett
On Fri, Dec 30, 2011 at 07:39:54PM -0800, Chris Travers wrote: > > So what we are talking about here is engineered to order and > configured to order sorts of things? I think such an add-on would in > fact be very useful. > > Longer-run I would recommend trying to tie this in to projects some >

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Nigel Titley
On 31/12/11 11:26, Nigel Titley wrote: > On 31/12/11 10:23, Nigel Titley wrote: >> On 31/12/11 09:50, Chris Travers wrote: >> >>> Ok now we are getting somewhere. >>> >>> What username are you using to set up the database? It must be a >>> database superuser. >> >> I was using postgres. However, I

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Nigel Titley
On 31/12/11 10:23, Nigel Titley wrote: > On 31/12/11 09:50, Chris Travers wrote: > >> Ok now we are getting somewhere. >> >> What username are you using to set up the database? It must be a >> database superuser. > > I was using postgres. However, I've now added "create database" > privilege to

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-31 Thread Erik Huelsmann
On Sat, Dec 31, 2011 at 11:33 AM, Erik Huelsmann wrote: > On Fri, Dec 30, 2011 at 11:12 PM, Erik Huelsmann wrote: >> On Fri, Dec 30, 2011 at 3:10 PM, Erik Huelsmann wrote: >>> Hi Chris, >>> We have been having a slight multicurrency issue with payments that we do not believe can be ade

Re: [Ledger-smb-devel] Multicurrency issue, concerns, and proposed longer-term direction.

2011-12-31 Thread Erik Huelsmann
On Fri, Dec 30, 2011 at 11:12 PM, Erik Huelsmann wrote: > On Fri, Dec 30, 2011 at 3:10 PM, Erik Huelsmann wrote: >> Hi Chris, >> >>> We have been having a slight multicurrency issue with payments that we >>> do not believe can be adequately resolved inside a stable branch. >>> Fortunately this is

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Nigel Titley
On 31/12/11 09:50, Chris Travers wrote: > Ok now we are getting somewhere. > > What username are you using to set up the database? It must be a > database superuser. I was using postgres. However, I've now added "create database" privilege to the ledgersmb user and the process has largely gone

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Chris Travers
On Sat, Dec 31, 2011 at 12:44 AM, Nigel Titley wrote: > On 31/12/11 02:20, Chris Travers wrote: >> Check the /tmp/ledgersmb/dblog_stderr for the error. > > psql:sql/Pg-database.sql:2: ERROR:  syntax error at or near "EXTENSION" > LINE 1: CREATE EXTENSION tablefunc; >               ^ > psql:sql/Pg-

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Nigel Titley
On 31/12/11 08:44, Nigel Titley wrote: > On 31/12/11 02:20, Chris Travers wrote: >> Check the /tmp/ledgersmb/dblog_stderr for the error. > > psql:sql/Pg-database.sql:2: ERROR: syntax error at or near "EXTENSION" > LINE 1: CREATE EXTENSION tablefunc; >^ > psql:sql/Pg-database.sql:3

Re: [Ledger-smb-devel] Error when upgrading 1.2 db to 1.3 db

2011-12-31 Thread Nigel Titley
On 31/12/11 02:20, Chris Travers wrote: > Check the /tmp/ledgersmb/dblog_stderr for the error. psql:sql/Pg-database.sql:2: ERROR: syntax error at or near "EXTENSION" LINE 1: CREATE EXTENSION tablefunc; ^ psql:sql/Pg-database.sql:3: ERROR: syntax error at or near "EXTENSION" LINE 1