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
