find_ar_prepayment
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | find_ar_prepayment [2016/04/20 07:44] (current) – created 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 ' | ||
+ | This is usually caused by AR-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 | ||
+ | = ar.id) otherdate FROM ar WHERE transdate > (SELECT MIN(transdate) FROM acc_trans ac | ||
+ | WHERE ac.trans_id = ar.id); |
find_ar_prepayment.txt · Last modified: 2016/04/20 07:44 by sweitmann