Differences

This shows you the differences between two versions of the page.

--- ar_ap_versus_general_ledger [2016/12/22 15:10] – created sweitmann
+++ ar_ap_versus_general_ledger [2016/12/22 16:31] – sweitmann
@@ Line 1: / Line 1: @@
 Check if AR and acc_trans are in sync:
-   AR: select ar.invnumber, ac.trans_id, sum(ac.amount) from acc_trans ac join ar on (ar.id = ac.trans_id)
+   select ar.invnumber, ac.trans_id, sum(ac.amount) from acc_trans ac join ar on (ar.id = ac.trans_id)
    where chart_id in (select id from chart where link='AR') and ar.amount = ar.paid group by ar.invnumber,
    ac.trans_id having sum(ac.amount) <> 0;