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

[CK-Ledger-users] phpGroupWare 0.9.14.005 - PHP3 Compatiable Security and Bug Fix Release

[Dave H. <dav...@mb...>]

Hi all,

This release fixes some PHP3 compatibility issues, which were introduced
in 0.9.14.004. Please note not all apps work well with PHP3.

There is one calendar bug fixed in this release: moving entries to an
other user, when deleting an account. 

You can grab it via a cvs update or from http://phpgroupware.org/mirrors/

Cheers

Dave Hall
on behalf of the phpGroupWare Development Crew

[CK-Ledger-users] phpGW 0.9.14.004 and php3

[Dave H. <dav...@mb...>]

Hi all,

After the release of the 0.9.14.004 release we have discovered that
there is some php3 compatibility issues.  All php4 users are still
advised to update to 0.9.14.004, and we will have 0.9.14.005 which will
be 0.9.14.004 with php3 fixes will be out in the next 12hrs or so.

This only affects php3 users.  Sorry about this oversight.  This has now
been (or will be shortly) fixed in cvs, except for xmlprc and soap
(which will not be fixed).

Cheers

Dave

[CK-Ledger-users] phpGroupWare 0.9.14.004 - Security and Bug Fix Release

[Dave H. <dav...@mb...>]

Hi All,

All users should install this version.  There have been several
vulnerabilities discovered in previous versions of phpGroupWare.  One is
a Cross Site Scripting exploit - see
http://www.security-corporation.com/articles-20030702-005.html.  The
other unreported issue relates the Virtual File System being in the
document root - as of this release the vfs root must be out of the webroot.

Due to these security issues no previous versions of phpGroupWare will
be officially supported by the phpGroupWare crew.

There are some general bug fixes also included in this release.

Please download it from one of our mirrors -
http://phpgroupware.org/mirrors/

Cheers

phpGroupWare Development Crew

[CK-Ledger-users] Re: Simplified Chinese (zh) Translation

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

Hello, folks,

Somehow, in the original mail, I forgot to cc the ck-ledger-users list.

Best Regards,
CK

C K Wu wrote:

> Hello, folks,
>
> I have just posted 9 translation patches at savannah.gnu.org .
>
> The patches contain Simplified Chinese (zh) translation for the following
> nine modules:
> admin, calendar, email, forum, phpgwapi, preferences, projects, setup,
> todo.
>
> charset is defined to be gb18030, since afaik all software used in
> mainland China
> (the main region using Simplified Chinese) must support the gb18030
> charset.
>
> All credits should go to www.dottech.com.tw, which provides the
> original Traditional Chinese translation.  I only use an automatic
> conversion
> utility to convert the lang phrases from Traditional to Simplified
> Chinese.
>
> I don't intend to maintain the Simplified Chinese translation in future.
>
> My objective is to complete the Chinese language infrastructure within
> phpGroupWare as it stands currently, so when the next version of
> CK-Ledger is released, full Chinese language infrastructure is available.
> Therefore, feel free to take on the role of future Simplified Chinese
> translation maintainer.
>
> Best Regards,
> CK Wu
> Hong Kong

[CK-Ledger-users] Demo Site Rebuilt

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

Hello, folks,

I have rebuilt the demo site.  It is now running under,
phpGroupWare 0.9.14.003 + CK-Ledger 0.6.3.

The site is available at http://ck-ledger.sourceforge.net

Cheers,
CK

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

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

Hello, David,

Thank you for your interest in CK-Ledger.

It is a stated aim of this project that CK-Ledger will
run on Linux and that I am not going to develop a version
that is runnable on top of M$ Windows.  My objective
is to attract SMEs away from M$.

I have definitely put in codes that will cause problems
when being run on top of M$ Windows.  This strategy
will continue in future.

So, while your effort is much appreciated, I am afraid
you are doing a disservice for the project.

Cheers,
CK

David Crawford wrote:

> I have installed phpgroupware and ck-ledger on:
>
> Windows 98
> Apache 1.3.20
> MySQL 3.23.49
>
> and it seems to work OK. I will do some more testing and post the results here. If I have time I will try to fix any bugs I find.
>
> Regards
> David Crawford
>
> 110 Barnfield Avenue
> Kingston Upon Thames
> KT2 5RF
> United Kingdom
>
> Home: 020 8404 6757
> Mobile: 07761 823795
>
> Web: http://www.crawfordclan.pwp.blueyonder.co.uk
> --
> __________________________________________________________
> Sign-up for your own FREE Personalized E-mail at Mail.com
> http://www.mail.com/?sr=signup
>
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise solutions
> www.enterpriselinuxforum.com
>
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users

