ck-ledger-users — Mailing list and discussion group for CK-Ledger Users

Re: [CK-Ledger-users] How can I activate CK-Ledger Icons in the PHPGroupware toolbar?

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

Hi, Alessandro,

Thank you for checking out ck-ledger.

Both Marc Lutolf's and Chris Weiss' reply at [Phpgroupware-users] are
correct and relevant.  The detail steps are also recorded in CK-Ledger's
Installation Manual, available from the [Docs] section of the project's
summary page, http://sourceforge.net/projects/ck-ledger.  Step 12 to
step 23 of the Installation Procedure should help.

Cheers,
CK

Alessandro Bottoni wrote:

> I just tried to install ck-ledger 0.1.7 on PHPGroupWare 0.9.14 (It was the
> first time in my life I tried to install PHPGroupware...).
>
> Everything seems to be fine: the "setup" page of PHPGW shows all the
> CK-Ledger components, like all other applications, and allows me to install
> them. I have not got any error message so I suppose everything is working
> fine.
>
> Unfortunatley, the icons of CK-Ledger and the icons of many other
> PHPGroupWare applications (all of them correctly installed, apparently) do
> not show up in the PHPGroupWare toolbar (neither admin nor user's ones) so I
> cannot access these applications. I do not care about many other applications
> but CK-Ledger is crucial for me...
>
> Does anybody know how I can "activate" the application icons in the
> PHPGroupWare toolbar?
>
> As an alternative: does anybody know how I can acces these application in any
> other way (for example, writing the right application URL in the browser
> address's line)?.
>
> Thanks in advance.
>
> ---------------------
> Alessandro Bottoni
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users

[CK-Ledger-users] How can I activate CK-Ledger Icons in the PHPGroupware toolbar?

[Alessandro B. <ale...@li...>]

I just tried to install ck-ledger 0.1.7 on PHPGroupWare 0.9.14 (It was the 
first time in my life I tried to install PHPGroupware...).

Everything seems to be fine: the "setup" page of PHPGW shows all the 
CK-Ledger components, like all other applications, and allows me to install 
them. I have not got any error message so I suppose everything is working 
fine.

Unfortunatley, the icons of CK-Ledger and the icons of many other 
PHPGroupWare applications (all of them correctly installed, apparently) do 
not show up in the PHPGroupWare toolbar (neither admin nor user's ones) so I 
cannot access these applications. I do not care about many other applications 
but CK-Ledger is crucial for me...

Does anybody know how I can "activate" the application icons in the 
PHPGroupWare toolbar?

As an alternative: does anybody know how I can acces these application in any 
other way (for example, writing the right application URL in the browser 
address's line)?.

Thanks in advance.

---------------------
Alessandro Bottoni

Re: [CK-Ledger-users] Installation manual

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

Hi, Gene,

Thank you for your interest in CK-Ledger.  An installation manual
is available online at http://sourceforge.net/projects/ck-ledger.   Just
click on the [Docs] label at the header menu line above the brief
project description..

Cheers,
CK


Gene Leung wrote:

> Hi CK,
>
> It is great to have this kind of open source software.  However, it
> would be better to have an installation file to instruct how to setup
> your software.  Thanks!
>
> Best Regards
> Gene Leung
>
> -------------------------------------------------------
> This sf.net email is sponsored by: OSDN - Tired of that same old
> cell phone?  Get a new here for FREE!
> https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users

[CK-Ledger-users] Installation manual

[Gene L. <ge...@re...>]

Hi CK,

It is great to have this kind of open source software.  However, it
would be better to have an installation file to instruct how to setup
your software.  Thanks!

Best Regards
Gene Leung

Re: [CK-Ledger-users] Availability...

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

Hi, Alfredo,

I am afraid a standalone version of CK-Ledger is not available at
the moment.  Much of the substructure (screen handling, database
handling,
installation facility, etc) of CK-Ledger is provided by phpgroupware,
so it would be rather difficult to produce a standalone version.

However, I would encourage you to install phpgroupware and try out
CK-Ledger.  Assistance on phpgroupware installation is available from
phpgroupware's main site, www.phpgroupware.org and its user mailing
list, php...@gn....

Cheers,
CK

Alfredo de Oliveira wrote:

>
>
>
> Please, is there a version of CK-LEDGER that runs standalone (not over
> phpgroupware) ? It would be great to test it.!
>
> alf...@bc...
>
> Thanks.
> Alfredo.

[CK-Ledger-users] Availability...

[Alfredo de O. <alf...@bc...>]

Please, is there a version of CK-LEDGER that runs standalone (not over =
phpgroupware) ? It would be great to test it.!

alf...@bc...


Thanks.
Alfredo.

[CK-Ledger-users] CK-Ledger v.0.1.7 released

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

Hello, folks,

I have posted a new release, v.0.1.7, of CK-Ledger, at SourceForge.Net.

New features include bulk emailing of documents (invoice, reminder,
statement, receipt, PO, order acknowledgement, quotation) and addition
of unallocated amount to AP/AR aging reports.  Bug fixes are also
included.

Please note that Konqueror/KDE3/RedHat7.3 has problem accessing the
various features of CK-Ledger,  while Konqueror/KDE2/RedHat7.2 and other
browsers have been tested to work fine under similar circumstances.
Mandrake 8.2, with KDE upgraded to v.3.0.2 also functions properly.

CK-Ledger (with 11 modules, Ledger Admin, Ledger, Inventory, Service,
AP, AR, PO, SO, Quotation, POS for Cashier, POS for Manager) is modeled
on an Open Source accounting software and runs on top of phpGroupWare.
Operating platform can either be LAMP or LAPP.  It provides accounting
functionalities to SMEs and utilizes phpgw to administer
accounts/groups.  Installation Manual and Features List are available at
http://sourceforge.net/projects/ck-ledger.  Please report error and
suggestion to the mailing list, ck-...@li....
General history and expected development of CK-Ledger is available at
the mailing list's Archive.


Cheers,
Wu Chiu Kay, aka CK Wu, aka CK (CK is the preferred alias)
Hong Kong

[CK-Ledger-users] Re: Expanding timetrack

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

Hello, Brian,

What follows may sound a bit discouraging.

The difficulty in standardising on contact, project, task and employee tables is not
a technical one but rather a political consideration.  As Ralf Becker mentioned,
whatever method or mechanism is adopted, it requires the support and agreement
from maintainers of all the modules concerned.  And indeed I would stick to my
original design in separating the vendor and customer table, because, imho, that's
the basic requirement of an accounting system, lest the user of ck-ledger would be
criticised by the auditor for using a poorly designed system.  I would expect other
phpgw modules to carry other but similar considrerations.  As I mentioned from
the very outset, one of the reason why I started the separate ck-ledger project was
to avoid such lengthy political deliberation and possibly bickering.

Overall, my suggestion is that you go ahead and implement methods and schemes that
best meet your requirements.  Then you could post your code as part of phpgw
or as other pluggin modules.  If other developers feel that your mechanism is desirable,
they will modify their modules to fit in.

With regard to management approval before posting a invoice and tracking the progress
of such approval, a workflow infrastructure, similar to biztalk is required.  Afaik, this
is not
available within phpgw, or similar linux based groupware.  Since I am designing ck-ledger
for use by SMEs, I don't think such feature is a priority, unless xmlrpc can be expanded
to provide something similar to workflow management.

Since there is some interest expressed around this topic, I am sending a copy of this
email to php...@gn... and ck-...@li....

PS - If other developers are interested in feeding invoice data into ck-ledger to generate
        customer invoices, a rather crude approach is illustrated in the second last email
listed below.

Cheers,
CK



Brian Johnson wrote:

> In order for this to really work, we need a standardized contact module so that the
>  company id can be passed through correctly.  Please let me know as soon as you
> decide on how this should be done.  As discussed previously, I think external
> functionality would be best if the vendors and customers tables were one, but
> standardizing on a contact module for the customers would at least be a start.
>
> I guess we also need to standardize on project list and task list tables and fields
> in order to create invoices from the time info.  Will we also need a standardized
> emploee list? Is there anything I can do to help with these?
>
> You mentioned incorporating some of the timetrack features into a payroll module -
> keep in mind which users should have access to either - it might be most appropriate
> to have the payroll module separate from the time entry system
>
> I have modified Timetrack to allow project managers to assign a billout rate for
> each employee and a billout multiplier for each task (to allow for expanded
> functionality - like overtime at twice normal rate for example).  Also, a dollar
> value quote can be entered into the project description and the jobstatus page can
> show the current charges against a project (updated after each time record entry)
> compared to the quote so project managers can quickly see project finances.
>
> We also need a method to track employee disbursements and their repayment to the
> employee - of course in my world, it all needs to be assigned to projects.  Is there
> something I can do to help for this?  I suppose it should be part of the time entry
> system for user friendlyness.
>
> Our priority right now is to get a method for invoicing for time records so anything
> I can do to help get this done as soon as possible is a priority for me. One thought
> - currently there is a field to track if the record is to be billable or not ('Y' or
> 'N' char field) - we could also use that to track if a record has been posted (set
> billable to 'P') to an invoice
>
> For our purposes, we need a system to create a draft invoice from the time entries,
> allow it to be edited, printed, saved, reviewed by a project manager (sometimes the
> empoyees time descriptions aren't adequatley worded to send to the client or we want
> to combine entries and summarize somewhat), allow it to be loaded again, edited, and
> finally, actually posted to the accounting system (the time records would have to be
> marked to track where in the process they are in case a draft invoice is somehow
> lost in the system - we would want the time records to again be marked billable).
>
> Brian Johnson (bjo...@je...) wrote*:
> >
> >I'll give that a try
> >
> >I'm currently tweaking timetrack to suit our purposes and make it a little more user
> >friendly
> >
> >Did you read the emails from this morning from phpgroupware-developers regarding the
> >module record linking system.  Maybe we could use something like that for contacts,
> >ck-ledger, and timetrack
> >
> >Do you think you need to make a new module for entering time or just use timetrack
> >to feed info to other modules
> >
> >
> >
> >
> >C K Wu (ck...@ch...) wrote*:
> >>
> >>Hi, Brian,
> >>
> >>Sorry for the delay in replying your email.
> >>
> >>Directly feeding invoices into ck-ledger is perhaps not too good an idea, since
> >>it would bypass the built-in validation check.  The better arrangement is to
> >>feed the invoice data through to /ck-ar/invoicewtadd.php (if tax is involved)
> >>and invoke the script by opening a separate window.  User can then adjust the
> >>various data (tax,discount, ledger account etc)..  If everything is OK, the invoice
> >>can be posted
> >>normally as a new invoice.
> >>
> >>To check out the feasibility of the approach, I have done a bit of testing.  I have
> >>added
> >>a "Create Invoice" column to timetrack's Job Status List by adding,
> >>
> >>[Inside jobslist.tpl]
> >>
> >><th width="4%"><font......><</font></th>
> >>.....
> >><td width="4%"><font......><</font></th>
> >>
> >>
> >>[Inside jobslist.php, in between $t->set_var("row_delete","");    and
> >>$t->parse("rows","row",True); ]
> >>
> >>// -------------------------- Beginning of Added Code ------------------------
> >>
> >>        $t->set_var("lang_invoice", lang("Create Invoice"));
> >>        $invoicedata = array(   'customer'              => '10108' ,
> >>                                'transdate'             => '2001-11-01',
> >>                                'duedate'               => '2001-11-01',
> >>                                'invnumber'             => 'arinvwt3 duplicate' ,
> >>                                'ordnumber'             => 'sowt3' ,
> >>                                'taxstatus'             => 't' ,
> >>                                'itemid1'               => '10112' ,
> >>                                'description1'          => 'Consultancy' ,
> >>                                'qty1'                  => '2',
> >>                                'unit1'                 => 'day' ,
> >>                                'discount1'             => '' ,
> >>                                'sellprice1'            => '230',
> >>                                'itemid2'               => '10109' ,
> >>                                'description2'          => 'Testing Part 123' ,
> >>                                'qty2'                  => '2',
> >>                                'unit2'                 => 'box' ,
> >>                                'discount2'             => '' ,
> >>                                'sellprice2'            => '100'
> >>                                                                                ) ;
> >>
> >>        $getstring = "external=yes";
> >>        while (list($key,$value) = each($invoicedata)) {
> >>                $val = urlencode($value) ;
> >>                $getstring .= "&$key=$val" ;
> >>                }
> >>
> >>     $t->set_var("row_invoice", "<a href=\"" .
> >>$GLOBALS['phpgw']->link("/ck-ar/invoicewtadd.php",
> >>        "$getstring") . "\" target='_blank'>"
> >>        . lang("Create Invoice") . "</a>");
> >>
> >>// -----------------------------   End of Added Code
> >>------------------------------------
> >>
> >>
> >>and adjust invoicewtadd.php by adding,
> >>
> >>[Inside /ck-ar/invoicewtadd.php, just after  $_POST=$HTTP_POST_VARS ;
> >>$_GET=$HTTP_GET_VARS ; ]
> >>
> >>$external = ($_GET["external"] ? $_GET["external"] : $_POST["external"] ;
> >>if (isset($external))    $HTTP_POST_VARS = $_POST = $_GET ;
> >>
> >>
> >>When the user clicks on the "Create Invoice" link, invoicewtadd.php will be fired
> >>with
> >>embedded data for a duplicate of invoice# [arinvwt3], one of the five test invoices.
> >>After clicking on the [recal tax] buttons and posting the invoice, the user will have
> >>
> >>an exact duplicate of the [arinvwt3] test invoice.
> >>
> >>You could follow this sample and program the necessary getstring data into the
> >>"Create Invoice" link,
> >>or follow your own design.  The array $invoicedata above should be sufficient info on
> >>what data
> >>to be passed over to create an invoice.
> >>
> >>However, this is only a stop gap measure and there are a lot of drawbacks about this
> >>approach.
> >>Ultimately, I'll try to incorporate timetrack functionalities into a payrol module.
> >>
> >>
> >>Cheers,
> >>CK
> >>
> >>[PS - Modifications to invoicewtadd.php and invoicentadd.php will be incorporated
> >>into
> >>        the next release of ck-ledger]
> >>
> >>
> >>
> >>Brian Johnson wrote:
> >>
> >>> I am currently expanding the feature set of the timetrack module to set billout
> >>> rates for employees to multiply by the time entries
> >>>
> >>> Is there a way I can feed a list of entries to ck-ledger to create an invoice?
> >>>
> >>> How much of the information has to match up?  (ie contacts, tasks, anything else)
> >>>
> >>> Do you have any suggestions on how this SHOULD be done? (even if it isn't the
> >>> easiest way)
> >>
> >
> >
> >

[CK-Ledger-users] Re: Information flow example for consultant's accounting

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

Hello, Brian,

Long time no chat.  How's things ?

Brian Johnson wrote:

> It been a while but I've finally found the time to write this example of how our
> office, and I think most offices that bill for time, operate.
>
> Each employee records the time they spend on each project and provides a brief
> description of the activity the performed.  The time from the time sheets is used to
> create invoices for clients and also can be used as the basis for payroll.  All
> other processes are generally the same as a regular business (eg accounts payable,
> accounts receivable, bank account reconciliation, etc)
>
> The phpgroupware timetrack module does a pretty good job of tracking time spent on a
> project.  It has a list of clients, a list of projects, a list of employees, and a
> list of activities.
>
> The Ck-Ledger module does a pretty good job of the general accounting stuff.
>

Nice to know that CK-Ledger is helping you to run your business.  However, the
same old word of caution, the software is still in beta and bugs are inevitable.

>
> Basically we need a method of integrating the two modules to use the same client
> list, project list, employee list, and activity list for both modules.  Then we need
> to create a billout rate for each employee and import the time info and the billout
> rate info into an invoice.
>
> Is it practical to have information shared between modules?  Maybe some other
> module's code could be used to make more ck-ledger modules.
>

The best method is to have views on a comprehensive table, so the same
underlying table is used for all higher end applications/modules. However, this only
works with Postgres.  Mysql does not seem to be too keen on providing
'view' as a basic feature.

>
> Is it necessary to have the vendors separate from the customers?  We deal with a lot
> of companies who are both vendors to us and also customers.  I don't know all the
> intracacies of the coding, but it seems easy to just have one table with all the
> required fields. When I look at the database tables the vendor table only has two
> fields that aren't included in the customers table (I assume that terms and tax
> included would be different for customers and vendors).  In fact, if we shift the
> extra fields from both vendors and customers into separate tables (are vendortax and
> customertax one-to-one relationships with vendors and customers?) then the general
> contact information becomes completely independent of the accounting information for
> each company
>

From an accounting point of view, I would advise against consolidating vendor and
customer
records that belong to the same company.  This provides the temptation to
book off A/P bills as -ve A/R, ie, netting off A/P and A/R debts to give a single net
balance.
IFAIK, most country's GAAP specifically forbid the netting off of payables and
receivables
from the same company.  I have seen audit reports that criticise such netting off as a
major
weakness of the corporate accounting (computerised or otherwise) system.  But, again,
views would be a nice mechanism to present two different identities for the same
underlying
contact record.

>
> The addbook module is the first working contact module that separates the individual
> from the company, maybe that could be used as a master contact list since it also
> integrates with the email module.  There would have to be a check added to make sure
> that any contact removed or edited wouldn't cause a problem in ck-ledger

I will certainly look into addbook (and also cdb) to see how best to integrate
the various pieces of contact info.

>
> I have corresponded with the timetrack maintainer and he really isn't interested in
> taking his module any further than tracking time.  To integrate it well into
> ck-ledger, we might have to use his code as a starting point for another ck-ledger
> module.
>
> Basically, the above items are things that we (our company) needs.  If you think
> they're a possibility, I would be willing to work on the time tracking module to get
> it to use another contact list, project list, and activity list (currently it uses
> it's own) and to create/use a billout rate system.  I would likely need you to code
> the pulling of information from those tables into a ck-ledger invoice
>

Well, that's likely to be the next on the menu, project accounting and billing, but I
need
to check out timetrack and infolog first to see how their timing info is being stored
before
deciding how to proceed with the system design.

>
> PS I found a payroll deduction module source in Tcl for the Canadian tax system that
> maybe could be used to help with a payroll module

Please, do send me a copy of the source.  Would definitely be of help for the future
hr and payroll modules.

Cheers,
CK

[CK-Ledger-users] Re: CK-Ledger

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

Hi, Mark,

Thank you for your interest in CK-Ledger.

The straight answer to your question is "It is extremely
difficult".  It involves reproducing the infrastructure
provided by phpgroupware's API, which includes
screen handling, user account maintenance, database
abstraction, installation facility, etc.  In fact, it is the
existence of these infrastructure that allow me to
concentrate on the business logic and be able to
develop the system in a rather rapid fashion.

However, if your existing authentication system is
ldap based.  You may be about to integrate your
authentication mechanism with phpgroupware's.
But, I am totally ignorant in this area.  You can
get more info on this at the mailing list,

php...@gn...
php...@gn...

or at phpgroupware's website, www.phpgroupware.org

In addition, I like to add that CK-Ledger is still in beta,
so bugs are inevitable.

PS - I am sending a copy of this reply to
ck-...@li...,
so the others are aware of current development.

Cheers,
CK


Mark Kepley wrote:

> Hi CK, Kudos, you have put in a lot of hard work in the ledger
> system!! I' m look at your system from the POS to AR side.  What would
> it take to change the CL-Ledger so that it doesn't have to run on
> phpgroupware as I already have an authentication system in place? I'm
> looking to replace a legacy POS/AR system.  I plan to integrate into
> our main system on a GL or POS transaction level. Regards, Mark Kepley

[CK-Ledger-users] CK-Ledger v.0.1.5 released

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

Hello, folks,

I have posted a new release, v.0.1.5, of CK-Ledger, at SourceForge.Net.

New features include SO/quotation matching, conversion of PO/SO to
invoice,
auto-matching of invoice/PO, invoice/SO, payment/invoice,
receipt/invoice and
SO/quotation. Bug fixes are included.

Please note that quotations may be accepted more than once, therefore,
sum of
all SOs allocated to a single quotation may exceed the quotation's full
value.
Please also be advised that Konqueror/KDE3/RedHat7.3 has problem
accessing the various features of CK-Ledger,  while
Konqueror/KDE2/RedHat7.2
and other browsers have been tested to work fine under similar
circumstances.
Mandrake 8.2, with KDE upgraded to v.3.0.2 also functions properly.

CK-Ledger (with 11 modules, Ledger Admin, Ledger, Inventory, Service,
AP,
AR, PO, SO, Quotation, POS for Cashier, POS for Manager) is modeled on
an Open Source accounting software and runs on top of phpGroupWare.
Operating platform can either be LAMP or LAPP.  It provides accounting
functionalities to SMEs and utilizes phpgw to administer
accounts/groups.
Installation Manual and Features List for CK-Ledger are available at
http://sourceforge.net/projects/ck-ledger.  Please report error and
suggestion
to the mailing list, ck-...@li....  General
history and
expected development of CK-Ledger is available at the mailing list's
Archive.

Cheers,
Wu Chiu Kay, aka CK Wu, aka CK (CK is the preferred alias)
Hong Kong

[CK-Ledger-users] Re: CK Ledger Install and Test

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

Hi Marc,

Thank you for your interest in CK-Leger.

There is no preference settings in CK-Ledger.  The preference
menu display shown on the screen is for phpgroupware and
other phpgw modules.  The parameters for setting up CK-Ledger
is accessible at Ledger Admin -> Default Value.

Auto-allocation of invoice is currently not supported by CK-Ledger.
However, this feature had been developed, fully tested and will
be part of the next release, which is likely to be uploaded to
SourceForge over the coming weekend.  The new mechanism
include clearing of existing allocation, auto-allocation by matching
against oldest exact equal amount, and auto-allocation based on
a FIFO scheme.

Additional standard Charts of Accounts are most welcome.  The
more the merrier.  However, there are a few points worth noting,

a)    Please, draw up the new sample Chart of Accounts based
        on a fictitious company or organisation.  I would like to
        avoid any future lawsuit claiming intellectual property right
        or trade secret.

b)    Please, indicate what industry the fictitious company is in.

c)    Please, limit the number of accounts to under 50.

d)    Please, draw up the Chart of Accounts in the form of,

        A/C#, Description, Type (A|H), Charttype (A|L|Q|I|E)

        A (type)    - account
        H - heading
        A (charttype) - asset
        L - liability
        Q - equity
        I - income
        E - expense

        one account per line and inside a pure text (ASCII) file or
        send it to me as inline text of an email.

e)    Please, provide a brief description of the transactional
        (VAT/Sales) tax of the country concerned, so I can
        adjust the software accordingly.

f)    or, if you feel adventuresome, program the Chart of Accounts,
        yourself, ie, provide a  ..../ledadmin/adminbuild.php clone
        for the fictitious company.  After appropriate testing, I'll
        incorporate the new Chart of Accounts into the main
        CK-Ledger code.  And, of course, you are most welcome
        to localise CK-Ledger for your target country too.

Hope I have answer your query.

In addition, I like to add a word of caution.  CK-Ledger is
still in beta.  Bugs are inevitable, so you may like to test the
software thoroughly before deploying it in any real production
environment.

PS - I am forwarding a copy of this reply to
ck-...@li...,
so the others are aware of current development.

Cheers,
CK



Marc Lutolf wrote:

> Have started looking at this package and just wanted to say
> it's a nice piece of work! If you've really only been at it this
> year (!), well done.
>
> I am looking to replace an inhouse standalone receivables
> package (in Cold Fusion), and this might be an alternative.
> Among the things it does, however, is to allocate an invoice
> number automatically. Which neatly brings me to the
> question of preferences.
>
> OK, I've only been playing with this a couple of hours, but I
> have yet to figure out how to access the preference
> configuration. Or maybe it doesn't yet exist?
>
> Other question: presumably you are interested in more
> standard chart of accounts. I don't see a way to bulk load
> these in the app. I might be able to contribute one for
> Switzerland or Italy. What format would you want it in?
>
> Marc

