SQL-Ledger

SQL-Ledger® ERP is double-entry accounting/ERP. Any text or graphical browser can

access accounting data on a SQL database server. A chart of accounts connects the system.
Each item has income, expense, inventory, and tax accounts. Sales and purchases quickly
update accounts. Using assembly, you can build products from parts, services, labor units, and
assemblies. When an assembly is sold, all linked accounts are updated and stock levels are
adjusted. Invoices, packing lists, income statements, balance sheets, sales, work, and purchase
orders, statements, receipts, and checks are generated using templates. HTML, TeX, and Text
are template formats. Latex converts tex to postscript and PDF. Using a PDF viewer, documents
can be emailed, printed, or faxed. Each customer/vendor can define the translation process for
items and foreign language templates, allowing invoices to be generated in a foreign language
without linguistic proficiency. This translation tool can create distinct forms for clients or
suppliers.
Foreign currency transactions are immediately converted, and exchange rate
differences, gains and losses are recorded. AR, AP, and GL reports can be changed and sorted to
generate a huge number of reports, aging reports show what's outstanding, and the tax report
lists taxable transactions for taxes collected and paid. The GL report generates sales and buy
journals and ledgers. You can examine and edit account transactions systemwide. Users can
choose language and data source. One installation can have a different language, books, or SQL
database server. Users can only access particular areas or functions of menus. Unavailable
menu items are hidden. New items automatically enter the access control system. All
transactions or until a certain date can be audited. Erroneous transactions must be reversed
and re-posted under audit control. If more control is needed, it's easy to add extra SQL server
functions.
External perl code can update SQL-Ledger globally and per login. Unmodified code can
be added. The command line interface allows real-time or batch app construction and
interaction. This allows offline remote apps or POS with a separate storage system to
communicate. SQL-Ledger users can be in various towns, nations, or continents. SQL-Ledger
runs on *NIX, Mac, and Windows.
Features

Accounts Receivable

 Flexible AR entry screen

  Unlimited number of accounts split transaction and payments assign project for each entry tax,
due date calculated based on customer selected tax can be included or on top
 customizable reports include only certain fields and subtotals in reports

 sort reports by invoice and due dates, invoice number, customer

 subtotals for sorted column
 aging report for all customers or one customer

 outstanding AR report

 tax report for tax collected

 report for non taxable items collected

 enter payments received for open invoices

 customizable customer invoice

Account Payable

 flexible AP entry screen

  # unlimited number of accounts split transaction and payments assign project for each entry
tax, due date calculated based on vendor selected tax can be included or on top
 customizable reports

 sort reports by invoice date, due date,

invoice number, order number, vendor
 subtotals for sorted column
 aging report for all vendors or one vendor

 enter payments for open invoices

 vendor invoices

 purchase orders

Voucher

 approve AP, payment, payment reversal and GL transactions before posting

 post all transactions within a batch
 post selected batches
 select which ones to import
 reports to list batches

General Ledger

 selection list for accounts

  record source, description, dates
 customizable reports
for all accounts
or asset, liability, equity, income or expense accounts
source, a range of dates, description

 select fields to include and subtotals

 sort reports by date, source, description and account
 subtotals for sorted column
 reports include all transactions posted by any module
 links to original transactions
 drill down into accounts to generate ledgers

create sales journal

purchase journals

or tax reports

 create multiple reports from just one interface

 data entered to filter reports is carried over to the next report

Inventory Control

 parts link to inventory, income, expense and tax accounts

 fields for Make and Model part will fit

 assemblies (manufactured goods) link to income and tax accounts
 kits, similar to assemblies but non-stocking and processed as a bundle when sold or
purchased. Items can either be shown on an invoice/packing list or hidden. This features is also
useful for bundling such things as promotional giveaways, bottle deposits, core charges, etc.
 service items link to income, expense and tax accounts

 inventory is recorded when items are purchased

 all expenses for cost of goods are posted when an item is sold
 expenses for service items are recorded when purchased
 entry to inventory is in no particular order
 stock parts with Vendor Invoice (Merchandise Received)

 keep inventory in multiple warehouses

 ship/receive merchandise
 warehouse transfer form and transaction log

 stock assemblies

re-order point calculates how many should be on hand

