I try to close out 2014 so that I can get a good view of accounts since I can't get a proper P&L. I should have done this before, but there were certain tax related adjustments that I hadn't entered yet.
It says: Error from Function: ERROR: Unapproved transactions in closed period CONTEXT: SQL statement "SELECT eoy_create_checkpoint(in_end_date)" PL/pgSQL function "eoy_close_books" line 4 at PERFORM More information has been reported in the error logs at LedgerSMB.pm line 764. I have drafts that were never approved. Not surprising. They got lost as drafts and were re-entered. Now I attempt to remove the old drafts: Error! 23503:ERROR: update or delete on table "acc_trans" violates foreign key constraint "cr_report_max_ac_id_fkey" on table "cr_report" DETAIL: Key (entry_id)=(25257) is still referenced from table "cr_report". CONTEXT: SQL statement "DELETE FROM acc_trans WHERE trans_id = in_id" PL/pgSQL function "draft_delete" line 9 at SQL statement at LedgerSMB.pm line 770. dbversion: 1.4.28, company: sswbooks How do I delete these unapproved transactions? Somehow the drafts are referenced in the reconciliations reports, I guess? -- ] Never tell me the odds! | ipv6 mesh networks [ ] Michael Richardson, Sandelman Software Works | network architect [ ] m...@sandelman.ca http://www.sandelman.ca/ | ruby on rails [ ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape _______________________________________________ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
