SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to index page
Thread view  Board view
DavidJ(R)

04.11.2015, 21:23
 

Delete account failed (General)

Using version 3.0.5
Trying to delete an account.
Checked there's no transactions linked.
Checked this account is NOT a default account.
But seeing following error.

--------- Error Message -----------

DBD::Pg::db selectrow_array failed: ERROR: syntax error at end of input at character 71 at SL/AM.pm line 187.
DBD::Pg::db do failed: ERROR: current transaction is aborted, commands ignored until end of transaction block at SL/AM.pm line 203.
Error!

DELETE FROM chart
WHERE id = 10488
ERROR: current transaction is aborted, commands ignored until end of transaction block

--------- End of Error Message -----------

Any simple fix, or is more information needed ?
Thanks

Dieter Simader(R)

05.11.2015, 20:32

@ DavidJ
 

Delete account failed

Using version 3.0.5
Trying to delete an account.
Checked there's no transactions linked.
Checked this account is NOT a default account.
But seeing following error.

--------- Error Message -----------

DBD::Pg::db selectrow_array failed: ERROR: syntax error at end of input at
character 71 at SL/AM.pm line 187.
DBD::Pg::db do failed: ERROR: current transaction is aborted, commands
ignored until end of transaction block at SL/AM.pm line 203.
Error!

DELETE FROM chart
WHERE id = 10488
ERROR: current transaction is aborted, commands ignored until end of
transaction block

--------- End of Error Message -----------

Any simple fix, or is more information needed ?
Thanks

check if you have an account for IC, AR and AP

DavidJ(R)

06.11.2015, 00:11

@ Dieter Simader
 

Delete account failed


check if you have an account for IC, AR and AP

Superb. That nailed it.
Many thanks.

--- More details ---
It seems must have account/s established to track Income AND COGS, even if the company has no inventory, no trading account, no COGS.
More testing needed to confirm. No big deal. No matter.

Back to index page
Thread view  Board view
964 Postings in 318 Threads, 323 registered users, 179 users online (0 registered, 179 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum