Re: [CK-Ledger-users] Directly editing data in the CK MySQL tables?
Status: Beta
Brought to you by:
ckwu
|
From: C K Wu <ck...@ch...> - 2004-07-30 11:29:45
|
Hi, Tony, I must apologise for missing your emails earlier. Apparently, my ISP=20 mail server's ip was being blacklisted and I got a total blackout for messages coming=20 from sourceforge.net. That causes me to miss your postings to the mailing list hosted at=20 sourceforge.net . By now, you probably noticed that I have released the first version of=20 CK-ERP. To check out the invoicing features of CK-ERP, you could visit the demo=20 site at, http://ck-ledger.sourceforge.net , which runs CK-Ledger 0.7.1 at the mome= nt. I'll upload CK-ERP 0.8.1 within the next day or two. If I can=20 successfully apply for a separate MySQL database to host CK-ERP, the demo site will be moved a litter later. I would certainly advise against inserting invoice transaction into the=20 database directly because invoices are fully linked to the other transactions, notably=20 accounting entries, payments and receipts. Perhaps, you could download the new CK-ERP softwa= re and test out the software first before deciding how to handle your=20 specific case. My brain is stuffed now having rushed to meet the July release deadline=20 for CK-ERP. I'll try to give your a more detail reply a little while later. Cheers, CK Tony Charles wrote: > =20 > Hello. > =20 > I'm thinking of using CK-ERP for my new business, but I'm not sure how=20 > easily it will integrate into my (planned) invoicing process. > =20 > I will charge my customers a very small fee each time they use my=20 > service. It doesn't make sense to invoice for each transaction, so=20 > I'll keep track of the transactions in my own MySQL table - and only=20 > invoice for the total amount after each 30 day period. (I'll also=20 > defer the invoicing process a few times, if the customer owes less=20 > than =A35). > =20 > 1) Is is okay for my invoicing script (Perl) to directly add=20 > invoices into the relevant CK-ERP table? I haven't installed CK-Ledger=20 > yet, because I'm waiting for CK-ERP (due in a week or two, right?=20 > :)). Can I assume that it will be easy to set things up in this way?=20 > Will I break anything in CK-ERP, if I enter transactions directly into=20 > the MySQL tables without telling CK-ERP about it? Do others do this=20 > kind of thing?=20 > =20 > 2) And what happens to an invoice once it has been entered into=20 > CK-ERP? Is there a "Print Invoice" function, for example? Can CK-ERP=20 > automatically issue reminders, if the invoice goes unpaid? (I'm=20 > planning to extend the Perl script so it handles these functions, but=20 > if CK-ERP does similar things, then I should obviously wait!)=20 > =20 > 3) Does it make sense for me to post a single transaction against the=20 > CK tables - which summarises all the transactions by a customer over=20 > the last 30 days? Or... should I be entering each small transaction=20 > into the CK tables as it is done by the customer, and then enter the=20 > invoice as a special record? > =20 > 4) How is an invoice even implemented in CK-ERP/Ledger? What module=20 > handles invoicing, if any? > =20 > Thank you!!! > =20 > Tony > =20 > Ps. I assume CK-ERP will still run on MySQL??? > =20 > =20 > =20 > =20 > =20 |