Re: [Ledger-smb-users] Ok, maybe it isn't worth upgrading all the data...

2011-12-05 Thread lbmlist
Added USD to Defaults and it posted. Thank you once again. I could have sworn setting the defaults at one point, but I did so many installs trying to clean up my 1.2 data that I obviously missed the last one. L On Mon, 5 Dec 2011, Chris Travers wrote: What currencies do yoiu have se

Re: [Ledger-smb-users] Ok, maybe it isn't worth upgrading all the data...

2011-12-05 Thread lbmlist
In System->Defaults it is blank. I'll set it to USD. L On Mon, 5 Dec 2011, Chris Travers wrote: What currencies do yoiu have set up? On Mon, Dec 5, 2011 at 4:34 PM, wrote: Loaded up 1.3.8rc1 and did the setup.pl New error: Error! UPDATE ap SET invnumber = ?, ordnumber = ?, quonum

Re: [Ledger-smb-users] Ok, maybe it isn't worth upgrading all the data...

2011-12-05 Thread Chris Travers
What currencies do yoiu have set up? On Mon, Dec 5, 2011 at 4:34 PM, wrote: > > > Loaded up 1.3.8rc1 and did the setup.pl > > New error: > > > Error! > > > UPDATE ap > SET invnumber = ?, > ordnumber = ?, > quonumber = ?, > transdate = ?, > amount = ?, > netamount = ?, > paid = ?, > datepaid = ?,

Re: [Ledger-smb-users] Ok, maybe it isn't worth upgrading all the data...

2011-12-05 Thread lbmlist
Loaded up 1.3.8rc1 and did the setup.pl New error: Error! UPDATE ap SET invnumber = ?, ordnumber = ?, quonumber = ?, transdate = ?, amount = ?, netamount = ?, paid = ?, datepaid = ?, duedate = ?, invoice = '1', shippingpoint = ?, shipvia = ?, taxincluded = ?, notes = ?, intnotes = ?, curr =

Re: [Ledger-smb-users] Ok, maybe it isn't worth upgrading all the data...

2011-12-05 Thread Chris Travers
On Mon, Dec 5, 2011 at 1:16 PM, wrote: > > Is there more than just running the query? > > hethcote=# UPDATE parts SET income_accno_id = (SELECT account.id > . Here is the versoin that made it into Fixes.sql UPDATE parts SET income_accno_id = (SELECT account.id FRO

[Ledger-smb-users] LedgerSMB 1.3.8-rc1 released

2011-12-05 Thread Chris Travers
Hi all; 1.3.8-rc1 is out. This includes a number of fixes. If you are affected by any of these, you may wish to test. If no regressions are found, this will be the form 1.3.8 is released in. The complete changelog is below. Best Wishes, Chris Travers Changelog for 1.3.8: * Fixed duplicate ke

Re: [Ledger-smb-users] Ok, maybe it isn't worth upgrading all the data...

2011-12-05 Thread lbmlist
Is there more than just running the query? hethcote=# UPDATE parts SET income_accno_id = (SELECT account.id . . . UPDATE 1699 attempt invoice again: Error! INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, project_id, invoice_id) VALUES (?, ?, ?, ?, ?, ?) ERROR: insert or updat

[Ledger-smb-users] VirtualBox image

2011-12-05 Thread David A. Bandel
Folks, I have a VirtualBox image up w/ the latest LedgerSMB. There are also instructions on how to proceed to create a company. For those who don't want to download a large image (nearly 1Gb), I have do it urself instructions. All may be found at: http://david.bandel.us/software/ Ciao, David