[CK-Ledger-users] Konqueror/KDE3 and CK-Ledger

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

Hello, Folks,

Finally, I get a clearer picture with the issue of Konqueror/KDE3.

Yesterday, I installed Mandrake 8.2 and upgraded the KDE environment
to 3.0.2.  Everything was back to normal again.  So, I presume the
problem
lies with the KDE3.0.0 that comes native with RedHat7.3.

Cheers,
CK

[CK-Ledger-users] Re: CK-Ledger

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

Hi, Ron,

Your friend's concern is a valid one.

In fact, it is exactly because phpgroupware had to abide by the strict GNU

rules, that I decided to start CK-Ledger as a project separate from
phpgroupware and I believe php3 compatibility is one of the GNU
conditions.

My development environment uses php-4.06.7.  I have never tested
CK-Ledger against a pure php3 environment and I am pretty sure
that I have used some language constructs that can only be run against
php4.

PS - I am sending a copy of this reply to
ck-...@li...,
so the others are aware of current development.

Cheers,
CK

Ron Guerin wrote:

> Hi,
>
> A friend of mine asked me to find out if CK-Ledger is compatible with
> PHP3 and PHP4.  I had assumed it is since all PHPGroupware modules are
> supposed to be compatible with both, but I could not find that
> information on the SourceForge site.
>
> Thanks,
>
> Ron Guerin

