VirtualBox SQL-Ledger Appliance

This virtual appliance comes pre-configured with our enhanced SQL-Ledger as well as LedgerSMB. Follow these instructions to get up and running: Summary This virtual appliance has been built using FreeBSD 7.3. You do not need to know or install FreeBSD to use it. Download and uncompress this virtual appliance (url is in your order confirmation […]

Generic CSV Import

It is easy to import CSV data into sql-ledger which is not support by ‘Import’ menu. Export your data from spreadsheet or software in a suitable CSV format. Assume it is named “/tmp/cities.csv”. Create a suitable table if it does not already exist. CREATE TABLE customertmp (id INTEGER, city TEXT); Add following lines at the […]

LedgerSMB Virtual Appliance

LedgerSMB is particularly difficult to install and configure for newbies due to its dependence on few CPAN Perl modules, fixes required and creation/configuration of a central database to store users. Our sql-ledger vmware virtual appliance now comes with LedgerSMB 1.2.21. (with our enhancements.) It is fully configured with a blank dataset and one user. You […]

Vmware Virtual Appliance

This virtual appliance comes pre-configured with our enhanced SQL-Ledger. Follow these instructions to get up and running: Summary This virtual appliance has been built using FreeBSD 6.4. You do not need to know or install FreeBSD to use it. Root password: none IP Address: Login to appliance from console using root (without password) and issue […]

CSV Export

You can export data from your sql-ledger tables using following command in ‘psql’. COPY (SELECT id, partnumber, description FROM parts ORDER BY partnumber) TO ‘/tmp/parts.csv’ CSV HEADER;

Usage Guidelines

SQL-Ledger is a browser-based application. Anybody familiar with internet browsing should feel at home using sql-ledger. All Sql-Ledger user-interface elements (menu, forms, reports) are displayed using standard HTML. You can use any modern browser to run the application. Firefox is recommended. Main menu Sql-ledger menu is displayed in left frame. Menu items can be collapsed […]

SQL-Ledger CSV Import

We have enhanced sql-ledger csv data import function. Now you can import following additional transactions. You already have these scripts if you are using our enhanced sql-ledger version. Sales invoices with payments (enhanced built-in functionality) Receipts and payments AR/AP transactions General Ledger Purchase Orders Parts and Price lists Customers and Vendors Chart of Accounts These […]

Import Sale Invoices

Sales invoices can be imported from text files. Format your data For list of additional data columns that can be imported see step 4. invnumber,transdate,duedate,customernumber,curr,invoicedescription,partnumber,qty,sellprice,employeenumber,AR,department,warehouse A100,10/12/2008,10/30/2008,AE001,GBP,Invoice description comes here,B001,10,102,E-001,1100,HARDWARE,LONDON A100,10/12/2008,10/30/2008,AE001,GBP,Invoice description comes here,F003,6,69,E-001,1100,HARDWARE,LONDON A101,10/12/2008,10/31/2008,CP002,GBP,Test description,F003,2,32,E-002,1100,SERVICES,PARIS A102,10/13/2008,11/1/2008,ER003,GBP,Sale of goods,T007,6,12,E-003,1100,SERVICES,LONDON A103,10/14/2008,11/2/2008,SP007,GBP,Sale,K001,12,32,E-004,1100,HARDWARE,PARIS (The last column AR is accounts receivable account number which is 1100 in UK chart of […]

Import Parts, Service Items, Labor Items

Format your data according to following sample: partnumber,description,unit,partsgroup,listprice,sellprice,lastcost,rop,bin,image,drawing,notes B002,”Brush Set”,NOS,brush,9.99,9.99,7,150,TOP,noimage,brush.jpg,notes about brush set D010,”Deluxe Hand Saw”,NOS,SAW,17.99,17.99,16,50,TOP,saw.jpg,nodrawing,notes about hand saw D011,”Digger Hand Trencher”,NOS,Picks & Hatchets,18.99,18.99,15,200,TOP,,nodrawing,notes about hand saw System assigns a unique parts_id to each part imported or group created. Duplicates are not allowed and duplicate check is done on partnumber. To start the import process, […]

Import General Ledger transactions

GL import helps you to move your data from legacy accounting software to sql-ledger in few easy steps: Please keep following points when preparing data in CSV format for import: Import script creates one GL transaction for each unique ‘reference’ number. There can be any number of lines (rows) in each transaction. Account must exist […]