SF.net SVN: ledger-smb:[6404] trunk

[..hidden..]

Revision: 6404
          http://sourceforge.net/p/ledger-smb/code/6404
Author:   einhverfr
Date:     2014-01-07 01:22:19 +0000 (Tue, 07 Jan 2014)
Log Message:
-----------
No longer importing audit trail entries where person_id is null (and documenting this).  Some other updates to release notes.

Modified Paths:
--------------
    trunk/doc/release_notes
    trunk/sql/upgrade/1.3-1.4.sql

Modified: trunk/doc/release_notes
===================================================================
--- trunk/doc/release_notes	2014-01-06 08:43:32 UTC (rev 6403)
+++ trunk/doc/release_notes	2014-01-07 01:22:19 UTC (rev 6404)
@@ -1,7 +1,7 @@
 RELEASE NOTES
 LedgerSMB 1.4
 
-Latest Revision:  1.4.0 beta 1, Dec 15, 2012
+Latest Revision:  1.4.0 beta 4, TBD
 
 1:  Welcome to LedgerSMB
 
@@ -69,6 +69,9 @@
 management of recurring transactions, as well as the budgets add-on.  The point
 of sale has been broken off into addons to allow for faster release cycles.
 
+Finally templates for user documents (invoices, etc) are now loaded in the 
+database.
+
 2.4:  Database Changes
 
 Projects and Departments have been replaced by the new reporting units
@@ -76,15 +79,21 @@
 
 3:  Known Issues
 
-3.1:  Foreign exchange and payment reversals
+3.1:  Upgrade Limitations
 
+The upgrade procedure does not import audit trails where we don't know who did 
+something (i.e. where person_id is null).  If you have such, you may want to 
+the pre-upgrade data around (it is in a schema called lsmb13).
+
+3.2:  Foreign exchange and payment reversals
+
 The current design of foreign exchange handling means that if you reverse a
 payment, the foreign exchange gains and losses will not be exactly reversed 
 unless you are able to reverse on the same day.  If reversed on different days the 
 gain/loss will be realized per the time when the payment was in effect and 
 not reversed.
 
-3.2:  Reconciliation and Adjustments
+3.3:  Reconciliation and Adjustments
 
 If you enter adjustments for reconciliation you cannot simply add them with the
 same source, etc. on the transaction screen.  You must go through payment,

Modified: trunk/sql/upgrade/1.3-1.4.sql
===================================================================
--- trunk/sql/upgrade/1.3-1.4.sql	2014-01-06 08:43:32 UTC (rev 6403)
+++ trunk/sql/upgrade/1.3-1.4.sql	2014-01-07 01:22:19 UTC (rev 6404)
@@ -526,8 +526,7 @@
 INSERT INTO partsvendor SELECT * FROM lsmb13.partsvendor;
 INSERT INTO partscustomer SELECT * FROM lsmb13.partscustomer;
 
-update lsmb13.audittrail set person_id=(select id from lsmb13.person where last_name='Admin') where person_id not in (select id from lsmb13.person) ;
-INSERT INTO audittrail SELECT * FROM lsmb13.audittrail;
+INSERT INTO audittrail SELECT * FROM lsmb13.audittrail where person_id is not null;
 INSERT INTO translation SELECT * FROM lsmb13.translation;
 INSERT INTO parts_translation SELECT * FROM lsmb13.parts_translation;
 INSERT INTO user_preference SELECT * FROM lsmb13.user_preference;

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits