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/23 13:59] (current) – 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;
+   ac.trans_id having round(sum(ac.amount)::numeric, 2) <> 0;
 Check if AP and acc_trans are in sync:
     select ap.invnumber, ac.trans_id, sum(ac.amount) from acc_trans ac join ap on (ap.id = ac.trans_id)
     where chart_id in (select id from chart where link='AP') and ap.amount = ap.paid group by ap.invnumber,
-    ac.trans_id having sum(ac.amount) <> 0;
+    ac.trans_id having round(sum(ac.amount)::numeric, 2) <> 0;