[CK-Ledger-users] Re: Porting of SQL-Ledger to run on top of phpgroupware

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

Hello, Brian,

Thanks for checking out CK-Ledger.  Nice to hear that the
software is useful in an actual business setting.

Brian Johnson wrote:

> Awesome idea!
>
> This has a lot of potential and thanks for all the work already done.
>
> I have a couple of feature requests:
>
> 1. could the main contact/company info be the phpgroupware addressbook?  It
> would be great if there was one contact database.  It seems logical that the
> main phpgw addressbook should be the one used.  This would allow the
> reduction of duplication of identical information and therefore optimization
> of the database
>

This is definitely the way to go.  However, there was discussion on a major
overhaul of phpgroupware's addressbook/Infolog around June last year with
the possibility of adding a CRM module.  I would probably wait until the
formal release of phpgroupware 0.9.14 before working on the integration.

>
> 2. could we integrate it with a time tracking utility to allow users to
> input time and charge it based on time spent (I'm in a service industry
> where we bill based on time).  I have modified the timetrack module to work
> this way - I could send you the code.  It allows users to create a project
> linked to a contact in the addressbook and then enter time for each project.
> Currently, I set a billout rate for each employee so that we can track it
> against budget figures but there is no method for invoicing.  The automatic
> linking of this time info to your ledger package for billing and payment
> tracking would be ideal.  Unfortunately, the service module currently would
> require us to summarize the time info and manually create invoices
>
> I'm desperately looking for a replacement to Quickbooks Pro and your package
> seems like a potential winner!  You may be surprised to note that despite
> the large numbers of SME that bill based on time (pretty much all
> consultants), there are hardly any accounting packages that can handle their
> needs.  Quickbooks Pro is about the only one, and it still has definite
> problems.
>
> I'm not a programmer, but I can do a bit of php coding modification and I
> certainly can help you layout a program flow algorithym prior to
> programming.

Please, do send me the code.  This is exactly what I envisage to be the benefit
of porting SQL-Ledger over to phpgroupware.  Please also send me your program
flow algorithm, especially if it fit with your business' manual billing
workflow.

By the way, if you find any major error with CK-Ledger-0.0.5, do give me
a yell.  I am planning to upgrade the project from pre-alpha to alpha.

Best Regards,
CK