[CK-Ledger-users] CK Ledger on Windows

[David C. <dav...@in...>]

I have installed phpgroupware and ck-ledger on:

Windows 98
Apache 1.3.20
MySQL 3.23.49

and it seems to work OK. I will do some more testing and post the results here. If I have time I will try to fix any bugs I find.

Regards
David Crawford

110 Barnfield Avenue
Kingston Upon Thames
KT2 5RF
United Kingdom

Home: 020 8404 6757
Mobile: 07761 823795

Web: http://www.crawfordclan.pwp.blueyonder.co.uk
-- 
__________________________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup

Re: [CK-Ledger-users] Site down?

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

Hi, Marc,

Yes.  I've gone back to the demo site and the content somehow
has gone corrupted.  I'll rebuild the site over the next week.

Thanks for spotting the problem.

Cheers,
CK

Marc Lutolf wrote:

> I haven't been able to reach the demo site for a couple of days.
> Is there a problem with it?
>
> Marc
>
> -------------------------------------------------------
> Enterprise Linux Forum Conference & Expo, June 4-6, 2003, Santa Clara
> The only event dedicated to issues related to Linux enterprise solutions
> www.enterpriselinuxforum.com
>
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users

[CK-Ledger-users] Site down?

[Marc L. <mf...@ne...>]

I haven't been able to reach the demo site for a couple of days.
Is there a problem with it?

Marc

Re: [CK-Ledger-users] Importing Sales Transactions

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

Hello, Jon,

Thank you for your interest in CK-Ledger.

Unfortunately, currently, CK-Ledger does not have transaction
import facility.  You would need to transfer the transactions manually.

AFAIK, (phpgroupware + CK-Ledger) can co-exist with other
web applications within the same LAMP/LAPP environment on the
same machine.  However, because of the frequent new versions
of various LAMP/LAPP components, you may find a situation
where webapp1 requires MySQL 3.23, while webapp2 requires
MySQL 4.0, forcing you to run two different version copies of MySQL
on the same machine, if the two web applications are to run
concurrently on the same machine.

In terms of disruption to your existing server, my suggestion is
that you run the combined target environment (existing app +
phpgroupware + CK-Ledger) on a testing machine first before
actually deploying it back onto your existing server.

Cheers,
CK

Jon wrote:

>     New to ck-ledger....  Trying to figure out if this will work for me
> or not.
>
>     I've read and tried the demo but haven't been able to verify what I
> want and think I need is there or not.
>
>     I have a web site that retains sales transactions, etc.  I can
> export
> into a CSV file whatever I want... with a little coding for the specific
>
> data I want.  I want to be able to tally sales transactions to generate
> typical profit/loss information at regular intervals.  I want to be able
> to
> import this information to easily work with the data.  I think what I
> want
> to export for import is sales and purchase prices, tax if applicable,
> and shipping and handling charges.
>
>     I can handle apache, linux, MySQL, etc. as I have a server running
> all this
> now.  My guess ck-ledger can give me everything I'm looking for now plus
>
> a whole lot more that I don't yet realize I need.  Can I do what I'm
> looking for
> with ck-ledger ? Will I be able to install ck-ledger on my existing
> server with
> out disrupting what is there now (I mention that because it seems other
> packages
> requires a new installation of apache and MySQL) ???
>
> Any guidance appreciated.
>
> Jon
>
> -------------------------------------------------------
> 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] Importing Sales Transactions

[Jon <pr...@at...>]

    New to ck-ledger....  Trying to figure out if this will work for me
or not.

    I've read and tried the demo but haven't been able to verify what I
want and think I need is there or not.

    I have a web site that retains sales transactions, etc.  I can
export
into a CSV file whatever I want... with a little coding for the specific

data I want.  I want to be able to tally sales transactions to generate
typical profit/loss information at regular intervals.  I want to be able
to
import this information to easily work with the data.  I think what I
want
to export for import is sales and purchase prices, tax if applicable,
and shipping and handling charges.

    I can handle apache, linux, MySQL, etc. as I have a server running
