Re: Upgrading lsmb-1.2 database

On Mon, Oct 13, 2014 at 4:57 AM, Kai Huuhko <..hidden..> wrote:

>
> select a.accno, a.description, ac.amount, ac.transdate, ac.source, ac.memo
> from account a
> join acc_trans ac on a.id = ac.chart_id
> where ac.trans_id not in (
> select id from ar union select id from ap union select id from gl
> );
>
> Then you can archive them out of acc_trans, or deal with them, and then
> delete them from acc_trans. I usually like to copy them somewhere else
> first so one can audit and deal with them later if necessary.

Found them, apparently a transaction had become duplicated without any
corresponding entries in ar, ap or gl. Data looks good now.

Thanks for the help!

No problem.

Best Wishes,

Chris Travers

>>
>>
>> >
>> >>
>> >>
>> >>
>> >> ------------------------------------------------------------------------------
>> >> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>> >> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS
>> >> Reports
>> >> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>> >> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>> >> http://p.sf.net/sfu/Zoho
>> >> _______________________________________________
>> >> Ledger-smb-users mailing list
>> >> ..hidden..
>> >> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>> >>
>> >
>> >
>> >
>> > --
>> > Best Wishes,
>> > Chris Travers
>> >
>> > Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
>> > lock-in.
>> > http://www.efficito.com/learn_more
>> >
>> >
>> > ------------------------------------------------------------------------------
>> > Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>> > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
>> > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>> > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>> > http://p.sf.net/sfu/Zoho
>> > _______________________________________________
>> > Ledger-smb-users mailing list
>> > ..hidden..
>> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>> >
>>
>>
>> ------------------------------------------------------------------------------
>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>> http://p.sf.net/sfu/Zoho
>> _______________________________________________
>> Ledger-smb-users mailing list
>> ..hidden..
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
>
>
> --
> Best Wishes,
> Chris Travers
>
> Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
> lock-in.
> http://www.efficito.com/learn_more
>
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
> http://p.sf.net/sfu/Zoho
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://p.sf.net/sfu/Zoho
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more