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
tipsandtricks [2018/05/28 11:11] sweitmanntipsandtricks [2023/09/06 09:38] (current) – [SQL-Ledger Tips & Tricks] sweitmann
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 30: Line 31:
   * [[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]]   * [[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 ====== ====== Demo and Test System ======
tipsandtricks.1527505895.txt.gz · Last modified: 2018/05/28 11:11 by sweitmann