all this
now.  My guess ck-ledger can give me everything I'm looking for now plus

a whole lot more that I don't yet realize I need.  Can I do what I'm
looking for
with ck-ledger ? Will I be able to install ck-ledger on my existing
server with
out disrupting what is there now (I mention that because it seems other
packages
requires a new installation of apache and MySQL) ???

Any guidance appreciated.

Jon

[CK-Ledger-users] Re: Features

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

Hello, Marin,

Thank you for your interest in CK-Ledger.

Lotus Notes style workflow management is being discussed at the
infrastructure level, ie as a feature of phpgroupware.
Once the workflow engine is completed by the phpgroupware
team, I'll try to apply it to CK-Ledger.

One of the basic premise of CK-Ledger is that it is for use by
SMEs, which do not have too much hardware, software nor
system admin resource.  Indeed, I would expect the accounting
manager to double as the system admin.  Therefore, any advanced
feature will definitely not be part of CK-Ledger's future plan.

CK-Ledger is definitely not designed to handle database of that
size.  With the early releases, I've tested the production of
ledger listing with 500,000 transactions.  It times out because
of the php sesssion time limit.  Therefore, short answer to your size
question is a definite 'no', because of the constraint posed by its
building blocks, php and web-based, etc.

Cheers,
CK

Marin Blu wrote:

> As I have testing almost all the open source projects for
> ERP&CRM&Accounting, I believe that your product is good
> but its missing some important modules
> Kindly note, that some Top level CRM packages, after 120MB
> DB have many problems.
>
> What about workflow management ? skills and escalations ?
> Do you have any plans ?
>
> Do you test your appl with 300-500MB Databases ?
>
> Keep the good work,
> Marin

Re: [CK-Ledger-users] Test Run CK-Ledger with RH9.0 and MK9.1

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

Hi, folks,

I have made a small progress.

Mandrake9.1 (Apache2.0.44, Mysql4.0, php4.2.2):
I have further installed php-xml-4.3.0-2mdk.i586.rpm from CD2.
Now, everything returns to normal.  However, I am not sure if
Mysql4.0 may carry some compatibility issues that have yet to
be discovered.

Mandrake9.1 (Apache2.0.44, Postgresql7.3.2, php4.2.2):
After installation of the php-xml rpm, things improve quite a
bit.  Login and going into ledadmin is now OK.  Deletion
of previous tables is OK.  However, creation of new postgresql
table (Admin/Setup -> Setup Data Tables) results in,

Fatal Error:  It appears that you have not created the database tables
for phpGroupWare.  Click here to run setup.

The same old Postgresql 7.3+ problem.  However, with this
Mandrake scenario, apparently, I can get thru phpgwapi correctly
and only some CK-Ledger scripts are malfunctioning due the
7.3+ problem.  At the same time, clicking the other CK-Ledger
icons displayed the index (index.php) page correctly, while clicking
other phpgw icons may or may not result in the same Fatal Error message.

I'll try to update the CK-Ledger codebase to work with Postgresql 7.3+
prior to the next release.

Cheers,
CK


C K Wu wrote:

> Hi, folks,
>
> I have test run phpGroupWare 0.9.14.002 + CK-Ledger 0.6.3 with
> RedHat 9.0 and Mandrake 9.1.  The result is not too encouraging.
>
> RedHat9.0 (Apache2.0.40, Mysql3.23.54a, php4.2.2) - Everything went
> OK.
>
> RedHat9.0 (Apache2.0.40, Postgresql7.3.2, php4.2.2):
> Installation of phpgroupware and ck-ledger is complete.  However, when
>
> clicking the ledadmin icon for the first time, the following error
> message appears,
>
> REG_EMPTY in /var/www/html/phpgw/phpgwapi/inc/functions.inc.php on
> line 637
> Fatal Error:  It appears that you have not created the database tables
> for phpGroupWare.  Click here to run setup.
>
> Apparently, this is due to Postgresql being upgraded to 7.3+.  Ralf
> Becker of
> the phpgroupware team made this remark when commenting on a reported
> and similar incidence,
>
> <remark>
> postgreSql 7.3.x is currently not supported by phpGroupWare, see
> http://www.phpgroupware.org/wiki/KnownIssues+0.9.14
>
> This happens because pgSql droped in 7.3 a lot of automatic
> conversation
> they done before and mysql still does. We will solve that problem with
>
> the upcomming .16 release, sheduled for may/june.
> </remark>
>
> This means the case would only be rectified after phpgw0.9.16 and at
> the same time,
> CK-Ledger's own code base would have to be updated to adjust to
> Postgresql7.3+
> requirements.
>
> Mandrake9.1 (Apache2.0.44, Mysql4.0, php4.2.2):
> Installation OK.  First login attempt failed, problem being default
> safe mode = on.
> It is a known problem that phpgroupware does not work with safte mode
> = on.
> Then, I install php-ini-4.3.0-1mdk.noarch.rpm from CD1.  The installed
> php.ini
> set safe mode = off and registered global = on.  This time, login
> screen carries
> the following message,
>
> Warning: dl() [function.dl]: Unable to load dynamic library
> '/usr/lib/php/extensions/xml.so' -
> /usr/lib/php/extensions/xml.so:  cannot open shared object file:  No
> such file or directory
> in /var/www/html/ckledger/phpgwapi/inc/xml_functions.inc.php on line
> 32.
>
> Mandrake9.1 (Apache2.0.44, Postgresql7.3.2, php4.2.2):
> The same result as with the Mysql case.  Presumably, there is also the
> Postgresql7.3+
> problem lurking in the background.
>
> Bottom line:  Only RedHat9.0 (Apache2.0.40, Mysql3.23.54a, php4.2.2)
> works
> at the moment.
>
> Cheers,
> CK
>

[CK-Ledger-users] Test Run CK-Ledger with RH9.0 and MK9.1

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

Hi, folks,

I have test run phpGroupWare 0.9.14.002 + CK-Ledger 0.6.3 with
RedHat 9.0 and Mandrake 9.1.  The result is not too encouraging.

RedHat9.0 (Apache2.0.40, Mysql3.23.54a, php4.2.2) - Everything went OK.

RedHat9.0 (Apache2.0.40, Postgresql7.3.2, php4.2.2):
Installation of phpgroupware and ck-ledger is complete.  However, when
clicking the ledadmin icon for the first time, the following error
message appears,

REG_EMPTY in /var/www/html/phpgw/phpgwapi/inc/functions.inc.php on line
637
Fatal Error:  It appears that you have not created the database tables
for phpGroupWare.  Click here to run setup.

Apparently, this is due to Postgresql being upgraded to 7.3+.  Ralf
Becker of
the phpgroupware team made this remark when commenting on a reported and
similar incidence,

<remark>
postgreSql 7.3.x is currently not supported by phpGroupWare, see
http://www.phpgroupware.org/wiki/KnownIssues+0.9.14

This happens because pgSql droped in 7.3 a lot of automatic conversation

they done before and mysql still does. We will solve that problem with
the upcomming .16 release, sheduled for may/june.
</remark>

This means the case would only be rectified after phpgw0.9.16 and at the
same time,
CK-Ledger's own code base would have to be updated to adjust to
Postgresql7.3+
requirements.

Mandrake9.1 (Apache2.0.44, Mysql4.0, php4.2.2):
Installation OK.  First login attempt failed, problem being default safe
mode = on.
It is a known problem that phpgroupware does not work with safte mode =
on.
Then, I install php-ini-4.3.0-1mdk.noarch.rpm from CD1.  The installed
php.ini
set safe mode = off and registered global = on.  This time, login screen
carries
the following message,

Warning: dl() [function.dl]: Unable to load dynamic library
'/usr/lib/php/extensions/xml.so' -
/usr/lib/php/extensions/xml.so:  cannot open shared object file:  No
such file or directory
in /var/www/html/ckledger/phpgwapi/inc/xml_functions.inc.php on line 32.

Mandrake9.1 (Apache2.0.44, Postgresql7.3.2, php4.2.2):
The same result as with the Mysql case.  Presumably, there is also the
Postgresql7.3+
problem lurking in the background.

Bottom line:  Only RedHat9.0 (Apache2.0.40, Mysql3.23.54a, php4.2.2)
works
at the moment.

Cheers,
CK

[CK-Ledger-users] CK-Ledger's medium term plan

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

Hi, folks,

I've just completed a comprehensive re-testing of CK-Ledger,
picked up and rectified a fair number of bugs and released v.0.6.3.

