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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi, everybody,

I have uploaded the tarball for a pre-alpha release version, 0.0.5, of
CK-Ledger to sourceforge yesterday.

As indicated in the release note, it is modeled on SQL-Ledger v.1.8.2.
It require phpgroupware 0.9.12, but will also work with 0.9.14RC1.

Features additional to SQL-Ledger are,
Ledger Admin - data backup/restore;
Ledger (G/L) - audit control report, journal history, ledger listing;
Inventory - audit control report, inventory in/out history, explicit
inventory adjustment transaction, goods receipt transaction, goods
delivery transaction;
Service - separate module for access by non-warehouse staff;
Accounts Payable - audit control report, manual override of system
calculated tax, separate rate and account setting for tax received and
paid, explicit payment transaction, matching of payment against invoice
allowing one payment settling multiple invoices, invoice/PO matching,
invoice payment history, cheque printing;
Accounts Receivable - audit control report, manual override of system
calculated tax, separate rate and account setting for tax received and
paid, explicit receipt transaction, matching of receipt against invoice
allowing one receipt settling multiple invoices, invoice/SO matching,
invoice receipt history, customer statement, invoice reminder, official
receipt;
Purchase Order - audit control report, purchase order billing history;
Sales Order - audit control report, sales order billing history.

Working Configuration:
RedHat7.2, Apache 1.3.20, PostgreSQL 7.1.3, phpgroupware 0.9.12 (most
stable setup)
RedHat7.2, Apache 1.3.20, PostgreSQL 7.1.3, phpgroupware 0.9.14RC1 (some
errors occur when logging out of phpgw, but this does not affect the
working of CK-Ledger)
Mandrake 8.1, Apache 1.3.20, PostgreSQL 7.1.2, phpgroupware 0.9.14RC1
(same errors as with RedHat 7.2)

[I have also tried RedFlag Linux Server 2.0.  It used to work before I
set up the Ledger Admin module.  It fails at the Ledger Admin/Ledger
Build process.
Apparently, it's due to the use of a new SQL syntax not supported by the
PostgreSQL v.6.x.  If PostgreSQL is upgraded to 7.1.2 or above, it would
probably work.  If anyone is successful in this regard or is able to run
CK-Ledger with RedFlag Linux Server 3.0, would appreciate a note back to
this mailing list.]

If anyone is successful with other Linux distribution, would also
appreciate a note back to this list.

Installation Procedure.
1.    Setup a working Linux environment with Apache and PostgreSQL fully
installed.
2.    Setup phpgroupware 0.9.12 or 0.9.14RC1.  For detail instruction,
please refer to www.phpgroupware.org
3.    Test to ensure you have a working phpgroupware setup.
4.    Download ck-ledger-0.0.5.tar.gz from sourceforge.net.
5.    # cd /var/www/html/phpgroupware                    [assuming
/var/www/html/phpgroupware is phpgw's base directory]
6.    # tar -xzvf <path of ck-ledger-0.0.5.tar.gz>        [extract code
into 8 folders, ledadmin, ledger, inventory, service, ap, ar, po, so
within phpgw's base directory]
7.    Login phpgroupware as administrator.
8.    Invoke admin (the castle icon) module.
9.    Pick the "Applications" choice
10.    Repeat the following process 8 times (ie. Step 11, 12a, 11, 12b,
11, 12c, ..........).
11.    Press "Add" button
12.    Fill in the new application details
a.        Application name:  ledadmin    Application title: Ledger
Administration ;   [leave the other settings unchanged];  Press "Add"
button
b.        Application name:  ledger        Application title:
Ledger;                            [leave the other settings
unchanged];  Press "Add" button
c.        Application name:  inventory    Application title:
CK-inventory                    [leave the other settings unchanged];
Press "Add" button
d.        Application name: service        Application title:
Service                            [leave the other settings
unchanged];  Press "Add" button
e.        Application name: ap                Application title:
Accounts Payable            [leave the other settings unchanged];  Press
"Add" button
f.        Application name: ar                Application title:
Accounts Receivable        [leave the other settings unchanged];  Press
"Add" button
g.        Application name: po                Application title:
Purchase Order               [leave the other settings unchanged]; Press
"Add" button
h.        Application name: so                Application title:  Sales
Order                    [leave the other settings unchanged];  Press
"Add" button
13.    Invoke admin (the castle icon) module again.
14.    Pick the "User groups" choice
15.    Click "Edit" on the Default group line            [This is just
an example.  You could create your own group and work from there too]
16.    Click to activate the modules, Ledger Administration, Ledger,
CK-inventory, Service, Accounts Payable, Accounts Receivable, Purchase
Order, Sales Order
17.    Press "Submit Changes" button.
18.    Logout from adminstrator account.
19.    Login as a common member of the Default group, say demo.
20.    The CK-Ledger modules will show up as "abacus" icons.
21.    Choose the LedgerAdmin module.  You may have to click all 8 icons
to find out which icon relates to which module.
22.    Read in detail the "Welcome to LedgerAdmin" page.
23.    Pick Admin/Setup choice at the top left hand corner
24.    Choose action 4 - Delete all Data and Data Tables
25.    Press "Input Admin Action Parameters" button
26.    Press "Start Action" button                        [For new
installs, there may be error messages saying that the data tables are
not present.  But don't worry]
27.    Press one of the "Done" buttons
28.    Choose action 1 - Setup Data Tables
29.    Press "Input Admin Action Parameters" button
30.    Press "Start Action"
button                                              [A list of table
created message will appear]
31.    Press one of the "Done" buttons
32.    Choose action 2 - Build Chart of Accounts and other Master Data
33.    Press "Input Admin Action Parameters" button
34.    Pick your desired Chart of Account                    [Currently,
only Default Chart of Account works.  It is modelled on SQL-Ledger's
default chart]
35.    Presss "Start Action" button
36.    Press one of the "Done" buttons
37.    Choose action 3 - Create Test Data                    [For live
production, creation of test data should be skipped]
38.    Press "Input Admin Action Parameters" button
39.    Press "Start Action"
40.    Press one of the "Done" buttons

At this point, CK-Ledger is fully functional and all features are
available for your testing.

A few points to note:

1.    Some of the menu choices are still not yet implemented
2.    There is an inventory module native to phpgroupware, therefore it
is advisable to name CK-Ledger's inventory as CK-inventory.
3.    The cheque printing facility assumes a normal stub-based manual
handwriting cheque format (not the special computer stationery type).
        The layout would have to be tuned for different bank's cheque
format.  The included facility is just for sample only.
4.    Since this is a pre-alpha release, so DO NOT, DON'T, DO NOT AGAIN
use this version against any production data or environment.

Have a nice time testing this version.  Please report any error back to
this list.

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