src-util/buildvalidation/src/org/openbravo/buildvalidation/GLJournalAccountingCheck_data.xsql
changeset 26696 a2dd91b010a9
parent 26406 af63dcb16553
child 26688 3eef7954a071
equal deleted inserted replaced
26695:aafe4f86b29c 26696:a2dd91b010a9
    53          SELECT DISTINCT t1.ad_client_id
    53          SELECT DISTINCT t1.ad_client_id
    54          FROM gl_journalline t1, fact_acct t2
    54          FROM gl_journalline t1, fact_acct t2
    55          WHERE t1.gl_journal_id = t2.record_id
    55          WHERE t1.gl_journal_id = t2.record_id
    56          AND t1.gl_journalline_id = t2.line_id
    56          AND t1.gl_journalline_id = t2.line_id
    57          AND t1.c_validcombination_id IS NOT NULL
    57          AND t1.c_validcombination_id IS NOT NULL
       
    58          AND AD_Table_ID = '224'
    58          AND ((t1.amtsourcedr - t1.amtsourcecr) <> (t2.amtsourcedr - t2.amtsourcecr)
    59          AND ((t1.amtsourcedr - t1.amtsourcecr) <> (t2.amtsourcedr - t2.amtsourcecr)
    59          OR  (t1.amtacctdr - t1.amtacctcr) <> (t2.amtacctdr - t2.amtacctcr))
    60          OR  (t1.amtacctdr - t1.amtacctcr) <> (t2.amtacctdr - t2.amtacctcr))
    60       ]]>
    61       ]]>
    61     </Sql>
    62     </Sql>
    62   </SqlMethod>  
    63   </SqlMethod>  
   109       FROM gl_journalline t1, fact_acct t2
   110       FROM gl_journalline t1, fact_acct t2
   110       WHERE t1.gl_journal_id = t2.record_id
   111       WHERE t1.gl_journal_id = t2.record_id
   111       AND t1.gl_journalline_id = t2.line_id
   112       AND t1.gl_journalline_id = t2.line_id
   112       AND t1.c_validcombination_id IS NOT NULL
   113       AND t1.c_validcombination_id IS NOT NULL
   113       AND t1.ad_client_id = ?
   114       AND t1.ad_client_id = ?
       
   115       AND AD_Table_ID = '224'
   114       AND ((t1.amtsourcedr - t1.amtsourcecr) <> (t2.amtsourcedr - t2.amtsourcecr)
   116       AND ((t1.amtsourcedr - t1.amtsourcecr) <> (t2.amtsourcedr - t2.amtsourcecr)
   115       OR  (t1.amtacctdr - t1.amtacctcr) <> (t2.amtacctdr - t2.amtacctcr))
   117       OR  (t1.amtacctdr - t1.amtacctcr) <> (t2.amtacctdr - t2.amtacctcr))
   116       ]]>
   118       ]]>
   117     </Sql>
   119     </Sql>
   118     <Parameter name="client"/>
   120     <Parameter name="client"/>