[CK-Ledger-users] Phpgroupware RC4 + CK-Ledger

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

Hello, folks,

I have installed phpgroupware RC4 and tested it against ck-ledger
(v.0.1.3 + subsequent enhancement).

After initial login, there was an error message above the phpgroupware
display, which read,

Warning:  Supplied argument is not a valid File-Handle resource in
/var/www/html/phpgroupware/phpgwapi/inc/class.network.inc.php on line 81

[probably due to my firewall settings]

I, then, followed Chris Weiss' hack, in suppressing the timeserver sync,
ie,

within ..../phpgwapi/inc/class.datetime.inc.php,

commented out the line,   if (!$this->gmtnow &&
!@isset($GLOBALS['phpgw_info']['server']['tz_offset']))

and added below it,         if (false)

Everything went back to normal from then on, and all features of
ck-ledger functioned as previously.
All the while, register_globals was set to off.  [However, a word of
caution, though, while phpgwapi +
ck-ledger work with register_globals=off, other modules of phpgroupware
may not.]

I like to add my support to parameterising the timeserver sync so the
user can set it to 'on' or 'off' and
to choose which timerserver to use.

Cheers,
Wu Chiu Kay, aka CK Wu, aka CK (CK is the preferred alias)
Hong Kong

[CK-Ledger-users] Re: I want to join Your CK-Ledger project

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

