Re: error adding sales transaction.

["Chris Travers" <..hidden..>]

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