SQL-Ledger Documentation ▶ User Interface

User Interface

Color Themes

Several color themes are available to customize the appearance of the user interface:

• the legacy themes with sql-ledger- in their name
• Everforest, a dark and low-contrast theme based on the color scheme with the same name by Sainnhe Park, available for several code editors
• Horizon and Quartz, based on the color model of the SAP Fiori Design System
• Silver, a pure black-and-white theme

Horizon, Quartz and Silver come in three variants:

• light, always displays dark text on a light background
• dark, always displays light text on a dark background
• flex, flexibly adapts to the settings of the operating system

The theme is set individually for each user under Preferences. The system default is horizon-flex.css. It is changed via the variable stylesheet in the Global Configuration.

Helping Notes

A click on the triangle right of a page title opens a helping note. This note is related to the page, not to the currently displayed data and is accessible for all users of a company. It can contain hints or instructions for the employees with login to the system.

A filled triangle (◥) indicates an existing note, if it is just outlined (◹), it means that no note has been added yet. The content is written in plain text, optionally decorated with simple markdown.

# Big Title
## Smaller Title
This word is *italic*. And this one is **bold**.
The repo for this code on [GitHub](https://github.com/Tekki/sql-ledger).
See the note for [adding a customer](customer).

The access to the directory used for the notes has to be granted in the global configuration.

Keyboard Shortcuts

Advanced users try to avoid to switch from keyboard to mouse, they do most of their work with the keyboard only. For them, many shortcuts are available.

Access Keys

It is possible to use keyboard combinations to press a button or to jump directly to an input field. The keys used to activate the command depend on the browser and the operating system. On Windows and Linux, it can be either:

• Alt-[key]
• Alt-Shift-[key]

and on MacOS:

• Control-Option-[key]
• Control-Option-Shift-[key]
• Control-Alt-[key]

The [key] is revealed when the mouse is moved over the input field or the button in question. Notice that depending on the browser and the operating system not all combinations are available.

Some of the commonly used shortcuts for buttons are:

key	command
?	Helping Note
U	Update
C	Continue
S	Save
O	Post
V	Preview
P	Print

The following keys move the cursor directly to an input field:

key	jump to
0	last row of the document
1 … 9	row 1 … 9 of the document
/	customer or vendor
*	document date
-	description
+	notes
.	payment date
$	curreny
,	invoice number

/ * - + . are the special characters on the numeric keypad. The shortcuts for customer or vendor, date, description, and notes are available in the frontend of the reports, too. The keys 1 … 9 and 0 open the document at the specified position of a report.

Quick Date Entry

It is not necessary to enter full dates, they can be abbreviated and will be expanded as soon as the cursor jumps out of the date field, for example by pressing TAB.

Let's assume the current date is November 26, 2022 and the date format is set to dd.mm.yy.

input	is expanded to
+5	01.12.2022
-10	16.11.2022
3	03.11.2022
5-2	05.02.2022
4.3.23	04.03.2023

+/- n: plus or minus days

A + or - followed by a number n will set the date to today in n days or to n days ago.

n: day

A single number sets the date to day n in the current month and year.

n1 n2: day and month

Two numbers define the day and month in the current year. They can be separated by any non-numeric character. Depending on the date format set in the user preferences, the first number is either the day or the month.

n1 n2 n3: day, month, year

Three numbers set day, month and year, in the order according to the date format. Days and months are always written with two digits, they get a leading zero if necessary. Years lower than 100 are expanded to 20.. if they are below 70, to 19.. if they are above.