International SQL-Ledger Network Association

User Tools

Site Tools

Trace:
ar_ap_versus_general_ledger

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
ar_ap_versus_general_ledger [2016/12/22 16:31] – sweitmannar_ap_versus_general_ledger [2016/12/23 13:56] – sweitmann
Line 3: Line 3:
    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,    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;
        
        
Line 10: Line 10:
     select ap.invnumber, ac.trans_id, sum(ac.amount) from acc_trans ac join ap on (ap.id = ac.trans_id)      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,     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;
ar_ap_versus_general_ledger.txt · Last modified: 2016/12/23 13:59 by sweitmann