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 <[email protected]>wrote:
> 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
>
------------------------------------------------------------------------------
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
