Filing bug 3509555 to note better error handling would be good......
On Tue, Mar 20, 2012 at 7:06 AM, Andrew Rowland <[email protected]> wrote: > Thanks Chris, > > Currency was indeed the issue. After I added AUD as my default in System > > Defaults it seems to work. > I also see the print button after posting the invoice. > > Many thanks > > Andrew > > > On Tue, Mar 20, 2012 at 9:37 PM, Chris Travers <[email protected]> > wrote: >> >> On Tue, Mar 20, 2012 at 5:24 AM, Andrew Rowland <[email protected]> >> wrote: >> > Hi >> > >> > After getting the 1.2 > 1.3 database upgrade working, I'm having some >> > fundamental issues posting a new sales inovice. >> > >> > I get an error screen with lots of SQL and '?'s. >> > >> > In the postgres log I see.... >> > >> > 2012-03-13 22:03:14 WST STATEMENT: >> > UPDATE ar set >> > invnumber = '2013', >> > ordnumber = '', >> > quonumber = '', >> > transdate = '2012-03-05', >> > entity_credit_account = '50', >> > amount = '448', >> > netamount = '448', >> > paid = '0', >> > datepaid = 'now', >> > duedate = '2012-03-05', >> > invoice = '1', >> > shippingpoint = '', >> > shipvia = '', >> > terms = '0', >> > notes = '', >> > intnotes = '', >> > taxincluded = '0', >> > curr = NULL, >> > department_id = '0', >> > person_id = '49', >> > till = NULL, >> > language_code = 'en', >> > ponumber = '' >> > WHERE id = '10842' >> > >> > 2012-03-13 22:04:09 WST ERROR: new row for relation "ar" violates check >> > constraint "ar_check" >> >> Do you have any currencies set up? >> >> What currency are you using? >> >> Best Wishes, >> Chris Travers >> > >> > >> > From ar table in postgres... >> > >> > Check constraints: >> > "ar_check" CHECK (amount IS NULL AND curr IS NULL OR amount IS NOT >> > NULL >> > AND curr IS NOT NULL) >> > >> > This is a new invoice so I would expect and INSERT rather than an UPDATE >> > but >> > other than that it seems OK to me - any ideas ? >> > >> > Also what happened to the print button that was present in 1.2 - has it >> > gone >> > or is it a permissions thing ? >> > >> > Using 1.3.13 if that helps >> > >> > >> > Thanks >> > >> > Andrew >> > >> > >> > ------------------------------------------------------------------------------ >> > This SF email is sponsosred by: >> > Try Windows Azure free for 90 days Click Here >> > http://p.sf.net/sfu/sfd2d-msazure >> > _______________________________________________ >> > Ledger-smb-users mailing list >> > [email protected] >> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users >> > >> >> ------------------------------------------------------------------------------ >> This SF email is sponsosred by: >> Try Windows Azure free for 90 days Click Here >> http://p.sf.net/sfu/sfd2d-msazure >> _______________________________________________ >> Ledger-smb-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
