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

[CK-Ledger-users] Re: can't get CK-Ledger running

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

Hi, James,

Thank you for checking out CK-Ledger.

james wrote:

>Hi=20
>Could someone help me out?
>I'm using phpgroupware 0.9.14.007  with SuSe 9.0 and it is working just =
fine.
>but I tried to install CK-Ledger it failed.
>
>I followed the manual:=20
>I did extract code into 15 folders, ck-ledadmin, ck-ledger, ck-bank, ck-=
inv,=20
>ck-service, ck-ap, ck-ar, ck-po, ck-so, ck-quote, ck-pos-c,ck-pos-m, ck-=
hr,=20
>ck-sss, ck-payroll   in the same folder is phpgroupware.
>
>
>11.Login phpgroupware as administrator.=3D  root , it is ok
>12.Invoke admin (the castle icon) module. =3D it means click on admin ic=
on ? if=20
>so I did.
> =20
>
Yes.

>13.Pick the =E2=80=9CApplications=E2=80=9D choice. =3D this is what I ca=
n't find=20
> =20
>
After clicking the admin icon, you would have a display similar to the=20
following,

[castle icon]  Admin

. Site configuration
. Peer servers
. User accounts
. User groups
. Applications                       [<- this is the "Applications"=20
choice, click on this link]
. Global Categories
=2E
=2E

>So what I'm doing wrong ?
>
>thanks
>James
>
>
>
> =20
>

Just as a reminder, the latest version of CK-Ledger, 0.7.3, will not=20
work with
phpgw 0.9.14.  The following are working combinations,

CK-Ledger 0.7.3 + phpgw 0.9.16 (all release candidates)
CK-Ledger 0.7.1 (and below) + phpgw 0.9.14 (up to .007)

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

Cheers,
CK

[CK-Ledger-users] Email Address Change

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

Hello, Folks,

My email address had reverted back to,

ck...@ch....

There are just too many spams going to ck...@ho...,
which will be cancelled by early Feb 2004.

Cheers,
CK

Re: [CK-Ledger-users] Simplified Chinese Database Problem

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

Hi, Thomas,

Thank you for checking out CK-Ledger.

Chinese is not a required setting for CK-Ledger.  In fact, the setting is
controlled by the underlying phpgw and by default it is switched off.
The error that you encountered is caused by phpgw changing the
name of the language table when it evolves from 0.9.14 to 0.9.16.
Because of this and some other even more substantial changes
to phpgw, ck-ledger-0.7.3 is not compatible to phpgw 0.9.14.

My best advice is to run,

