From: Luc v. S. <lu...@co...> - 2007-01-16 19:36:15
|
I started using SQL-ledger in nov 2006 and have been basically using it to do my purchase orders and by doing that I learned gradually. I postponed doing bookkeeing and sales bookings ( with a few exceptions ). Now I have been reviewing my ledger and discovered there are some mistakes here and there. I have setup the general ledger now and basically want to redo my work so everything works according this ledger. However I have not been able to easily undo all bookings and I have discovered that some things like services I can not alter the account at this moment. I have access to postgressql via PGadmin, but i am not knowledgable when it comes to postgress nor do I know enough about interdependecies within SQL-ledger. I looked at the reverse transactions possibility but nothing seems to happen ( I assume this is beacuse I did not log transactions) Next to that my database was setup in ASCIII encoding and PGadmin advices me to use UTF8. The questions: 1) Is there an easy way to start all over again whithout reentering all suppliers, customers, goods ?) 2) If not within SQl-ledger, can I just copy the tables out of ASCII encoded database an paste tese tables in a UTF8 database ? Thanks in advance for your quick reply Luc |