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 revision Previous revision
Next revision
Previous revision
tipsandtricks [2017/05/05 06:00]
sweitmann
tipsandtricks [2020/06/27 14:04] (current)
sweitmann [SQL-Ledger Tips & Tricks]
Line 8: 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 16: 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 28: Line 30:
   * [[AR/AP_versus_General_Ledger|How to check if AR/AP and acc_trans are in sync]]   * [[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]]   * [[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]]
 +
 +====== Demo and Test System ======
 +
 + * Get the "look and feel" of SQL-Ledger here: [[Demo and Test System|Demo and Test System]]
  
  
  
  
tipsandtricks.1493964019.txt.gz ยท Last modified: 2017/05/05 06:00 by sweitmann