skip to content
International SQL-Ledger Network Association
User Tools
Register
Log In
Site Tools
Search
Tools
Show pagesource
Old revisions
Backlinks
Import
Recent Changes
Media Manager
Sitemap
Register
Log In
>
Recent Changes
Media Manager
Sitemap
Trace:
•
tipsandtricks
tipsandtricks
SQL-Ledger Tips & Tricks
How to use a mobile device barcode scanner with SQL-Ledger
How to convert PostgreSQL database from SQL_ASCII to UTF8
How to install phppgadmin on Debian
How to convert locale files from SQL_ASCII to UTF8
How to convert templates from SQL_ASCII to UTF8
How to import CSV data (Ledger123.com)
How to upgrade from ledger123 version 2.8 to 3.0
How to downgrade from ledger123 version 3.0 to 2.8
Best PostgreSQL Diff Tool (apgdiff)
How to define a printer with print options
How to add a warehouse (Ledger123.com)
How to find closed orders that have not been invoiced
How to find GL-transactions involving tax accounts
How to find AR-prepayment transactions
How to find AP-prepayment transactions
How to find AR and AP-transactions that are "out of balance"
How to find AP-transactions that have been booked without tax
How to delete departments using SQL statement
Some SQL-Ledger API basics
How to update your tax_chart_id
How to check if AP and AR transactions all have valid vendor/customer id's
How to create an SQL file for chart of accounts
How to set gifi's to same number as account
How to solve "Dataset newer than version" error message
How to compare amounts paid in ar and acc_trans
How to update fxpaid table
How to check if acc_trans is balanced
How to check if AR/AP and acc_trans are in sync
How to check if AR/AP transactions contain both fx-gain and fx-loss
How to merge rma-develop
How to checkout printed variables
How to round AR table to numeric 2
How to debug AR and AP PDF variables
How to extract specific columns from a .csv file
Demo and Test System
* Get the “look and feel” of SQL-Ledger here:
Demo and Test System
tipsandtricks.txt
· Last modified: 2021/12/19 19:58 by
mwagner
Page Tools
Show pagesource
Old revisions
Backlinks
Back to top
Import