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
|