I SQL-Ledger and Business Processes
Introduction to SQL-Ledger
Why SQL-Ledger
Advantages of SQL-Ledger
Key Features
Limitations of SQL-Ledger
System Requirements of SQL-Ledger
User Account and Database Administration Basics
Companies and Datasets
How to Create a User
Permissions
User Account Types
Other Features
Chart of Accounts
Introduction to Double Entry Bookkeeping
Account Types
Debits and Credits
A few Examples
General Guidelines on Numbering Accounts
Adding/Modifying Accounts
Listing Account Balances and Transactions
Administration
Taxes, Defaults, and Preferences
Adding A Sales Tax Account
Setting a Sales Tax Amount
Default Account Setup
Currency Setup
Sequence Settings
Audit Control
Explaining transaction reversal
Close books option
Audit Trails
Departments
Cost v Profit Centers.
Warehouses
Languages
Types of Businesses
Misc.
GIFI
SIC
Overview of Template Editing
Year-end
Options in the sql-ledger.conf
Goods and Services
Basic Terms
The Price Matrix
Pricegroups
Groups
Labor/Overhead
Services
Shipping and Handling as a Service
Parts
Assemblies and Manufacturing
Stocking Assemblies
Reporting
All Items and Parts Reports
Requirements
Services and Labor
Assemblies
Groups and Pricegroups
Translations
How Cost of Goods Sold is tracked
AP
Basic AP Concepts
Vendors
AP Transactions
AP Invoices
Correcting an AP Invoice
Cash payment And Check Printing
Rapid Payment Entry Screen
Transaction/Invoice Reporting
Transactions Report
Outstanding Report
AP Aging Report
Tax Paid and Non-taxable Report
Vendor Reporting
Vendor Search
Vendor History
AR
Customers
Customer Price Matrix
AR Transactions
AR Invoices
Cash Receipt
Cash Receipts for multiple customers
AR Transaction Reporting
AR Transactions Report
AR Aging Report
Customer Reporting
Projects
Project Basics
Timecards
Projects and Invoices
Reporting
Timecard Reporting
Project Transaction Reporting
List of Projects
Possibilities for Using Projects
Quotations and Order Management
Sales Orders
Quotations
Shipping
AR Work Flow
Service Example
Single Warehouse Example
Multiple Warehouse Example
Requests for Quotation (RFQ)
Purchase Orders
Receiving
AP Work Flow
Bookkeeper entering the received items, order completed in full
Bookkeeper entering received items, order completed in part
Receiving staff entering items
Generation and Consolidation
Generation
Consolidation
Reporting
Shipping Module: Transferring Inventory between Warehouses
HR
POS
Sales Screen
Possibilities for Data Entry
Hardware Support
Reports
Open Invoices
Receipts
General Ledger
GL Basics
Paper-based accounting systems and the GL
Double Entry Examples on Paper
The GL in SQL-Ledger
Cash Transfer
GL Transactions
Payroll as a GL transaction
Reconciliation
Reports
GL as access to almost everything else
Recurring Transactions
Financial Statements and Reports
Cash v. Accrual Basis
Viewing the Chart of Accounts and Transactions
Trial Balance
The Paper-based function of a Trial Balance
Running the Trial Balance Report
What if the Trial Balance doesn't Balance?
Trial Balance as a Summary of Account Activity
Trial Balance as a Budget Planning Tool
Income Statement
Uses of an Income Statement
Balance Sheet
What if the Balance Sheet doesn't balance?
No Statement of Owner Equity?
The Template System
Text Templates
HTML Templates
LaTeX Templates
What is LaTeX ?
Using LyX to Edit LaTeX Templates
Customizing Logos
How are They Stored in the Filesystem?
Upgrade Issues
II Technical Overview
Basic Architecture
The Software Stack
Capacity Planning
Scalability Strategies
Database Maintenance
Known issues
Customization Possibilities
Brief Guide to the Source Code
Data Entry Screens
Examples
Extensions
Examples
Templates
Examples
Reports
Examples
Integration Possibilities
Reporting Tools
Examples
Line of Business Tools on PostgreSQL
Known Issues
Strategies
Examples
Line of Business Tools on other RDBMS's
Strategies
Integration Products and Open Source Projects
Customization Guide
General Information
Customizing Templates
Page Breaks in LaTeX
Conditionals
Loops
File Inclusion
Cross-referencing and multiple passes of LaTeX
Variable Substitution
Customizing Forms
Customizing Modules
Database Access
Examples
Adding a New Report for Sales Data
Truncating Number of Invoices on a Check Stub
Adding the a Check ID flag for Alcohol Purchases
III Appendix
Where to Go for More Information
Glossary
GNU Free Documentation License
1. APPLICABILITY AND DEFINITIONS
2. VERBATIM COPYING
3. COPYING IN QUANTITY
4. MODIFICATIONS
5. COMBINING DOCUMENTS
6. COLLECTIONS OF DOCUMENTS
7. AGGREGATION WITH INDEPENDENT WORKS
8. TRANSLATION
9. TERMINATION
10. FUTURE REVISIONS OF THIS LICENSE
ADDENDUM: How to use this License for your documents