International SQL-Ledger Network Association

This is an old revision of the document!

---

In earlier RMA versions of SQL-Ledger sometimes exchange rate differences were not booked correctly on the debitor and creditor control accounts, but ended up on the exchange rate difference account instead. This would lead to different results in the P+L versus the results in the Balance Sheet.

The following query will help you identify such transactions:

  SELECT transdate, invnumber, ABS(amount) FROM ar WHERE transdate BETWEEN '2014-01-01' and '2015-12-31'
  AND id IN (SELECT trans_id FROM acc_trans WHERE ABS(amount) = 0.01 AND chart_id IN (SELECT id FROM 
  chart WHERE category='E'));
  

You may need to adjust the dates and amounts to fit your individual search.