User Tools

Site Tools


find_ap_prepayment

Differences

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

Link to this comparison view

find_ap_prepayment [2016/04/20 07:51]
sweitmann created
find_ap_prepayment [2016/04/20 08:01] (current)
sweitmann
Line 1: Line 1:
-Sometimes the amount shown on the debitor ​control account in the balance sheet does not correspond to the amount shown in the 'AR--Reports--Outstanding'​ report. ​+Sometimes the amount shown on the creditor ​control account in the balance sheet does not correspond to the amount shown in the 'AP--Reports--Outstanding'​ report. ​
  
-This is usually caused by AR-prepayment transactions. Here is a sql query that will help you to quickly identify any such transactions:​+This is usually caused by AP-prepayment transactions. Here is a sql query that will help you to quickly identify any such transactions:​
  
     SELECT invnumber, transdate, (SELECT MIN(transdate) FROM acc_trans ac WHERE ac.trans_id = ap.id)     SELECT invnumber, transdate, (SELECT MIN(transdate) FROM acc_trans ac WHERE ac.trans_id = ap.id)
     otherdate FROM ap WHERE transdate > (SELECT MIN(transdate) FROM acc_trans ac WHERE ac.trans_id =      otherdate FROM ap WHERE transdate > (SELECT MIN(transdate) FROM acc_trans ac WHERE ac.trans_id = 
     ap.id);     ap.id);
find_ap_prepayment.txt ยท Last modified: 2016/04/20 08:01 by sweitmann