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

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

Hi, everybody again,

I am afraid the installation procedure that I wrote in my last email
missed out on a major point.  Geoff from Australia, went thru' a
(phpgroupware 0.9.12+ck-ledger) installation on his Debian machine
and got stuck at step 21.  After choosing the LedgerAdmin icon, he
got the following errors,

Warning: PostgreSQL query failed: ERROR: Relation 'phpgw_inv_statuslist'
does not exist in
/var/www/phpgroupware/phpgwapi/inc/class.db_pgsql.inc.php on line 96
Database error: Invalid SQL: select * from phpgw_inv_statuslist
PostgreSQL Error: 1 (ERROR: Relation 'phpgw_inv_statuslist' does not exist )

The problem was solved by manually creating the table,
'phpgw_inv_statuslist', through,

# su -l postgres
$ psql phpgroupware
$ \i /var/www/html/phpgroupware/inv/doc/create_tables.pgsql

or using a single command,
# su -l -c "psql phpgroupware <
/var/www/html/phpgroupware/inv/doc/create_tables.pgsql"

After that, everything went normal.  Therefore, the installation procedure
should have an additional Step 6a,

# su -l -c "psql phpgroupware <
/var/www/html/phpgroupware/inv/doc/create_tables.pgsql"

Apparently, with phpgroupware 0.9.14RC1, the table was created by
phpgroupware's own setup process.

Best Regards,
CK


C K Wu wrote:

> 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