User Tools

Site Tools


tipsandtricks

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
tipsandtricks [2016/09/19 13:32] sweitmanntipsandtricks [2020/05/22 07:36] sweitmann
Line 1: Line 1:
 ====== SQL-Ledger Tips & Tricks ====== ====== 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]]   * [[psql_ascii_2_utf8|How to convert PostgreSQL database from SQL_ASCII to UTF8]]
   * [[phppgadmin_debian|How to install phppgadmin on Debian]]   * [[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)]]   * [[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]]   * [[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)]]   * [[http://apgdiff.com/how_to_use_it.php |Best PostgreSQL Diff Tool (apgdiff)]]
   * [[printer_with_options |How to define a printer with print options]]   * [[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_ap_prepayment|How to find AP-prepayment transactions]]
   * [[find_arap_outofbalance|How to find AR and AP-transactions that are "out of balance"]]   * [[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]]   * [[delete_departments_sql_command|How to delete departments using SQL statement]]
   * [[API_basics|Some SQL-Ledger API basics]]   * [[API_basics|Some SQL-Ledger API basics]]
Line 22: Line 26:
   * [[fix_dataset_newer_than_version|How to solve "Dataset newer than version" error message]]   * [[fix_dataset_newer_than_version|How to solve "Dataset newer than version" error message]]
   * [[compare_amount_paid_in_ar_and_acc_trans|How to compare amounts paid in ar and acc_trans]]   * [[compare_amount_paid_in_ar_and_acc_trans|How to compare amounts paid in ar and acc_trans]]
 +  * [[update_fxpaid|How to update fxpaid table]]
 +  * [[unbalanced_acc_trans|How to check if acc_trans is balanced]]
 +  * [[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]]
 +
 +====== Demo and Test System ======
 +
 + * Get the "look and feel" of SQL-Ledger here: [[Demo and Test System|Demo and Test System]]
 +
 +
 +
 +
tipsandtricks.txt · Last modified: 2023/09/06 09:38 by sweitmann