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

Re: Ledger Error



I try every posible steps :
1. I open the transaction (unpaid invoice) and on the bottom input date : date, source, memo, amount, exchange rate and account ( our euro bank account) 2. I click on CASH then RECEIPT and again put all the data. Both of the way I try to put always send up the same way . Let me copy the error information :

*DBD::Pg::st execute failed: ERROR: insert or update on table "acc_trans" violates foreign key constraint "acc_trans_chart_id_fkey" DETAIL: Key (chart_id)=(10109) is not present in table "chart". at LedgerSMB/IS.pm line 1363.
*


   Error!

*
INSERT INTO acc_trans (
trans_id, chart_id, amount,
transdate, fx_transaction,
cleared)
VALUES (?, ?, ?, ?, '1', ?)
ERROR: insert or update on table "acc_trans" violates foreign key constraint "acc_trans_chart_id_fkey"
DETAIL: Key (chart_id)=(10109) is not present in table "chart".*

And then the whole invoice is vanished from the ledger. So to be honest I cant really work. It seems to happen only with EURO and Dollars transaction.

Regards,
Monika
How are you trying to receive payment? That is: what steps are you following, and what is the error?

Regards,

Luke

On Thu, 29 Jul 2010, Monika Koper wrote:

Dear All

I stuck in one point on SMB. when I issue an invoice for somebody  in
EURO and then after a month or so I try to input the payment details
against that invoice the SMB always shows the message : ERROR and
delete  the invoice from Ledger. Anybody can help me with that ??

Regards,
Monika

------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users


------------------------------------------------------------------------------
The Palm PDK Hot Apps Program offers developers who use the
Plug-In Development Kit to bring their C/C++ apps to Palm for a share
of $1 Million in cash or HP Products. Visit us here for more details:
http://p.sf.net/sfu/dev2dev-palm
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users