assemblies can also be stocked from the assembly screen

 customizable reports
 sort reports by headings

 convenient way to keep price lists for vendors and customers

 display price history for items and pick price

Billing / Invoicing

 post to selectable AR / AP account

 tax, due date calculated based on vendor / customer selected

tax can be included or on top
 customizable customer invoice (html) or Postscript / PDF

 send invoice by email in html, postscript or pdf format

 packing / pick list

 vendor invoice functions also as merchandise received module to stock inventory

 display margins for individual items and totals on invoices and orders.

Payroll

 define wages and deductions, no payroll tables to maintain

 control which wages and deductions apply for each employee
 set individual exemptions for each employee
 print summary and detailed reports for employees
 print payslip and check
 upload payments file to bank for processing payments

Time Cards

 customizable time card reports

  sort reports by project, service code, employee, date, monthly, quarterly, and yearly periods
 report summarized by week
 print time card for an employee (Postscript/PDF, or html)

Recurring Invoices

 list of recurring transactions

 scheduled recurring transaction

 post/print/e-mail recurring transactions

POS

 cash receipt report divided into payment types

(i.e. cash, interac, visa, mc)

 screen printout for supervisors to view all open invoices

 user limited access to menu items

 cash receipt printout

 POS invoice with many forms of payment

  Specify buttons for POS

Check Printing

 print checks on pre-printed forms or plain stock.

 customizable templates to use any type of format

 print PDF check to screen for processing from a terminal

 print checks directly on a printer
 select invoices for payment

Purchase / Sales order

 customizable purchase order (html) or (Postscript / PDF)

 customizable sales order (html) or (Postscript / PDF)

 email sales order to customer
 email purchase order to vendor

 create vendor invoice from purchase order

  create customer invoice from sales order
could be used for quotations too
 save orders for recurring invoices

 customizable reports (sales order list)

 generate purchase orders from sales orders

 enter pre-payments made to vendor at time of order. Same for customer orders, enter deposits

received on order.
 consolidate multiple orders and generate an invoice. Add your own description to indicate for
which period the invoice is for. i.e For services rendered / beginning date - ending date.
 consolidate multiple invoices into one invoice.

Customizable Taxes

 data driven dynamic system

 any number of taxes may be set up

 taxes are selectable for each part service and

assembly

 customers and vendors can be set taxable at each rate

 tax calculations either on top or included in price

 tax reports can be produced with a GL report

  tax reports can also be generated for tax collected and

paid

 each tax is printed on invoice only when there is a tax

 non-additive tax calculations for multi-level taxes
 tax on tax may be simulated by adding tax to tax
 tax included calculations are done in the background
 netprice calculations to record income and expenses
 consolidated tax reports

Multi User

 multiple user access

 use the same login name or another name

 individual templates

 access control

enable only certain menu items, others are not shown

 language selection
  company address can be changed for different location (warehouse)

Multi Company

 multiple companies with one installation

 companies use their own space
 access to data is controlled per user
 individual templates

 access control

CMS

 Attach reference documents to customers, employees, transactions, projects, etc. Documents

can be kept "Confidential" so not everyone has access to the documents.
 Upload documents and attach to transactions. Once documents are attached they can be
viewed by the program associated with the type of document. i.e launch a spreadsheet in
openoffice or Excell, or display a word document in your word

processor.

Audit Control

 enforce transaction reversal for all dates

 close books up to a date to prevent users from editing or deleting transactions that are closed

 post and delete buttons are not shown for closed transaction
 incorrect transactions must be reversed and entered anew
 audit log and reports to see what was done.

Foreign Currency
  foreign currency invoices
 automatically keep track of exchange rate difference, gains and losses

 foreign currency transactions

 foreign currency orders

 multiple exchange rates for every transaction
 foreign currency GL transactions

Internationalization

 currency formatting with or without thousand separator

 comma separator can be either dot or comma
 enter formatted or unformatted numbers
 long and short date formatting

 switch the display to a foreign language

 add your own language and master templates
 foreign language templates and chart of accounts

 translate chart of accounts to any number of languages

 language is automatically chosen according to the user's preferences

Access Control

 password protection
 customized menus are dynamically included in access control

 each menu item can be enabled / disabled by the system administrator

great for creating screens for counter staff

 setup menu to change preferences can be disabled to lock options
 access to data is controlled per user
