[CK-Ledger-users] CK-Ledger v.0.0.5 released
Status: Beta
Brought to you by:
ckwu
|
From: C K Wu <ck...@ch...> - 2002-02-16 05:59:52
|
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 |