Unable to post sales invoice after 1.2 > 1.3 upgrade

[Andrew Rowland <..hidden..>]

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"


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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users