ck-ledger-users Mailing List for CK-Ledger (Page 6)
Status: Beta
Brought to you by:
ckwu
Menu
▾
▴
ck-ledger-users — Mailing list and discussion group for CK-Ledger Users
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
(18) |
Mar
(3) |
Apr
(6) |
May
(19) |
Jun
(8) |
Jul
(10) |
Aug
(10) |
Sep
(17) |
Oct
(10) |
Nov
(8) |
Dec
(12) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(15) |
Feb
(9) |
Mar
(16) |
Apr
(7) |
May
(5) |
Jun
(1) |
Jul
(6) |
Aug
(8) |
Sep
(42) |
Oct
(8) |
Nov
(22) |
Dec
(3) |
| 2004 |
Jan
(14) |
Feb
(8) |
Mar
(8) |
Apr
(1) |
May
(2) |
Jun
|
Jul
(13) |
Aug
(4) |
Sep
(6) |
Oct
(5) |
Nov
|
Dec
|
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(4) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: C K Wu <ck...@ho...> - 2003-09-10 03:27:48
|
Marc Lutolf =B4=A3=A8=EC: >Hi CK, > >Here are some notes to your message. > >Cheers, > >Marc > > >FOREX vendor invoice >FOREX payment >FOREX customer invoice >FOREX receipt >FOREX adjustment journals >FOREX period end journal to record unrealised FOREX gain/loss > >The last two are perhaps infrequent occurrence that can be dealt with >manually. > > =20 > >>>agree >>> =20 >>> > > >For FOREX invoices, I think it is sufficient to introduce something like= , > >Currency: [drop-down currency list] Exchange rate: _______ > > =20 > >>>agree >>> =20 >>> > >ie, a single foreign currency for the entire invoice. It would probably >require too much effort if each invoice line item is allowed to choose >a different currency. The initial default exchange rate is taken from >a FOREX table updatable via Ledger Admin, but could be override at >invoice creation time. The actual booked invoice amount will be >calculated as, FOREX AMOUNT x Exchange Rate . > >For monetary FOREX payment/receipt, a similar arrangement can be >implemented. > > =20 > >>>Yes. Overrides bring a whole new set of problems. For my purposes it i= s >>> =20 >>> >enough to work with a standard exchange rate. > >The hard part is perhaps invoice matching against payment/receipt. There= are >three possible scenarios, > >a) X currency invoice can only be settled against X currency >payment/receipt. >b) X currency invoice can be settled against X currency and/or home >currency payment/receipt. >c) X currency invoice can be settled against any currency payment/receip= t. > >At this stage, I would incline to go for alternative a), since it is the >easiest to implement and probably handles majority of cases faced by an = SME. > > =20 > >>>absolutely agree that a is the way to go >>> =20 >>> > >Here is what I am using at the moment: > >CREATE TABLE xar_ledger_currency ( > xar_id int(11) NOT NULL default '0', > xar_isocode varchar(5) NOT NULL default '', > xar_currname varchar(100) NOT NULL default '', > xar_rounding float NOT NULL default '0', > xar_notes longtext NOT NULL, > PRIMARY KEY (xar_id), > UNIQUE KEY xar_isocode (xar_isocode) >) TYPE=3DMyISAM; > >The iso code is not really used, except as a possible key for importing = new >data. Internally the system needs to work with the unique id. > >Note the rounding field. This is for currencies that get rounded in >transactions. In Switzerland for instance, you almost always have roundi= ng >up to the nearest 0.05 CHF. Notable exceptions are bank accounts, so you >have to define the rounding per account. > >I work with a 3 tier system: there is a system default given by the curr= ency >table, which can be taken over or overridden manually by the customer. O= n >creation of an invoice you can take the customer's exchange rate or over= ride >it manually on the invoice. > >I don't like the name FOREX too much, because it's not just foreign >exchange; the home currency is in the currency table, too! But that's me. > > > =20 > Great. I'll try to have these implemented by the next release. Cheers, CK |
|
From: Marc L. <mf...@ne...> - 2003-09-09 13:33:35
|
Hi CK, Here are some notes to your message. Cheers, Marc FOREX vendor invoice FOREX payment FOREX customer invoice FOREX receipt FOREX adjustment journals FOREX period end journal to record unrealised FOREX gain/loss The last two are perhaps infrequent occurrence that can be dealt with manually. >>agree For FOREX invoices, I think it is sufficient to introduce something like, Currency: [drop-down currency list] Exchange rate: _______ >>agree ie, a single foreign currency for the entire invoice. It would probably require too much effort if each invoice line item is allowed to choose a different currency. The initial default exchange rate is taken from a FOREX table updatable via Ledger Admin, but could be override at invoice creation time. The actual booked invoice amount will be calculated as, FOREX AMOUNT x Exchange Rate . For monetary FOREX payment/receipt, a similar arrangement can be implemented. >>Yes. Overrides bring a whole new set of problems. For my purposes it is enough to work with a standard exchange rate. The hard part is perhaps invoice matching against payment/receipt. There are three possible scenarios, a) X currency invoice can only be settled against X currency payment/receipt. b) X currency invoice can be settled against X currency and/or home currency payment/receipt. c) X currency invoice can be settled against any currency payment/receipt. At this stage, I would incline to go for alternative a), since it is the easiest to implement and probably handles majority of cases faced by an SME. >>absolutely agree that a is the way to go Here is what I am using at the moment: CREATE TABLE xar_ledger_currency ( xar_id int(11) NOT NULL default '0', xar_isocode varchar(5) NOT NULL default '', xar_currname varchar(100) NOT NULL default '', xar_rounding float NOT NULL default '0', xar_notes longtext NOT NULL, PRIMARY KEY (xar_id), UNIQUE KEY xar_isocode (xar_isocode) ) TYPE=MyISAM; The iso code is not really used, except as a possible key for importing new data. Internally the system needs to work with the unique id. Note the rounding field. This is for currencies that get rounded in transactions. In Switzerland for instance, you almost always have rounding up to the nearest 0.05 CHF. Notable exceptions are bank accounts, so you have to define the rounding per account. I work with a 3 tier system: there is a system default given by the currency table, which can be taken over or overridden manually by the customer. On creation of an invoice you can take the customer's exchange rate or override it manually on the invoice. I don't like the name FOREX too much, because it's not just foreign exchange; the home currency is in the currency table, too! But that's me. |
|
From: C K Wu <ck...@ho...> - 2003-09-09 02:27:49
|
robert : >I haven't had a need for multicurrency support even though I live along the >US/Mexican border. All our transactions appear in US dollars and with US >vendors. So, forgive me for asking a dumb question... why couldn't the >business simply record the transaction in their home currency using that >day's exchange rates? > > > For transactions that are completed instantaneously, eg cross counter trade, this may be possible. However, for transactions with an extended life (eg a Mexican vendor sending a US dollar invoice to a US customer and the invoice got settled three months later), this foreign currency denominated transaction (A/R asset) will have to be reflected, during the interim period, in the accounting book, with due regard to the fluctuating exchange rate. The same thing happens if the Mexican cross counter vendor receives US dollar proceeds and decides to hold on to the US currency, pending favourable exchange rate before converting the US dollar back to Mexican peso. Cheers, CK |
|
From: robert <rd...@st...> - 2003-09-09 01:27:09
|
I haven't had a need for multicurrency support even though I live along the US/Mexican border. All our transactions appear in US dollars and with US vendors. So, forgive me for asking a dumb question... why couldn't the business simply record the transaction in their home currency using that day's exchange rates? Just wondering, robert |
|
From: <chi...@ya...> - 2003-09-08 03:32:01
|
Hi, Andrea, Thank you for the suggestion. I think you've said it yourself. It is easier said than done. There are sufficient inherent difference between the two projects to make a common API pretty much impossible. CK-Ledger supports MySQL. SQL-Ledger don't. SQL-Ledger runs standalone. CK-Ledger relies on phpGroupWare as a middle layer. Just to name a few. At the same time, the web service mode of data transfer would not work. If there is any screw up after the data transfer, the importing app will blame it on the data being screwed even before transfer, while the source app will say the importing app is importing wrongly. It is the classic hardware guy blaming the software and the software folk doing the reverse. Since it is a free software environment, the user has no legal recourse, and simply blame it on the reliability of free software as a whole and go back to using proprietary software. So, while the thought is laudable, it is pretty much impossbile. Best Regards, CK Andrea Rota 提到: >>Have you ever thought about working on a two-way conversion tool between >>SQL-Ledger and CK-Ledger, cooperatively developed by the two teams? >>It would allow more people to actively experiment with either ledger >>system, while avoiding the "chasing-each-other" effect... >>I see both projects as excellent free software products: wouldn't it be >>great to try a (loose) collaboration on a sort of common ledger API, in >>the form of a web service (XML-RPC or SOAP) interface to the ledger >>application, so that one could refer to the common web service interface >>to export and import data? >>This would also help in maintaining a clear and always up-to-date >>documentation of the API-to-relational mapping for both sistems, that >>would in turn help in having a well documented "data scheme" for both >>ledger systems, a real plus for a free software project. >> >>Just a suggestion, and nothing more: I understand that this might be >>quite hard to manage, because it involves agreement on a common API from >>two different teams - but it would be great to have. It could maybe also >>help in developing converters to this sort of meta-ledger-API from >>proprietary ledger systems... >> >>[...] >> >> >> _________________________________________________________ 最新鈴聲推介:十面埋伏，多謝失戀，心淡... http://ringtone.yahoo.com.hk |
|
From: Andrea R. <sil...@he...> - 2003-09-07 16:57:54
|
> From: =?big5?q?C=20K=20Wu?= <chi...@ya...> > Subject: Re: [CK-Ledger-users] SQL-LEDGER > To: jch...@en... > Cc: rd...@st..., ck-...@li... > > Hi, Jim, > > My feeling towards SQL-Ledger import facility is still > the same. > > a) I don't wish to be seen as chasing after > SQL-Ledger user base. I am a great > admirer of Dieter's work. In fact, this is the > reason why I created CK-Ledger > based on SQL-Ledger's design in the first > place. However, if Robert would > provide the conversion script, it is perhaps > something that you could discuss > between yourselves, but I am afraid I would not > incorporate the conversion > script into CK-Ledger, short of official > blessing from Dieter himself. Have you ever thought about working on a two-way conversion tool between SQL-Ledger and CK-Ledger, cooperatively developed by the two teams? It would allow more people to actively experiment with either ledger system, while avoiding the "chasing-each-other" effect... I see both projects as excellent free software products: wouldn't it be great to try a (loose) collaboration on a sort of common ledger API, in the form of a web service (XML-RPC or SOAP) interface to the ledger application, so that one could refer to the common web service interface to export and import data? This would also help in maintaining a clear and always up-to-date documentation of the API-to-relational mapping for both sistems, that would in turn help in having a well documented "data scheme" for both ledger systems, a real plus for a free software project. Just a suggestion, and nothing more: I understand that this might be quite hard to manage, because it involves agreement on a common API from two different teams - but it would be great to have. It could maybe also help in developing converters to this sort of meta-ledger-API from proprietary ledger systems... [...] -- Regards, __ Andrea Rota Xelera - Soluzioni GNU/Linux http://www.xelera.it .:. .:. .:. "Omnis enim res, quae dando non deficit, dum habetur et non datur, nondum habetur, quomodo habenda est." |
|
From: <chi...@ya...> - 2003-09-04 11:40:13
|
Hi, Marc, Yes. Multicurrency is indeed the next major target. Just about every company here in Hong Kong have to due with two currencies, the Hong Kong dollar and mainland China's Remibi (RMB). Currently, if any company wishes to maintain separate books for individual currencies, then the multi-ledger/attribute features suffice. However, if the effect of different currency transactions is to appear within one ledger, then major redesign and addition to CK-Ledger have to be carried out. Let's think about it over this week-end and compare notes early next week and see if we can come up with a design that would fit both the European and the Asian scene. PS - Sorry. I should have mentioned that the floor is open and all comments from whatever part of the world are welcome. Cheers, CK Marc Lutolf : > I've started thinking a bit about how multicurrency functionality could be > implemented on CK-Ledger. Any thoughts? > > Marc > > > > ------------------------------------------------------- > 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 > > > > _________________________________________________________ 最新鈴聲推介:十面埋伏，多謝失戀，心淡... http://ringtone.yahoo.com.hk |
|
From: <chi...@ya...> - 2003-09-04 11:37:25
|
Hi, Jerre, Sorry for the delay in replying. I had been tied up with updating CK-Ledger's demo website in mainland China. Hopefully I'll be able to complete the work within this week. Jerre Cope 提到: >>I've setup a chart of accounts for a non-profit High School >> >>Band organization. I was wondering if you were interested >> >>in the chart of accounts and how I should send it. Perhaps >> >>do a backup and edit away the statements that have nothing >> >>to do with the chart table? >> >> >> Yes. The additional sample chart of accounts is most welcomed. Doing a backup and edit away the non-chart table related parts is definitely a good way of doing it. However, you may like to check on two minor details. a) Please ensure that the High School Band organization does agree to the publication of the chart of accounts to the world at large, since incorporating the chart into the CK-Ledger distribution code would make it available to anyone interested. b) Please limit the number of accounts to under 100. If both a) & b) are OK, please email me a copy of the tailored backup file. >> >>Also, I changed the Income & Balance Sheet statement Date >> >>column headers to read "From" rather than "Form". It's >> >>probably quick to tell you that then send you the source code. >> >> >> I've checked with my CK-Ledger codebase and the SourceForge demo site. It seems that with v.0.7.1, they are spelled correctly. However, I'll keep looking to see if you may be referring to some other column headers that I have missed. >> >>The Chart editing screen does not let me setup a Equity type >> >>account, it leaves off that choice on the pull down menu. >> >>I've been flipping it to Q from MySQL because I've been in a >> >>hurry and I haven't had a chance to learn the code yet. I >> >>think perhaps there are things about CVS I should know if >> >>I'm to make real contributions to the code. >> Again, my codebase and the demo site seem to allow the creation of Equity type account. I wonder if you may be using a pre-v.0.7.1 version. In terms of CVS, I have made a decision at the outset of the project not to create a CVS repository. I have the firm belief that it is very difficult to maintain discipline among volunteers in an open source environment. The argument among phpgw developers when Ralf Becker's CVS update right was taken away perhaps exemplifies the difficulty. >> >> >>I want to make a module similar to your Staff Self-Service >> >>only for A/R, so that students can look up their own A/R >> >>statements (which are credits made during fund-raising >> >>efforts, we don't maintain debit balances). >> >> >> In contrast to the CVS situation, I would certainly encourage you to write a separate module to solve your application requirement. If you think fit, then you could email your module to me and I'll incorporate the module into the CK-Ledger main code with full recognition that you are the author of the module. Indeed, you will be fully responsible for the subsequent maintenance of the module itself. I'll serve the passive role of maintaining CK-Ledger as a conduit for your module's publication unless there are some issues of inter-module collaboration being raised. However, I would also encourage you to maintain a index page for your module, with all the various disclaimer, security issues and problems being highlighted. >> >>I've discovered that I can run the Leger Reports and cut the >> >>tables from the webbrowser and paste them into OpenOffice >> >>for a very pretty Financial Statement. >> >> >> Thanks. I'll try it out myself and if all goes OK, I'll add a message in the Ledger Report filter screen highlighting the cut-and-paste approach of Statement generation. >> >>Thanks again for the good work. >> >> >> >> >> My pleasure. Cheers, CK PS. I am sending a copy of this reply to ck-...@li..., so the others are aware of current development _________________________________________________________ 最新鈴聲推介:十面埋伏，多謝失戀，心淡... http://ringtone.yahoo.com.hk |
|
From: <chi...@ya...> - 2003-09-04 11:33:39
|
Hi, Jim,
My feeling towards SQL-Ledger import facility is still
the same.
a) I don't wish to be seen as chasing after
SQL-Ledger user base. I am a great
admirer of Dieter's work. In fact, this is the
reason why I created CK-Ledger
based on SQL-Ledger's design in the first
place. However, if Robert would
provide the conversion script, it is perhaps
something that you could discuss
between yourselves, but I am afraid I would not
incorporate the conversion
script into CK-Ledger, short of official
blessing from Dieter himself.
b) The other point is that AFAIR the internal data
structure of SQL-Ledger
had been evolving thru' the years. If you have
several SQL-Ledger sites
that were deployed at different points in time,
then you would have to be
extra careful about the conversion. The data
structure of the various sites
may have some lingering legacy that may not
have been fully handled during
SQL-Ledger version upgrade.
I totally agree with Robert's suggestion that the best
timing is the
beginning of your next fiscal period. Furthermore,
there is one other
person/group that you really have to consult. Your
SQL-Ledger site auditors,
internal and external. They are the person(s) that
ultimately decide whether
the result of any conversion is acceptable or not, and
I suspect they'll demand
lots and lots of paper trail, :-) .
Cheers,
CK
robert:
> On Monday 01 September 2003 10:41 am,
jch...@en... wrote:
>
>
>> ... I use sql-ledger on a couple sites and think it
>>
>> works well. ... I would really like to
>>
>> switch and try ck-ledger as it has some features
that I really could use.
>>
>>
>
>
> I could look into putting together some scripts to
convert your data files from one system to the other
since you're willing to try out ck-ledger.
>
> Would you be willing to run a new system with no
historical transactions if your customer, vendor,
employee, and inventory files were converted over?
You wouldn't lose your historical data since that
would be available with your current SQL-ledger
system. Of course, local/state/federal laws could
require you to keep your SQL-ledger system available
for some time.
>
> A good switch-over point would be the beginning of
your next fiscal period and you would probably want to
run both systems concurrently for some time.
>
> CK? What do you think? Would this be easy? How
similar are the data tables? I'm not very familiar
with the data tables of either system but I've
exported/imported data before.
>
>
> robert
>
>
>
>
-------------------------------------------------------
> 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
>
>
>
>
_________________________________________________________
最新鈴聲推介:十面埋伏，多謝失戀，心淡...
http://ringtone.yahoo.com.hk
|
|
From: <chi...@ya...> - 2003-09-04 11:23:30
|
Hi, folk, My ISP's smtp server had just fallen into a blackhole (being blacklisted by a RBL). So, for the moment, I shall be posting from my yahoo.com.hk account. However, my email address, ck...@ho..., still works fine in receiving incoming mails. In a short while, I'll re-send my recent emails that got rejected by ck-...@li.... Sorry for the delay in responding to your emails. Cheers, CK _________________________________________________________ 最新鈴聲推介:十面埋伏，多謝失戀，心淡... http://ringtone.yahoo.com.hk |
|
From: <jch...@en...> - 2003-09-03 14:13:50
|
Thank you for replying. I would be more than willing with your help to try and import one SQL-Ledger site into CK-LEDGER and see how it goes. I could have the girls run both concurrently as you mentioned until the year end. You can reach me directly at jch...@en.... Thanks again for replying. Jim Chaters |
|
From: Marc L. <mf...@ne...> - 2003-09-03 09:32:41
|
I've started thinking a bit about how multicurrency functionality could be implemented on CK-Ledger. Any thoughts? Marc |
|
From: robert <rd...@st...> - 2003-09-02 23:48:15
|
On Monday 01 September 2003 10:41 am, jch...@en... wrote: > > ... I use sql-ledger on a couple sites and think it > > works well. ... I would really like to > > switch and try ck-ledger as it has some features that I really could use. > I could look into putting together some scripts to convert your data files from one system to the other since you're willing to try out ck-ledger. Would you be willing to run a new system with no historical transactions if your customer, vendor, employee, and inventory files were converted over? You wouldn't lose your historical data since that would be available with your current SQL-ledger system. Of course, local/state/federal laws could require you to keep your SQL-ledger system available for some time. A good switch-over point would be the beginning of your next fiscal period and you would probably want to run both systems concurrently for some time. CK? What do you think? Would this be easy? How similar are the data tables? I'm not very familiar with the data tables of either system but I've exported/imported data before. robert |
|
From: <jch...@en...> - 2003-09-01 15:40:26
|
Hi. Nice application. I red in the archives that there is no plan to write a script that would import sql-dqtq as you don't want to be seen as going after sql-ldger users. I use sql-ledger on a couple sites and think it works well. Dieter has done a good job. But... I would really like to switch and try ck-ledger as it has some features that I really could use. I would not consider that you are chasing sql-ledger users but just offering an alternative. Thanks Jim |
|
From: C K Wu <ck...@ho...> - 2003-08-13 13:26:24
|
Hi, Rui, CK-Ledger is a set of separate modules (currently 15 in total) that can be installed on top of phpGW. It is not a fork of phpgroupware. The demo webstie is run with the following configuration, Top-Level Applications: CK-Ledger + other modules that are embedded in phpGW's distribution set (eg SiteMgr) Middle Layer: phpGroupWare (download from www.phpgroupware.org) Bottom Layer: LAMP (provided by sourceforge.net, cosoft.org.cn, gro.clinux.org as the case may be) If you are to build your own installation, you would have to assemble the various building blocks from the various published sources. Cheers, CK P.S. - I am sending a copy of this reply to ck-...@li..., so the others are aware of current development. Rui Miguel Seabra wrote: > Hi, > > I couldn't understand from the web site whether CK Ledger is a separate > module one can install on phpGW or if it is a sort of fork. > > Is it a module? > > Best regards, Rui > > -- > + No matter how much you do, you never do enough -- unknown > + Whatever you do will be insignificant, > | but it is very important that you do it -- Gandhi > + So let's do it...? > > Please AVOID sending me WORD, EXCEL or POWERPOINT attachments. > See http://www.fsf.org/philosophy/no-word-attachments.html > > ------------------------------------------------------------------------ > Name: signature.asc > signature.asc Type: application/pgp-signature > Description: This is a digitally signed message part |
|
From: C K Wu <ck...@ho...> - 2003-08-11 04:41:19
|
Hi, Louis-Charles,
Thank you for checking out CK-Ledger.
Louis-Charles Dumais wrote:
> Hi,
>
> I installed your software and I must say that the results are impressive.
> I'm looking to implement the software in a small enterprise environnement.
> Do you think the software is ready for this at this stage of development?
>
The software is in beta, so bugs are inevitable. However, there shouldn't
be any major design fault with the software as it stands currently. If, you
are rolling out the software in an actual production environment, I would
suggest very frequent backup, just to be sure that you can recover from any
major disaster.
>
> Also, a nice feature would be to add the current date on the sales order by
> default when you create an order.
>
This is fairly easy to implement. It will be in the next release.
>
> Is the CK-ledger a realtime system? I have been trying to add an inventory
> then sale the same quantity with the sale order page but the inventory isnt
> updating itself automatically. Is there a setting parameter I must check to
> get realtime inventory?
>
The software is realtime in the sense of being a web application, ie it is
subject to the usual delay generated by the web server. To find out
what is going on, I would suggest the following,
a) Add a testing inventory item.
b) Check if the item has been created by reviewing the current list of
inventory
items.
c) Increase the inventory balance by entering a +ve inventory adjustment.
(using goods receipt will require adding the associated purchase order)
d) Check the inventory balance to see if it has been increased correctly
e) Create a testing sales order to see if you can sell off the current
inventory balance.
>
> The software seems great, would you like a french translation?
>
You are most welcome to add the french translation and if you are interested,
adding a sample french chart of account and the associated french taxation
detail.
Cheers,
CK
>
> Louis-Charles Dumais
>
> _________________________________________________________________
> Tired of spam? Get advanced junk mail protection with MSN 8.
> http://join.msn.com/?page=features/junkmail
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> CK-Ledger-users mailing list
> CK-...@li...
> https://lists.sourceforge.net/lists/listinfo/ck-ledger-users
|
|
From: Louis-Charles D. <lcd...@ho...> - 2003-08-10 22:05:46
|
Hi, I installed your software and I must say that the results are impressive. I'm looking to implement the software in a small enterprise environnement. Do you think the software is ready for this at this stage of development? Also, a nice feature would be to add the current date on the sales order by default when you create an order. Is the CK-ledger a realtime system? I have been trying to add an inventory then sale the same quantity with the sale order page but the inventory isnt updating itself automatically. Is there a setting parameter I must check to get realtime inventory? The software seems great, would you like a french translation? Louis-Charles Dumais _________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail |
|
From: Hsing-Foo W. <hsi...@st...> - 2003-08-08 09:54:50
|
Nice CK! C K Wu wrote: > Hello, folks, > > I have posted a new release, v.0.7.1, of CK-Ledger, at SourceForge.Net. > > New features include traditional Chinese translation, simplified Chinese > translation, Postgresql 7.3.2 compatibility, enhanced payroll generation > process and enhanced email advice when HR staff action on timesheet and > leave application. Other enhancements and 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) 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. Please report error and suggestion to the mailing > list, ck-...@li... . General history and > expected development is available at the mailing list's Archive. > > Demo is located at, > http://ck-ledger.sourceforge.net > http://ck-ledger.gro.clinux.org > http://ck-ledger.cosoft.org.cn > > Download is available from, > http://sourceforge.net/projects/ck-ledger > http://gro.clinux.org/projects/ck-ledger > http://cosoft.org.cn/projects/ck-ledger > http://sf.linuxforum.net/projects/ck-ledger > > > Cheers, > Wu Chiu Kay, aka CK Wu, aka CK (CK is the preferred alias) > Hong Kong > > > > _______________________________________________ > Phpgroupware-users mailing list > Php...@gn... > http://mail.gnu.org/mailman/listinfo/phpgroupware-users |
|
From: C K Wu <ck...@ho...> - 2003-08-08 09:40:33
|
Hello, folks, I have posted a new release, v.0.7.1, of CK-Ledger, at SourceForge.Net. New features include traditional Chinese translation, simplified Chinese translation, Postgresql 7.3.2 compatibility, enhanced payroll generation process and enhanced email advice when HR staff action on timesheet and leave application. Other enhancements and 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) 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. Please report error and suggestion to the mailing list, ck-...@li... . General history and expected development is available at the mailing list's Archive. Demo is located at, http://ck-ledger.sourceforge.net http://ck-ledger.gro.clinux.org http://ck-ledger.cosoft.org.cn Download is available from, http://sourceforge.net/projects/ck-ledger http://gro.clinux.org/projects/ck-ledger http://cosoft.org.cn/projects/ck-ledger http://sf.linuxforum.net/projects/ck-ledger Cheers, Wu Chiu Kay, aka CK Wu, aka CK (CK is the preferred alias) Hong Kong |
|
From: Alex B. <al...@co...> - 2003-08-04 05:49:43
|
El dom, 03-08-2003 a las 20:18, C K Wu escribió: > Hello, Alex, > > Thank you for considering CK-Ledger as a possible starting > point for offering solution to your client. I'll be more than > happy to incorporate whatever changes you make to > CK-Ledger back into the main CK-Ledger distribution > code, if you so incline. Shure thing. I will allways preffer trying to make it happen in the upstream than making an internal branch. Ill soon send you guys the details, im shure youll have lots of things to say about the best way to implement this. > > P.S. This reply is not sent to the phpgw list, but instead directed > to ck-...@li..., because I think > it may not be of general interest to the phpgw list. > > Best Regards, > CK Wu > > Alex Borges wrote: > > > El vie, 01-08-2003 a las 08:08, Doug Dicks escribió: > > > Hello All, > > > > > > I need some opinions or advice. > > > > > > A month ago some of my coworkers and I left our previous employer to > > > start a new company. We've just gotten our first significant contract, > > > one which calls for a groupware (email, address book, time-tracking) > > > solution. It's a large number of users, but generally not all at the > > > same time. > > > > > > We'd really like to use an open solution. We all believe in open source > > > and are willing to contribute work back to the project. Something like > > > Exchange/Outlook would kill our profit margin, but we'd rather break > > > even than fail. > > > > > > The new project is pretty high-visibility within the local community and > > > has several very large companies involved. The outcome of this project > > > will certainly have a major, major impact on the future of our new company. > > > > > > So, given all of this, would you use PHPGroupware if this were *your* > > > company? Why or why not? > > > > > > Thanks for your advice. PHPGroupware is our "plan a", and I need to > > > validate this direction. Things should get rolling very quickly now > > > that we have the deal, and the project schedule doesn't allow for any > > > time to change out the core technology half-way through. > > > > > > Thanks again. I look forward to your comments. > > > > > > > This is a very good question. Some of the contributors here are members > > of company that have taken this step long ago. Probably the first of > > them should be Dan and/or jengo (dont remember), creators of this thing, > > that founded a company.... and many others. Some of them founded their > > companies, others are independent consultants and others are in-house > > consultants for the companies they work with. > > > > ----------------------------- > > |Here is a success story. Ill try to be as objective as possible. > > ----------------------------- > > > > All in all, i have a phpgw working with a 600 administrative (with pcs > > and net connections) user organization with 30 branches all over my > > country (mexico) and in other countries (costa rica, the us). This is a > > large autoparts maker. Its been a lot of work, but i dont regret it at > > all, this year its actually starting to pay off. > > > > I started that deployment last year, about march. I was supposed to move > > this guys from exchange to a solution of my choosing. I had been > > tracking phpgw and using it inhouse for a year before that and i liked > > it. > > > > So in i went. I saved them about 90% of what it was gonna cost them if > > they stayed in exchange (two year deadline was comming), so i lost money > > (do the numbers), and i had to heavily modify phpgw to their liking. > > > > Took me about 8 months to stabilize the whole thing with migration and > > all the changes they wanted (the javascript addressbook was one of those > > changes). > > > > Today its a different story i think. The phpgw i took back then was a > > great app, but it needed significant tweaking to make it into that > > corporate datacenter. Stuff like a central company directory with links > > to accounts were there, just not how the admin wanted it. So i rolled my > > own changes. > > > > In the end all my work it was so messy that i didnt even want to pass it > > back to the community, knowing it would be instantly rejected (hey, i > > rejected it myself). So, i waited until stabilization was completed and, > > in the meantime, i started contributing and discussing what the client > > asked of me. > > > > The release schedulled by aug 8 covers all of what i did and more with a > > very high standard of quality. > > > > Some of that was made by the community since some ppl here had the same > > needs as myself, some were ideas of other ppl that i hadnt thought of, > > some is stuff that im paying to be done and is being finished as we > > write (its 2:30 am here, i should get back to that). > > > > This year we were contacted by a university with 4000 students wanting > > an e-learning solution. I immediatly thought of phpgw but my associates > > shrugged on me since weve spent so much on it with almost no profit > > (now, to level this, this is not true, its not much proffit from phpgw, > > but the client also pays a service fee for network consultancy and > > mantainership of their servers. we convinced them to switch their dbms > > to linux as well, and we wouldve never gotten in if we didnt have what > > they really needed at the right time). > > > > So anyways, i started looking for this elearning solution and found it, > > its called whiteboard. But, in looking at it, i thought most of its > > stuff is already in good shape in phpgw, so it would be a better idea to > > port it. I contacted the author and he is interested in the idea. So we > > will probably have that by the end of the year as well. > > > > Another client thats a-comming is an industry needing a simple CRM. With > > quoting capabilities for their sales model. No prob, i thought, there is > > CKledger and, whatever it cannot do, we can make happen in house. > > > > So, all in all, phpgroupware has some shortcommings, but they are mainly > > related to the fact that its written in php. What ive learned is that > > its a PLATFORM, not just a webmail or a suite, but a whole framework for > > building collaboration applications. From that point of view, phpgw has > > NO match, no other FLOSS groupware project that ive found worries about > > providing a platfrom independent collaboration API. This thing can > > export its methods through xmlrpc or php and supports a good number of > > databases for the backend. > > > > In this respect, everyone in the community is working on that idea (i > > think). You have escandinavian companies doing some great document > > management stuff, american ppl studying the posibilities of > > interoperation of phpgw with other FLOSS solutions (OpenOffice, > > OpenGroupware, Evolution), EU companies making plugins to sync it with > > outlook, others trying to formalize and document the design, AU > > consultants working on the freamework to have a generic syncronization > > solutions (palm syncyng...etc.) and we are ALL open to subcontracts (had > > to pitch that one in). > > > > Its a live community of ppl with real business problems and scenarios, > > most likely similar to yours, so, YES, I bet my company on this thing, > > for that matter, I bet yours! ... ;) > > > > Also, this is a community that you can talk with, discuss the problems > > you encounter and i can assure you that, if you interact with it the > > right way, youll soon find people with solutions to your problems > > (solutions that maybe youll have to implement yourself, maybe not). > > > > So, thats the risk, that a FLOSS project may or may not go in the > > direction you want it to. Same thing happens with linux or any other > > project of this kind. BUT, if you comply with the quality and > > interaction ettiquete rules, you will allways have a way to solve your > > problems by doing it yourself, by associating with interested parties in > > the community or by paying to get it done (there are guidelines for this > > too, not everything will be accepted into core, even if you try and pay, > > but there is a place for this kind of modification as well). > > > > Um...i cant direct you to the links where all this stuff is documented > > (guidelines, way to work...e.tc.) cause the main site got haXored by > > evil daemon-kiddies. But stick arround, download the thing, look at the > > api, discuss your needs and have tons of fun. > > > > (Hell thats a long sales pitch) > > > > > Doug > > > -- > > > Doug Dicks > > > Revelant Technologies > > > > > > > > > > > > _______________________________________________ > > > Phpgroupware-users mailing list > > > Php...@gn... > > > http://mail.gnu.org/mailman/listinfo/phpgroupware-users > > > > _______________________________________________ > > Phpgroupware-users mailing list > > Php...@gn... > > http://mail.gnu.org/mailman/listinfo/phpgroupware-users > > > > _______________________________________________ > Phpgroupware-users mailing list > Php...@gn... > http://mail.gnu.org/mailman/listinfo/phpgroupware-users |
|
From: C K Wu <ck...@ho...> - 2003-08-04 01:19:09
|
Hello, Alex, Thank you for considering CK-Ledger as a possible starting point for offering solution to your client. I'll be more than happy to incorporate whatever changes you make to CK-Ledger back into the main CK-Ledger distribution code, if you so incline. P.S. This reply is not sent to the phpgw list, but instead directed to ck-...@li..., because I think it may not be of general interest to the phpgw list. Best Regards, CK Wu Alex Borges wrote: > El vie, 01-08-2003 a las 08:08, Doug Dicks escribi=F3: > > Hello All, > > > > I need some opinions or advice. > > > > A month ago some of my coworkers and I left our previous employer to > > start a new company. We've just gotten our first significant contrac= t, > > one which calls for a groupware (email, address book, time-tracking) > > solution. It's a large number of users, but generally not all at the > > same time. > > > > We'd really like to use an open solution. We all believe in open sou= rce > > and are willing to contribute work back to the project. Something li= ke > > Exchange/Outlook would kill our profit margin, but we'd rather break > > even than fail. > > > > The new project is pretty high-visibility within the local community = and > > has several very large companies involved. The outcome of this proje= ct > > will certainly have a major, major impact on the future of our new co= mpany. > > > > So, given all of this, would you use PHPGroupware if this were *your* > > company? Why or why not? > > > > Thanks for your advice. PHPGroupware is our "plan a", and I need to > > validate this direction. Things should get rolling very quickly now > > that we have the deal, and the project schedule doesn't allow for any > > time to change out the core technology half-way through. > > > > Thanks again. I look forward to your comments. > > > > This is a very good question. Some of the contributors here are members > of company that have taken this step long ago. Probably the first of > them should be Dan and/or jengo (dont remember), creators of this thing= , > that founded a company.... and many others. Some of them founded their > companies, others are independent consultants and others are in-house > consultants for the companies they work with. > > ----------------------------- > |Here is a success story. Ill try to be as objective as possible. > ----------------------------- > > All in all, i have a phpgw working with a 600 administrative (with pcs > and net connections) user organization with 30 branches all over my > country (mexico) and in other countries (costa rica, the us). This is a > large autoparts maker. Its been a lot of work, but i dont regret it at > all, this year its actually starting to pay off. > > I started that deployment last year, about march. I was supposed to mov= e > this guys from exchange to a solution of my choosing. I had been > tracking phpgw and using it inhouse for a year before that and i liked > it. > > So in i went. I saved them about 90% of what it was gonna cost them if > they stayed in exchange (two year deadline was comming), so i lost mone= y > (do the numbers), and i had to heavily modify phpgw to their liking. > > Took me about 8 months to stabilize the whole thing with migration and > all the changes they wanted (the javascript addressbook was one of thos= e > changes). > > Today its a different story i think. The phpgw i took back then was a > great app, but it needed significant tweaking to make it into that > corporate datacenter. Stuff like a central company directory with links > to accounts were there, just not how the admin wanted it. So i rolled m= y > own changes. > > In the end all my work it was so messy that i didnt even want to pass i= t > back to the community, knowing it would be instantly rejected (hey, i > rejected it myself). So, i waited until stabilization was completed and= , > in the meantime, i started contributing and discussing what the client > asked of me. > > The release schedulled by aug 8 covers all of what i did and more with = a > very high standard of quality. > > Some of that was made by the community since some ppl here had the same > needs as myself, some were ideas of other ppl that i hadnt thought of, > some is stuff that im paying to be done and is being finished as we > write (its 2:30 am here, i should get back to that). > > This year we were contacted by a university with 4000 students wanting > an e-learning solution. I immediatly thought of phpgw but my associates > shrugged on me since weve spent so much on it with almost no profit > (now, to level this, this is not true, its not much proffit from phpgw, > but the client also pays a service fee for network consultancy and > mantainership of their servers. we convinced them to switch their dbms > to linux as well, and we wouldve never gotten in if we didnt have what > they really needed at the right time). > > So anyways, i started looking for this elearning solution and found it, > its called whiteboard. But, in looking at it, i thought most of its > stuff is already in good shape in phpgw, so it would be a better idea t= o > port it. I contacted the author and he is interested in the idea. So we > will probably have that by the end of the year as well. > > Another client thats a-comming is an industry needing a simple CRM. Wit= h > quoting capabilities for their sales model. No prob, i thought, there i= s > CKledger and, whatever it cannot do, we can make happen in house. > > So, all in all, phpgroupware has some shortcommings, but they are mainl= y > related to the fact that its written in php. What ive learned is that > its a PLATFORM, not just a webmail or a suite, but a whole framework fo= r > building collaboration applications. From that point of view, phpgw has > NO match, no other FLOSS groupware project that ive found worries about > providing a platfrom independent collaboration API. This thing can > export its methods through xmlrpc or php and supports a good number of > databases for the backend. > > In this respect, everyone in the community is working on that idea (i > think). You have escandinavian companies doing some great document > management stuff, american ppl studying the posibilities of > interoperation of phpgw with other FLOSS solutions (OpenOffice, > OpenGroupware, Evolution), EU companies making plugins to sync it with > outlook, others trying to formalize and document the design, AU > consultants working on the freamework to have a generic syncronization > solutions (palm syncyng...etc.) and we are ALL open to subcontracts (ha= d > to pitch that one in). > > Its a live community of ppl with real business problems and scenarios, > most likely similar to yours, so, YES, I bet my company on this thing, > for that matter, I bet yours! ... ;) > > Also, this is a community that you can talk with, discuss the problems > you encounter and i can assure you that, if you interact with it the > right way, youll soon find people with solutions to your problems > (solutions that maybe youll have to implement yourself, maybe not). > > So, thats the risk, that a FLOSS project may or may not go in the > direction you want it to. Same thing happens with linux or any other > project of this kind. BUT, if you comply with the quality and > interaction ettiquete rules, you will allways have a way to solve your > problems by doing it yourself, by associating with interested parties i= n > the community or by paying to get it done (there are guidelines for thi= s > too, not everything will be accepted into core, even if you try and pay= , > but there is a place for this kind of modification as well). > > Um...i cant direct you to the links where all this stuff is documented > (guidelines, way to work...e.tc.) cause the main site got haXored by > evil daemon-kiddies. But stick arround, download the thing, look at the > api, discuss your needs and have tons of fun. > > (Hell thats a long sales pitch) > > > Doug > > -- > > Doug Dicks > > Revelant Technologies > > > > > > > > _______________________________________________ > > Phpgroupware-users mailing list > > Php...@gn... > > http://mail.gnu.org/mailman/listinfo/phpgroupware-users > > _______________________________________________ > Phpgroupware-users mailing list > Php...@gn... > http://mail.gnu.org/mailman/listinfo/phpgroupware-users |
|
From: C K Wu <ck...@ho...> - 2003-08-01 02:19:22
|
Hi Constantinos, Thank you for your interest in the progress of CK-Ledger. At the moment, my CK-Ledger development codebase is being run on top of phpgroupware 0.9.14.006. After thrashing out the remaining problem of interoperating with Postgres 7.3.2, a new version of CK-Ledger will be released, which is expected to be made by the end of next week (ie Aug 10). P.S. - I am sending a copy of this reply to ck-...@li..., so the others are aware of current development. Best Regards, CK Constantinos Marinoglou wrote: > Hi CK, > > When are you planning to include the new phpgroupware > version at your appl ? > > Best Regards, > Konstantinos > > --- C K Wu <ck...@ho...> wrote: > 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 > > > > ________________________________________________________________________ > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ |
|
From: Ralf B. <Ral...@ou...> - 2003-07-21 23:10:27
|
Hi all, this release fixes a just discovered exploit in phpGroupWare. The exploit works for *ALL* branches (.14, .16 and HEAD) !!! EVERYONE, PLEASE UPDATE IMEDIATLY !!! There is also one calendar bug fixed in this release: Dayview is displaying events again (was broken in .14.005) and germany manual files for some apps added. You can grab it via a cvs update or from http://phpgroupware.org/downloads/ Cheers Ralf Becker on behalf of the phpGroupWare Development Crew -- ---------------------------------------------------------------------- Ralf Becker OUTDOOR UNLIMITED Training GmbH Telefon 0631 / 31657-0 Leibnizstraße 17 Telefax 0631 / 31657-26 D-67663 Kaiserslautern EMail Ral...@ou... |
|
From: C K Wu <ck...@ho...> - 2003-07-10 23:40:55
|
Hi, Kenson, [This is a repeat of the reply that I sent you earlier] Thank you for checking out CK-Ledger. The error that you encountered is indeed very much due to the required tables hadn't been created. The index page of each ck-ledger module carries a 'User/Administrator' column on the left hand side. Mid-way down the column is a small section showing how data tables and test data may be created. You could also refer to the Installation Manual kept at the [doc] subfolder of each ck-ledger module. There is one important point that you may have to take note of. CK-Ledger is designed and tested in a Linux environment. It is a deliberate decision of mine that CK-Ledger is not going to run properly within a M$ Windows environment. I am pretty sure that you will encounter further error and problems that are fatal. This M$ Windows incompatibility will be maintained in future. My advice is that you could try to install one of the many free Linux (RedHat, Mandrake, ....) distributions and install/test CK-Ledger from there. Best Regards, CK Kenson Peh wrote: Kenson Peh wrote: > Hi Team, > > I am a newbie to using phpgroupware with CK-ledger. I have facing a problem > when after success to add in ck-hr and etc feature into phpgroupware. When i > click on Employee on HR module. I will get : > Database error: Invalid SQL: SELECT * FROM hrcode WHERE type='prefix' ORDER > BY name > MySQL Error: 1146 (Table 'phpgroupware.hrcode' doesn't exist) > > Below is the step i install application: > PC: OS-win 2000pro, apache 1.3.4, php4, mysql3.25 > 1. Unzip phpgroupware and ck-ledger. (success) > 2. Install phpgroupware and register ck-hr (success) > 3. login as admin and check the feature authentication > 4. click on Human Resourse and click Employee then i get > Database error: Invalid SQL: SELECT * FROM hrcode WHERE type='prefix' ORDER > BY name > MySQL Error: 1146 (Table 'phpgroupware.hrcode' doesn't exist) > > Version i download for ck-ledger is "ck-ledger-0[1].6.3.tar.gz" > Version i download for phpgroupware is version 0.9.14.005 > > Do i miss some step in order to get ck-hr feature working? > > Thanks for helping me! > > Regards, > Kenson > > _________________________________________________________________ > Download the latest MSN Messenger http://messenger.msn.com.my > > ------------------------------------------------------- > This SF.Net email sponsored by: Parasoft > Error proof Web apps, automate testing & more. > Download & eval WebKing and get a free book. > www.parasoft.com/bulletproofapps1 > _______________________________________________ > CK-Ledger-users mailing list > CK-...@li... > https://lists.sourceforge.net/lists/listinfo/ck-ledger-users |
|
From: Kenson P. <pk...@ho...> - 2003-07-10 02:35:43
|
Hi Team, I am a newbie to using phpgroupware with CK-ledger. I have facing a problem when after success to add in ck-hr and etc feature into phpgroupware. When i click on Employee on HR module. I will get : Database error: Invalid SQL: SELECT * FROM hrcode WHERE type='prefix' ORDER BY name MySQL Error: 1146 (Table 'phpgroupware.hrcode' doesn't exist) Below is the step i install application: PC: OS-win 2000pro, apache 1.3.4, php4, mysql3.25 1. Unzip phpgroupware and ck-ledger. (success) 2. Install phpgroupware and register ck-hr (success) 3. login as admin and check the feature authentication 4. click on Human Resourse and click Employee then i get Database error: Invalid SQL: SELECT * FROM hrcode WHERE type='prefix' ORDER BY name MySQL Error: 1146 (Table 'phpgroupware.hrcode' doesn't exist) Version i download for ck-ledger is "ck-ledger-0[1].6.3.tar.gz" Version i download for phpgroupware is version 0.9.14.005 Do i miss some step in order to get ck-hr feature working? Thanks for helping me! Regards, Kenson _________________________________________________________________ Download the latest MSN Messenger http://messenger.msn.com.my |
3 messages has been excluded from this view by a project administrator.
