Frequently Asked Questions


PLEASE NOTE: Ledger was superseded by LedgerLite in January 2015. Unfortunately we're no longer in a position to support Ledger. However we're still able to convert your existing data from Ledger to LedgerLite if you decide to upgrade and continue with our support.


Contents


Where is the Ledger user manual?

Where is the Ledger database located?

Why do I get a message telling me the database is not accessible?

Why do accounts not appear in the drop down list?

Why can't I find the Maintain menu?

Why can't I see all the entries I've posted to an account?

Why doesn't Ledger run on Windows Vista?

How do I set up Ledger to start a set of accounts?

How does Ledger handle multiple accounting entities?

Can I run Ledger on Linux or a Mac?

Why isn't Ledger in Wikipedia's list of accounting software?

What is the BDE?

What is Paradox?

What's the difference between standard mode and client/server mode?

What is Firebird?

What is Interbase?

How do I convert my database from Paradox to Firebird?

What's the Framework?

Why doesn't your software run on other operating systems?

Why do you use Delphi?



Where is the Ledger user manual?


Because Ledger is so easy to install and use we didn't bother with a manual since we figured you probably wouldn't read it anyway. Instead everything you need to know to get started is on our quick start page.


. . . well perhaps . . . not everything! The biggest difficulty you're likely to encounter when using our software is that it assumes a basic understanding of the principles of accounting and in particular the function of a general ledger. Unlike other popular accounting systems our software is not dumbed-down to accommodate users that haven't taken the time to understand the fundamentals.


