Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
On Mon, Nov 12, 2012 at 8:17 PM, Berend Tober bto...@broadstripe.netwrote: Chris Travers wrote: 1.4 is coming along. We could use more involvement. ... Hi; I have committed your patches. The one to pg-database.sql thought seems out of date and already applied. Are you running last snapshot or from svn? Best Wishes, Chris Travers -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Hi, Chris, Is there a migration path for 1.3 - 1.4 available yet? Would like to run the two versions side-by-side for a bit with real numbers... I'll definitely be happy to test, and I have a need for some cash-based income reports come January (and I know we'll have to do some adjustments to prior years' returns...) Cheers, John On 11/13/2012 06:04 AM, Chris Travers wrote: On Mon, Nov 12, 2012 at 8:17 PM, Berend Tober bto...@broadstripe.net mailto:bto...@broadstripe.net wrote: Chris Travers wrote: 1.4 is coming along. We could use more involvement. ... Hi; I have committed your patches. The one to pg-database.sql thought seems out of date and already applied. Are you running last snapshot or from svn? Best Wishes, Chris Travers !DSPAM:50a25374326914621311308! -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov !DSPAM:50a25374326914621311308! ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel !DSPAM:50a25374326914621311308! -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: I have committed your patches. The one to pg-database.sql thought seems out of date and already applied. Are you running last snapshot or from svn? I think so. Maybe I should have deleted my working copy and did a fresh-from-scratch checkout, but I figured SVN is pretty trustworthy. Since I had checked-out trunk a while ago, I simply did an svn update. Here is info from my local working copy: [chief trunk]$ pwd /usr/local/src/ledger-smb/trunk [chief trunk]$ svn info Path: . URL: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk Repository Root: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb Repository UUID: 4979c152-3d1c-0410-bac9-87ea11338e46 Revision: 5185 Node Kind: directory Schedule: normal Last Changed Author: ehuelsmann Last Changed Rev: 5184 Last Changed Date: 2012-11-10 15:05:37 -0500 (Sat, 10 Nov 2012) Let me know if you think I have done something inadvisable, please. -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: Anyone who would like help getting started should email this list. I think there is something wrong in file sql/modules/Payroll.sql at lines 72 CREATE OR REPLACE FUNCTION payroll_income_type__get(in_id int) 73 RETURNS payroll_income_type AS $$ 74 SELECT * FROM payroll_income_class WHERE id = $1; 75 $$ LANGUAGE SQL; The declared return type is payroll_income_type, but it actually returns a set of payroll_income_class rows. These objects have different types -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: Anyone who would like help getting started should email this list. journal_entry is spelled wrong in sql/modules/Roles.sql. Attached patch fixes. Index: sql/modules/Roles.sql === --- sql/modules/Roles.sql (revision 5191) +++ sql/modules/Roles.sql (working copy) @@ -242,7 +242,7 @@ GRANT lsmb_?lsmb dbname ?__exchangerate_edit TO lsmb_?lsmb dbname ?__ar_transaction_create; -GRANT INSERT ON ar, invoice_note, business_unit_ac, jounral_entry, journal_line, +GRANT INSERT ON ar, invoice_note, business_unit_ac, journal_entry, journal_line, business_unit_jl TO lsmb_?lsmb dbname ?__ar_transaction_create; -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: Anyone who would like help getting started should email this list. sql/modules/Roles.sql attempts to execute: 1409 GRANT EXECUTE ON FUNCTION admin__list_roles(text) 1410 TO lsmb_?lsmb dbname ?__users_manage; No such function admin__list_roles is defined. Should that be admin__get_roles ? -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: Anyone who would like help getting started should email this list. sql/modules/Transaction_Templates.sql creates a function journal__add, which appears to add a row to a journal table. I do not see such a named table. Is it maybe supposed to be table journal_entry? Same for function journal__search and journal__get_entry? -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/11/09 00:13 , Chris Travers wrote: Hi all; 1.4 is coming along. We could use more involvement. I won't promise that everything works but the core of the software should. You will need PostgreSQL 8.4 of higher, plus the standard requirements to get started (Module::Install). Right now the core functions should work, but some things may not. Any bug reports are welcome. Additionally if anyone wants to look at the current report system and contribute new reports we are getting to the end of when this will be possible to include in the main distribution. Anyone who would like help getting started should email this list. You can get the latest by svn co https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk Best wishes, Chris Travers I think my best way to work with this would be to duplicate my books, and duplicate my accounting, which I'm willing to do until 1.4 comes out. I'm not quite sure how I would go about doing this. I'll take a look at this some time in the coming week when I get back home. Jigme Datse Yli-Rasku - -- Datse Multimedia Productions http://DatseMultimedia.com/ Tel:250-352-6870 Mobile: 250-354-7094 -BEGIN PGP SIGNATURE- Version: GnuPG/MacGPG2 v2.0.18 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://www.enigmail.net/ iQEcBAEBAgAGBQJQoXfhAAoJEPTTlG5JFW+77sAH/irwx5tG6xOSNoAOsPZAQdaX FBkDvrvAXxV6ZrIBc9YTE2FuOdR5JYCBn60fGnsV03Bg0azOnizJteAapsT+8jhP 1+dQU+O2W9vFKXG1A4pQbjGH8NrdUlc5NfkT8Cuj86oPiX8CtCkKoF0olybhM/NR wjpdAJl6i1/YOMVgvCe4d5roQm9Zigul/CWdUvMBrNUmgDbeOQiWnmcI5JUkIFb7 DP3W6LjEzderH6J6eZMFcgUZVCYZP2UpfFKbyFNDcw4FHif7soWmeQjShjOc0Mfa 3KCr5SsOVjPwQI3qnvoaqo9UcuuwHzZxFJwS8gphNaJUHfBbzp5qH8jFd2/Ec94= =xvJK -END PGP SIGNATURE- -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: Hi all; 1.4 is coming along. We could use more involvement. I won't promise that everything works but the core of the software should. There is a syntax error in file sql/modules/PNL.sql It is reported on line 25: ERROR: syntax error at or near ) LINE 25: ... OR in_business_units IS NULL OR ac.entry_id IN) ^ but that same expression actually occurs both on line 48 and 80. I do not know what the argument to IN is supposed to be at that point. -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: Hi all; 1.4 is coming along. We could use more involvement. I won't promise that everything works but the core of the software should. I believe the name of function batch_search is spelled incorrectly at line 143. Attached patch fixes. Index: sql/modules/Voucher.sql === --- sql/modules/Voucher.sql (revision 5185) +++ sql/modules/Voucher.sql (working copy) @@ -140,7 +140,7 @@ ); CREATE OR REPLACE FUNCTION -batch__search(in_class_id int, in_description text, in_created_by_eid int, +batch_search(in_class_id int, in_description text, in_created_by_eid int, in_date_from date, in_date_to date, in_amount_gt numeric, in_amount_lt numeric, in_approved bool) -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: 1.4 is coming along. We could use more involvement. I won't promise that everything works but the core of the software should. The module sql/modules/Fixes.sql at line attempts to add a column which already exists in the CREATE TABLE statement for table makemodel in sql/Pg-database.sql Attached patch removes ALTER TABLE DDL. Index: sql/modules/Fixes.sql === --- sql/modules/Fixes.sql (revision 5185) +++ sql/modules/Fixes.sql (working copy) @@ -6,10 +6,6 @@ -- during 1.4m2 BEGIN; -ALTER TABLE makemodel ADD barcode TEXT; - -COMMIT; - BEGIN; ALTER TABLE account ADD COLUMN is_temp BOOL NOT NULL DEFAULT FALSE; COMMIT; -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Status of 1.4 and call for involvement
Chris Travers wrote: 1.4 is coming along. We could use more involvement. ... Anyone who would like help getting started should email this list. You can get the latest by svn co https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk I have svn updated my check out of trunk. I get a number of errors running prepare-company-database.sh. The first two appear due to a table creation ordering problem. The tables business_unit_class and business_unit are referenced as foreign keys before they are created. Attached patch changes creates those two tables earlier. There are still a bunch of errors I am getting, though, after the sql/modules start to load. Index: sql/Pg-database.sql === --- sql/Pg-database.sql (revision 5185) +++ sql/Pg-database.sql (working copy) @@ -1231,6 +1231,39 @@ primary key (id) ); +CREATE TABLE business_unit_class ( +id serial not null unique, +label text primary key, +active bool not null default false, +ordering int +); + +COMMENT ON TABLE business_unit_class IS +$$ Consolidates projects and departments, and allows this to be extended for +funds accounting and other purposes.$$; + +INSERT INTO business_unit_class (id, label, active, ordering) +VALUES (1, 'Department', '0', '10'), + (2, 'Project', '0', '20'), + (3, 'Job', '0', '30'), + (4, 'Fund', '0', '40'), + (5, 'Customer', '0', '50'), + (6, 'Vendor', '0', '60'), + (7, 'Lot', '0', 50); + +CREATE TABLE business_unit ( + id serial PRIMARY KEY, + class_id int not null references business_unit_class(id), + control_code text, + description text, + start_date date, + end_date date, + parent_id int references business_unit(id), + credit_id int references entity_credit_account(id), + UNIQUE(id, class_id), -- needed for foreign keys + UNIQUE(class_id, control_code) +); + CREATE TABLE business_unit_jl ( entry_id int references journal_line(id), bu_class int references business_unit_class(id), @@ -1925,26 +1958,6 @@ you have to spend to acquire the foreign currency (buy rate).$$; -- -CREATE TABLE business_unit_class ( -id serial not null unique, -label text primary key, -active bool not null default false, -ordering int -); - -COMMENT ON TABLE business_unit_class IS -$$ Consolidates projects and departments, and allows this to be extended for -funds accounting and other purposes.$$; - -INSERT INTO business_unit_class (id, label, active, ordering) -VALUES (1, 'Department', '0', '10'), - (2, 'Project', '0', '20'), - (3, 'Job', '0', '30'), - (4, 'Fund', '0', '40'), - (5, 'Customer', '0', '50'), - (6, 'Vendor', '0', '60'), - (7, 'Lot', '0', 50); - CREATE TABLE bu_class_to_module ( bu_class_id int references business_unit_class(id), module_id int references lsmb_module(id), @@ -1958,19 +1971,6 @@ JOIN lsmb_module; -- by default activate all existing business units on all modules -CREATE TABLE business_unit ( - id serial PRIMARY KEY, - class_id int not null references business_unit_class(id), - control_code text, - description text, - start_date date, - end_date date, - parent_id int references business_unit(id), - credit_id int references entity_credit_account(id), - UNIQUE(id, class_id), -- needed for foreign keys - UNIQUE(class_id, control_code) -); - CREATE TABLE job ( bu_id int primary key references business_unit(id), parts_id int, -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
[Ledger-smb-devel] Status of 1.4 and call for involvement
Hi all; 1.4 is coming along. We could use more involvement. I won't promise that everything works but the core of the software should. You will need PostgreSQL 8.4 of higher, plus the standard requirements to get started (Module::Install). Right now the core functions should work, but some things may not. Any bug reports are welcome. Additionally if anyone wants to look at the current report system and contribute new reports we are getting to the end of when this will be possible to include in the main distribution. Anyone who would like help getting started should email this list. You can get the latest by svn co https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk Best wishes, Chris Travers -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel