Re: Unable to post sales invoice after 1.2 > 1.3 upgrade

[Chris Travers <..hidden..>]

Filing bug 3509555 to note better error handling would be good......

On Tue, Mar 20, 2012 at 7:06 AM, Andrew Rowland <..hidden..> 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 <..hidden..>
> wrote:
>>
>> On Tue, Mar 20, 2012 at 5:24 AM, Andrew Rowland <..hidden..>
>> 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
>> > ..hidden..
>> > 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
>> ..hidden..
>> 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
> ..hidden..
> 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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users