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
ar_ap_versus_general_ledger [2016/12/22 16:45] – sweitmannar_ap_versus_general_ledger [2024/09/25 06:21] (current) – external edit 127.0.0.1
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 round(sum(ac.amount)::numeric) <> 0; +   ac.trans_id having round(sum(ac.amount)::numeric, 2) <> 0; 
-    +     
-   +
 Check if AP and acc_trans are in sync: 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)      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 round(sum(ac.amount)::numeric) <> 0;+    ac.trans_id having round(sum(ac.amount)::numeric, 2) <> 0;
ar_ap_versus_general_ledger.1482425147.txt.gz · Last modified: 2024/09/25 06:19 (external edit)