Hi, Jacek,

Thank you for your interest in CK-Ledger.

My background and the general direction of CK-Ledger
is available from a email dated 16 Feb 2002, that I posted
to ck-...@li....  Actually, some
of the targets listed there had been accomplished.
ck-...@li... also carries info
on the latest development.  Notably, Geoff (from Australia)
is testing out the software and provides numerous enhancement
suggestions.  Robert del Huerto (from US) is developing a rental module.

You are most welcomed to put your Polish touch to CK-Ledger.
As to the actual participation process, my suggestions are,

a)    You could developed a sample (English-based) Chart of Accounts
        for a typical Polish company (say, an insurance company).
However, I
        would advise against transplanting the Chart of Accounts from
        your existing or ex-employer.  This would allow you to
familiarise with
        CK-Ledger's logic and php coding.  In terms of actual
programming work,
        it is mainly to provide a polish clone for
.../ck-ledadmin/adminbuild.php.
        However, you would have to consider in detail, the implications
of
        Polish transactional (sales/VAT) tax system, if it is in place
in Poland.
        Once it is tested to be working fine, I'll incorporate it into
the main
        CK-Ledger code as an Polish sample Chart of Accounts.

b)    Next, you could develop Polish translations for CK-Ledger, so the
        user interface can be localised for use in Poland.  Multilingal
support
        is provided by the underlying phpgroupware.  More detail info is

        available from www.phpgroupware.org and
php...@gn....

Hope this answers your query, and you are welcome to join any time.

PS - I am forwarding a copy of this reply to
ck-...@li...,
so others are aware of current development.

Cheers,
CK


Jacek Wolski wrote:

> Hi Wu!
>
> I reviewed your CK-Ledger, and I think this is the project I
> was looking for.
>
> First of all I want a well-structed, cleanly written,
> modular project with database abstraction layer and
> multilingual support - your application matches the
> requirements perfectly.
>
> My primary interest is creation of an open source accounting
> system.
> As a Pole, I think of creation of a system which will hold
> "international accounting schemes" templates, which will
> enable support of Polish law and language.
>
> As to my professional background I work for insurance
> company on HP/UX plus Oracle 8 database environment.
>
> I am strong with Unix scripting, database development and
> optimisation, medium with database design and next to green
> with PHP, yet as I know C well, I think that transition will
> not last to long.
>
> If you are interested please write something about you, and
> about roadmap of CK-Leger project.
>
> Bye
>
> Jacek

[CK-Ledger-users] Re: POS Interest

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

Hello, Quentin,

POS is definitely one major component of CK-Ledger.  However,
I must admit I have dead zero knowledge on cash register hardware,
so interfacing with such hardware is not my cup of tea.  If you
like to integrate Mercator/JavaPOS with CK-Ledger, it would be
a strategic good fit for both software.

My plan is to concentrate on the backend part of POS.  At the moment,
there are two specific enhancements that I will be working on,

a)    Sales Plan - blank fields are already left in the db tables in
anticipation of this feature.
b)    Sales Commission Calculation - this will be developed after
CK-Ledger's payrol module is completed.

Cheers,
CK



Quentin Olson wrote:

> Hello,
>
> Yes I did get things working and it looks really good. I realize it is
> beta software, that's ok. I intend to check it out for a while but
> first impressions are excellent. Initially I will export my
> transaction data to your tables, then see what it looks like, then try
> to do a gap analysis between the current functionality and the minimal
> required. I also have a set of cash office requirements laying around
> somewhere that I will try to forward to you.
>
> How much interest do you have in this area (that is integration with
> retail environments) and what are your plans for ck-ledger?
>
> -quentin
>
> C K Wu wrote:
>
>> Hi, Quentin,
>>
>> Thank you for your interest in CK-Ledger.  I gather that
>> you have subsequently downloaded v.0.1.3 and it works
>> fine.  So, do try out the software.
>>
>> I definitely love to hear any suggestion for improvement to
>> the software.  However, if you do plan to bid for any project,
>> using CK-Ledger as a part component, allow me to put in
>> a word of caution.  The software, itself, is still in beta,
>> so hidden bugs are inevitable.  At the same time, if I can assist
>> your project bidding in any way, do give me a yell.  However,
>> my plate is pretty full at the moment, so I do need quite a bit
>> of fore-warning.
>>
>> I am also forwarding a copy of this reply to
>> ck-...@li...,
>> so the others are aware of current development.
>>
>> Cheers,
>> CK
>>
>>
>>
>> Quentin Olson wrote:
>>
>>
>> > Hello,
>> >
>> > I am interested in your project. I have a related one
>> > (sourceforge.net/projects/mercator), a Java POS application.
>> > My project is a pure transaction engine and is currently in
>> > early production status, being used in some real businesses.
>> > I have need of a back office/cash office component which
>> > your projects seems to partially address. I would like to
>> > discuss your plans, I think I can give you a lot of input
>> > for the cash office piece (pos-m, pos-c) and am willing to
>> > help you develop it. I also know of  a project coming up
>> > (for public bid) where I need these components and your
>> > project seems to be the closest I've run into.
>> >
>> > I have installed your system but am having a little trouble
>> > getting it running (I submitted the "No =93Start Action=94
>> > button" help message.)
>> >
>> > Regards,
>> > Quentin Olson
>> >
> --
> Global Retail Technology, LLC
> www.globalretailtech.com
> +1 360.394.3726
> +1 360.981.9346 (mobile)
>
>
>

[CK-Ledger-users] Re: POS Interest

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

Hi, Quentin,

Thank you for your interest in CK-Ledger.  I gather that
you have subsequently downloaded v.0.1.3 and it works
fine.  So, do try out the software.

I definitely love to hear any suggestion for improvement to
the software.  However, if you do plan to bid for any project,
using CK-Ledger as a part component, allow me to put in
a word of caution.  The software, itself, is still in beta,
so hidden bugs are inevitable.  At the same time, if I can assist
your project bidding in any way, do give me a yell.  However,
my plate is pretty full at the moment, so I do need quite a bit
of fore-warning.

I am also forwarding a copy of this reply to
ck-...@li...,
so the others are aware of current development.

Cheers,
CK



Quentin Olson wrote:

> Hello,
>
> I am interested in your project. I have a related one
> (sourceforge.net/projects/mercator), a Java POS application.
> My project is a pure transaction engine and is currently in
> early production status, being used in some real businesses.
> I have need of a back office/cash office component which
> your projects seems to partially address. I would like to
> discuss your plans, I think I can give you a lot of input
> for the cash office piece (pos-m, pos-c) and am willing to
> help you develop it. I also know of  a project coming up
> (for public bid) where I need these components and your
> project seems to be the closest I've run into.
>
> I have installed your system but am having a little trouble
> getting it running (I submitted the "No =93Start Action=94
> button" help message.)
>
> Regards,
> Quentin Olson

[CK-Ledger-users] CK-Ledger v.0.1.3 released

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

Hello, folks,

I have posted a new release, v.0.1.3, of CK-Ledger, at SourceForge.Net.

New features include drill down from AP (vendor) aging report, AR
(customer) aging report, POS Cash Balance report, finetuning of cash
sale screen layout, adjustment to all scripts to allow
registered_globals=3Doff, addition of tabindex to major forms, addition o=
f
setup.inc.php files to allow faster phpgw setup, logic change to ensure
system exit to appropriate screen after creating new transaction items,
and logo being added to formal documents.

Provision for registered_globals=3Doff setting is implemented by adding,

 $_POST =3D $HTTP_POST_VARS;   $_GET =3D $HTTP_GET_VARS ;
 $var =3D ($_GET[=93var']) ? $_GET[=93var=94] : $_POST[=93var=94] ;

to the top of each php script file.  Only a minimal number of $var's are
initiated.  This way, the security provided by the =93off=94 setting is
maintained.

The drill down features implemented since v.0.1.1 was first proposed by
Geoff of Australia, and the initial set of setup.inc.php files was
provided by Sigurd of Norway.

Please note that Konqueror/KDE3/RedHat7.3 has problem accessing the
various features of CK-Ledger,  while Konqueror/KDE2 and other browsers
have been tested to work fine under similar circumstances.

CK-Ledger (with 11 modules, Ledger Admin, Ledger, Inventory, Service,
AP, AR, PO, SO, Quotation, POS for Cashier, POS for Manager) is modeled
on an Open Source accounting software and runs on top of phpGroupWare.
It provides accounting functionalities to SMEs and utilizes phpgw to
administer accounts/groups.  Installation Manual and detail Features
List for CK-Ledger are available at
http://sourceforge.net/projects/ck-ledger.  Please report error and
suggestion to the mailing list, ck-...@li....
General history and expected development of CK-Ledger is available at
the mailing list's Archive.

Cheers,
Wu Chiu Kay, aka CK Wu, aka CK (CK is the preferred alias)
Hong Kong

[CK-Ledger-users] Re: ck-ledger

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

Hello, Thomas,

Thanks for your interest in CK-Ledger.  Before answering your
query, please note that, earlier on, I have received a formal request
from the SQL-Ledger team to remove all reference to SQL-Ledger from
CK-Ledger and, in deed, since CK-Ledger, v.0.0.9.1, all such
references had been removed.

a)    SQL-Ledger's and CK-Ledger's table schemas are different.  Some
        of the tables and fields may have the same name, but they could
mean
        totally different things.

b)    I would advise against importing SQL-Ledger's SQL data directly
        into CK-Ledger.  It would be better to recreate your account
        balances, invoice balances, etc, within CK-Ledger at a fix point
in time
        (eg just after year end).  Moreover, SQL-Ledger's data structure
        does not support some of CK-Ledger's features, eg, ledger listing.

c)    CK-Ledger supports multiple ledgers, so if each company utilizes
        one or more ledgers, 'multiple companies' are supported.  However,

        multiple ledger setup does require quite a bit of manual tweaking
        of the underlying phpgroupware.

d)    There are too many differences between CK-Ledger and SQL-Ledger.
        You would have to test out the two software individually to find
out
        the numerous differences.

I am forwarding a copy of this reply to
ck-...@li...,
so others are aware of current development.

Cheers,
CK


"Thomas T. Thai" wrote:

> Hi CK,
>
> How close is CK-Ledger to SQL-Ledger? are the table schemas the same?
> I've been using SQL-Ledger, but I would like to import my SQL data to
> work with CK-Ledger.
>
> Does CK-Ledger support multiple companies? In SQL-Ledger, you have to
> create a different db for each company.
>
> What else is missing from CK-Ledger when compared to SQL-Ledger 1.8.4?
>
> --
> Thomas T. Thai
> Minnesota.com, Inc.

[CK-Ledger-users] Re: ck-ledger

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

Hello, Geoff,

I have posted a new release yesterday.  Other than
bugfixes, the major feature added is report drill
down.  I managed to solve the two major problems
that I mentioned earlier.

1.    Return path - I decided to open new windows
        for the drill down, so return path is no longer a issue.

