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

Re: Ledger Error



Hi
SMB version 1.2.18 an yes, I update before post.

Monika
Forgot to ask: which version are you running?

Method 2 is the proper one. Are you hitting "update" before you try to post?

Luke

On Fri, 30 Jul 2010, Monika Koper wrote:

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


------------------------------------------------------------------------------
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