SQL server backend

 password protection
 customized menus are dynamically included in access control

 each menu item can be enabled / disabled by the system administrator

great for creating screens for counter staff

 setup menu to change preferences can be disabled to lock options
 access to data is controlled per user

Customizable Templates

 customizable html and tex templates for

Invoice
Packing List
Bin List
Sales Order
Purchase Order
Check
Reminder

 produce postscript and PDF output from tex templates for professional looking
documents
 per user or a group of users

 html templates with embedded codes

failsafe, codes are replaced at runtime

won't break the code if there is an error in the template

 built-in template editor

Customers
  billing address and shipping address

if not filled in then billing address is used instead

 set customer taxable at each tax rate

 additionally set if tax should be included in price
 payment terms
due dates are calculated based on the terms entered
Vendors

 vendor address
 set vendor taxable at each tax rate
 additionally set if tax should be included in price
 payment terms
due dates are calculated based on the terms entered
 space for notes

 customizable reports

 sort vendor list

Assemblies (BOM kits)

  assemblies, manufactured goods are a combination of parts, services and/or
assemblies
 linked to income and tax accounts
 assemblies can be built from other assemblies
 cost of goods and expenses are posted when the assembly is sold

 stock assemblies
 total price and weight calculated
 change selling price rather than using a calculated total
 individual items can be changed from within assembly screen
any price and weight change will change the totals for the assembly

 customizable reports

Chart of Accounts

 organize chart of accounts into headings and accounts

 available account types
Asset, Liability, Equity, Income, Expense, whether the account is a contra account, and if the

account should be a Heading or an Account

 set accounts to a summary account for
Accounts Receivables
Accounts Payables
Inventory
 include account in drop-down selection menus on
AR, AP, tracking and non-tracking items screens
 set account as a tax account
 change account numbers anytime
 setup your own master chart of accounts for setting up new companies
 translate chart of accounts into any number of languages to work with the same chart of

accounts in different languages

 list chart of accounts with Debit and Credit columns
 drill down into account number for a list of transactions
  limit transactions to a date range, period, and an amount (>= or <=)
 include subtotals in ledgers
 sort ledgers by date, reference, description, source, and account

 translate chart of accounts to any number of languages

 language is automatically chosen according to the user's preferences

Customizable Reports

 extensive AR AP GL reports
 create reports from just one interface
 select fields to include and subtotals
 sort reports by various columns
 subtotals for sorted column
 links to original transactions
 drill down into accounts to generate more reports

 create sales journals purchase journals tax

reports
 data entered to filter reports is carried over to the next report

 GL report with contra accounts

 sort and group by account number, most commonly used in Europe
 fully configurable
 save report layout and instantly recall
 user defined report layout.

Memorize Report Layout

 save and restore public and private report layouts

 Reports can be selected from menu list
 dynamically built for every user
 Private reports are only visible for user and administrator

Financial Statement
  Balance Sheet for every month, quarter of the year

 Income Statement for every month, quarter, year

 generate based on GIFI or regular accounts
 compare to previous year's data

 Trial Balance with headings and subtotals

 drill down into each account for a complete list of transactions posted to the
account
 limit trial balance to a range of dates
 data filters are carried over to the next report
 links to original transaction
 sort report by date, source, description
 subtotals on sorted column

Paymet Export file

 payments export file for use with BDD, DTA, Postgiro or other

formats
 fully configurable
 add your own information
 summary record
 header record
 memorized layout

Administration module

 password protected

 list users, data sources and template directories

  create carbon copy preferences by simply editing an existing user

 interface to manage local and remote databases

 create chart of accounts from external files

 add your own master chart of accounts
 create your own master templates
 delete users and associated template directory

 delete dataset, only resources which are not in use are listed

 enable / disable menu items for users

Application Interface

 change themes for each user with a stylesheet

 modify the application without changing the core

 build information catalogs

 add other programs for a groupware application

 build dynamic content with menu files

 add global customized menus or menus for a login
 not limited to perl code
 does not interfere with future upgrades
 batch transactions for stand-alone POS terminals

 global and per login customization

 add new functions and screens globally or per login
i.e you can give your customers restricted access to a sales order system
  example of an ordering system linking a chain of stores