2.    Too much concurrently access - Ledger Listing
        is now limited to cover a period < 200 days and
        concurrently access is barred by a resourcelock
        table [semaphore is just too difficult for me :-(  ] .

However, I am still a little concern about the combined
loading of ledger listing generation and other workloads
in an online environment.  Could you give me some feedback
performance-wise if you do decided to test out the
new release.  However, please be extra careful with
the testing, especially the resourcelock table.  If somehow
you got stuck, the resourcelock can be released by,

UPDATE resourcelock SET used_by = '' ;

With regard to invoice/receipt emailing, I thought this
has been implemented in the basic system, but are you
referring to bulk emailling of formal documents ?  Bulk
emailing is something that I am planning to work on soon.
It should be useful for Robert too for sending out monthly
rental invoices.

The other question about breaking away from phpgroupware
is a big decision.  There are pros and cons about it.  I am not
sure about the answer yet.  However, this is definitely something
to think about in the median future.

Thanks for all the suggestions.  I am sorry that I forgot to
put in an acknowledgement for your contributions when
releasing v.0.1.1.  I hope you don't mind.

Cheers,
CK


geoff wrote:

> Hi CK,
>
> Am running about 2000 transactions of our company
> accounts at the moment. I wish the phone would stop
> ringing so I could home in more on what I regard as
> the essential elements. I read the angst in the sql ledger
> letters and realize that too much complexity can be
> counter productive.
>
> CK ledger would be diificult for me to use without
> my small kluge to be able to drill down edit from
> reports (we have spoken about this before) I will also
> add an ability to email invoices/receipts and print reports
> if its not in the master plan. I will forward any  further
> wish list items as they come to mind now that your
> in a consolidation phase.
>
> And for the sake of a simple user interface / session handling
> module it would be easy to break out of phpgroupware
> (would anybody use its other facilities)
>
> Fantastic work - talk to you soon
>
> Geoff
>
> ----- Original Message -----
> From: "C K Wu" <ck...@ch...>
> To: "geoff" <ge...@qu...>
> Sent: 08 June, 2002 11:28 PM
> Subject: ck-ledger
>
> > Hello, Geoff,
> >
> > I've just completed the release of ck-ledger 0.0.11, which
> > is mainly for the addition of 2 POS modules.  The bugs and
> > enhancements  that you've identified will be the target of
> > the next release.
> >
> > Cheers,
> > CK
> >
> >

[CK-Ledger-users] Re: Subtle Bugs

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

Both of these bugs had been rectified in v.0.1.1 .

Cheers,
CK

C K Wu wrote:

> Hello, folks,
>
> I've found two subtle bugs with the codes that I wrote.
>
> 1.    When coding the $phpgw->link() function, sometimes I wrote it as
> $phpgw->link('/ck-ap/invoicentlist.php?filter=$filter'), when it shall
> have
> been $phpgw->link('/ck-ap/invoicentlist.php','filter=$filter').  It used
> to
> work.  However, after phpgwRC3, phpgw auto-append
> ?sessionid=..&domain=.. to the link() function output.  Therefore, the
> first case will end up as
> .../ck-ap/invoicentlist.php?filter=$filter?sessionid=..&domain=..
> causing the sessionid not being recognised, thus, session not verified
> and
> the screen jumps back to login display.  This will be rectified in the
> coming
> release.  In the meantime, you could search within each ck-ledger folder
> for,
> # grep link * | grep ?
> and change the erroneous function calls.  There shouldn't be too many of
> them.
>
> 2.    When updating a record, I use the logic of validation, posting,
> writing output
> onto screen.  This allows the result of validation/posting to be
> displayed along with
> the record details.  However, this has the unfortunate effect of having
> the
> validation and posting missing out on data that were generated during
> screen
> writing, like item totals.  I am working to rewrite the logic and a new
> release is
> expected within the next two weeks.  In the mean time, if you are using
> ck-ledger
> in any way, please ask your user(s) to press the "Update Fields" button
> at least
> once, before clicking the "Post/Update (invoice/journal/...)" button.
>
> Sorry for the oversight.
>
> Best Regards,
> CK

[CK-Ledger-users] Subtle Bugs

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

Hello, folks,

I've found two subtle bugs with the codes that I wrote.

1.    When coding the $phpgw->link() function, sometimes I wrote it as
$phpgw->link('/ck-ap/invoicentlist.php?filter=$filter'), when it shall
have
been $phpgw->link('/ck-ap/invoicentlist.php','filter=$filter').  It used
to
work.  However, after phpgwRC3, phpgw auto-append
?sessionid=..&domain=.. to the link() function output.  Therefore, the
first case will end up as
.../ck-ap/invoicentlist.php?filter=$filter?sessionid=..&domain=..
causing the sessionid not being recognised, thus, session not verified
and
the screen jumps back to login display.  This will be rectified in the
coming
release.  In the meantime, you could search within each ck-ledger folder
for,
# grep link * | grep ?
and change the erroneous function calls.  There shouldn't be too many of
them.

2.    When updating a record, I use the logic of validation, posting,
writing output
onto screen.  This allows the result of validation/posting to be
displayed along with
the record details.  However, this has the unfortunate effect of having
the
validation and posting missing out on data that were generated during
screen
writing, like item totals.  I am working to rewrite the logic and a new
release is
expected within the next two weeks.  In the mean time, if you are using
ck-ledger
in any way, please ask your user(s) to press the "Update Fields" button
at least
once, before clicking the "Post/Update (invoice/journal/...)" button.

Sorry for the oversight.

Best Regards,
CK

Re: [CK-Ledger-users] Screen Rendering by Konqueror

[robert <rd...@st...>]

> Konqueror/KDE3 is still working havoc with my installation of
> redhat7.3+phpgw+ck-ledger, while galeon behaves perfectly normal.
> If you got a different result with Konqueror/KDE3, could you share
> your experience with the list.
>

I'm also using redhat v7.3 but I'm using opera.  I've had no ill effects 
(yet).



robert

[CK-Ledger-users] Screen Rendering by Konqueror

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

Hello, folks,

I've found that if phpgw's template is set to idsociety justweb or
verdilak, then,
Konqueror, when rendering multi-sectioned screens (like the Invoice/PO
Matching View screen) will foul up the whole display.  With the other
templates, default and linux-at-work.de, screen rendering is OK.
Apparently,
this is due to the fact that the graphics navbar is occupying half of
left hand
margin.  Default template put the navbar at the top and linux-at-work-de
is
clever enough to allow the navbar to occupy the entire left margin.
I've
updated the Installation Manual to reflect this client browser
consideration.

Konqueror/KDE3 is still working havoc with my installation of
redhat7.3+phpgw+ck-ledger, while galeon behaves perfectly normal.
If you got a different result with Konqueror/KDE3, could you share
your experience with the list.

Cheers,
CK