find_ap_prepayment
Differences
This shows you the differences between two versions of the page.
find_ap_prepayment [2016/04/20 07:51] – created sweitmann | find_ap_prepayment [2016/04/20 08:01] (current) – sweitmann | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | Sometimes the amount shown on the debitor | + | Sometimes the amount shown on the creditor |
- | 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