Backup to file

 Backup data to a file or send to an email account for off-line storage

 Data is stored in ASCII format
 Backups can also be imported into a spreadsheet for further processing
 Restore data at the same or another location
 Restoring data requires shell level access to prevent accidental overwrites

Import Transaction

 import sales invoices, purchase and sales orders, pricelists, parts, services, labor, partsgroups,

payments, customers, vendors, chart of accounts.

 payments are automatically reconciled with your bank account

 import sales invoices

 select which ones to import

 import bank transactions and match to invoices

 select payments to import

Use on Handheld

 touch screen provides for very quick navigation

 no special version required for use on a handheld

 no Java required
  great for entering data on the road or from a warehouse

 lynx mode provides extra navigation menu

 can easily be customized to provide all kinds of uses from ordering systems to updating
inventory
 Because everything is run on the server the display unit doesn't need to know anything other
than how to display information.

 SQL-Ledger running on a Nokia 770 tablet.

Document Control

 generate document control numbers for tracking payments

 numbers are controlled by variables defined for bank account
 Modulo 10 and 11 check digit calculations
 import payments based on document control numbers
 SQL Ledger

SCALE 5 4 3 2 1
Customer Relationship/Account Management
Ensure that the CRM module lets users view customers across a wide range of
custom views including products, geography, account type and more. An effective
CRM Module should also allow ease of access to necessary ERP information on any
device at any time.
Account Payable Reporting
Good ERP systems will provide your AP team with sufficient reporting so that
collections is more efficient and account aging is easier to assess.
Bank Reconciliation
Your potential ERP solution needs a Bank Reconciliation feature to help your
organization reconcile bank statement balances with the General Ledger cash
accounts amount.
Benefits Administration
Your ERP needs a system for to manage and track participation in benefits
programs, including insurance, compensation, profit sharing and retirement
programs.
MRP (Material Requirements Planning)
Some organizations require production planning, scheduling, and an inventory
control system. If this is part of your requirements as well, check that the ERPs you
are evaluating include this module.
BOM (Bill Of Materials)
Do you need to use bills of material when creating production orders to
manufacture products? If so, be sure this feature is built into whatever ERP you
are considering.
Logistics Management
Since logistics management is essential to all of your organization’s planning and
execution, having logistics management in your ERP is a core feature. I don’t think
an ERP qualifies without logistics management as an integral feature.
Email Tools
Email tools come in many different platforms. Being part of essential CRM
requirements, Making sure that robust email tools are part of the product feature
set.
B2C Commerce(Business to Consumer)
Here again is a choice of organizational preference whether your ERP acts as your
point of commerce or you select a stand-alone commerce platform.
Advanced Allocations
If you want help improving overall efficiency, accuracy of financial reporting, and
shortening close cycles, having advanced allocations functionality in your ERP is
critical.
Tax Administration: Payroll & Tax Filing
You need a tax administration technology as a core part of your ERP solution as it
inherently saves your finance team substantial time, money and effort.
Engineering Change Management
Managing your products and manufacturing and business processes is a
fundamental and continual challenge your organization likely faces. Having a solid
ECM component ensures that challenge is most effectively handled. The solution
should have ECM with central logistics functions that can be used to change
various aspects of production basic data depending on specific conditions
Top Analyst Report Community Reviews, Customer Recommendation
Check that the ERP Vendors you are evaluating have received positive scores and
reviews across the range of ERP features and functions listed above. Make sure
you evaluate from the perspective of both analysts and within ERP customer
review sites.
Module/API Integration
Your selected ERP package needs integration between modules and optionally (but
often necessary) other 3rd party platform APIs, so that all of the core business
functions are connected. Information should flow across the organization so that
BI reports on organization-wide results.
Business Process Management (BPM)
Business Process Management Software will provide the capability to automate
virtually any business process. This is vital to your ERP system and selection.
TOTAL
AVERAGE(OVERALL 15PTS)/ PASSING: 8PTS
LEGEND:
5 – OUTSTANDING MODULES
4 - CONCEPT MODULES ARE EFFECTIVES
3 – CONCEPT MODULES ARE EFFFECTIVES YET LACKING ON SOME CRITERIA
2 – NEEDS MODULE REVISION
1 – UNRELIABLE MODULES