[CK-Ledger-users] Directly editing data in the CK MySQL tables?
Status: Beta
Brought to you by:
ckwu
|
From: Tony C. <ton...@bt...> - 2004-07-25 12:10:23
|
=20 Hello.=20 =20 I'm thinking of using CK-ERP for my new business, but I'm not sure how easily it will integrate into my (planned) invoicing process. =20 I will charge my customers a very small fee each time they use my service. It doesn't make sense to invoice for each transaction, so I'll keep track of the transactions in my own MySQL table - and only invoice for the total amount after each 30 day period. (I'll also defer the invoicing process a few times, if the customer owes less than =A35). =20 1) Is is okay for my invoicing script (Perl) to directly add invoices into the relevant CK-ERP table? I haven't installed CK-Ledger yet, because I'm waiting for CK-ERP (due in a week or two, right? :)). Can I assume that it will be easy to set things up in this way? Will I break anything in CK-ERP, if I enter transactions directly into the MySQL tables without telling CK-ERP about it? Do others do this kind of thing? =20 2) And what happens to an invoice once it has been entered into CK-ERP? Is there a "Print Invoice" function, for example? Can CK-ERP automatically issue reminders, if the invoice goes unpaid? (I'm planning to extend the Perl script so it handles these functions, but 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 CK tables - which summarises all the transactions by a customer over the last 30 days? Or... should I be entering each small transaction into the CK tables as it is done by the customer, and then enter the invoice as a special record? =20 4) How is an invoice even implemented in CK-ERP/Ledger? What module 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 |