[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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



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