Currently, I have three immediate tasks:
.    test run phpgroupware0.9.14.002 + CK-Ledger0.6.3 on RedHat9.0
.    test run phpgroupware0.9.14.002 + CK-Ledger0.6.3 on Mandrake9.1
.    produce Chinese translations for CK-Ledger

At the same time, it seems to be an appropriate moment to step back and
review CK-Ledger's current status and to decide on CK-Ledger's next few
steps.

My own view on CK-Ledger's current status:
.    CK-Ledger is fairly complete feature-wise for use by SMEs
.    There are a  few brave souls that are employing CK-Ledger for
business use
.    CK-Ledger ranks equal with SQL-Ledger and NOLA feature-wise
.    CK-Ledger still lacks the multilingual appeal that SQL-Ledger has

Current efforts:
.    Marc and I are working on an alternative approach for CK-Ledger.
It is still
    in experimental stage.  More info will be available if the approach
proves to be feasible.
.    While working on the Chinese translation, I hope to rationalise the
multilingual
    environment of CK-Ledger to entice more developers to produce new
translations
    for CK-Ledger

Future targets and incremental development steps:
.    Release 1.0 - feature freeze at v.0.6.3.  Produce two more
maintenance release, v.0.6.5
    and v.0.6.7 to thrash out most of the remaining bugs.  Then, v.1.0.
.    Synchronize with phpgroupware1.0 - accounting feature freeze at
v.0.6.3.  Add features
    that phpgroupware requires of phpgw1.0 applications.  Then, release
CK-Ledger 1.0 at
    the same time as phpGroupWare1.0.
.    Establish a formal feature wishlist.  Prioritize items on the
wishlist and construct a formal
    development schedule for CK-Ledger based on the prioritzed wishlist.

Your thought, opinion (dissenting or otherwise), suggestion, proposal,
etc, etc are most welcome.

Cheers,
CK

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

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

Hello, folks,

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

New features include option for standard tax rate for all sales and
purchases, and add tax facility for (no tax) PO, SO and Quotation.
Other enhancements and numerous bug fixes are also included.

CK-Ledger (with 15 modules, Ledger Admin, Ledger, Bank Reconciliation,
Inventory, Service, AP, AR, PO, SO, Quotation, POS for Cashier, POS for
Manager, HR, Staff Self Service, Payroll) 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 and back office
functionalities to SMEs and utilizes phpgw to administer
accounts/groups.  Demo is located at http://ck-ledger.sourceforge.net .
The software is available for download at
http://sourceforge.net/projects/ck-ledger .   Please report error and
suggestion to the mailing list, ck-...@li....
General history and expected development 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: A possible bug

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

Hello, folks,

I finally manage to track down this bug. It is caused by the inventory
item - Kit (id#15030), not having its inventory account defined.
Kit is meant to be an assembly.  With the initial design, an assembly
is supposed to explode into smaller inventory parts and therefore
does not have its own associated inventory account.  However,
subsequently, I relax the design, allowing an assembly to be
bought and sold as a standalone inventory part.  In the mean
time, I forget to update the test data content that relates to Kit,
hence, the bug.

You could recreate the bug, by converting an existing PO to invoice.
First, delete all PO rows.  Then add a new row.  Set the inventory
part to Kit(id#15030).  Then post the resulting invoice immediately
without refreshing the screen.  The invoice will be posted.  If, you
then view the accounting entries of this invoice, you will see
a single Cr of A/P.

Again, this bug will affect all versions of CK-Ledger, and it will
be rectified in the next release.

Cheers,
CK


C K Wu wrote:

> Hello, folks,
>
> I guess this possible bug is just too difficult to recreate.  I guess I'll
> just
> give up and blame it on a communication or db update failure when
> Invoice#4321 was being created.  However, to provide monitoring
> over this issue, I am adding a background Dr/Cr balance check
> to the next release of CK-Ledger, so any imbalance can be catched
> at the earliest instance.  The check will be invoked when a module's
> [Report] menu choice is selected.  Hopefully, this will not add too much
> workload to the overall system and at the same time provide continuous
> monitoring without manual action being involved.
>
> Best Regards,
> CK
>
> C K Wu wrote:
>
> > Hello, folks,
> >
> > Recently, I had a look at the demo site at ck-ledger.sourceforge.net
> > and found the ledger to have a Dr/Cr imbalance.
> >
> > I suspect the imbalance may have been caused by the following sequence
> > of events,
> >
> > A PO#1234 (id#20022) purchasing 1 unit of Kit-15030 was created.
> > The PO was then converted to an AP invoice#4321 (id#20023) covering the
> > purchase of 1 unit of Kit-15030 costing 2300.
> >
> > This should have resulted in the following accounting entries,
> >
> > Dr     1520 - Inventory Hardware          2300
> > Cr     2100 - Accounts Payable                             2300
> >
> > Somehow, the Dr entry was not created or was deleted/edited out after
> > the creation.
> >
> > I have been trying to recreate the error using my own ck-ledger codes or
> > using
> > the codes at ck-ledger.sourceforge.net.  However, in each attempt, the
> > validation
> > checks had spotted the Dr/Cr imbalance and rejected my posting request.
> > So,
> > I am scratching my head, and wondering what's happening.
> >
> > I wonder if you could help by recreating the error at your testing
> > machine or by
> > logging into ck-ledger.sourceforge.net and diagnose the problem there.
> >
> > Thank you for your assistance in advance.
> >
> > Best Regards,
> > CK

[CK-Ledger-users] Re: A possible bug (this time with the reason)

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

Hello, folks,

Another Dr/Cr imbalance occurs at the demo site.  However,
this time with the added Dr/Cr balance check feature, I am able to
trace it to the following item fairly quickly,

Journal ID-20017, AR invoice#101

At the same time, I have been able to recreate the error.  The
AR invoice was created via "Add New (AR) invoice [with Tax]"
in the normal fashion.  Subsequently, the invoice was editted and
the tax status changed to "Tax exempt", causing the item to be
priced (with no tax) while retaining the tax entries in the resulting
journal, hence, the Dr/Cr imbalance.

I've yet to decide how best to rectify this error.  Meanwhile, please
look out for this bug in the software.  It should affect all versions
so far.  I'll try to put out a maintenance release to cover this bug.
at the earliest instance.

Cheers,
CK


C K Wu wrote:

> Hello, folks,
>
> Recently, I had a look at the demo site at ck-ledger.sourceforge.net
> and found the ledger to have a Dr/Cr imbalance.
>
> I suspect the imbalance may have been caused by the following sequence
> of events,
>
> A PO#1234 (id#20022) purchasing 1 unit of Kit-15030 was created.
> The PO was then converted to an AP invoice#4321 (id#20023) covering the
> purchase of 1 unit of Kit-15030 costing 2300.
>
> This should have resulted in the following accounting entries,
>
> Dr     1520 - Inventory Hardware          2300
> Cr     2100 - Accounts Payable                             2300
>
> Somehow, the Dr entry was not created or was deleted/edited out after
> the creation.
>
> I have been trying to recreate the error using my own ck-ledger codes or
> using
> the codes at ck-ledger.sourceforge.net.  However, in each attempt, the
> validation
> checks had spotted the Dr/Cr imbalance and rejected my posting request.
> So,
> I am scratching my head, and wondering what's happening.
>
> I wonder if you could help by recreating the error at your testing
> machine or by
> logging into ck-ledger.sourceforge.net and diagnose the problem there.
>
> Thank you for your assistance in advance.
>
> Best Regards,
> CK

[CK-Ledger-users] phpGroupWare 0.9.14.002 Bug Fix Release

[Dave H. <dav...@mb...>]

Hi all,

Finally the 0.9.14.002 is ready for you to play with.  Grab it from
http://www.phpgroupware.org/downloads/ .  This is the final bugfix
release for the 0.9.14 API. 

Please backup your db before installing the new version, as there is a
mandatory db update.  You must also run setup/config.

This is what you get:
* many improvements behind the scenes
* various fixes for many apps
* additional translations
* Improved php4 sessions support - including accesslog and sessions
count and listing (similar to db sessions)
* Better LDAP support

* For pgsql users:
- seperate LIMIT/OFFSET for pgSql 7.3
- DropTable: Fixed problems with sequnces, which prevent reinstallation
of apps
- AlterColumn: properly sets defaults and not-null-constrains

* For mysql users:
- error message includes the reason
- removed infinite loop in setup

* calendar: 
lot fixes around start/end of daylight-saveing-time (events/days double
or did show up on wrong days)

* Setup/Config: 
- changes in the lang-files (via cvs update) are detected now on login
and added automaticaly
- overflow in phpgw_config fixed
- security hole plugged

Thanks to all who have contributed to the release, especially Ralf
Becker, Lars Kneche, Chris Weiss, the various patch submitters and bug
reporters.

Have fun, and you know where to report any problems.

Cheers

Dave Hall (aka skwashd)

[CK-Ledger-users] Upgrade of Demo Site

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

Hi, folks,

The demo site at http://ck-ledger.sourceforge.net had been upgraded
to v.0.6.1.  Since the standard test data set gets re-generated, the
previous
Dr/Cr imbalance is no longer visible.

Having completed the Payroll module, I think CK-Ledger is now fairly
attractive in terms of being applied in an SME environment.

My current plan is to,

a)    Perform a comprehensive test on the existing CK-Ledger code to
        check out the integration of the more recently added modules.

b)    Develop Chinese translation for CK-Ledger