phpgw.0.9.16RC1 + ck-ledger-0.7.3   (the latest fully tested 
combination) [If you can't get hold of RC1, go for RC2]

or,   phpgw0.9.14.007 + ck-ledger-0.7.1

CK-Ledger-0.7.3 is the latest tested beta version of CK-Ledger.

Cheers,
CK



Thomas Switala wrote:

>Hi
>
>I installed phpgroupware-0.9.14.007 on a Fedora system.
>
>I am using ck-ledger-0.7.3 and Installed it fine, when I create the database
>it gives me a problem it can
>not find the 'Simplified Chinese languages' zh. Is this going to be vital to
>a system that is going to be only
>in English. Is there a way that I can switch of the Chinese language
>settings.
>
>Please assist.
>
>--
>Warm Regards
>Thomas I. Switala
>CTO and Lead Systems Architect Genotribe Ltd
>
>--
>Cell :    +27-82-822-5080       (South-Africa)
>            +234-803-794-8252   (Nigeria)
>IM:       gen...@ja...   (Jabber)
>            genotribe                                        (Yahoo)
>
>
>
>
>-------------------------------------------------------
>The SF.Net email is sponsored by EclipseCon 2004
>Premiere Conference on Open Tools Development and Integration
>See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
>http://www.eclipsecon.org/osdn
>_______________________________________________
>CK-Ledger-users mailing list
>CK-...@li...
>https://lists.sourceforge.net/lists/listinfo/ck-ledger-users
>
>
>  
>

[CK-Ledger-users] Simplified Chinese Database Problem

[Thomas S. <ti...@ge...>]

Hi

I installed phpgroupware-0.9.14.007 on a Fedora system.

I am using ck-ledger-0.7.3 and Installed it fine, when I create the database
it gives me a problem it can
not find the 'Simplified Chinese languages' zh. Is this going to be vital to
a system that is going to be only
in English. Is there a way that I can switch of the Chinese language
settings.

Please assist.

--
Warm Regards
Thomas I. Switala
CTO and Lead Systems Architect Genotribe Ltd

--
Cell :    +27-82-822-5080       (South-Africa)
            +234-803-794-8252   (Nigeria)
IM:       gen...@ja...   (Jabber)
            genotribe                                        (Yahoo)

Re: [CK-Ledger-users] How do I get old messages in this list

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

Hi, Metta,

Bhikkhu Mettavihari wrote:

>On Sun, Jan 18, 2004 at 05:16:25PM +0800, C K Wu wrote:
>
>Hi, CK
>
>Thanks for being around.
>
>  
>
>>For ck-ledger-users, the equivalent website is,
>>http://lists.sourceforge.net/lists/listinfo/ck-ledger-users
>>    
>>
> 
>  
>
>>However, if I remember correctly, sourceforge does not build monthly nor
>>yearly index files for mailing lists hosted at their site, so wget[ting] 
>>from their website may not work.  It may be the case that viewing each email
>>by browser access is the only method provided by sourceforge.
>>    
>>
>
>You are right,
>The site did not have anything useful
>I think the files are laying some other place and we have no access to them.
>
>Anyway I made the install and the test with out much of problems.
>Just a few bad settings in some of my mysql setup which caused me having
>a few problems with phpgroupware.
>
>I have now installed all and looked at your test file in the setup.
>You have a nice installation with step by step to follow.
>
>
>
>After Installation is there any way I can import my data into mysql tables.
>  
>
Currently, there is no mass data import facility available.  I am afraid 
you would have to input the data manually.

>We sell books.
>
>We have round 4000 items of Books.
>We seem to have more information in the inventory than you have on the form.
>how about expanding the table with more data.
>  
>
It is difficult to design a general purpose inventory record layout to 
meet every organisation's requirement.  However, if you could describe 
your inventory info, I may be able to change the inventory record layout 
in future releases if the requirement is of general interest.

>I have a list of vendors
>
>I have a list of customers
>
>What is the next step I should try at.
>  
>
At this point, I like to add a standard ridder before going further.  
CK-Ledger is still in beta, so bugs are inevitable.  Using CK-Ledger in 
a production environment does carry substantial risk, so regular backup 
is very much mandatory.

I would suggest the next step is to test out CK-Ledger fully to see if 
it meets your processing requirement.  If the answer is confirmative, 
then plan your data conversion/master data creation carefully.  You may 
have to re-do the data conversion again in the future since it is likely 
the vendor/customer record layout will be changed once phpgw 0.9.16 
stabilises, and I would not promise auto-conversion of legacy CK-Ledger 
data to accord with future record layout.  If you are looking for 
documentation to guide you thru' the process, I am afraid no such 
documentation is available.  My best advice is for you to sit down with 
your accountant to plan out the process and yes, the accountant needs to 
be a very experienced one too.

Cheers,
CK

>regards
>Metta
>
>ps. Bhikkhu is a title like Mr, and mean Monk. 
>my name for short would be Metta
>
>  
>

Re: [CK-Ledger-users] How do I get old messages in this list

[Bhikkhu M. <ck...@bp...>]

On Sun, Jan 18, 2004 at 05:16:25PM +0800, C K Wu wrote:

Hi, CK

Thanks for being around.

> For ck-ledger-users, the equivalent website is,
> http://lists.sourceforge.net/lists/listinfo/ck-ledger-users
 
> However, if I remember correctly, sourceforge does not build monthly nor
> yearly index files for mailing lists hosted at their site, so wget[ting] 
> from their website may not work.  It may be the case that viewing each email
> by browser access is the only method provided by sourceforge.

You are right,
The site did not have anything useful
I think the files are laying some other place and we have no access to them.

Anyway I made the install and the test with out much of problems.
Just a few bad settings in some of my mysql setup which caused me having
a few problems with phpgroupware.

I have now installed all and looked at your test file in the setup.
You have a nice installation with step by step to follow.



After Installation is there any way I can import my data into mysql tables.

We sell books.

We have round 4000 items of Books.
We seem to have more information in the inventory than you have on the form.
how about expanding the table with more data.

I have a list of vendors

I have a list of customers

What is the next step I should try at.

regards
Metta

ps. Bhikkhu is a title like Mr, and mean Monk. 
my name for short would be Metta

-- 
A saying of the Buddha from http://metta.lk/ 
Well awakened the disciples of Gotama ever arise - they who by day and night always contemplate the body. 
Random Dhammapada Verse 299  
 

Re: [CK-Ledger-users] How do I get old messages in this list

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

Hi, Bhikkhu,

Thank you for your interest in CK-Ledger.

Since the ck-ledger-users mailing list is run under a mailman
environment, you would probably have a better feature
clarification if you send your query to mailman's user list at,
mai...@py... .  It may also help if you
indicate whether you wish to download recent emails for
offline reading or whether you like to have a command
for continue retrieval of emails so you could rebuilt the
mailing list at metta.lk  for mirroring.

Cheers,
CK

PS - I am sending a copy of this reply to php...@gn...
since you seems to have sent the same query to phpgw's user list.



Bhikkhu Mettavihari wrote:

>Hi all,
>
>I am just new to this list,
>and would like to get a copy of the last 100 messages
>in this list
>
>On other lists there is a command to send to the server
>which will send me the last messages,
>but in help there does not seem to be any facility
>to retrieve old list-mails.
>
>Do you have a command that can help me
>as I do not have direct access to the net,
>but have to go out to browse the Net.
>
>regards
>Mettavihari
>
>  
>

Re: [CK-Ledger-users] How do I get old messages in this list

[Jason F. <ja...@fl...>]

On Saturday 17 January 2004 3:03 am, Bhikkhu Mettavihari wrote:
> Hi all,
>
> I am just new to this list,
> and would like to get a copy of the last 100 messages
> in this list
>
> On other lists there is a command to send to the server
> which will send me the last messages,
> but in help there does not seem to be any facility
> to retrieve old list-mails.
>
> Do you have a command that can help me
> as I do not have direct access to the net,
> but have to go out to browse the Net.
>
> regards
> Mettavihari


How about reading through the archives:
http://sourceforge.net/mailarchive/forum.php?forum=ck-ledger-users


-- 
Jason Flatt (jason @ flattfamily . com)
Father of five (http://www.flattfamily.com/)
Linux user (http://www.sourcemage.org/)
IRC Nick: Oadae  Channels: #sourcemage, #lvlug  Server: irc.freenode.net
PGP Key: E992213F - 0254 9DB7 BE0E 312D 8352 6E39 0700 FB95 E992 213F

[CK-Ledger-users] How do I get old messages in this list

[Bhikkhu M. <ck...@sa...>]

Hi all,

I am just new to this list,
and would like to get a copy of the last 100 messages
in this list

On other lists there is a command to send to the server
which will send me the last messages,
but in help there does not seem to be any facility
to retrieve old list-mails.

Do you have a command that can help me
as I do not have direct access to the net,
but have to go out to browse the Net.

regards
Mettavihari

-- 
A saying of the Buddha from http://metta.lk/ 
I do not call him a Brahmana merely because he is born of a (Brahmin) womb or sprung from a (Brahmin) mother. He is merely a "Bhovadi" (one addressed as "Sir") if he is with impediments. He who is free from impediments, free from clinging - him I call a Brahmana. 
Random Dhammapada Verse 396  
 

[CK-Ledger-users] RE: (Feature) Request (for CK-Ledger)

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

Hello anupam,

I read your post with interest. As CK pointed out, I am offering CK-Ledger
running on top of the Xaraya applications framework. If you are familiar
with Envolution you may know that Xaraya, like Envo, is a PostNuke fork. Let
me also state that I'm involved in the Xaraya project, so please take that
into consideration as I state my views :)

First of all, you're not shy about that feature request :), it's pretty
massive. I think CK is spot on with his observation that integration should
be handled by the middle layer, i.e. phpgw, egroupware, Xaraya, Envo, what
have you. So the first task is to settle on a framework. CK has already
stated the position with respect to the first 2, my commitment is to the
third. As to Envolution, I'll make the following comments, which will
probably raise some hackles, but which I think prospective porters need to
understand.

Of all the *Nuke forks Envolution is probably the most risky gamble at this
time. About half a year ago another fork led to a majority of the Envolution
developers moving to MaxDev. Since then Envolution has shut down all non-US
support sites, and this has led to a further reduction of its user base.
Finally, the project is working on a total rewrite of its CMS, which
introduces another uncertainty into the equation. For all I know in a year
Envolution will be top dog, but for now it's in  weeak position IMHO.

At Xaraya we are exploring ways in which the Ledger module might be linked
up to a port of the PostNuke pncommerce module and to John Cox's Paypal
module being developed on Xaraya. So we are moving in a slightly different
direction (e-commerce) than what your feature request proposes.

If you have your heart set on a *Nuke middleware layer, I know for a fact
that the pncommerce team would be interested in porting CK-Ledger to
PostNuke, but there may be a resource problem. So if you think you could
lend a hand in that effort, I'm sure they would be interested to hear from
you (www.pncommerce.com). Alternatively you might raise your feature request
with the people at MaxDev (www.maxdev.com). Their site states a commitment
to business applications iirc, so you might find interest there. They also
probably have the developer base that could take on a project like this.
Only downside (if you can call it that) is that they are heavily Italian
based IMHO. On the other hand PHP is PHP, whether in English or Italian :)

As to DCL there is a lot going on in that niche. DCL has been the best
trouble ticket system in PHP for a while IMHO, but I personally was never
too satisfied with its email gateway solution. I understand there is now a
PHP version of bugzilla out (haven't looked closely), so maybe there will be
another option there.

Just some food for thought,

Marc

-----Original Message-----
From: C K Wu [mailto:ck...@ch...]
Sent: Wednesday, January 14, 2004 4:55 AM
To: anupam anand; mf...@ne...; ck-...@li...;
php...@gn...
Subject: Re: (Feature) Request (for CK-Ledger)


Hello, anupam,

Thank you for your interest in CK-Ledger.


anupam anand wrote:

>Integrate DCL + egroupware + ck-ledger + good(lean -
>
>elegant/corporate look) themes/templates + jetbox/jetstream
>
>+ envolution
>
>
>
CK-Ledger will remain with phpgw for the forseeable future based on
phpgw's expected use of standard XSLT versus egroupware's adoption of
custom designed etemplate.

I am firstly an accountant, secondly a system developer; so I would
leave any integration (with other apps) to the middle layer, ie
phpgw.  AFAIK, there are on-going discussions to integrate DCL with
phpgw and to utilize xml-rpc to allow phpgw talk with other groupware
software (say Evolution).

There is quite an extensive range of theme/templates embedded
within phpgw to choose from.  If you have suggestions on a
corporate-look theme, you may like to send a request to
php...@gn... or better yet develop the theme
and contribute it to the phpgw theme set.

>
>Also, i was wondering if you could integrate the xaraya
>
>ledger instead with egroupware; and possibly provide an
>
>install doc with the current version itself
>
>
>
>
>
Xaraya-Ledger is a separate project handled by Marc Lutolf.  I am
forwarding this reply to Marc.  He may add his views later on.  The
install doc for the CK-Ledger's current version, v.0.7.3 is embedded
inside the software tarball's doc folders as, the
"Installation Manual - 0.7.3.html" file.

Cheers,
CK

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

>
>thankx
>
>
>
>

[CK-Ledger-users] Re: (Feature) Request (for CK-Ledger)

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

Hello, anupam,

Thank you for your interest in CK-Ledger.


anupam anand wrote:

>Integrate DCL + egroupware + ck-ledger + good(lean -
>
>elegant/corporate look) themes/templates + jetbox/jetstream
>
>+ envolution
>
>  
>
CK-Ledger will remain with phpgw for the forseeable future based on
phpgw's expected use of standard XSLT versus egroupware's adoption of
custom designed etemplate.

I am firstly an accountant, secondly a system developer; so I would
leave any integration (with other apps) to the middle layer, ie
phpgw.  AFAIK, there are on-going discussions to integrate DCL with
phpgw and to utilize xml-rpc to allow phpgw talk with other groupware
software (say Evolution).

There is quite an extensive range of theme/templates embedded
within phpgw to choose from.  If you have suggestions on a
corporate-look theme, you may like to send a request to
php...@gn... or better yet develop the theme
and contribute it to the phpgw theme set.

>
>Also, i was wondering if you could integrate the xaraya
>
>ledger instead with egroupware; and possibly provide an
>
>install doc with the current version itself
>
>
>
>  
>
Xaraya-Ledger is a separate project handled by Marc Lutolf.  I am
forwarding this reply to Marc.  He may add his views later on.  The
install doc for the CK-Ledger's current version, v.0.7.3 is embedded
inside the software tarball's doc folders as, the
"Installation Manual - 0.7.3.html" file.

Cheers,
CK

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

>
>thankx
>
>
>  
>

[CK-Ledger-users] CK-Ledger on Xaraya

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

Hello List,

A Ledger module based on CK-Ledger has been released for the Xaraya
applications framework.
The Xaraya Ledger module is based on the following CK-Ledger components: AR,
AP, GL, Sales Orders and Service, as well as administrative functions for
setup and configuration. Users familiar with CK-Ledger should feel right at
home in this version.
The ledger module implements a subset of CK-Ledger functions, but takes
advantage of native Xaraya functionality, such as the        permissions and
templating systems. Further enhancements to the module are planned, and
feedback and feature requests are welcome.

The Xaraya Ledger module is not completely compatible with CK-Ledger; that's
the price you pay for running on a different platform and wanting to take
advantage of it. Nonetheless efforts are made to keep it aligned where ever
possible in order to increase possibilities for cross-fertilization and code
sharing.

You can find more information on the module here:
http://www.xaraya.com/index.php/articles/634
Downloads are available on this site or at
http://www.xaraya.com/~marcinmilan/ledger.zip

I am happy to answer questions or bug reports about the module either on
this mailing list or at
http://lists.xaraya.com/mailman/listinfo/xaraya_public-dev or
http://lists.xaraya.com/mailman/listinfo/xaraya_public-dev.

Enjoy,

Marc

Re: [CK-Ledger-users] Integration w/*GroupWare . . .

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

Hello, Jason,

If you look thru' the development history of phpgw/egw,
you'll notice that egw is a fork of phpgw while
phpgw was evolving from 0.9.14 to 0.9.16 .  The main
difference of the two projects software-wise is the expected
adoption of standard XSLT by phpgw and the use of custom
designed etemplate by egw.  While no firm decision had
been made, it is likely that CK-Ledger will remain with
phpgw given the more standardised approach to screen rendering.

Cheers,
CK

Jason Flatt wrote:

>On Wednesday 31 December 2003 06:06 pm, C K Wu wrote:
>  
>
>>Hello, Jason,
>>
>>Thank you for your interest in CK-Ledger.
>>
>>Given the major changes made to phpgw 0.9.16 and the fact that
>>0.9.16 is still undergoing the RC process, any integration attempt
>>will be made post the formal release of 0.9.16.
>>
>>Cheers,
>>CK
>>    
>>
>
>
>What about integration with eGroupWare?  Or am I on my own on that one?
>
>
>  
>

Re: [CK-Ledger-users] Integration w/*GroupWare . . .

[Jason F. <ja...@fl...>]

On Wednesday 31 December 2003 06:06 pm, C K Wu wrote:
> Hello, Jason,
>
> Thank you for your interest in CK-Ledger.
>
> Given the major changes made to phpgw 0.9.16 and the fact that
> 0.9.16 is still undergoing the RC process, any integration attempt
> will be made post the formal release of 0.9.16.
>
> Cheers,
> CK


What about integration with eGroupWare?  Or am I on my own on that one?


-- 
Jason Flatt (jason @ flattfamily . com)
Father of five (http://www.flattfamily.com/)
Linux user (http://www.sourcemage.org/)
IRC Nick: Oadae  Channels: #sourcemage, #lvlug  Server: irc.freenode.net
PGP Key: E992213F - 0254 9DB7 BE0E 312D 8352 6E39 0700 FB95 E992 213F

Re: [CK-Ledger-users] Integration w/*GroupWare . . .

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

Hello, Jason,

Thank you for your interest in CK-Ledger.

Given the major changes made to phpgw 0.9.16 and the fact that
0.9.16 is still undergoing the RC process, any integration attempt
will be made post the formal release of 0.9.16.

Cheers,
CK


Jason Flatt wrote:

>Hello all.
>
>I'm wondering if there are plans for integrating CK-Ledger into the groupware 
>app that it sits on.  It seems rather a waste of time to go through the 
>process of setting up the groupware if CK-Ledger doesn't even use it.
>
>I've noticed other people asking about this in the past, but I have failed to 
>find an answer.
>
>
>  
>

[CK-Ledger-users] Integration w/*GroupWare . . .

[Jason F. <ja...@fl...>]

Hello all.

I'm wondering if there are plans for integrating CK-Ledger into the groupware 
app that it sits on.  It seems rather a waste of time to go through the 
process of setting up the groupware if CK-Ledger doesn't even use it.

I've noticed other people asking about this in the past, but I have failed to 
find an answer.


-- 
Jason Flatt (jason @ flattfamily . com)
Father of five (http://www.flattfamily.com/)
Linux user (http://www.sourcemage.org/)
IRC Nick: Oadae  Channels: #sourcemage, #lvlug  Server: irc.freenode.net
PGP Key: E992213F - 0254 9DB7 BE0E 312D 8352 6E39 0700 FB95 E992 213F

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

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

Hi, Dick,

Thank you for your interest in CK-Ledger.

CK-Ledger 0.7.3 had been tested against against phpgroupware 0.9.16RC1 
within
a Fedora Core I environment, ie, apache-2.0.47-10, mysql-3.23.58-4 / 
postgresql-7.3.4-2, php-4.3.3-6.

With your install of mysql4 and apache1.3 and the fact that phpgw0.9.16
is a release candidate, bugs are somewhat expected.  Unfortunately,
because of change to phpgw0.9.16's api, CK-Ledger 0.7.3 is not backward
compatible to previous release of phpgw.

My suggestion is that you could setup a Fedora Core I environment to
test out the combination of CK-Ledger 0.7.3 + phpgroupware 0.9.16RC1.
If that fails, you could try CK-Ledger 0.7.1 + phpgroupware 0.9.14.007.
The main thing that you will miss is the foreign currency feature of
CK-Ledger 0.7.3 .

Cheers,
CK

PS - I am sending a copy of this reply to ck-ledger-users mailing list
so others are aware of current development.

Dick Stins wrote:

>Hi Ckwu,
>
>
>
>I tried to install ck-ledger 0.7.3 with phpgroupware
>
>0.9.16.RC1 and mysql-4.0.16 and apache_1.3.29.
>
>
>
>I found lot's of bugs in phpgroupware. Is there a stable
>
>release available? the installation procedure is quiet hard.
>
>
>
>When I like ck-ledger, I am going to write an import module
>
>for bank transactions and a webshop (if not already done).
>
>  
>
You are most welcome to add a bank transaction or webshop module
and I would be more than happy to incorporate your modules into
CK-Ledger's main codebase after appropriate testing.

>
>I noticed that you are an oracle applications developer? 
>
>My main skills are Oracle pl/sql, forms (since 1989).
>
>
>
>Thanks for your help.
>
>
>
>With best regards,
>
>
>
>Dick Stins
>
>
>  
>

[CK-Ledger-users] Payroll

[Assured C. <as...@as...>]

Hi,

I need to set up my payroll tables where can i do this?

Thank You

Re: [CK-Ledger-users] Bulk Printing

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

Hi, Diane,

There is no bulk print feature at the moment.  The design
of the system is for Statements and Invoices to be emailed
directly to customers to save on the use of paper and postage.
If you could indicate your difficulty in applying the emailing
approach, perhaps I could help to devise a solution.

Cheers,
CK

Assured Computing wrote:

>Hi,
>
>Is there a place to bulk print the AR Statements and Invoices??
>
>Thank You
>Diane
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: SF.net Giveback Program.
>Does SourceForge.net help you be more productive?  Does it
>help you create better code?  SHARE THE LOVE, and help us help
>YOU!  Click Here: http://sourceforge.net/donate/
>_______________________________________________
>CK-Ledger-users mailing list
>CK-...@li...
>https://lists.sourceforge.net/lists/listinfo/ck-ledger-users
>
>
>  
>

[CK-Ledger-users] Bulk Printing

[Assured C. <as...@as...>]

Hi,

Is there a place to bulk print the AR Statements and Invoices??

Thank You
Diane

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

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

Hi, Joseph,

Well.  It's another enhancement to be implemented then.

Cheers,
CK

Joseph wrote:

>Hi Wu,
>
>Yes, this would be in ideal situation as it is easier to track the
>entries in their original amount.  In addition if the bank will make an
>additional charge, I don't know if it is part of the exchange or some
>entry that shouldn't be there.
>
>On Sun, 2003-11-16 at 06:49, C K Wu wrote:
>  
>
>>Hi, Joseph,
>>
>>I think the gest of the matter is while the ledger reports have to be
>>in CAD, you need to retain the original USD amount for your other
>>operational processing, say bank reconciliation, reference to past
>>billed amount, etc, etc...
>>
>>    
>>
>[snip]
>
>  
>
>>Ideally, to retain the original foreign currency (FC) amount, there would be a separate set of journals being fired off in parallel,
>>
>>For the vendor invoice,
>>Dr	Inventory, USD		100(USD)
>>Cr	A/P, USD		100(USD)
>>
>>For the payment,
>>Dr	A/P, USD		100(USD)
>>Cr	Bank, USD		100(USD)
>>
>>Thus, the original set of account will be used for ledger reporting, while the
>>[xxx, USD] accounts will provide info for your other processing that requires 
>>the original FC amount.
>>
>>    
>>
>Yes, and the exchange portion for all these accounts should be recorded
>in extra some kind of exchange accounts.
>I think the same situation would apply if the sale is in USD:
>Cr 	Inventory     100USD
>Dr	Sales		100USD
>
>and exchange again recorded separately.
>
>  
>
>>This is the way some traditional accounting packages handle FC.  If this solves
>>your problem, it could be scheduled as enhancement for a future release.  But,
>>I don't know when it will be ready, given the long list of future enhancements
>>already on hand.
>>    
>>
>
>For example even QuickBooks didn't design it correctly.  I've talked to
>one business in Edmonton that use QuickBooks as well and they manage it
>by keeping too sets of Books one in USD and one in CAD; for company that
>has Inventory like us, it is not possible to have two sets of books; so
>we manage with the help of "Class".  Every transaction is either Class
>USD or Class CAD and it is a pain at the end of the year to make a
>Balance sheet.
>Linux is gaining grounds and there are a lot of unhappy Intuit customers
>wanting to switch.  
>
>  
>

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

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

Hi, Joseph,

Well.  This really involves decisions in terms of CK-Ledger's operating
environment and horizontal linkage to other open source software.  I'll
certainly give it some thought when planning the future direction of
CK-Ledger.

Cheers,
CK

Joseph wrote:

>Hi Wu,
>
>Another enhancement I would think of would be to incorporate it with one
>of the E-commerce packages and one that is free and based as well on php
>and MySQL is osCommerce: http://www.oscommerce.org/
>
>It would be nice if the customer places an order and it will get
>automatically entered into the accounting package or at least be place
>in a temporary account pending for approval.
>I think this feature would be better discussed on
>ck-...@li... mailing list; others might have a
>good ideas and provide additional input.
>
>  
>

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

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

Hi, Joseph,

I think the gest of the matter is while the ledger reports have to be
in CAD, you need to retain the original USD amount for your other
operational processing, say bank reconciliation, reference to past
billed amount, etc, etc...

Referring to your example,

Example: we have USD [Bank] Account, we purchased inventory in the amount of
100USD and paid for this inventory in USD from USD [Bank] Account.

Assumption:  100USD = 130CAD

Existingly, CK-Ledger will generate the following journals,

For the vendor invoice,
Dr	Inventory	130(CAD)
Cr	A/P		130(CAD)

For the payment,
Dr	A/P		130(CAD)
Cr	Bank		130(CAD)


Ideally, to retain the original foreign currency (FC) amount, there would be a separate set of journals being fired off in parallel,

For the vendor invoice,
Dr	Inventory, USD		100(USD)
Cr	A/P, USD		100(USD)

For the payment,
Dr	A/P, USD		100(USD)
Cr	Bank, USD		100(USD)

Thus, the original set of account will be used for ledger reporting, while the
[xxx, USD] accounts will provide info for your other processing that requires 
the original FC amount.

This is the way some traditional accounting packages handle FC.  If this solves
your problem, it could be scheduled as enhancement for a future release.  But,
I don't know when it will be ready, given the long list of future enhancements
already on hand.

Cheers,
CK



Joseph wrote:

>Hi Wu,
>
>Thank you for your reply.
>
>[snip]
>  
>
>>Presumably, you have already got a working phpgroupware/ck-ledger installed.
>>If so, you are probably missing the very last step, creation of the test 
>>data.  Test data
>>can be created via Ledger Admin -> admin/setup.  If you don't see the 
>>menu choice,
>>just re-login as a phpgroupware admin user, the menu choice will then be 
>>available.
>>I must stress that they are test data only.  At the end of the day, you 
>>would need to
>>input your own account data to reflect your company's own chart of account.
>>    
>>
>
>No, I wasn't able to make it to work yet.  I'll have to make few
>snapshot and email it to you so you will not how to finish it.
>I got the Graphical part working, I can log-in but when I it seems to me
>the MySQL database is not fully or correctly populated as I get an error
>message when I try to create an order or post anything into and account.
>
>[snip]
>  
>
>>Dieter is right in maintaining the ledger in a single currency.  AFAIK, most
>>country's GAAP would require a company to publish its accounts in the local
>>currency.  Your concern, (correct me if I am wrong), is the provision of 
>>tools
>>by the software to allow foreign currency operations prior to the booking of
>>journals to the ledger.  With CK-Ledger, the original currency and amount
>>of foreign invoices, po, so, quotations are maintained as primary source 
>>data.
>>[btw, I think SQL-Ledger is doing the same].  Therefore, I think this is
>>really just a matter of printout format to suit your foreign currency 
>>operation.
>>    
>>
>
>Yes, you are right the accounts need to be in single currency but the
>Government is not imposing any requirements how the accounts are lay-out
>or how I view them.  
>The Government want to see my books in balance on the paper only.
>
>I've talked to Dieter about SQL-Ledger about this problem (we are from
>the same city, Edmonton) and he has mentioned to me that it would
>require extensive modification.
>
>I'll try to illustrate you the problem.  
>You are correct most Countries (if not all) require business post the
>accounts in their original currency.   However, they don't care how it
>is structure as long as I can balance the books.
>
>Like typical International business, we buy our inventory in USD and we
>keep the inventory in USD, as it is too much problem to convert it to
>domestic currency (Canadian Dollars as it fluctuate too much).  So we
>sell our inventory most of the time in USD even to Canadian customers;
>but if it is a credit card transaction, it needs to be converted to
>Canadian Dollars.
>
>Dieter SQL-Ledger work very good everything is converted automatically
>to Canadian Dollar including the foreign accounts (USD accounts) and
>this is the major problem; the way he shows them in the books.
>
>Example: we have USD Account, we purchased inventory in the amount of
>100USD and paid for this inventory in USD from USD Account.  And because
>we it was automatically converted to CAD (Canadian Dollars) the USD
>account is showing 130.00CAD balance.
>100.00  (inventory Invoice)
> 30.00  (Exchange amount)
>
>Logically it makes sense but it is not practical from day to day
>operation point of view.  
>Our statement from the USD Bank Account comes in USD amount.  The USD
>account is showing 130.00 balance so it makes it hard to see how much is
>on your account.  It is even harder to balance it.
>
>If I go to Reconcile the account I see the amount:
>100.00CAD  (inventory Invoice)
> 30.00CAD  (Exchange amount)
>
>and one check Box to check it off; that makes sense.  So I check it off
>and reconcile the account 130.00
>The next month statement comes in and I need to reconcile the account
>again.  However, my opening balance is showing 130.00.  This is WRONG. 
>It should be 100.00 opening balance.  
>
>The solution to this problem is to store the Exchange portion of the
>transaction in the Separate Account.  For example if my USD account is
>Called: "ATB Financial USD" the exchange account could be called "ATB
>Financial USD - Exchange".  The customer should not be able to edit any
>transaction or delete from this account because the account is only to
>keep the books in balance with domestic currency, in this case Canadian
>Dollars.  
>In addition this account "ATB Financial USD - Exchange" could be hidden
>from view as user don't need to see it at all (just as an option).  It
>is only to print the "Balance Sheet" and keep the books in balance.
>
>There are other minor problems with SQL-Ledger but Dieter was able to
>address them right away.  It pertained purchasing Inventory in USD and
>storing the latest purchase price.  The SQL-Ledger was storing converted
>amount in Canadian Dollar.  So when I went to make then another Purchase
>Order, the CAD was showing as latest purchase price, and this is not
>correct.  But this update feature can be turn OFF so it is not a big
>deal.
>
>
>  
>
>>Currently, CK-Ledger's customer statement looks something like,
>>
>>Bal b/f                            
>>CAD                                                                      100
>>Bal b/f                            
>>USD                                                                      200
>>
>>invoice settled                CAD                      20
>>invoice settled                 USD                      30
>>
>>Bal c/f                              
>>CAD                                                                      80
>>Bal c/f                               
>>USD                                                                     170
>>
>>If you need some other report with different format or layout, please send
>>me a email with a brief description of the format/layout.  I'll try to 
>>schedule
>>it for a future release.
>>    
>>
>
>I'll try to work on installation tomorrow so maybe I can put it to a
>test.
>
>[snip]
>  
>
>>Use the browser print function to output the invoice, order, etc.   
>>There is a
>>line (explaining this ) at the page bottom just above the row of buttons.
>>
>>Cheers,
>>CK
>>
>>PS - I am sending a copy of this email to 
>>ck-...@li...,
>>so the others are aware of current development.
>>    
>>
>
>OK, I will subscribe tomorrow to ck-...@li...
>mailing list.  
>
>I would like to help you to make that International function worked
>correctly in CK-Ledger so it is done right.  
>
>  
>

Re: [CK-Ledger-users] Error on Ledger Module

[Fevzi G. <fev...@so...>]

It seemd like a version mismatch to me.
You could be using phpgw 14 with CKL073
Versions are not backward compatible.
phpgw 14 works with CKL071
for CKL073 u need to install phpgw 16 RC1
this is the problem IMHO


----- Original Message ----- 
From: "C K Wu" <ck...@ho...>
To: "Manuel Montoya" <wi...@bi...>
Cc: <ck-...@li...>
Sent: Thursday, November 13, 2003 5:50 AM
Subject: Re: [CK-Ledger-users] Error on Ledger Module


> Hi, Manuel,
>
> Thank you for checking out CK-Ledger.
>
> It is likely that you have not yet built up your db tables as part of
> the setup process.
> The various steps of the setup process is available from Ledger Admin ->
> Admin/setup.
> For more detail, please refer to the User/Administrator column of any
> module's index page
> [specially, please refer to the box on the best way to study the module] .
>
> Cheers,
> CK
>
>
> Manuel Montoya ??:
>
> > Hi, Im trying to instal CK-Ledger on a Debian/Woody/Mysql/PHP4
> > machine. Im using the last phpgrupware .tar.gz version, not the debian
> > version.
> > PGW alone works fine. Then I installed CKL follow the directions, all
> > is OK but he ledger Icon (the second icon, little notebook with the
> > abacus) return me
> > this error:
> >
> > *Database error:* Invalid SQL: Select * from defaults
> > *MySQL Error*: 1146 (Table 'phpgroupware.defaults' doesn't exist)
> >
> > *Session halted.
> > *
> >
> > *
> > *
> >
> > *And indeed the table doesn`t exist
> > *
> >
> > *How can I fix it?*
> >
> > *
> > Thanks in advance.
> > *
> >
> > *MM
> > *
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: ApacheCon 2003,
> > 16-19 November in Las Vegas. Learn firsthand the latest
> > developments in Apache, PHP, Perl, XML, Java, MySQL,
> > WebDAV, and more! http://www.apachecon.com/
> > _______________________________________________
> > CK-Ledger-users mailing list
> > CK-...@li...
> > https://lists.sourceforge.net/lists/listinfo/ck-ledger-users
> >
> >
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: ApacheCon 2003,
> 16-19 November in Las Vegas. Learn firsthand the latest
> developments in Apache, PHP, Perl, XML, Java, MySQL,
> WebDAV, and more! http://www.apachecon.com/
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users

Re: [CK-Ledger-users] Error on Ledger Module

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

Hi, Manuel,

Thank you for checking out CK-Ledger.

It is likely that you have not yet built up your db tables as part of 
the setup process.
The various steps of the setup process is available from Ledger Admin -> 
Admin/setup.
For more detail, please refer to the User/Administrator column of any 
module's index page
[specially, please refer to the box on the best way to study the module] .

Cheers,
CK


Manuel Montoya ??:

> Hi, Im trying to instal CK-Ledger on a Debian/Woody/Mysql/PHP4 
> machine. Im using the last phpgrupware .tar.gz version, not the debian 
> version.
> PGW alone works fine. Then I installed CKL follow the directions, all 
> is OK but he ledger Icon (the second icon, little notebook with the 
> abacus) return me
> this error:
>
> *Database error:* Invalid SQL: Select * from defaults
> *MySQL Error*: 1146 (Table 'phpgroupware.defaults' doesn't exist)
>
> *Session halted.
> *
>
> *
> *
>
> *And indeed the table doesn`t exist
> *
>
> *How can I fix it?*
>
> *
> Thanks in advance.
> *
>
> *MM
> *
>
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: ApacheCon 2003,
> 16-19 November in Las Vegas. Learn firsthand the latest
> developments in Apache, PHP, Perl, XML, Java, MySQL,
> WebDAV, and more! http://www.apachecon.com/
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users
>
>