Re: error adding sales transaction.

["J Kinable" <..hidden..>]

Well I think this is the problem:
When I go to sales->add transaction, there are several fields I have to fill in:
Amount, Account, Description etc. Beneath 'Account' (and above Notes)
there are 2 dropdown boxes. In the first dropdown box I can select an
account where the money comes from, but the second dropdownbox (right
below the first one) is completely empty! Here I can't select any
account where I can post the money transfer on. How can I add accounts
to this second dropdown box?

Thnx,

Joris


On 5/21/07, Chris Travers <..hidden..> wrote:
> This usually happens because of some missing account type.
>
> Usually it is an AR, Inventory, Income, or Expense account.
>
> Please provide more information.  Are you selling a part or a service?
>  What does your chart of accounts look like?
>
> BTW, it is a good thing we throw this error.  Otherwise your books may
> get out of balance.
>
> Best Wishes,
> Chris Travers
>
> On 5/21/07, J Kinable <..hidden..> wrote:
> > Good morning,
> >
> > I'm failing to add a new sales transaction and I'm not sure what's
> > going wrong. After going to sales->add transaction, fill in all the
> > fiels, click post and click post a again to confirm, I receive the
> > following error:
> > DBD::Pg::st execute failed: ERROR: null value in column "chart_id"
> > violates not-null constraint Error!
> > INSERT INTO acc_trans (trans_id, chart_id, amount, transdate) VALUES
> > (?, (SELECT id FROM chart WHERE accno = ?), ?, ?) ERROR: null value in
> > column "chart_id" violates not-null constraint
> >
> > Screenshots of the problem:
> > http://nemesisclan.snt.utwente.nl/ledger_picture_2.png
> > http://nemesisclan.snt.utwente.nl/ledger_picture_3.png
> > Anyone any idea how I can solve this problem quickly? Please be
> > specific in your solution description since I'm not yet very familiar
> > with this program.
> >
> > Thnx in advance,
> >
> > Joris
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > Ledger-smb-users mailing list
> > ..hidden..
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
> >
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users