I had the same situation. That's why i added SELECT trans_id,count(trans_id) FROM acc_trans where trans_id not in (select id from ap union select id from ar union select id from gl) group by trans_id;
to sql/upgrade/1.2-pre-upgrade-checks.sql I think , but i am not sure, that is has to do with commit's that are done in too many places. Things some times get committed even if main transaction aborts. Merry Christmas, Herman 2011/12/22 Erik Huelsmann <[email protected]>: > Hi all, > > As part of my efforts to establish that my LSMB database hasn't been > damaged by the multi-currency problems that we found and fixed in > 1.3.10, I'm looking at the AR table and finding rows which have a NULL > amount field. These rows are not referenced from the ACC_TRANS table, > but nevertheless, I'm not sure they ought to be there. > > So, here's my question: is it normal to have rows with NULL amounts in > the AR table? If not, can I safely remove them, if they're not > referenced from ACC_TRANS? Any idea how they might have appeared? > > Bye, > > > Erik. > > ------------------------------------------------------------------------------ > Write once. Port to many. > Get the SDK and tools to simplify cross-platform app development. Create > new or port existing apps to sell to consumers worldwide. Explore the > Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join > http://p.sf.net/sfu/intel-appdev > _______________________________________________ > Ledger-smb-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel ------------------------------------------------------------------------------ Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
