Differences

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

--- tipsandtricks [2016/10/27 09:46] – sweitmann
+++ tipsandtricks [2024/09/25 06:21] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== SQL-Ledger Tips & Tricks ======
+  * [[http://matthijshavinga.blogspot.nl/2017/04/how-to-run-cookie-factory-with-sql.html|How to use a mobile device barcode scanner with SQL-Ledger]]
   * [[psql_ascii_2_utf8|How to convert PostgreSQL database from SQL_ASCII to UTF8]]
   * [[phppgadmin_debian|How to install phppgadmin on Debian]]
@@ Line 6: / Line 8: @@
   * [[http://www.ledger123.com/category/data-import/|How to import CSV data (Ledger123.com)]]
   * [[upgrade_2_to_3 |How to upgrade from ledger123 version 2.8 to 3.0]]
+  * [[downgrade_3_to_2 |How to downgrade from ledger123 version 3.0 to 2.8]]
   * [[http://apgdiff.com/how_to_use_it.php |Best PostgreSQL Diff Tool (apgdiff)]]
   * [[printer_with_options |How to define a printer with print options]]
@@ Line 14: / Line 17: @@
   * [[find_ap_prepayment|How to find AP-prepayment transactions]]
   * [[find_arap_outofbalance|How to find AR and AP-transactions that are "out of balance"]]
+  * [[find_ar_without_tax|How to find AP-transactions that have been booked without tax]]
   * [[delete_departments_sql_command|How to delete departments using SQL statement]]
   * [[API_basics|Some SQL-Ledger API basics]]
@@ Line 24: / Line 28: @@
   * [[update_fxpaid|How to update fxpaid table]]
   * [[unbalanced_acc_trans|How to check if acc_trans is balanced]]
-  * [[update_fxpaid|How to update fxpaid table]]
+  * [[AR/AP_versus_General_Ledger|How to check if AR/AP and acc_trans are in sync]]
+  * [[FX_gain/FX_loss|How to check if AR/AP transactions contain both fx-gain and fx-loss]]
+  * [[merge_rma_develop|How to merge rma-develop]]
+  * [[checkout_variables|How to checkout printed variables]]
+  * [[query_2:_correct_AR8percision|How to round AR table to numeric 2]]
+  * [[ar_ap_pdf_varaible_debug|How to debug AR and AP PDF variables]]
+  * [[extractcsv|How to extract specific columns from a .csv file]]
+  * [[deletearapinvoices|How to delete AR and AP transactions in PostgreSQL]]
+  * [[setuprevolutapi|How to configure Revolut Bank with SQL-Ledger]]
+  * [[generatecharfile|How to generate dataset template from existing database]]
+  * [[sqlonalldatabases|Script for running SQL-statement on all databases]]
+====== Demo and Test System ======
+ * Get the "look and feel" of SQL-Ledger here: [[Demo and Test System|Demo and Test System]]