c)    Expand on the medium term plan of CK-Ledger based on
        phpgroupware's planned direction (re: version v.0.9.16 and 1.0)

Your comments and suggestions on how CK-Ledger should be developed
are most welcome.  Your remark on the Payroll module post evaluation
is also highly appreciated, especially if it is related to your local
payroll
requirements.

BTW, if you have been using CK-Ledger for a while, could you
describe a bit of your experience, say user friendness, learning curve,
etc, etc.  That would certainly help in deciding in future improvements
for CK-Ledger.

Cheers,
CK

Re: [CK-Ledger-users] feature request ... or at least suggestions ;-)

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

Hi, Thomas,

Thank you for your interest in CK-Ledger.

The 2nd question first.  From the very outset, I have decided not
to produce a script to convert sql-ledger data, because,

1)    I don't want to be seen as chasing after SQL-Ledger user base.
2)    I don't have enough knowledge about the internal workings of
        SQL-Ledger to produce such a script reliably, especially, when there are
        so many generations of SQL-Ledger versions, with different table structures.

The 1st question.  There are, indeed, many desirable features that
are targets for future releases of CK-Ledger.  Your suggestion is certainly
part of the wish list.  I am actually watching out for development within
phpgroupware itself.  I remember seeing someone suggesting a general
class for the production of pdf output.  Again, phpgroupware is moving
towards XSLT.  So, to answer your question, these features may be
implemented depending on the underlying infrastructure.  Or, you could
join us (the CK-Ledger team), and produce the required script.  I'll be more
than happy to incorporate your work into the CK-Ledger codebase.

Cheers,
CK


Thomas Seifert wrote:

> Hi folks,
>
> I just looked at ck-ledger (using sql-ledger until now) because I'm using some
> self-made php-scripts to work with the invoices generated in sql-ledger ... but
> it sounds not really good to mix php-scripts with perl-scripts in that place ;-).
>
> In many areas ck-ledger seems to have outstanding features but some are missing
> (at least IMHO).
>
> What about the tex-templates and the generated pdf-output of invoices? Are these planned
> or is there any real cause to keep away from them?
>
> Oh and is there any way to have a small script which converts the sql-ledger data to ck-ledger data?
>
> TIA,
>
> Thomas
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users

[CK-Ledger-users] feature request ... or at least suggestions ;-)

[Thomas S. <tho...@my...>]

Hi folks,

I just looked at ck-ledger (using sql-ledger until now) because I'm using some 
self-made php-scripts to work with the invoices generated in sql-ledger ... but
it sounds not really good to mix php-scripts with perl-scripts in that place ;-).

In many areas ck-ledger seems to have outstanding features but some are missing
(at least IMHO).

What about the tex-templates and the generated pdf-output of invoices? Are these planned
or is there any real cause to keep away from them?

Oh and is there any way to have a small script which converts the sql-ledger data to ck-ledger data?


TIA,

Thomas

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

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

Hello, folks,

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

New features include a Payroll module, background Dr/Cr balance check,
additional validation check on email delivery, staff self-lodged
expense/allowance claim.  Other enhancements and bug fixes are also
included.

