On Mon, Oct 13, 2014 at 4:57 AM, Kai Huuhko <kai.huu...@gmail.com> 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
> >> >> Ledger-smb-users@lists.sourceforge.net
> >> >> 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
> >> > Ledger-smb-users@lists.sourceforge.net
> >> > 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
> >> Ledger-smb-users@lists.sourceforge.net
> >> 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
> > Ledger-smb-users@lists.sourceforge.net
> > 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
> Ledger-smb-users@lists.sourceforge.net
> 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
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
