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
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
