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
