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 [2024/09/25 06:21] (current) – external edit 127.0.0.1
@@ 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)
     otherdate FROM ap WHERE transdate > (SELECT MIN(transdate) FROM acc_trans ac WHERE ac.trans_id =
     ap.id);