Re: [CK-Ledger-users] Directly editing data in the CK MySQL tables?

[C K Wu <ck...@ch...>]

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