Since payroll and salary calculation varies greatly depending on
individual legal and corporate requirements, I have designed the Payroll
module to provide a framework that is flexible enough to handle most
situations.  Specifically, I have chosen to implement PRC's individual
income tax and Hong Kong's Mandatory Provident Fund contribution.  The
former is a pay-as-you-earn type of payroll tax with progressive higher
tax rates.  The latter requires combined employer and employee
contribution to a pension fund.  These should provide a model for other
types of staff medical insurance, pension plan, etc or other legally
required deduction from staff salary.  If you have problem implementing
payroll requirements in your local region, please send a email to
ck-...@li... describing your local
requirements.  If these are generally required features,   I'll try to
add enhancements in future releases to cover these requirements.

CK-Ledger (with 15 modules, Ledger Admin, Ledger, Bank Reconciliation,
Inventory, Service, AP, AR, PO, SO, Quotation, POS for Cashier, POS for
Manager, HR, Staff Self Service, Payroll) 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 and back office
functionalities to SMEs and utilizes phpgw to administer
accounts/groups.  Demo site is located at
http://ck-ledger.sourceforge.net .   Installation Manual and Features
List are also 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: A possible bug

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

Hello, folks,

I guess this possible bug is just too difficult to recreate.  I guess I'll
just
give up and blame it on a communication or db update failure when
Invoice#4321 was being created.  However, to provide monitoring
over this issue, I am adding a background Dr/Cr balance check
to the next release of CK-Ledger, so any imbalance can be catched
at the earliest instance.  The check will be invoked when a module's
[Report] menu choice is selected.  Hopefully, this will not add too much
workload to the overall system and at the same time provide continuous
monitoring without manual action being involved.

Best Regards,
CK

C K Wu wrote:

> Hello, folks,
>
> Recently, I had a look at the demo site at ck-ledger.sourceforge.net
> and found the ledger to have a Dr/Cr imbalance.
>
> I suspect the imbalance may have been caused by the following sequence
> of events,
>
> A PO#1234 (id#20022) purchasing 1 unit of Kit-15030 was created.
> The PO was then converted to an AP invoice#4321 (id#20023) covering the
> purchase of 1 unit of Kit-15030 costing 2300.
>
> This should have resulted in the following accounting entries,
>
> Dr     1520 - Inventory Hardware          2300
> Cr     2100 - Accounts Payable                             2300
>
> Somehow, the Dr entry was not created or was deleted/edited out after
> the creation.
>
> I have been trying to recreate the error using my own ck-ledger codes or
> using
> the codes at ck-ledger.sourceforge.net.  However, in each attempt, the
> validation
> checks had spotted the Dr/Cr imbalance and rejected my posting request.
> So,
> I am scratching my head, and wondering what's happening.
>
> I wonder if you could help by recreating the error at your testing
> machine or by
> logging into ck-ledger.sourceforge.net and diagnose the problem there.
>
> Thank you for your assistance in advance.
>
> Best Regards,
> CK

Re: [CK-Ledger-users] table errors

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

Hello, Brian,

Yes.  Some of the table structure and naming may have been changed to cater
for improved processing and integration with new modules.

If table data is not important, I'll suggest the following process,

a)    Record all data that is additional to the standard test environment manually (on
paper)
b)    Do a data backup via Ledger Admin -> Data Backup
c)    Delete all existing ck-ledger tables via Ledger Admin -> Admin/Setup -> 4 -
Delete all Data & Data Table
d)    Recreate new ck-ledger table structure via Ledger Admin -> Admin/Setup -> 1 -
Setup Data Tables
e)    Build Chart of Accounts via Ledger Admin -> Admin/Setup -> 2 - Build Chart of
Accounts & other Master Data
f)    [Optionally] Create test data set via Ledger Admin -> Admin/Setup -> 3 - Create
Test Data
f)    Reinstitute the data recorded in step a)

The above process should not affect other phpgw tables within the same database.
However, I would still suggest test run the process on a test machine first.  At the
same time, the backup data obtained from step b) should allow you to recover to
earlier version if necessary.

I'll be releasing a new version, v.0.6.1, with a new payroll module within the next
couple of days.
So, if you could wait, I'll suggest holding off the data recovery process for a few
more days
to avoid repeating the process for upgrading to v.0.6.1.

Best Regards,
CK


Brian Johnson wrote:

> I upgraded to phpgw 0.9.14.001 and ck-ledger 0.5.1 and started to get table errors
>
> Looks like some field names have changed (mostly id names and sequence names)
>
> Any ideas on how to recover?  The table data is not important.
>
> --
> Brian Johnson
>
> This is where my witty signature line would be if I bothered to edit this line :)
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users