User Tools

Site Tools


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 revision Previous revision
ar_ap_versus_general_ledger [2016/12/23 13:56]
sweitmann
ar_ap_versus_general_ledger [2016/12/23 13:59] (current)
sweitmann
Line 4: Line 4:
    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,​ 2) <> 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:
  
ar_ap_versus_general_ledger.txt · Last modified: 2016/12/23 13:59 by sweitmann