Re: [Ledger-smb-devel] Online editing of Templates ?
On Tue, 2012-05-08 at 11:23 -0400, Chris Travers wrote: On Tue, May 8, 2012 at 7:11 AM, Robert James Clay j...@rocasa.us wrote: On Wed, 2012-05-02 at 10:38 -0400, Robert James Clay wrote: That looks to be an issue where I was assuming that if a language specific file isn't already present, LSMB automatically starts off with a copy of the default file but that does not appear to be the case yet. If that is not something that is already present and not already planned, should I submit a feature request for it? I would keep it as a bug report because we get an error when we try to do something that is exposed from the UI. Submitted as # 3531738. (Sorry about the delay in getting it in...) Jame -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] File import plugin documentation
On 27/05/2012 03:22, Chris Travers wrote: On Fri, May 25, 2012 at 7:17 AM, Nigel Titleyni...@titley.com wrote: On 25/05/2012 14:55, Chris Travers wrote: Ok, so this is for reconciliation. I will commit a sample and send you a link, Many thanks. Sample code at https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.3/doc/samples/recon_csv.pl OK, having wrestled with this for a couple of hours this evening I've finally managed to import a reconciliation file. Various things confused me, the last being that the parse_id() should refer to the account id and not the account number (obvious really). Given a bit of luck I'll be able to write some documentation before long. Nigel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
[Ledger-smb-devel] Bug in Taxable sales report
Sales - Reports - Taxable Sales with From = 1/1/2012 and To 31/3/2012 gives the following error Error! * SELECT gl.transdate, gl.id, gl.invnumber, e.name, e.id as entity_id, eca.id as credit_id, eca.meta_number, gl.netamount, sum(CASE WHEN a.id IS NOT NULL then ac.amount ELSE 0 END) as tax, gl.invoice, gl.netamount + sum(CASE WHEN a.id IS NOT NULL then ac.amount ELSE 0 END) as total FROM (select id, transdate, amount, netamount, entity_credit_account, invnumber, invoice from ar where ? = 2 UNION select id, transdate, amount, netamount, entity_credit_account, invnumber, invoice from ap where ? = 1) gl JOIN entity_credit_account eca ON eca.id = gl.entity_credit_account JOIN entity e ON eca.entity_id = e.id JOIN acc_trans ac ON ac.trans_id = gl.id LEFT JOIN (select * from account where tax is true and accno = ? UNION SELECT * from account where tax is true and ? is null ) a on a.id = ac.chart_id LEFT JOIN dpt_trans dpt ON (gl.id = dpt.trans_id) WHERE (? is null or dpt.department_id = ?) AND (gl.transdate = ? or ? is null) AND (gl.transdate = ? or ? is null) GROUP BY gl.transdate, gl.id, gl.invnumber, e.name, e.id, eca.id, eca.meta_number, gl.amount, gl.netamount, gl.invoice HAVING (sum(CASE WHEN a.id is not null then ac.amount else 0 end) 0 AND ? IS NOT NULL) OR (? IS NULL and sum(CASE WHEN a.id is not null then ac.amount ELSE 0 END) = 0) ERROR: date/time field value out of range: 31/3/2012 LINE 25: AND (gl.transdate = '31/3/2012' or '31/3/2012' is... ^ HINT: Perhaps you need a different datestyle setting.* -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
[Ledger-smb-devel] Next development 1.4 release coming soon
Hi all; Here's what's left to do on my side. 1) I want to move the customer/vendor history reports to the new framework from the 1.3 framework 2) I want to move the transactions/outstanding reports from old code to the new framework 3) There are some issues with database creation still that I want to resolve 4) There are some menu tweaks that will need to happen plus a couple of minor structural changes to the menu At that point, the AR/AP/Journal functionality should be essentially where it will be at the release of 1.4 aside from bug fixes, etc. Work will be focused on moving reports over, rewriting employee and user handling and (after that is done) payroll. After this release I will start trying to support test instances of 1.4. This means schema change scripts and dumps of menu_node and menu_attribute. The changelog for 1.4 is already impressive. The shift in codebase has paid off. Best Wishes, Chris Travers The current changelog relative to 1.3 is: General Enhancements: * scripts/* files moved to make inheritance possible (Chris T) * PostgreSQL contrib dependencies removed, now require Pg 8.4 (Chris T) * Performance enhancements on menu routines (Chris T and Steven M) * Projects and Departments can now have subprojects and Departments (Chris T) * Project/department mechanism generalized to support funds, etc (Chris T) * Removed the Config::Std dependency and moved to Config::General (Chris T) * Improved error handling using Try::Tiny and die (Chris T) * Added +/- selection indicators to menu CSS (Chris T) * Added dynatable.html template that can be included in templates (Chris T) * Dynatable forms obtained through GET now show link back to form (Chris T) * LedgerSMB-error and Form-error now show db version and company (Chris T) * Simpler use of Log::Log4perl instead of LedgerSMB::Log (Chris T) * Changing all auth calls to hit postgres db instead of template1 (Chris T) * Centralized database commit for new code (Chris T) * invoice.unit is now unbounded numeric to reduce errors (Chris T, 3516235) New Reporting Framework * Easy bridge between SQL and display (Chris T) * All reports exportable to CSV (Chris T) * All reports exportable to PDF (Chris T) * Unified UI for reports (Chris T) Customer/Vendor Handling * Added sales tax id and license number fields for companies (Chris T) * Simpified database schema (Chris T) New CSV Import Module * Imports GL transactions (Chris T) * Imports AP batches (Chris T) * Imports charts of accounts entries (Erik H) * Imports GIFI tables (Erik H) * Imports SIC tables (Erik H) * Imports timecards (Chris T) * Extensible * field maps can be overridden New Business Reporting Unit System (Chris T) * Replaces Projects and Departments * Business reporting units may be nested * Allows one to do funds accounting, track jobs separately from projects, etc * Report on any combination of business reporting units (up to one per class) -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Bug in Taxable sales report
Filed as bug 3531784. Best Wishes, Chris Travers -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
Re: [Ledger-smb-devel] Next development 1.4 release coming soon
Wow. Great stuff! Did the web services stuff make it in yet, or will that be coming after 1.4 solidifies? Cheers, John Locke http://www.freelock.com On 06/03/2012 07:38 PM, Chris Travers wrote: Hi all; Here's what's left to do on my side. 1) I want to move the customer/vendor history reports to the new framework from the 1.3 framework 2) I want to move the transactions/outstanding reports from old code to the new framework 3) There are some issues with database creation still that I want to resolve 4) There are some menu tweaks that will need to happen plus a couple of minor structural changes to the menu At that point, the AR/AP/Journal functionality should be essentially where it will be at the release of 1.4 aside from bug fixes, etc. Work will be focused on moving reports over, rewriting employee and user handling and (after that is done) payroll. After this release I will start trying to support test instances of 1.4. This means schema change scripts and dumps of menu_node and menu_attribute. The changelog for 1.4 is already impressive. The shift in codebase has paid off. Best Wishes, Chris Travers The current changelog relative to 1.3 is: General Enhancements: * scripts/* files moved to make inheritance possible (Chris T) * PostgreSQL contrib dependencies removed, now require Pg 8.4 (Chris T) * Performance enhancements on menu routines (Chris T and Steven M) * Projects and Departments can now have subprojects and Departments (Chris T) * Project/department mechanism generalized to support funds, etc (Chris T) * Removed the Config::Std dependency and moved to Config::General (Chris T) * Improved error handling using Try::Tiny and die (Chris T) * Added +/- selection indicators to menu CSS (Chris T) * Added dynatable.html template that can be included in templates (Chris T) * Dynatable forms obtained through GET now show link back to form (Chris T) * LedgerSMB-error and Form-error now show db version and company (Chris T) * Simpler use of Log::Log4perl instead of LedgerSMB::Log (Chris T) * Changing all auth calls to hit postgres db instead of template1 (Chris T) * Centralized database commit for new code (Chris T) * invoice.unit is now unbounded numeric to reduce errors (Chris T, 3516235) New Reporting Framework * Easy bridge between SQL and display (Chris T) * All reports exportable to CSV (Chris T) * All reports exportable to PDF (Chris T) * Unified UI for reports (Chris T) Customer/Vendor Handling * Added sales tax id and license number fields for companies (Chris T) * Simpified database schema (Chris T) New CSV Import Module * Imports GL transactions (Chris T) * Imports AP batches (Chris T) * Imports charts of accounts entries (Erik H) * Imports GIFI tables (Erik H) * Imports SIC tables (Erik H) * Imports timecards (Chris T) * Extensible * field maps can be overridden New Business Reporting Unit System (Chris T) * Replaces Projects and Departments * Business reporting units may be nested * Allows one to do funds accounting, track jobs separately from projects, etc * Report on any combination of business reporting units (up to one per class) -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel !DSPAM:4fcc1fe4314443743763323! -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Ledger-smb-devel mailing list Ledger-smb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
