Administration

Everything an administrator needs is a screen rather than a support ticket — and on our hosting, creating a dataset is self-service.

  • Create a company dataset yourself from the dashboard, with the chart, templates and language you choose.
  • Add users, set their role, language and password.
  • System defaults: numbering, precision, default accounts, business types, warehouses, departments.
  • Payment methods, currencies, tax codes and languages maintained in the application.
  • Edit the stylesheet and the document templates in the browser.
  • Year end, and the audit lock date, are administrator actions.

Where to find it System › Defaults  ·  System › Preferences  ·  System › Warehouses  ·  System › Departments  ·  System › Type of Business  ·  System › Payment Methods  ·  System › Currencies  ·  System › Languages

Finding your way around

  1. After signing in, the menu is on the left; every module opens into a list of its screens. The search box above the menu finds a screen by name.
  2. The home page shows recent transactions and what is overdue, each row linking to the record.
  3. Screens are forms: fill in, press Update to recalculate, and the action buttons (Post, Save, Print) are along the foot.
The SQL-Ledger home screen with the module menu on the left and recent and overdue transactions
Home: the module menu, the dataset you are in, recent transactions and what is overdue.

First-time setup

  1. System › Defaults: company name and address as they print on documents, business number, precision, the default accounts, and the last number used for every document type — set these to carry on from your old numbering.
  2. System › Preferences: your own name, password, language, date and number formats and stylesheet.
  3. Then the lists: warehouses, departments, business types (with their discounts), payment methods, currencies, languages and taxes. Each is a screen under System with an Add button.
  4. Employees and their logins are under HR; roles under System › Roles. See access control.
System defaults screen
The defaults every screen falls back to.
The default accounts and last-numbers section of the system defaults screen
Lower down: the fallback accounts and the last number used per document type, each lockable against manual change.
User preferences screen showing language, date and number formats
Each user sets their own language, dates and numbers.
Warehouse list
Warehouses…
Department list with cost and profit centre markers
…departments…
Business type list with discount percentages
…business types and their discounts…
Payment method list
…and payment methods, all maintained in the application.
The currencies list
Currencies, with their precision.

From the blog

Every dataset on our hosting has this, from day one.

Create your free account or ask us about migrating