Re: [Ledger-smb-devel] Where we are at on the 1.4 changelog

2012-07-16 Thread Chris Travers
On Sun, Jul 15, 2012 at 10:43 PM, John Locke m...@freelock.com wrote:

  Holy crap this sounds great!

 Fantastic work.

 What's your sense on stability, at this point? e.g. can we assume that
 financial logic is sound?


Financial logic is generally sound in terms of transactions and GL reports
work.

I am working on replacing the trial balance, income statement, and balance
sheet.

The customer/vendor/employee logic is solid (and has been rewritten again
to be more modular and with better interfaces).  Also the COGS routines
have been rewritten as stored procedures and these are unit tested.


 What does the upgrade from 1.3 look like -- are there scripts/tools for
 doing that yet?


The basic logic has been completed mostly, but we may still have a couple
of changes in the db schema.  New tables of course won't be a problem with
the upgrade routines we generally use.  What hasn't been done yet but will
be done before the next snapshot, will be logic to detect 1.3 vs 1.4 and
upgrade appropriately.

We will follow the same non-destructive  upgrade process


 Really looking forward to checking this out. However we're totally slammed
 right now, don't see a spare moment before August the way things are
 looking... and I don't have a server set up with Postgres 8.4+ yet...


No problem.

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


[Ledger-smb-devel] Where we are at on the 1.4 changelog

2012-07-15 Thread Chris Travers
I figured it would be worthwhile to send out the changelog and get feedback.

General Enhancements:
* Performance enhancements on menu routines (Chris T and Steven M)
* Added +/- selection indicators to menu CSS (Chris T)
* Changing all auth calls to hit postgres db instead of template1 (Chris T)
* invoice.unit is now unbounded varchar to reduce errors (Chris T, 3516235)
* Invoices with inventory subject to draft/vouchers workflows (Chris T)
* Added Equity (Temp) account type, closed at year-end (Chris T)
* Added description field to transaction and invoice screens (Chris T)
* Removed ability to repost/delete transactions (Chris T)
* Partsgroups can now be nested though this is not yet used by LSMB (Chris
T)
* Session expiration now with configurable behavior (Chris T)

Installation/Upgrade
* PostgreSQL contrib dependencies removed, now require Pg 8.4 (Chris T)
* LaTeX format detection now run-time call, not configured (Chris T)

Code/API improvements
* scripts/* files moved to make inheritance possible (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 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)
* Centralized database commit for new code (Chris T)

New RESTful Web Services Framework
* Supports XML and JSON as input formats
* Supports XML and JSON as output formats
* Supports read/write for Contacts:
   * Customers
   * Vendors
   * Employees
   * Leads
   * More

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)
* Enhanced trial balance allows for partial trial balance (Chris T)
* Enhanced trial balance allows for saved criteria (Chris T)

Customer/Vendor/Employee Handling and CRM
* Added sales tax id and license number fields for companies (Chris T)
* Simpified database schema (Chris T)
* Full text search of notes for customers/vendors (Chris T)
* Added file attachments to customers, vendors, employees, leads etc (Chris
T)
* Added lead handling (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)
* Imports initial inventory and periodic counts (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)

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] Where we are at on the 1.4 changelog

2012-07-15 Thread John Locke

Holy crap this sounds great!

Fantastic work.

What's your sense on stability, at this point? e.g. can we assume that 
financial logic is sound?


What does the upgrade from 1.3 look like -- are there scripts/tools for 
doing that yet?


Really looking forward to checking this out. However we're totally 
slammed right now, don't see a spare moment before August the way things 
are looking... and I don't have a server set up with Postgres 8.4+ yet...


Cheers,
John Locke
http://www.freelock.com


On 07/15/2012 06:37 PM, Chris Travers wrote:
I figured it would be worthwhile to send out the changelog and get 
feedback.


General Enhancements:
* Performance enhancements on menu routines (Chris T and Steven M)
* Added +/- selection indicators to menu CSS (Chris T)
* Changing all auth calls to hit postgres db instead of template1 
(Chris T)
* invoice.unit is now unbounded varchar to reduce errors (Chris T, 
3516235)

* Invoices with inventory subject to draft/vouchers workflows (Chris T)
* Added Equity (Temp) account type, closed at year-end (Chris T)
* Added description field to transaction and invoice screens (Chris T)
* Removed ability to repost/delete transactions (Chris T)
* Partsgroups can now be nested though this is not yet used by LSMB 
(Chris T)

* Session expiration now with configurable behavior (Chris T)

Installation/Upgrade
* PostgreSQL contrib dependencies removed, now require Pg 8.4 (Chris T)
* LaTeX format detection now run-time call, not configured (Chris T)

Code/API improvements
* scripts/* files moved to make inheritance possible (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 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)
* Centralized database commit for new code (Chris T)

New RESTful Web Services Framework
* Supports XML and JSON as input formats
* Supports XML and JSON as output formats
* Supports read/write for Contacts:
   * Customers
   * Vendors
   * Employees
   * Leads
   * More

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)
* Enhanced trial balance allows for partial trial balance (Chris T)
* Enhanced trial balance allows for saved criteria (Chris T)

Customer/Vendor/Employee Handling and CRM
* Added sales tax id and license number fields for companies (Chris T)
* Simpified database schema (Chris T)
* Full text search of notes for customers/vendors (Chris T)
* Added file attachments to customers, vendors, employees, leads etc 
(Chris T)

* Added lead handling (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)
* Imports initial inventory and periodic counts (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)


Best Wishes,
Chris Travers
!DSPAM:500370c2280062201711104!


--
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/

!DSPAM:500370c2280062201711104!


___
Ledger-smb-devel mailing list
Ledger-smb-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel


!DSPAM:500370c2280062201711104!



--
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