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

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

Hi, Brian,

I'll check it out and see how to integrate it with CK-Ledger.

Cheers,
CK

Brian Johnson wrote:

> Here's the timetrack module that we modified
>
> I've forgotten what state we left it in since it didn't do a clean install
> when we first got it but I think we left it pretty clean
>
> Extract the files into a diretory called timetrack below your phpgroupware
> directory
>
> You will likely have to run the sql scripts in the setup/sql directory
>
> It is also important that you create TTrack_Managers and TTrack_Payroll user
> groups and add yourself to them
>
> I'll help you set it up on your system if you run into problems. I'm going
> to try to figure out pgdump so that it will be easier to set up the tables
> in postgresql
>
> I'll forward a summary of the way I think a time billing system should sork
> from a services industry perspective in the near future
>
> -----Original Message-----
> From: C K Wu [mailto:ck...@ch...]
> Sent: Monday, February 18, 2002 8:28 PM
> To: Brian Johnson; ck-...@li...
> Subject: Re: Porting of SQL-Ledger to run on top of phpgroupware
>
> 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
>
>   ------------------------------------------------------------------------
>                     Name: timetrack.zip
>    timetrack.zip    Type: Zip Compressed Data (application/x-zip-compressed)
>                 Encoding: base64