Our goal is to provide you with software that will contribute to your long-term business success and for this to happen we believe it's important that you grasp the basic principles of accounting. Once you've mastered these principles (which isn't that hard!) we're confident you'll find Ledger better and easier to use than any other accounting system (apart from LedgerLite or LedgerPlus!!)


If you'd like a good book that provides an excellent introduction to accounting we unreservedly recommend Accounting Demystified by Jeffry R. Haber. We think it's the best accounting book we've seen and suggest it's likely to be the only book on accounting you'll ever need (unless of course you decide to become an accountant!) For a concise explanation that may be useful as an additional resource please see our essay on accounting theory.


If you still can't find the information you're looking for either on our quick start page or here on this FAQ page please don't hesitate to email support@responsive.co.nz and we'll be happy to answer any questions you may have. Or even better post them in the Responsive Software Google Group where we can answer them for everyone's benefit.


Where is the Ledger database located?


When you install Ledger the default location for the database is C:\Program Files\Responsive Software\Ledger\Database. The database files are created automatically in this folder when you run Ledger for the first time. If your data is important to you then you need to make sure this folder gets included in your regular backup.


NOTE: If you're running Ledger on Windows Vista the database may be stored in C:\Users\(USERNAME)\AppData\Local\VirtualStore\Program Files\Responsive Software\Ledger\Database. If you're on Windows 7 the database may be stored in C:\Program Files (x86)\Responsive Software\Ledger\Database or Windows 8 in C:\Users\(USERNAME)\AppData\Local\VirtualStore\Program Files (x86)\Responsive Software\Ledger\Database.


To find the folder where the Ledger database is stored on your computer search for the file WorkstationConfiguration.DB. You will find this file located in the Ledger Database folder.


Why do I get a message telling me the database is not accessible?


If you're running Ledger on Windows Vista please see the question below Why doesn't Ledger run on Windows Vista?


If you've installed Ledger on a drive other than C: (say X:) you need to change the BDE setting. Go to the control panel and run the BDE Administrator. Click on the Databases tab, click on RSLEDGER and change the PATH value from C:\Program Files\Responsive Software\Ledger\Database to X:\Program Files\Responsive Software\Ledger\Database. Then exit the BDE Administrator and save the changes.


Check also that the Paradox network control directory is accessible by the BDE. To do this go to the control panel and run the BDE Administrator. Click on the Configuration tab. In the tree view click on the + sign to expand the nodes Configuration, Drivers, Native and PARADOX. On the right hand side next to NET DIR check that the directory specified exists and is fully accessible on your computer.


If your computer is using a language other than English you may also need to change the BDE setting. For example if you are in Mexico and your computer is using Spanish go to the control panel and run the BDE Administrator. Click on the Databases tab, click on RSLEDGER and change the PATH value from C:\Program Files\Responsive Software\Ledger\Database to C:\Archivos de Programa\Responsive Software\Ledger\Database. Then exit the BDE Administrator and save the changes.


If you installed a beta release of Expression WebDesigner or some other recent software from Microsoft you may also get this error. This software contains a bug that prevents the Borland Database Engine from accessing a database correctly. To fix this problem either uninstall the offending software or contact Microsoft to see if they can provide a fix.


Why do accounts not appear in the drop down list?


On the Entries, Accounts and Cashbooks screens only the accounts for the currently selected Default Accounting Company will appear in the Account drop down list. (Ledger is multi-company which means it can handle multiple accounting entities.) When you first install Ledger the Default Accounting Company is set to <Default>. You can change this by going to the File menu and selecting Configure. Then go to the Workstation tab, select <Default> (or a company name) from the Default Accounting Company drop down list and click on the OK button.


Why can't I find the Maintain menu?


If you're using Ledger in a client/server configuration and your User Name has not been set up as an Administrator through the Ledger Server you will not be able to access the Maintain menu on the Ledger Client. To fix this go to the Ledger Server main screen. Then go to the File menu and select Users. Put a Y in the Administrator field next to your User Name.


Why can't I see all the entries I've posted to an account?


Ledger allows you to specify a default period that limits the number of visible entries. If you want to see all the entries in an account you need to turn this off. Go to the File menu and select Configure. Then click on the Workstation tab. Remove the ticks from the Begin Period and End Period check boxes. Then click on the OK button.


Why doesn't Ledger run on Windows Vista?


If you've installed Ledger on a computer running Windows Vista you may need to make some additional changes to the BDE configuration before it will run correctly. For more information please see Configuration - Windows Vista.


To summarize what needs to be done in a few easy steps! -

A. Go to Start menu and select Run
B. Type in regedit and click OK.
C. Open the HKEY_LOCAL_MACHINE branch.
D. Open the SOFTWARE branch.
E. Right-Click on BORLAND.
F. In the popup menu select Permission
G. Click Users.
H. Under Type of Access select Full Control and click OK.
I. Click OK to exit the Registry Key Permissions dialog box.
J. Exit the Registry Editor window.
K. Go to My Computer.
L. Go to the C: drive.
M. Create a new folder on the C: drive and call it BDEShare.
N. Go to the Control Panel.
O. Open the BDE Administrator.
P. Click on the following in order
     1. The Configuration tab (on the left hand side.)
     2. The + next to the Configuration node (the + will change to -)
     3. The + next to the Drivers node (the + will change to -)
     4. The + next to the Native node (the + will change to -)
     5. The word PARADOX.
     6. The field next to NET DIR (on the right hand side.)
Q. In the NET DIR field type C:\BDEShare and press the <Enter> key.
R. Click on the X in the top right of BDE Administrator to close.
S. Try running Ledger again.


How do I set up Ledger to start a set of accounts?


When you start using Ledger for the first time you need to choose an opening date for your accounts and decide how the balance sheet should look as at this date. You then need to maintain the chart of accounts and create an account for each item in the balance sheet if it doesn't already exist. These balance sheet accounts should be of type A, L or P. (To delete accounts you no longer need you can hold down the <Ctrl> key and press the <Delete> key.)


Next you need to post an entry with its date set to the opening date. Add a separate line to this entry for each balance sheet account and set its debit or credit amount to the account balance as at the opening date. In the Description field on each line you can enter the words Opening Balance or similar. After clicking on the Save button you should be able to print a balance sheet as at the opening date and check it's as you expect.


Finally you can create a cashbook for each bank account you wish to reconcile and make an opening entry as at the opening date. Make sure you leave the Other A/c field on the opening cashbook entry blank in order to prevent a ledger entry from being created. (A line for each bank account in the ledger with its opening balance should have formed part of the opening entry described in the previous paragraph.)


How does Ledger handle multiple accounting entities?


When you start using Ledger for the first time a chart of accounts is created automatically for the <Default> company. In the Maintain Accounts screen where the Company field appears blank it indicates that this account belongs to the <Default> company.


To create additional companies (or accounting entities) go to the Maintain menu and select Companies. To add a new company use the <Insert> key on your keyboard. In the Abbrev field enter the abbreviation you wish to use to identify the new company and enter its name in the Name field.


Then maintain the chart of accounts and add the accounts you need for the new company. In the Company field of each new account enter the new company abbreviation or double-click the Company field to select the new company from a list.


NOTE: For simplicity we refer to an accounting entity as a company. This is not the same as the Company Name that appears on all the printed reports.


Ledger will only allow you to work with one company at a time. The currently selected company is referred to as the Default Accounting Company. If the currently selected company is anything other than the <Default> company its name will appear in the title bar next to the word Ledger.


To switch companies go to the File menu and select Configure. Then click on the Workstation tab and select a company from the Default Accounting Company drop-down list. Then click on the Ok button.


Can I run Ledger on Linux or a Mac?


Ledger is designed to run on any version of Windows. Because Ledger uses the standard Windows API it should also run on most Windows emulators for Linux or the Mac.


Why isn't Ledger in Wikipedia's list of accounting software?


The page describing Ledger in Wikipedia (http://en.wikipedia.org/wiki/Responsive_Software_Ledger) was deleted by the moderators in November 2005 and protected against recreation. Because we give away our software to promote our business Ledger is classed as advertising and therefore lacks the required standards of objectivity for inclusion in Wikipedia.


Of course we wholeheartedly recommend Ledger and reckon it's better than anything else on the market but please don't be swayed by us! For an "unbiased" view see http://en.wikipedia.org/wiki/Comparison_of_accounting_software


What is the BDE?


BDE is short for Borland Database Engine. This is the system software Ledger uses to access the database when it is stored in a Paradox format.


What is Paradox?


Paradox is a relational database management system (RDBMS) that was very popular before it was overtaken by Microsoft Access and which many still consider to be superior. The Paradox database format is still widely used by many other applications because of its superior speed and efficiency.


What's the difference between standard mode and client/server mode?


In standard mode Ledger runs as a single program that accesses the database directly using the BDE (Borland Database Engine.) When you install Ledger it operates in standard mode by default with a single-user setup. On a LAN you can switch to a multi-user setup and continue to use standard mode where Ledger runs as a single program on each computer and directly accesses the database via the BDE. Standard mode is suitable for a small number of users on a LAN.


In client/server mode Ledger runs as two separate programs - one as a client and the other as a server. Only the server program has direct access to the database (which can be either Paradox via the BDE or Firebird/Interbase.) When a client program is started it must establish a connection to the server using the TCP/IP protocol in order to access the database. Whenever the client needs some data it sends a request to the server via the TCP/IP connection. The server then retrieves the requested data from the database and returns it to the client. And whenever the client wants to save some data it sends it to the server which then stores it in the database.


Before a client can connect to the server the user is prompted to enter a User Name and Password. A connection is only allowed if the User Name has been set up in the server program and the correct Password has been entered. Client/server mode is suitable for a TCP/IP network (including the Internet) and where there are a large number of users.


What is Firebird?


Firebird is a relational database management system (RDBMS). It is an open source product and is completely free of registration, licensing and deployment fees even for commercial applications. It is based on source code released by Borland Software Corporation on 25 July 2000 under the InterBase Public License v.1.0 and shares much in common with Interbase.


For more information please see the Firebird website www.firebirdsql.org.


What is Interbase?


Interbase is a relational database management system (RDBMS). It is a closed source product developed and marketed by Borland Software Corporation.


For more information please see the Interbase website www.embarcadero.com/products/interbase.


How do I convert my database from Paradox to Firebird?


To convert your Ledger database from Paradox to Firebird first change to client/server setup.


Next install and configure Firebird. Make sure the Firebird server is running and accessible from the computer where the Ledger Server is installed.


Edit the file C:\Program Files\Firebird\Firebird_1_5\aliases.conf using a text editor (e.g. Notepad) and add the following line:


     rsledger = C:\Program Files\Responsive Software\Ledger\Ledger.FDB


On the server workstation create a shortcut to the Ledger program C:\Program Files\Responsive Software\Ledger\Ledger.exe and rename it Ledger Convert. Right-click on this shortcut and select Properties. Then click on the Shortcut tab.


In the Target field after the "C:\Program Files\Responsive Software\Ledger\Ledger.exe" filename (and outside the quotation marks) add the command line parameter /v. Then click on the OK button.


Shutdown the Ledger Server if it is running.


Double-click on the Ledger Convert icon to start the conversion. Enter the Firebird User Name (default SYSDBA) and Password (default masterkey) and follow the prompts.


After the conversion has finished delete the Ledger Convert shortcut. Be careful not to run the conversion a second time or you will need to delete the Firebird database and start again.


Right-click on the Ledger Server shortcut and select Properties. Then click on the Shortcut tab.


In the Target field after the "C:\Program Files\Responsive Software\Ledger\Ledger.exe" filename (and outside the quotation marks) change the command line parameter from /s to /s /f. Then click on the OK button.


Double-click on the Ledger Server icon and enter the Firebird User Name and Password to restart the server.


What's the Framework?


The Framework is a generic business application that we make available to our clients as a starting point for customized software. It includes a general ledger function, a cashbook function, a document and image repository, a point-of-sale function that operates both on-line and off-line and an HTTP server function for web site development. It also includes all the logic necessary for client/server communications and database management.


The full Delphi source code for the Framework can be downloaded under either a commercial licence for US$3,650 or a non-commercial licence for US$100. (The source code for each licence is identical.)


The Framework was used to build Ledger.


Why doesn't your software run on other operating systems?


Although it would be nice to create software that runs reliably on multiple platforms the high cost of doing so means that for most business applications it can't be justified economically. This is especially true for applications used primarily within an organisation and for packaged software where the market consists mainly of Windows users.


However our Framework does include a secure HTTP server function that can be used to provide a browser interface whenever this is necessary to allow public access from the World Wide Web.


Why do you use Delphi?


We've been using Delphi since its release in 1995 and believe it's still demonstrably the best tool for developing secure reliable Windows applications. None of the other tools we've looked at come close to matching Delphi's ease-of-use, elegance, speed, stability, flexibility and power.


The Pascal language that Delphi uses is ideally suited to expressing coded business logic in a way that's easy to read, understand and maintain. Many other languages popular today are derived from C which is used predominantly to build operating systems and device drivers. Not only is C more difficult to read than Pascal, in our experience many C programmers actually take pride in writing code that is hard to understand and maintain. (We also believe begin, end, and, or, not, procedure and function are more readable than {, }, &&, ||, !, void and ().)


Because a Delphi program is compiled it can produce a single stand-alone executable that's guaranteed to run reliably on all versions of Windows whereas the behaviour of a program developed with an interpreted language is dependent on the version of the installed scripting engine. This is the hidden reason many software developers are forced to use the Software-As-A-Service (SaaS) model because without full control of the system on which the program is running they are unable to guarantee a reliable operation.


For more information about the advantages of Delphi please see The Business Case For Delphi