From e10829e143ce3594cc00a86d71b327ae70278ef4 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Mon, 9 Apr 2007 21:40:35 +0000 Subject: Updated changelog for 1.2.1 git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1049 4979c152-3d1c-0410-bac9-87ea11338e46 --- doc/html_manual/LedgerSMB-manual.html | 1105 ++++++++++++++++----------------- 1 file changed, 552 insertions(+), 553 deletions(-) (limited to 'doc/html_manual/LedgerSMB-manual.html') diff --git a/doc/html_manual/LedgerSMB-manual.html b/doc/html_manual/LedgerSMB-manual.html index f1053f41..219f05ea 100644 --- a/doc/html_manual/LedgerSMB-manual.html +++ b/doc/html_manual/LedgerSMB-manual.html @@ -10,7 +10,7 @@ - + @@ -25,7 +25,7 @@ class="pplr8t-x-x-120">The LedgerSMB Core Team

March 26, 2007

+class="pplr8t-x-x-120">April 9, 2007 Copyright ©2006 The LedgerSMB Core Team. Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version @@ -1044,41 +1044,40 @@ example, when PST applies to the total and GST as well).

Sales Tax is collected on behalf of a state or national government by the individual store. Thus a sales tax account is a liability– it represents money owed by the business to the government.

To add a sales tax account, create an account in the Chart of Accounts as a liability account, check all of -the "tax" checkboxes, and answer the following question as "yes:" -

"Include this account on the customer/vendor forms to flag customer/vendor as taxable?" -

Once this account is created, one can set the tax amount. -

+the "tax" checkboxes. +

Once this account is created, one can set the tax amount. +

4.1.2 Setting a Sales Tax Amount

Go to System->Defaults and the tax account will be listed near the bottom of the page. The rate can be set +

Go to System->Defaults and the tax account will be listed near the bottom of the page. The rate can be set there. -

4.1.3 Default Account Setup

These accounts are the default accounts for part creation and foreign exchange tracking. -

These accounts are the default accounts for part creation and foreign exchange tracking. +

4.1.4 Currency Setup

The US accounts list this as USD:CAD:EUR. One can add other currencies in here, such as IDR (Indonesian +

The US accounts list this as USD:CAD:EUR. One can add other currencies in here, such as IDR (Indonesian Rupiah), etc. Currencies are separated by colons. -

4.1.5 Sequence Settings

These sequences are used to generate user identifiers for quotations, invoices, and the like. If an identifier is +

These sequences are used to generate user identifiers for quotations, invoices, and the like. If an identifier is not added, the next number will be used. -

A common application is to set invoices, etc. to start at 1000 in order to hide the number of issued invoices +

A common application is to set invoices, etc. to start at 1000 in order to hide the number of issued invoices from a customer. -

Leading zeros are preserved. Other special values which can be embedded using

Leading zeros are preserved. Other special values which can be embedded using <?lsmb ?> tags include: -

DATE: expands to the partsgroup. Valid only for parts. PHONE; expands to the telephoen number for customers and vendors.

4.2 Audit Control

Auditability is a core concern of the architects of any accounting system. Such ensures that any modification +

Auditability is a core concern of the architects of any accounting system. Such ensures that any modification to the accounting information leaves a trail which can be followed to determine the nature of the change. Audits can help ensure that the data in the accounting system is meaningful and accurate, and that no foul play (such as embezzlement) is occurring. -

4.2.1 Explaining transaction reversal

In paper accounting systems, it was necessary to have a means to authoritatively track corrections of +

In paper accounting systems, it was necessary to have a means to authoritatively track corrections of mistakes. The means by which this was done was known as "transaction reversal." -

When a mistake would be made, one would then reverse the transaction and then enter it in correctly. For +

When a mistake would be made, one would then reverse the transaction and then enter it in correctly. For example, let us say that an office was renting space for $300 per month. Let us say that they inadvertently entered it in as a $200 expense. -

The original transaction would be: +

The original transaction would be:

$200 style="vertical-align:baseline;" id="TBL-2-4-">

The reversal would be: +

The reversal would be:

style="vertical-align:baseline;" id="TBL-3-4-">

This would be followed by re-entering the rent data with the correct numbers. This was meant to ensure +

This would be followed by re-entering the rent data with the correct numbers. This was meant to ensure that one did not erase data from the accounting books (and as such that erasing data would be a sign of foul play). -

Ledger-SMB has a capability to require such reversals if the business deems this to be necessary. When +

Ledger-SMB has a capability to require such reversals if the business deems this to be necessary. When this option is enabled, existing transactions cannot be modified and one will need to post reversing transactions to void existing transactions before posting corrected ones. -

Most accountants prefer this means to other audit trails because it is well proven and understood by +

Most accountants prefer this means to other audit trails because it is well proven and understood by them. -

4.2.2 Close books option

You cannot alter a transaction that was entered before the closing date. -

You cannot alter a transaction that was entered before the closing date. +

4.2.3 Audit Trails

This option stores additional information in the database to help auditors trace individual transactions. The +

This option stores additional information in the database to help auditors trace individual transactions. The information stored, however, is limited and it is intended to be supplemental to other auditing facilities. -

The information added includes which table stored the record, which employee entered the +

The information added includes which table stored the record, which employee entered the information, which form was used, and what the action was. No direct financial information is included. -

4.3 Departments

Departments are logical divisions of a business. They allow for budgets to be prepared for the individual +

Departments are logical divisions of a business. They allow for budgets to be prepared for the individual department as well as the business as a whole. This allows larger businesses to use Ledger-SMB to meet their needs. -

4.3.1 Cost v Profit Centers.

In general business units are divided into cost and profit centers. Cost centers are generally regarded as +

In general business units are divided into cost and profit centers. Cost centers are generally regarded as business units where the business expects to lose money and profit centers are where they expect to gain money. For example, the legal department in most companies is a cost center. -

One of the serious misunderstandings people run up against is that Ledger-SMB tends to more narrowly +

One of the serious misunderstandings people run up against is that Ledger-SMB tends to more narrowly define cost and profit centers than most businesses do. In Ledger-SMB a cost center is any department of the business that does not issue AR transactions. Although many businesses may have cost centers (like technical support) where customer fees may subsidize the cost of providing the service, in Ledger-SMB, these are profit centers. -

Ledger-SMB will not allow cost centers to be associated with AR transactions. So if you want this +

Ledger-SMB will not allow cost centers to be associated with AR transactions. So if you want this functionality, you must create the department as a profit center. -

4.4 Warehouses

Ledger-SMB has the ability to track inventory by warehouse. Inventory items can be moved between +

Ledger-SMB has the ability to track inventory by warehouse. Inventory items can be moved between warehouses, and shipped from any warehouse where the item is in stock. We will explore this concept more later. -

4.5 Languages

Languages allow for goods and services to be translated so that one can maintain offices in different +

Languages allow for goods and services to be translated so that one can maintain offices in different countries and allow for different goods and service descriptions to be translated to different languages for localization purposes. -

4.6 Types of Businesses

One can create types of businesses and then give them discounts across the board. For example, one might +

One can create types of businesses and then give them discounts across the board. For example, one might give a firm that uses one’s services as a subcontractor a 10% discount or more. -

4.7 Misc.

4.7.1 GIFI

GIFI is a requirement for Canadian customers. This feature allows one to link accounts with +

GIFI is a requirement for Canadian customers. This feature allows one to link accounts with Canadian tax codes to simplify the reporting process. Some European countries now use a similar system. -

People that don’t otherwise have a use for GIFI can use it to create reports which agregate accounts +

People that don’t otherwise have a use for GIFI can use it to create reports which agregate accounts together. -

4.7.2 SIC

Standard Industrial Classification is a way of tracking the type of business that a vendor or customer is in. +

Standard Industrial Classification is a way of tracking the type of business that a vendor or customer is in. For example, an accountant would have an SIC of 8721 while a graphic design firm would have an SIC of 7336. The classification is hierarchical so one could use this field for custom reporting and marketing purposes. -

4.7.3 Overview of Template Editing

The templates for invoices, orders, and the like can be edited from within Ledger-SMB. The submenus within +

The templates for invoices, orders, and the like can be edited from within Ledger-SMB. The submenus within the System submenu such as HTML Templates, Text Templates and LATEX templates provide access to this functionality. -

4.7.4 Year-end

Although the Year-end functionality in Ledger-SMB is very useful, it does not entirely make the process +

Although the Year-end functionality in Ledger-SMB is very useful, it does not entirely make the process simple and painless. One must still manually enter adjustments prior to closing the books. The extent to which these adjustments are necessary for any given business is a matter best discussed with an accountant. -

The standard way books are normally closed at the end of the year is by moving all +

The standard way books are normally closed at the end of the year is by moving all adjusted¹ @@ -1299,18 +1298,18 @@ moved. Equity drawing/dividend accounts are also moved, but the investment accou reasoning behind this process is that one wants a permanent record of the amount invested in a business, but any dividends ought not to count against their recipients when new investors are brought on board. -

Ledger-SMB automatically moves all income and expense into the specified year-end/retained earnings +

Ledger-SMB automatically moves all income and expense into the specified year-end/retained earnings account. It does not move the drawing account, and this must be done manually, nor does it automate the process of making adjustments. -

Contrary to its name, this function can close the books at any time, though this would likely be of limited +

Contrary to its name, this function can close the books at any time, though this would likely be of limited use.

4.8 Options in the ledger-smb.conf

The ledger-smb.conf configures the software by assigning site-wide variables. Most of these should be left +

The ledger-smb.conf configures the software by assigning site-wide variables. Most of these should be left alone unless one knows what one is doing. However, on some systems some options might need to be changed, so all options are presented here for reference: -

templates: ]
Color = lpr -PEpson
However, this can use any program that can accept print documents (in Postscript) from standard input, so there are many more possibilities.

5 Goods and Services

The Goods and Services module will focus on the definition of goods and services and the related accounting +

The Goods and Services module will focus on the definition of goods and services and the related accounting concepts. -

5.1 Basic Terms

COGS: Sell; Price is the price at which the item is sold.

5.2 The Price Matrix

It is possible to set different prices for different groups of customers, or for different customers individually. +

It is possible to set different prices for different groups of customers, or for different customers individually. Similarly, one can track different prices from different vendors along with the required lead time for an order. -

5.3 Pricegroups

Pricegroups are used to help determine the discount a given customer may have. -

Pricegroups are used to help determine the discount a given customer may have. +

5.4 Groups

Groups represent a way of categorizing POS items for a touchscreen environment. It is not fully functional +

Groups represent a way of categorizing POS items for a touchscreen environment. It is not fully functional yet, but is sufficient that with some stylesheet changes, it could be made to work. -

5.5 Labor/Overhead

Labor/overhead is usually used for tracking manufacturing expenses. It is not directly billed to a customer. It +

Labor/overhead is usually used for tracking manufacturing expenses. It is not directly billed to a customer. It is associated with an expense/Cost of Goods Sold (COGS) account. -

5.6 Services

Services include any labor that is billed directly to the customer. It is associated with an expense/COGS +

Services include any labor that is billed directly to the customer. It is associated with an expense/COGS account and an income account. Services can be associated with sales tax. -

5.6.1 Shipping and Handling as a Service

One approach to dealing with shipping and handling is to add it as a service. Create a service called +

One approach to dealing with shipping and handling is to add it as a service. Create a service called “Shipping and Handling”, with a sell price $1 per unit, and a 0% markup. Bill it as $1 per unit. This allows one to add the exact amount of shipping and handling as necessary. -

5.7 Parts

A part is any single item you might purchase and either might resell or use in manufacturing an assembly. It +

A part is any single item you might purchase and either might resell or use in manufacturing an assembly. It is linked to an expense/COGS account, an income account, and an inventory account. Parts can be associated with sales tax. -

5.8 Assemblies and Manufacturing

Manufacturers order parts but they sell the products of their efforts. Ledger-SMB supports manufacturing +

Manufacturers order parts but they sell the products of their efforts. Ledger-SMB supports manufacturing using the concept of assemblies. An assembly is any product which is manufactured on site. It consists of a selection of parts, services, and/or labor and overhead. Assemblies are treated as parts in most other regards. -

However, one cannot order assemblies from vendors. One must instead order the components and stock +

However, one cannot order assemblies from vendors. One must instead order the components and stock them once they are manufactured. -

5.8.1 Stocking Assemblies

One stocks assemblies in the Stock Assembly entry on the Goods and Services submenu. When an assembly +

One stocks assemblies in the Stock Assembly entry on the Goods and Services submenu. When an assembly is stocked the inventory is adjusted properly. -

The Check Inventory option will cause Ledger-SMB to refuse to stock an assembly if the inventory +

The Check Inventory option will cause Ledger-SMB to refuse to stock an assembly if the inventory required to produce the assembly would drop the part below the reorder point. -

5.9 Reporting

5.9.1 All Items and Parts Reports

The All Items report provides a unified view of assemblies, parts, services, and labor for the company, while +

The All Items report provides a unified view of assemblies, parts, services, and labor for the company, while the Parts report confines it to parts. -

Types of reports are: -

Types of reports are: +

Active: Lists all items which are marked as obsolete. Orphaned; Lists all items which have never had a transaction associated with them.

One can also list these goods by invoice, order, or quotation. -

For best results, it is a good idea to enter some AR and AP data before running these reports. +

One can also list these goods by invoice, order, or quotation. +

For best results, it is a good idea to enter some AR and AP data before running these reports. -

5.9.2 Requirements

This report is designed to assist managers determine the quantities of goods to order and/or stock. It +

This report is designed to assist managers determine the quantities of goods to order and/or stock. It compares the quantity on hand with the activity in a given time frame and provides a list of goods which need to be ordered and the relevant quantity. -

5.9.3 Services and Labor

This is similar to the Parts and All Items menu but only supports Active, Obsolete, and Orphaned +

This is similar to the Parts and All Items menu but only supports Active, Obsolete, and Orphaned reports. -

5.9.4 Assemblies

This is similar to the Parts and All Items reports but it also provides an ability to list individual items in the +

This is similar to the Parts and All Items reports but it also provides an ability to list individual items in the assemblies as well. -

AP Invoices, Purchase Orders, and RFQ’s are not available on this report. -

AP Invoices, Purchase Orders, and RFQ’s are not available on this report. +

5.9.5 Groups and Pricegroups

These reports provide a simple interface for locating groups and pricegroups. The report types are similar to +

These reports provide a simple interface for locating groups and pricegroups. The report types are similar to what they are for services. -

5.10 Translations

One can add translations so that they show up in the customer’s native language in the issued +

One can add translations so that they show up in the customer’s native language in the issued invoice. -

To issue translations, one must have languages defined. One can then add translations to descriptions and +

To issue translations, one must have languages defined. One can then add translations to descriptions and part groups. -

5.11 How Cost of Goods Sold is tracked

Cost of Goods Sold is tracked on a First-In, First-out (FIFO) basis. When a part is purchased, its cost is +

Cost of Goods Sold is tracked on a First-In, First-out (FIFO) basis. When a part is purchased, its cost is recorded in the database. The cost of the item is then added to the inventory asset account. When the good is sold, the cost of the item is moved to the cost of goods sold account. -

This means that one must actually provide invoices for all goods entered at their actual cost. If one enters +

This means that one must actually provide invoices for all goods entered at their actual cost. If one enters in $0 for the cost, the cost of goods sold will also be $0 when the item is sold. We will cover this entire process in more depth after we cover the AP and AR units below. -

6 AP

6.1 Basic AP Concepts

The Accounts Payable module tracks all financial commitments that the company makes to other businesses. +

The Accounts Payable module tracks all financial commitments that the company makes to other businesses. This includes rent, utilities, etc. as well as orders of goods and services. -

6.2 Vendors

A vendor is any business that the company agrees to pay money to. -

One can enter vendor information under AP->Vendors->Add Vendor. The vendor list can be searched +

A vendor is any business that the company agrees to pay money to. +

One can enter vendor information under AP->Vendors->Add Vendor. The vendor list can be searched under AP->Vendors->Reports->Search. -

Enter start and end-dates for each vendor. This will make searches and drop-down boxes faster when +

Enter start and end-dates for each vendor. This will make searches and drop-down boxes faster when some vendors are no longer actively supporting your company. -

A few fields that need explanation are: -

A few fields that need explanation are: +

BIC: is the number of days one has to pay the invoice. Vendor; Number is automatically generated.

6.3 AP Transactions

AP Transactions are generally used for items other than goods and services. Utilities, rent, travel expenses, +

AP Transactions are generally used for items other than goods and services. Utilities, rent, travel expenses, etc. could be entered in as an AP transaction. -

If the item is paid partially or in full when the transaction is entered, one can add payments to the +

If the item is paid partially or in full when the transaction is entered, one can add payments to the payment section. -

All other payments can and should be entered under cash payment (below). -

The PO Number and Order Number fields are generally used to track associations with purchase orders +

All other payments can and should be entered under cash payment (below). +

The PO Number and Order Number fields are generally used to track associations with purchase orders sent to vendors, etc. These fields can be helpful for adding misc. expenses to orders for reporting purposes. -

The department drop-down box appears when one has created one or more departments. A +

The department drop-down box appears when one has created one or more departments. A transaction is not required to be associated with a department, but one can use this feature for budget tracking. -

With AP Transactions, there is no option for internal notes. All notes will appear on any printed version of +

With AP Transactions, there is no option for internal notes. All notes will appear on any printed version of the transaction. -

Note: Printing a transaction does not post it. No data is committed until the invoice is posted. -

Note: Printing a transaction does not post it. No data is committed until the invoice is posted. +

6.4 AP Invoices

AP Invoices are used to enter in the receipt of goods and services. Goods and services are deemed entered +

AP Invoices are used to enter in the receipt of goods and services. Goods and services are deemed entered into the inventory when they are invoiced. -

This screen is reasonably similar to the AP Transaction Screen, though the part entry section is a bit +

This screen is reasonably similar to the AP Transaction Screen, though the part entry section is a bit different. -

The AP Invoice section has a capacity to separate internal notes from notes printed on the invoice. Note, +

The AP Invoice section has a capacity to separate internal notes from notes printed on the invoice. Note, however, that since these are received invoices, it is rare that one needs this ability. -

Note that Ledger-SMB can search for partial part numbers or descriptions. -

Also if you have a group you can use this to select the part. -

To remove a line item from an invoice or order, delete the partnumber and click update. -

Note that Ledger-SMB can search for partial part numbers or descriptions. +

Also if you have a group you can use this to select the part. +

To remove a line item from an invoice or order, delete the partnumber and click update. +

6.4.1 Correcting an AP Invoice

If an invoice is entered improperly, the methods used to correct it will vary depending on whether +

If an invoice is entered improperly, the methods used to correct it will vary depending on whether transaction reversal is enforced or not. If transaction reversal is not enforced, one can simply correct the invoice or transaction and repost. Note, however, that this violates generally accepted accounting principles. -

If transaction reversal is in effect, one needs to create a duplicate invoice with exactly opposite values +

If transaction reversal is in effect, one needs to create a duplicate invoice with exactly opposite values entered. If one part was listed as received, then one should enter a negative one for the quantity. Then one can enter the invoice number as the same as the old one. Add an R to the end to show that it is a reversing transaction. Once this is posted, one can enter the invoice correctly. -

6.5 Cash payment And Check Printing

It is a bad idea to repost invoices/transactions just to enter a payment. The Cash->Payment window allows +

It is a bad idea to repost invoices/transactions just to enter a payment. The Cash->Payment window allows one to enter payments against AP invoices or transactions. -

The printing capability can be used to print checks. The default template is NEBS 9085, though you can +

The printing capability can be used to print checks. The default template is NEBS 9085, though you can use 9082 as well (as Quickbooks does). -

The source field is used to store an identifying number of the source document, such as the check +

The source field is used to store an identifying number of the source document, such as the check number. One must select the item to have it paid, and then enter the amount. One can then print a check. -

6.5.1 Rapid Payment Entry Screen

One can also use the rapid payment entry screen to print multiple checks. However, this does not allow you +

One can also use the rapid payment entry screen to print multiple checks. However, this does not allow you to print the multiple checks to the screen as a separate document is created for each check. In this event, one must print directly to a printer as postscript. -

6.6 Transaction/Invoice Reporting

6.6.1 Transactions Report

This report is designed to help you locate AP transactions based on various criteria. One can +

This report is designed to help you locate AP transactions based on various criteria. One can search by vendor, invoice number, department, and the like. One can even search by the shipping method. -

The summary button will show what was placed where, while the details button will show all debits and +

The summary button will show what was placed where, while the details button will show all debits and credits associated with the transaction. -

To view the invoice, click on the invoice number. In the detail view, to view the account transactions as a +

To view the invoice, click on the invoice number. In the detail view, to view the account transactions as a whole, click on the account number. -

Open invoices are ones not fully paid off, while closed invoices are those that have been +

Open invoices are ones not fully paid off, while closed invoices are those that have been paid. -

6.6.2 Outstanding Report

The outstanding report is designed to help you locate AP transactions that are not paid yet. The +

The outstanding report is designed to help you locate AP transactions that are not paid yet. The ID field is mostly useful for locating the specific database record if a duplicate invoice number exists. -

6.6.3 AP Aging Report

This report can tell you how many invoices are past due and by how much. -

A summary report just shows vendors while a detail report shows individual invoices. -

This report can tell you how many invoices are past due and by how much. +

A summary report just shows vendors while a detail report shows individual invoices. +

6.6.4 Tax Paid and Non-taxable Report

These reports have known issues. It is better to use the GL reports and filter accordingly. -

These reports have known issues. It is better to use the GL reports and filter accordingly. +

6.7 Vendor Reporting

6.7.1 Vendor Search

The Vendor Search screen can be used to locate vendors or AP transactions associated with those +

The Vendor Search screen can be used to locate vendors or AP transactions associated with those vendors. -

The basic types of reports are: -

The basic types of reports are: +

All: Lists those vendors who are currently inactive. time frame. class="pplb8t-">Orphaned; Lists those vendors who do not have transactions associated with them. These vendors can be deleted.

One can include purchase orders, Requests for Quotations, AP invoices, and AP transactions on this report as +

One can include purchase orders, Requests for Quotations, AP invoices, and AP transactions on this report as well if they occur between the from and to dates. -

6.7.2 Vendor History

This report can be used to obtain information about the past goods and services ordered or received from +

This report can be used to obtain information about the past goods and services ordered or received from vendors. One can find quantities, partnumber, and sell prices on this report. This facility can be used to search RFQ’s, Purchase Orders, and AP Invoices. -

7 AR

7.1 Customers

Customers are entered in using the AR->Customers->Add Customer menu. -

The salesperson is autopopulated with the current user who is logged in. Otherwise, it looks fairly similar +

Customers are entered in using the AR->Customers->Add Customer menu. +

The salesperson is autopopulated with the current user who is logged in. Otherwise, it looks fairly similar to the Vendor input screen. Customers, like vendors can be assigned languages, but it is more important to do so because invoices will be printed and sent to them. -

The credit limit field can be used to assign an amount that one is willing to do for a customer on +

The credit limit field can be used to assign an amount that one is willing to do for a customer on credit. -

7.1.1 Customer Price Matrix

The price list button can be used to enter specific discounts to the customer, and groups of customers can be +

The price list button can be used to enter specific discounts to the customer, and groups of customers can be assigned a pricegroup for the purpose of offering specific discounts on specific parts to the customer. Such discounts can be temporary or permanent. -

7.2 AR Transactions

AR Transactions are where one can add moneys owed the business by customers. One can associate these +

AR Transactions are where one can add moneys owed the business by customers. One can associate these transactions with income accounts, and add payments if the item is paid when the invoice is issued. -

The PO number field is used to track the PO that the customer sent. This makes it easier to find items +

The PO number field is used to track the PO that the customer sent. This makes it easier to find items when a customer is asking for clarification on a bill, for example. -

7.3 AR Invoices

AR Invoices are designed to provide for the delivery of goods and services to customers. One would +

AR Invoices are designed to provide for the delivery of goods and services to customers. One would normally issue these invoices at the time when the everything has been done that is necessary to get paid by the customer. -

As with AP invoices, one can search for matches to partial part numbers and descriptions, and enter +

As with AP invoices, one can search for matches to partial part numbers and descriptions, and enter initial payments at this screen. -

7.4 Cash Receipt

The Cash->Receipt screen allows you to accept prepayments from customers or pay single or multiple +

The Cash->Receipt screen allows you to accept prepayments from customers or pay single or multiple invoices after they have been posted. One can print a receipt, however the current templates seem to be based on check printing templates and so are unsuitable for this purpose. This presents a great opportunity for improvement. -

7.4.1 Cash Receipts for multiple customers

The cash->receipts screen allows you to accept payments on all open customer invoices of all +

The cash->receipts screen allows you to accept payments on all open customer invoices of all customers at once. One could print (directly to a printer only) all receipts to be sent out if this was desired. -

7.5 AR Transaction Reporting

The AR Outstanding report is almost identical to the AP Outstanding report and is not covered in any detail +

The AR Outstanding report is almost identical to the AP Outstanding report and is not covered in any detail in this document. -

7.5.1 AR Transactions Report

This is almost identical to the AP Transactions Report. -

If a customer’s PO has been associated with this transaction, one can search under this field as +

This is almost identical to the AP Transactions Report. +

If a customer’s PO has been associated with this transaction, one can search under this field as well. -

7.5.2 AR Aging Report

This report is almost identical to the AP Aging report, with the exception that one can print up statements for +

This report is almost identical to the AP Aging report, with the exception that one can print up statements for customer accounts that are overdue. One more application is to calculate interest based on balance owed so that these can be entered as AR transactions associated with the customer. -

7.6 Customer Reporting

These reports are almost identical to the AP Vendor reports and are not discussed in these notes. -

These reports are almost identical to the AP Vendor reports and are not discussed in these notes. +

8 Projects

8.1 Project Basics

A project is a logical collection of AR and AP transactions, orders, and the like that allow one to better +

A project is a logical collection of AR and AP transactions, orders, and the like that allow one to better manage specific service or product offerings. Ledger-SMB does not offer comprehensive project management capabilities, and projects are only used here as they relate to accounting. -

One can also add translated descriptions to the project names as well. -

One can also add translated descriptions to the project names as well. +

8.2 Timecards

Timecards allow one to track time entered on specific services. These can then be used to generate invoices +

Timecards allow one to track time entered on specific services. These can then be used to generate invoices for the time entered. -

The non-chargeable is the number of hours that are not billed on the invoice. -

One can then generate invoices based on this information. -

The project field is not optional. -

The non-chargeable is the number of hours that are not billed on the invoice. +

One can then generate invoices based on this information. +

The project field is not optional. +

8.3 Projects and Invoices

One can select the project id for line items of both AR and AP invoices. These will then be tracked against the +

One can select the project id for line items of both AR and AP invoices. These will then be tracked against the project itself. -

8.4 Reporting

8.4.1 Timecard Reporting

The Timecard Report allows one to search for timecards associated with one or more projects. One can then +

The Timecard Report allows one to search for timecards associated with one or more projects. One can then use the total time in issuing invoices (this is not automated yet). -

8.4.2 Project Transaction Reporting

The Standard or GIFI options can be used to create different reports (for example, for Canadian Tax reporting +

The Standard or GIFI options can be used to create different reports (for example, for Canadian Tax reporting purposes). -

This report brings up a summary that looks sort of like a chart of accounts. Of one clicks on the account +

This report brings up a summary that looks sort of like a chart of accounts. Of one clicks on the account numbers, one can see the transactions associated with the project. -

8.4.3 List of Projects

This provides a simple way of searching for projects to edit or modify. -

This provides a simple way of searching for projects to edit or modify. +

8.5 Possibilities for Using Projects

@@ -1850,53 +1849,53 @@ numbers, one can see the transactions associated with the project.

One can use them similar to departments for tracking work done for a variety of customers.

One can use them for customer-specific projects, such as this training.

9 Quotations and Order Management

This unit will introduce the business processes that Ledger-SMB allows. These processes are designed to +

This unit will introduce the business processes that Ledger-SMB allows. These processes are designed to allow various types of businesses to manage their orders and allow for rudimentary customer relationship management processes to be built around this software. In this section, we will introduce the work flow options that many businesses may use in their day-to-day use of the software. -

9.1 Sales Orders

Sales orders represent orders from customers that have not been delivered or shipped yet. These orders can +

Sales orders represent orders from customers that have not been delivered or shipped yet. These orders can be for work in the future, for back ordered products, or work in progress. A sales order can be generated form an AR invoice or from a quotation automatically. -

9.2 Quotations

Quotations are offers made to a customer but to which the customer has not committed to the work. +

Quotations are offers made to a customer but to which the customer has not committed to the work. Quotations can be created from Sales orders or AR Invoice automatically. -

9.3 Shipping

The Shipping module (Shipping->Shipping) allows one to ship portions or entireties of existing sales orders, +

The Shipping module (Shipping->Shipping) allows one to ship portions or entireties of existing sales orders, printing pick lists and packing slips. -

One can then generate invoices for those parts that were shipped. -

In general, one will be more likely to use these features if they have multiple warehouses that they ship +

One can then generate invoices for those parts that were shipped. +

In general, one will be more likely to use these features if they have multiple warehouses that they ship from. More likely most customers will just generate invoices from orders. -

9.4 AR Work Flow

9.4.1 Service Example

A customer contacts your firm and asks for a quote on some services. Your company would create a +

A customer contacts your firm and asks for a quote on some services. Your company would create a quotation for the job and email it to the customer or print it and mail it. Once the customer agrees to pay, one creates a sales order from the quotation. -

When the work is completed, the sales order is converted into a sales invoice and this is presented to the +

When the work is completed, the sales order is converted into a sales invoice and this is presented to the customer as a bill. -

Note that in some cases, this procedure may be shortened. If the customer places an order without +

Note that in some cases, this procedure may be shortened. If the customer places an order without asking for a quotation and is offered a verbal quote, then one might merely prepare the sales order.

@@ -1920,12 +1919,12 @@ src="LedgerSMB-manual0x.png" alt="PICT" />

9.4.2 Single Warehouse Example

A customer contacts your firm and asks for a quotation for shipping a part. You would create the quotation +

A customer contacts your firm and asks for a quotation for shipping a part. You would create the quotation and when you get confirmation, convert it to an order. Once the parts are in place you could go to shipping and ship the part. -

The billing department can then generate the invoice from the sales order based on what merchandise has +

The billing department can then generate the invoice from the sales order based on what merchandise has been shipped and mail it to the customer. -

Note that this requires that you have the part in your inventory. +

Note that this requires that you have the part in your inventory.

9.4.3 Multiple Warehouse Example

A customer contacts your firm and asks for a quotation for a number of different parts. You would create a +

A customer contacts your firm and asks for a quotation for a number of different parts. You would create a quotation and when you get confirmation, convert it to a sales order. When you go to ship the item, you would select the warehouse in the drop-down menu, and select the parts to ship. One would repeat with other warehouses until the entire order is shipped. -

Then the billing department would go to the sales order and generate the invoice. It would then be +

Then the billing department would go to the sales order and generate the invoice. It would then be mailed to the customer.

9.5 Requests for Quotation (RFQ)

A request for quotation would be a formal document one might submit to a vendor to ask for a quote +

A request for quotation would be a formal document one might submit to a vendor to ask for a quote on a product or service they might offer. These can be generated from Purchase Orders or AP Invoices. -

9.6 Purchase Orders

A purchase order is a confirmation that is issued to the vendor to order the product or service. Many +

A purchase order is a confirmation that is issued to the vendor to order the product or service. Many businesses will require a purchase order with certain terms in order to begin work on a product. These can be generated from RFQ’s or AP Invoices. -

9.7 Receiving

The Shipping->Receiving screen allows you to track the parts received from an existing purchase order. Like +

The Shipping->Receiving screen allows you to track the parts received from an existing purchase order. Like shipping, it does not post an invoice but tracks the received parts in the order. -

9.8 AP Work Flow

9.8.1 Bookkeeper entering the received items, order completed in full

Your company inquires about the price of a given good or service from another firm. You submit an RFQ to +

Your company inquires about the price of a given good or service from another firm. You submit an RFQ to the vendor, and finding that the price is reasonable, you convert it to an order, adjust the price to what they have quoted, and save it. When the goods are delivered you convert the order into an AP invoice and post it. @@ -2023,7 +2022,7 @@ src="LedgerSMB-manual3x.png" alt="PICT" />

9.8.2 Bookkeeper entering received items, order completed in part

Your company inquires about the price of a given good or service from another firm, You submit an RFQ to +

Your company inquires about the price of a given good or service from another firm, You submit an RFQ to the vendor, and finding that the price is acceptable, you convert it into an order, adjusting the price to what they have quoted, and save it. When some of the goods are received, you open up the purchase order, enter the number of parts received, convert that order into an invoice, and post it. Repeat until all parts are @@ -2049,12 +2048,12 @@ src="LedgerSMB-manual4x.png" alt="PICT" />

9.8.3 Receiving staff entering items

Your company inquires about the price of a given good or service from another firm, You submit an RFQ to +

Your company inquires about the price of a given good or service from another firm, You submit an RFQ to the vendor, and finding that the price is acceptable, you convert it into an order, adjusting the price to what they have quoted, and save it. When some or all of the goods are received, the receiving staff goes to Shipping-Receiving, locates the purchase order, and fills in the number of items received. -

The bookkeeper can then determine when all items have been received and post the invoice at that +

The bookkeeper can then determine when all items have been received and post the invoice at that time.

9.9 Generation and Consolidation

9.9.1 Generation

The Generation screen allows you to generate Purchase Orders based on sales orders. One selects the sales +

The Generation screen allows you to generate Purchase Orders based on sales orders. One selects the sales orders one wants to use, and clicks "Generate Purchase Orders." Then one selects clicks on the parts to order, adjusts the quantity if necessary, and clicks "Select Vendor." This process is repeated for every vendor required. Then the Generate Orders button is clicked. -

9.9.2 Consolidation

One can consolidate sales and/or purchase orders using this screen. For the consolidation to work you must +

One can consolidate sales and/or purchase orders using this screen. For the consolidation to work you must have more than one order associated with the relevant customer or vendor. -

9.10 Reporting

The reporting functionality in the order management is largely limited to the ability to locate purchase +

The reporting functionality in the order management is largely limited to the ability to locate purchase orders, sales orders, RFQ’s, and quotations. -

9.11 Shipping Module: Transferring Inventory between Warehouses

One can transfer inventory between warehouses if necessary by using the Shipping->Transfer Inventory +

One can transfer inventory between warehouses if necessary by using the Shipping->Transfer Inventory screen. -

10 HR

The HR module is currently limited to tracking employees for and their start and end dates. It +

The HR module is currently limited to tracking employees for and their start and end dates. It has very little other functionality. One could build payroll systems that could integrate with it however. -

11 POS

LedgerSMB 1.2 includes a number of components merged from Metatron Technology Consulting’s SL-POS. +

LedgerSMB 1.2 includes a number of components merged from Metatron Technology Consulting’s SL-POS. Although it is still not a perfect solution, it is greatly improved in both workflow and hardware support. It is suitable for retail establishments at the moment. -

11.1 Sales Screen

The sales screen looks very much like a normal invoice entry screen with a few differences. +

The sales screen looks very much like a normal invoice entry screen with a few differences.

The discount text field is not available, nor is the unit field.. @@ -2136,7 +2135,7 @@ suitable for retail establishments at the moment.
Part Groups appear at the bottom of the screen.
Alt-N moves the cursor to the next free payment line.

11.2 Possibilities for Data Entry

@@ -2145,19 +2144,19 @@ suitable for retail establishments at the moment.

One could use touch screens, though this would ideally require some custom stylesheets to make it efficient.

11.3 Hardware Support

As LedgerSMB is a web-based application, the web browser usually does not allow the page to write to +

As LedgerSMB is a web-based application, the web browser usually does not allow the page to write to arbitrary files. Therefore hardware support for pole displays, etc. is not readily possible from the application itself. LedgerSMB gets around this limitation by using an additional set of network sockets from the server to the client to control its hardware. This naturally requires that other software is also running on the client. -

Notes for specific types of hardware are as follows: -

Notes for specific types of hardware are as follows: +

Touch: Drawers: These should be attached to the printer. The contro class="pplb8t-">Barcode; Scanners: Most customers use decoded barcode scanners through a keyboard wedge interface. This allows them to scan items as if they were typing them on the keyboard.

11.4 Reports

11.4.1 Open Invoices

The POS->Open screen allows one to find any POS receipts that are not entirely paid off. -

The POS->Open screen allows one to find any POS receipts that are not entirely paid off. +

11.4.2 Receipts

The POS->Receipts screen allows one to bring up a basic record of the POS terminals. It is not sufficient for +

The POS->Receipts screen allows one to bring up a basic record of the POS terminals. It is not sufficient for closing the till, however, though it may help for reconciliation. -

The till column is the last component or octet of the terminal’s IP address. Therefore it is a good idea to +

The till column is the last component or octet of the terminal’s IP address. Therefore it is a good idea to try to avoid having IP addresses where the last octet is the same. -

All entries are grouped by date and source in this report. -

All entries are grouped by date and source in this report. +

12 General Ledger

12.1 GL Basics

The General Ledger is the heart of Ledger-SMB. Indeed, Ledger-SMB is designed to be as close as possible to +

The General Ledger is the heart of Ledger-SMB. Indeed, Ledger-SMB is designed to be as close as possible to a software equivalent of a paper-based accounting program (but with no difference between the General Ledger and General Journal). -

12.1.1 Paper-based accounting systems and the GL

In order to understand the principle of the General Ledger, one must have a basic understanding of the +

In order to understand the principle of the General Ledger, one must have a basic understanding of the general process of bookkeeping using double-entry paper-based accounting systems. -

Normally when a transaction would be recorded, it would first be recorded in the "General Journal" +

Normally when a transaction would be recorded, it would first be recorded in the "General Journal" which would contain detailed information about the transaction, notes, etc. Then the entries from the General Journal would be transcribed to the General Ledger, where one could keep closer tabs on what was going on in each account. -

In the general journal, all transactions are listed chronologically with whatever commentary is deemed +

In the general journal, all transactions are listed chronologically with whatever commentary is deemed necessary, while in the general ledger each account has its own page and transactions are recorded in a simple and terse manner. The General Journal is the first place the transaction is recorded and the General Ledger is the last. -

At the end of the accounting period, the GL transactions would be summarized into a trial balance +

At the end of the accounting period, the GL transactions would be summarized into a trial balance and this would be used for creating financial statements and closing the books at the end of the year. -

12.1.2 Double Entry Examples on Paper

Let us say that John starts his business with an initial investment of $10,000. -

This is recorded in the General Journal as follows (in this example, suppose it is page 1): +

Let us say that John starts his business with an initial investment of $10,000. +

This is recorded in the General Journal as follows (in this example, suppose it is page 1):

This would then be transcribed into two pages of the General Ledger. The first page might be the +

This would then be transcribed into two pages of the General Ledger. The first page might be the Checking Account page:

On the John Doe Capital page, we would add a similar entry: +

On the John Doe Capital page, we would add a similar entry:

@@ -2376,29 +2375,29 @@ class="hline">

12.1.3 The GL in Ledger-SMB

The paper-based accounting procedure works well when one is stuck with paper recording requirements but +

The paper-based accounting procedure works well when one is stuck with paper recording requirements but it has one serious deficiency— all of this transcribing creates an opportunity for errors. -

Relational databases relieve the need for such transcription as it is possible to store everything +

Relational databases relieve the need for such transcription as it is possible to store everything physically in a way similar to the way a General Journal is used in the paper-based systems and then present the same information in ways which are more closely related to the General Ledger book. -

This is the exact way that the General Ledger is used in Ledger-SMB. The actual data is entered and +

This is the exact way that the General Ledger is used in Ledger-SMB. The actual data is entered and stored as if it was a general journal, and then the data can be presented in any number of different ways. -

All modules of Ledger-SMB that involve COA accounts store their data in the General Ledger (it is a little +

All modules of Ledger-SMB that involve COA accounts store their data in the General Ledger (it is a little more complex than this but this is very close to the actual mechanism). -

12.2 Cash Transfer

The simplest form of GL entry in Ledger-SMB is the Cash->Transfer screen. This screen shows two +

The simplest form of GL entry in Ledger-SMB is the Cash->Transfer screen. This screen shows two transaction lines, and fields for reference, department, description, and notes. -

The field descriptions are as follows: -

The field descriptions are as follows: +

Reference: lists additional information as necessary. Project; allows you to assign this line to a project.

The credit and debit options seem to be the opposite of what one would think of concerning one’s bank account. +

The credit and debit options seem to be the opposite of what one would think of concerning one’s bank account. The reason is that your bank statement is done from the bank’s point of view. Your bank account balance is an asset to you and therefor you show it as having a debit balance, but to the bank it is money they owe you and so they show it as having a credit balance. -

Note that in this screen, when an item is updated, it will reduce the number of lines to those already filled +

Note that in this screen, when an item is updated, it will reduce the number of lines to those already filled in plus an extra line for the new line in the data entry. -

12.3 GL Transactions

The GL Transaction screen (General Ledger->Add Transaction) is identical to the Cash Transfer screen with +

The GL Transaction screen (General Ledger->Add Transaction) is identical to the Cash Transfer screen with the exception that it starts with nine lines instead of two. Otherwise, they are identical. -

Again, one must be careful with debits and credits. Often it is easy to get confused. It is generally worth +

Again, one must be careful with debits and credits. Often it is easy to get confused. It is generally worth while to go back to the principle that one tracks them with regard to their impact on the equity accounts. So expenses are credits because they debit the equity accounts, and income is a debit because it credits the retained earning equity account. -

12.4 Payroll as a GL transaction

Currently payroll must be done as a GL transaction. The attempts to create a payroll system that would ship +

Currently payroll must be done as a GL transaction. The attempts to create a payroll system that would ship with LSMB have largely stalled. -

Most customers running their businesses will have an idea of how to do this. +

Most customers running their businesses will have an idea of how to do this.

12.5 Reconciliation

To reconcile an account (say, when one would get a checking account statement), one would +

To reconcile an account (say, when one would get a checking account statement), one would go to cash/reconciliation, and check off the items that have cleared. One can then attempt to determine where any errors lie by comparing the total on the statement with the total that LSMB generates. -

This can be done for other accounts too, such as petty +

This can be done for other accounts too, such as petty cash.²

12.6 Reports

The most flexible report in Ledger-SMB is the GL report because it has access to the entire set of financial +

The most flexible report in Ledger-SMB is the GL report because it has access to the entire set of financial transactions of a business. Every invoice posted, payment made or received, etc. can be located here. -

The search criteria include: -

The search criteria include: +

Reference: Type can be used to filter results by type of account (Asset Description; can be used to filter by GL description or by customer/vendor name.

The actual format of the report looks more like what one would expect in a paper accounting system’s general +

The actual format of the report looks more like what one would expect in a paper accounting system’s general journal than a general ledger per se. A presentation of the data that is more like the paper general ledger is found in the Chart of Accounts report. -

12.6.1 GL as access to almost everything else

The GL reports can be used to do all manner of things. One can determine, for example, which AP invoice or +

The GL reports can be used to do all manner of things. One can determine, for example, which AP invoice or transaction was paid with a certain check number or which invoice by a specific customer was paid by a specific check number. -

13 Recurring Transactions

Any transaction or invoice may be repeated a number of times in regular intervals. To schedule any GL, AR, +

Any transaction or invoice may be repeated a number of times in regular intervals. To schedule any GL, AR, or AP transaction or invoice, click the schedule button. -

In general the reference number should be left blank as this will force Ledger-SMB to create a new invoice +

In general the reference number should be left blank as this will force Ledger-SMB to create a new invoice or transaction number for each iteration. The rest of the options are self-explanatory. Note that a blank number if iterations will result in no recurrences of the transaction. -

To process the recurring transactions, click on the Recurring Transactions option on the main menu select +

To process the recurring transactions, click on the Recurring Transactions option on the main menu select the ones you want to process and click "Process Transactions." -

14 Financial Statements and Reports

Financial statements and reports are a very important part of any accounting system. Accountants and +

Financial statements and reports are a very important part of any accounting system. Accountants and business people rely on these reports to determine the financial soundness of the business and its prospects for the next accounting period. -

14.1 Cash v. Accrual Basis

Financial statements, such as the Income Statement and Balance Sheet can be prepared either on a cash or +

Financial statements, such as the Income Statement and Balance Sheet can be prepared either on a cash or accrual basis. In cash-basis accounting, the income is deemed earned when the customer pays it, and the expenses are deemed incurred when the business pays them. -

There are a number of problems with cash-basis accounting from a business point of view. The most +

There are a number of problems with cash-basis accounting from a business point of view. The most serious is that one can misrepresent the wellbeing of a business by paying a large expense after a deadline. Thus cash-basis accounting does not allow one to accurately pair the income with the related expense as these are recorded at different times. If one cannot accurately pair the income with the related expense, then financial statements cannot be guaranteed to tell one much of anything about the well-being of the business. -

In accrual basis accounting, income is considered earned when the invoice is posted, and +

In accrual basis accounting, income is considered earned when the invoice is posted, and expenses are considered incurred at the time when the goods or services are delivered to the business. This way, one can pair the income made from the sale of a product with the expense incurred in bringing that product to sale. This pairing allows for greater confidence in business reporting. -

14.2 Viewing the Chart of Accounts and Transactions

The Reports–>Chart of Accounts will provide the chart of accounts along with current totals in each +

The Reports–>Chart of Accounts will provide the chart of accounts along with current totals in each account. -

If you click on an account number, you will get a screen that allows you to filter out transactions in that +

If you click on an account number, you will get a screen that allows you to filter out transactions in that account by various criteria. One can also include AR/AP, and Subtotal in the report. -

The report format is similar to that of a paper-based general ledger. -

The report format is similar to that of a paper-based general ledger. +

14.3 Trial Balance

14.3.1 The Paper-based function of a Trial Balance

In paper-based accounting systems, the accountant at the end of the year would total up the debits and +

In paper-based accounting systems, the accountant at the end of the year would total up the debits and credits in every account and transfer them onto another sheet called the trial balance. The accountant would check to determine that the total debits and credits were equal and would then transfer this information onto the financial statements. It was called a trial balance because it was the main step at which the error-detection capabilities of double-entry accounting systems were used. -

14.3.2 Running the Trial Balance Report

This report is located under Reports –>Trial Balance. One can filter out items by date, accounting period, or +

This report is located under Reports –>Trial Balance. One can filter out items by date, accounting period, or department. One can run the report by accounts or using GIFI classifications to group accounts together. -

From this report, you can click on the account number and see all transactions on the trial balance as well +

From this report, you can click on the account number and see all transactions on the trial balance as well as whether or not they have been reconciled. -

14.3.3 What if the Trial Balance doesn’t Balance?

If the trial balance does not balance, get technical support immediately. This usually means that transactions +

If the trial balance does not balance, get technical support immediately. This usually means that transactions were not entered properly. Some may have been out of balance, or some may have gone into non-existent accounts (believe it or not, Ledger-SMB does not check this latter issue). -

14.3.4 Trial Balance as a Summary of Account Activity

The trial balance offers a glance at the total activity in every account. It can provide a useful look at financial +

The trial balance offers a glance at the total activity in every account. It can provide a useful look at financial activity at a glance for the entire business. -

14.3.5 Trial Balance as a Budget Planning Tool

By filtering out departments, one can determine what a department earned and spent during a given +

By filtering out departments, one can determine what a department earned and spent during a given financial interval. This can be used in preparing budgets for the next accounting period. -

14.4 Income Statement

The Income Statement is another tool that can be used to assist with budgetary planning as well as provide +

The Income Statement is another tool that can be used to assist with budgetary planning as well as provide information on the financial health of a business. -

The report is run from Reports–>Income Statement. The report preparation screen shows the following +

The report is run from Reports–>Income Statement. The report preparation screen shows the following fields: -

Department: in Report provides various options for reporting. Accounts; allows you to run GIFI reports instead of the standard ones.

The report shows all income and expense accounts with activity during the period when the report is run, the +

The report shows all income and expense accounts with activity during the period when the report is run, the balances accrued during the period, as well as the total income and expense at the bottom of each section. The total expense is subtracted from the total income to provide the net income during the period. If there is a loss, it appears in parentheses. -

14.4.1 Uses of an Income Statement

The income statement provides a basic snapshot of the overall ability of the business to make money. It is one +

The income statement provides a basic snapshot of the overall ability of the business to make money. It is one of the basic accounting statements and is required, for example, on many SEC forms for publicly traded firms. -

Additionally, businessmen use the income statement to look at overall trends in the ability of the business +

Additionally, businessmen use the income statement to look at overall trends in the ability of the business to make money. One can compare a given month, quarter, or year with a year prior to look for trends so that one can make adjustments in order to maximize profit. -

Finally, these reports can be used to provide a look at each department’s performance and their +

Finally, these reports can be used to provide a look at each department’s performance and their ability to work within their budget. One can compare a department or project’s performance to a year prior and look for patterns that can indicate problems or opportunities that need to be addressed. -

14.5 Balance Sheet

The balance sheet is the second major accounting statement supported by Ledger-SMB. The balance sheet +

The balance sheet is the second major accounting statement supported by Ledger-SMB. The balance sheet provides a snapshot of the current financial health of the business by comparing assets, liabilities, and equity. -

In essence the balance sheet is a statement of the current state of owner equity. Traditionally, it does not +

In essence the balance sheet is a statement of the current state of owner equity. Traditionally, it does not track changes in owner equity in the same way the Statement of Owner Equity does. -

The Balance Sheet report preparation screen is much simpler than the Income Statement screen. +

The Balance Sheet report preparation screen is much simpler than the Income Statement screen. Balance sheets don’t apply to projects, but they do apply to departments. Also, unlike an income statement, a balance sheet is fixed for a specific date in time. Therefore one does not need to select a period. -

The fields in creating a balance sheet are: -

The fields in creating a balance sheet are: +

Department: in report allows you to select supplemental information on t Accounts; allows you to select between standard and GIFI reports.

The balance sheet lists all asset, liability, and equity accounts with a balance. Each category has a total listed, and +

The balance sheet lists all asset, liability, and equity accounts with a balance. Each category has a total listed, and the total of the equity and liability accounts is also listed. -

The total assets should be equal to the sum of the totals of the liability and equity accounts. +

The total assets should be equal to the sum of the totals of the liability and equity accounts. -

14.6 What if the Balance Sheet doesn’t balance?

Get technical support immediately, This may indicate that out of balance transactions were entered or that +

Get technical support immediately, This may indicate that out of balance transactions were entered or that transactions did not post properly. -

14.7 No Statement of Owner Equity?

The Statement of Owner Equity is the one accounting statement that Ledger-SMB does not support. +

The Statement of Owner Equity is the one accounting statement that Ledger-SMB does not support. However, it can be simulated by running a balance sheet at the end of the time frame in question and comparing it to the beginning. One can check this against an income statement for the period in question to verify its accuracy. The statement of owner equity is not as commonly used now as it once was. -

15 The Template System

Ledger-SMB allows most documents to be generated according to a template system. This allows financial +

Ledger-SMB allows most documents to be generated according to a template system. This allows financial statements, invoices, orders, and the like to be customized to meet the needs of most businesses. Company logos can be inserted, the format can be radically altered, one can print letters to be included with checks to vendors instead of the checks themselves, and the like. In the end, there is very little that cannot be accomplished regarding modification of these documents with the template system. -

One can define different templates for different languages, so that a customer in Spain gets a different +

One can define different templates for different languages, so that a customer in Spain gets a different invoice than a customer in Canada. -

15.1 Text Templates

The only template that uses a text-only format is the POS receipt. This example provides the simplest way to +

The only template that uses a text-only format is the POS receipt. This example provides the simplest way to understand the template system. -

The first two lines are: +

The first two lines are:
<%company align=center width=40%>
<%address align=center width=40%>
-

The first line tells Ledger-SMB to print the company name as passed to it via a variable, centered, with a +

The first line tells Ledger-SMB to print the company name as passed to it via a variable, centered, with a page width of 40 characters. The second line does the same thing with the address. -

These variables are usually passed to the invoice using form fields (hidden or otherwise) in the +

These variables are usually passed to the invoice using form fields (hidden or otherwise) in the submitting web page. The printing script, however, can disable some of these fields or add others via database lookups and the like. -

In all types of templates, variable substitution occurs between <% and %>. One can optionally specify an +

In all types of templates, variable substitution occurs between <% and %>. One can optionally specify an alignment or a width but these are really only useful in text templates. -

15.2 HTML Templates

The following templates exist in HTML format: +

The following templates exist in HTML format:

Income Statement @@ -2880,20 +2879,20 @@ alignment or a width but these are really only useful in text templates.
RFQ
Time Card

These templates can be edited by an HTML editor. However, it is generally recommended that one back up +

These templates can be edited by an HTML editor. However, it is generally recommended that one back up templates first. The reason is that some HTML editors will fully re-parse the HTML and save it back without what they see as invalid tags. Most editors, however, will save the variable substitution tags because similar tags are also used by Microsoft’s active server pages. -

Finally, some editors are known to mangle formatting, so many problems can be avoided by ensuring that +

Finally, some editors are known to mangle formatting, so many problems can be avoided by ensuring that one has a backup of the templates, especially if they have already been customized. -

15.3 LATEX Templates

The following templates, by default, are available in LAT

The following templates, by default, are available in LATEX :

RFQ
Time Card

LAT

LATEX templates allow one to generate PDF and postscript documents and print directly to a postscript-enabled printer or print software (like CUPS). -

LAT

LATEX templates can be edited using a standard text editor (like vim or emacs), or using a synchronous LATEX implementation such as LY X. -

15.3.1 What is LATEX ?

LAT

LATEX (pronounced LAY-tech) is an extension on the TEX typesetting system. It largely consists of a set of macros that allow one to focus on the structure of the document while letting the TEX is used in a large number of academic journals (including those of the American Mathematics Association). It is available at http://www.tug.org and is included in most Linux distributions. -

Like HTML, LAT

Like HTML, LATEX uses plain text documents to store the formatting information and then when the document is rendered, attempts to fit it onto a page. LATEX supports the concept of stylesheets, allowing one to separate content from format, and this feature is used in many higher-end applications, like journal publication. -

Unlike HTML, LAT

Unlike HTML, LATEX is a complete though simple programming language that allows one to redefine internals of the system for formatting purposes. -

This document is written in LAT

This document is written in LATEX. -

15.3.2 Using LY X to Edit LATEX Templates

LY X is a synchronous LAT

LY X is a synchronous LATEX editor that runs on Windows, UNIX/Linux, and Mac OS X. It requires an installed LATEX-2e implementation and can be obtained at http://www.lyx.org. Like the most common LATEX implementations, it is open source and is included with most Linux distributions. -

15.4 Customizing Logos

LAT

LATEX requires different formats of logos depending on whether the document is going to be generated as a PDF or as postscript. Postscript requires an embedded postscript graphic, while PDF requires any type of graphic other than embedded postscript. Usually one uses a PNG’s for PDF’s, though GIF’s could be used as well. The logo for a LATEX document resides in the users directory. -

HTML documents can have logos in many different formats. PNG’s are generally preferred for printing +

HTML documents can have logos in many different formats. PNG’s are generally preferred for printing reasons. The image can be stored anywhere and merely referenced in the HTML. -

Note: Always test the an invoice with images to ensure that the rest of the page format is not thrown off +

Note: Always test the an invoice with images to ensure that the rest of the page format is not thrown off by it. -

15.5 How are They Stored in the Filesystem?

The template directory ("templates" in the root Ledger-SMB install directory) contains all the root templates +

The template directory ("templates" in the root Ledger-SMB install directory) contains all the root templates used by Ledger-SMB. These follow a naming convention of COAType-templatename.ext where COAType is the type of dataset that was created when the user was created, templatename is the name of the template, and ext is either txt, html, or tex (for text, html, and LATEX respectively). -

Inside this directory are one or more subdirectories where the relevant templates have been copied as +

Inside this directory are one or more subdirectories where the relevant templates have been copied as default language templates for the user. Many users can use the same user directory (which bears the name of the Ledger-SMB username). Within this directory are more subdirectories for translated templates, one for each language created. -

15.6 Upgrade Issues

When Ledger-SMB is upgraded, the templates are not replaced. This is designed to prevent the upgrade +

When Ledger-SMB is upgraded, the templates are not replaced. This is designed to prevent the upgrade script from overwriting changes made during the course of customizing the templates. -

Occasionally, however, the data model changes in a way which can cause the templates to stop printing +

Occasionally, however, the data model changes in a way which can cause the templates to stop printing certain information. When information that was showing up before an upgrade stops showing up, one can either upgrade the templates by copying the source template over the existing one, or one can edit the template to make the change. -

16 An Introduction to the CLI

16.1 Conventions

The command-line API will be referred to as the API. -

The command-line API will be referred to as the API. +

16.2 Preliminaries

Logging into Ledger-SMB (1.2+) updates a row in the users_conf table containing your account configuration +

Logging into Ledger-SMB (1.2+) updates a row in the users_conf table containing your account configuration defaults and other information. The implication for API users of LSMB is that you must login as part of running API scripts. For security purposes, it is recommended that scripts prompt for a password rather than storing it. -

All scripts included in the documentation can also be found in the doc/samples directory. -

Consider a simple example: -

cd /usr/local/ledger-smb ./ct.pl "login=name&path=bin&password=xxxxx&action=search&db=customer" -

The cd command moves your terminal session’s current working directory into the main Ledger-SMB +

All scripts included in the documentation can also be found in the doc/samples directory. +

Consider a simple example: +

cd /usr/local/ledger-smb ./ct.pl "login=name&path=bin&password=xxxxx&action=search&db=customer" +

The cd command moves your terminal session’s current working directory into the main Ledger-SMB directory. Then the Ledger-SMB perl script ct.pl is called with one long line as an argument. The argument is really several variable=value pairs separated by ampersands (&). The value for the login variable is the username that Ledger-SMB is to use, and the value for the password variable is the plaintext password. -

To build our examples we will use a username of "clarkkent" who has a password of "lOis,lAn3". -

cd /usr/local/ledger-smb ./ct.pl "login=clarkkent&path=bin&password=lOis,lAn3&action=search&db=customer" -

If we execute these commands we will get the html for the search form for the customer database. This +

To build our examples we will use a username of "clarkkent" who has a password of "lOis,lAn3". +

cd /usr/local/ledger-smb ./ct.pl "login=clarkkent&path=bin&password=lOis,lAn3&action=search&db=customer" +

If we execute these commands we will get the html for the search form for the customer database. This result isn’t useful in itself, but it shows we are on the right track. -

16.3 First Script: lsmb01-cli-example.sh

With a working example, we can start to build reproducible routines that we can grow to do some useful +

With a working example, we can start to build reproducible routines that we can grow to do some useful work. -

This is a bash script which: -

1. sets NOW to the current working directory 2. prompts for and reads your Ledger-SMB login 3. prompts +

This is a bash script which: +

1. sets NOW to the current working directory 2. prompts for and reads your Ledger-SMB login 3. prompts for and reads (non-echoing) your Ledger-SMB password 4. changes directory to /usr/local/ledger-smb 5. constructs login and logout commands and a transaction command 6. logins into ledger-smb (in a real program, output would be checked for success or failure) 7. executes the transaction 8. logs out of ledger-smb (although this is not necessary) 9. returns to the original working directory 10. exits -

Running lsmb01-cli-example.sh produces: -

$ lsmb01-cli-example.sh -

Ledger-SMB login: clarkkent -

Ledger-SMB password: +

Running lsmb01-cli-example.sh produces: +

$ lsmb01-cli-example.sh +

Ledger-SMB login: clarkkent +

Ledger-SMB password:

@@ -3081,11 +3080,11 @@ class="verbatim">

A script like this would work well for simple batch transactions, but bash is not a very friendly language +

A script like this would work well for simple batch transactions, but bash is not a very friendly language for application programming. -

A nicer solution would be to use a language such as perl to drive the command line API. -

A nicer solution would be to use a language such as perl to drive the command line API. +

16.3.1 Script 1 (Bash)

@@ -3147,28 +3146,28 @@ class="verbatim">

exit 0

16.4 Second Script: lsmb02-cli-example.pl

Our second script is written in perl and logs you in but it still uses the API in its simplest form, that is, it +

Our second script is written in perl and logs you in but it still uses the API in its simplest form, that is, it builds commands and then executes them. This type of script can be used for more complex solutions than the simple bash script above, though it is still fairly limited. If your needs require, rather than have the script build and then execute the commands it could be written to generate a shell script which is executed by hand. -

This script begins by prompting for your Ledger-SMB login and password. Using the supplied +

This script begins by prompting for your Ledger-SMB login and password. Using the supplied values a login command is constructed and passed into the runLScmd subroutine. runLScmd changes directory to /usr/local/ledger-smb/ for the length of the subroutine. It formats the command and executes it and returns both the output and error information to the caller in a scalar. -

The script checks to see if there was an error in the login, exiting if there was. -

Next, the script reads some records which are stored in the program following the __END__ token. It +

The script checks to see if there was an error in the login, exiting if there was. +

Next, the script reads some records which are stored in the program following the __END__ token. It takes each record in turn, formats it then feeds each transaction through runLScmd and looks at the results for a string that signals success. -

Once all the transactions are processed, runLScmd is called one last time to logout and the script +

Once all the transactions are processed, runLScmd is called one last time to logout and the script exits. -

16.4.1 Script 2 (Perl)

@@ -3340,7 +3339,7 @@ class="verbatim">

@@ -3348,10 +3347,10 @@ class="verbatim">

id="x1-174000II">Technical Overview

17 Basic Architecture

Ledger-SMB is a web-based Perl program that interfaces with PostgreSQL using the relevant Perl modules. +

Ledger-SMB is a web-based Perl program that interfaces with PostgreSQL using the relevant Perl modules. The code is well partitioned, and the main operation modules are written in an object oriented way. -

17.1 The Software Stack

@@ -3372,70 +3371,70 @@ class="content">The Ledger-SMB software stack in a Typical Implementation

Ledger-SMB runs in a Perl interpreter. I do not currently know if it is possible to run it with Perl2C or +

Ledger-SMB runs in a Perl interpreter. I do not currently know if it is possible to run it with Perl2C or other language converters to run in other environments. However, except for high-capacity environments, Perl is a good language choice for this sort of program. -

Ledger-SMB used to support DB2 and Oracle as well as PostgreSQL. However, currently some of the +

Ledger-SMB used to support DB2 and Oracle as well as PostgreSQL. However, currently some of the functionality is implemented using PostgreSQL user-defined functions. These would need to be ported to other database managers in order to make the software work on these. It should not be too hard, but the fact that it has not been done yet may mean that there is no real demand for running the software under other RDBMS’s. -

One can substitute other web servers for Apache. Normally Ledger-SMB is run as a CGI program +

One can substitute other web servers for Apache. Normally Ledger-SMB is run as a CGI program but it may be possible to run it in the web server process (note that this may not be entirely thread-safe). -

The operating system can be any that supports a web server and Perl (since PostgreSQL need not run on +

The operating system can be any that supports a web server and Perl (since PostgreSQL need not run on the same system). However, there are a few issues running Ledger-SMB on Windows (most notably in trying to get Postscript documents to print properly). -

On the client side, any web-browser will work. Currently, the layout is different for Lynx (which doesn’t +

On the client side, any web-browser will work. Currently, the layout is different for Lynx (which doesn’t support frames), and the layout is not really useful under eLinks (the replacement for Lynx which does support frames). Some functionality requires Javascript to work properly, though the application is usable without these features.

17.2 Capacity Planning

Some companies may ask how scalable Ledger-SMB is. In general, it is assumed that few companies are +

Some companies may ask how scalable Ledger-SMB is. In general, it is assumed that few companies are going to have a need for a high-concurrency accounting system. However, with all the features available in Ledger-SMB, the staff that may have access to some of the application may be senior enough to make the question worthwhile. -

This question also becomes more important when companies might look at integrating Ledger-SMB with +

This question also becomes more important when companies might look at integrating Ledger-SMB with a CRM solution, online store, or other environment. This section looks at a number of the known issues and their solutions. -

17.2.1 Scalability Strategies

Ledger-SMB is a fairly standard web-based application. However, sometimes the database schema changes +

Ledger-SMB is a fairly standard web-based application. However, sometimes the database schema changes during upgrades. In these cases, it becomes impossible to use different versions of the software against the same database version safely. Ledger-SMB checks the version of the database and if the version is higher than the version of the software that is running, will refuse to run. -

Therefore although one strategy might be to run several front-end web servers with Ledger-SMB, in +

Therefore although one strategy might be to run several front-end web servers with Ledger-SMB, in reality this can be a bit of a problem. One solution is to take half of the front-end servers off-line while doing the initial upgrade, and then take the other offline to upgrade when these are brought back online. -

The database manager is less scalable in the sense that one cannot just add more database servers and +

The database manager is less scalable in the sense that one cannot just add more database servers and expect to carry on as normal. However, aside from the known issues listed below, there are few performance issues with it. If complex reports are necessary, these can be moved to a replica database (perhaps using Slony-I). -

If this solution is insufficient for database scalability, one might be able to move staff who do not need +

If this solution is insufficient for database scalability, one might be able to move staff who do not need real-time access to new entries onto a PG-Pool/Slony-I cluster where new transactions are entered on the master and other data is looked up on the replica. In certain circumstances, one can also offload a number of other queries from the master database in order to minimize the load. Ledger-SMB has very few issues in the scalability of the application. -

17.2.2 Database Maintenance

PostgreSQL uses a technique called Multi-version Concurrency Control (MVCC) to provide a snapshot of the +

PostgreSQL uses a technique called Multi-version Concurrency Control (MVCC) to provide a snapshot of the database at the beginning of a statement or transaction (depending on the transaction isolation level). When a row is updated, PostgreSQL leaves the old row in the database, and inserts a new version of that row into the table. Over time, unless those old rows are removed, performance can degrade as PostgreSQL has to search through all the old versions of the row in order to determine which one ought to be the current one. -

Due to the way the SQL statements are executed in Ledger-SMB, most inserts will also create a dead +

Due to the way the SQL statements are executed in Ledger-SMB, most inserts will also create a dead row. -

A second problem occurs in that each transaction is given a transaction id. These id’s are numbered using +

A second problem occurs in that each transaction is given a transaction id. These id’s are numbered using 32-bit integers. If the transaction id wraps around (prior to 8.1), data from transactions that appear (due to the wraparound) to be in the future suddenly becomes inaccessible. This problem was corrected in PostgreSQL 8.1, where the database will refuse to accept new transactions if the @@ -3443,263 +3442,263 @@ transaction ID gets too close to a wraparound. So while the problem is not as se application merely becomes inaccessible rather than displaying apparent data loss. Wraparound would occur after about a billion transactions between all databases running on that instance of PostgreSQL. -

Prior to 8.1, the main way to prevent both these problems was to run a periodic vacuumdb command +

Prior to 8.1, the main way to prevent both these problems was to run a periodic vacuumdb command from cron (UNIX/Linux) or the task scheduler (Windows). In 8.1 or later, autovacuum capabilities are part of the back-end and can be configured with the database manager. See the PostgreSQL documentation for treatment of these subjects. -

In general, if performance appears to be slowly degrading, one should try to run vacuumdb -z from the +

In general, if performance appears to be slowly degrading, one should try to run vacuumdb -z from the shell in order to attempt to reclaim space and provide the planner with accurate information about the size and composition of the tables. If this fails, then one can go to other methods of determining the bottleneck and what to do about it. -

17.2.3 Known issues

The PostgreSQL planner assumes a minimum page size of ten pages for a physically empty table. The +

The PostgreSQL planner assumes a minimum page size of ten pages for a physically empty table. The reasoning behind this choice is that a table could grow rapidly and one could end up with bad database performance if the planner assumes a very small table. -

However, if you end up with joins between a very large table with millions of rows and a physically +

However, if you end up with joins between a very large table with millions of rows and a physically empty table, one can end up with a very bad query plan. In this case, the planner will choose a nested loop join and run through this loop for every row in the large table. As a result, performance will suddenly drop once the large table becomes too large to effectively do index scans of the join criteria on both tables. This problem most often occurs when people have no warehouses, departments, or projects defined and are running systems with a large number of transactions (such as a point of sale environment). -

Last time I saw this problem, the server would wait for thirty seconds to display a new point of sale +

Last time I saw this problem, the server would wait for thirty seconds to display a new point of sale screen while the server CPU activity would spike to 100%. -

One solution is to define one warehouse, department, and project, and then run vacuumdb -z from the +

One solution is to define one warehouse, department, and project, and then run vacuumdb -z from the shell to force the planner to acknowledge these tables as single-row tables. The other option is to go into the source code and edit the database queries to omit unused tables. -

18 Customization Possibilities

Ledger-SMB is designed to be customized relatively easily and rapidly. In general, the source +

Ledger-SMB is designed to be customized relatively easily and rapidly. In general, the source code is well written and compartmentalized. This section covers the basic possibilities involving customization. -

18.1 Brief Guide to the Source Code

Ledger-SMB is an application with over 34000 lines of code. While it is not possible to cover the entire +

Ledger-SMB is an application with over 34000 lines of code. While it is not possible to cover the entire application here, a brief overview of the source code is in order. -

In the root of the install directory, one will find a setup.pl program, a number of other .pl programs, and a +

In the root of the install directory, one will find a setup.pl program, a number of other .pl programs, and a number of directories. The setup.pl program is used to update or install Ledger-SMB. The other .pl programs provide a basic set of services for the framework (including authentication) and then pass the work on to the data entry screen file in the bin directory. -

The bin directory contains another directory for each terminal type. The main two offered are lynx and +

The bin directory contains another directory for each terminal type. The main two offered are lynx and mozilla. Lynx would be used for web browsers that do not support frames and is ideal for a text-mode VGA terminal. Mozilla is the terminal type used for most other web browsers. The perl files within these directories provides the user interface of the software. -

The css directory in the root install directory contains CSS documents to provide various stylesheets one +

The css directory in the root install directory contains CSS documents to provide various stylesheets one can select for changing various aspects of the look and feel of the application. -

The locale directory contains translation files that Ledger-SMB uses to translate between different +

The locale directory contains translation files that Ledger-SMB uses to translate between different languages. One could add translations to these files if necessary. -

The LSMB directory is where the Perl modules reside that provide the core business logic in Ledger-SMB. +

The LSMB directory is where the Perl modules reside that provide the core business logic in Ledger-SMB. These modules provide functionality such as form handling, email capabilities, and access to the database through its at least partially object oriented API. -

Finally, the sql directory provides the database schemas and upgrade scripts. -

Finally, the sql directory provides the database schemas and upgrade scripts. +

18.2 Data Entry Screens

One can customize the data entry screens to optimize work flow, display additional information, +

One can customize the data entry screens to optimize work flow, display additional information, etc. -

18.2.1 Examples

We set up hot keys for payment lines, automatically focused the keyboard on the last partnumber field, +

We set up hot keys for payment lines, automatically focused the keyboard on the last partnumber field, removed separate print and post buttons to ensure that invoices were always printed and posted together, and removed the ability to print to the screen, and even the ability to scan items in when an invoice was received (using a portable data terminal) and import this data into Ledger-SMB. Finally we added the ability to reconcile the till online in a paperless manner. -

For another customer, we added the ability to print AR invoices in plain text format and added templates +

For another customer, we added the ability to print AR invoices in plain text format and added templates (based on the POS sales template) to do this. -

18.3 Extensions

One can add functionality to the Perl modules in the LSMB directory and often add missing functions +

One can add functionality to the Perl modules in the LSMB directory and often add missing functions easily. -

18.3.1 Examples

For one customer, we added a module to take data from a portable data terminal collected when inventory +

For one customer, we added a module to take data from a portable data terminal collected when inventory items were taken and use that to add shrinkage and loss adjustments. We also extended the parts model to add a check id flag (for alcohol sales) and added this flag to the user interface. -

For another customer, we added a complex invoice/packing slip tracking system that allowed one to +

For another customer, we added a complex invoice/packing slip tracking system that allowed one to track all the printed documents associated with an order or invoice. -

18.4 Templates

As noted before templates can be modified or extended, though sometimes this involves extending the user +

As noted before templates can be modified or extended, though sometimes this involves extending the user interface scripts. Most templates are easy enough to modify. -

18.4.1 Examples

For one customer we added text-only invoices for AR and AP transactions/Invoices and an ability to use +

For one customer we added text-only invoices for AR and AP transactions/Invoices and an ability to use Javascript in them to automatically print them on load. -

18.5 Reports

The fact that all the data is available within the database manager is a huge advantage of Ledger-SMB over +

The fact that all the data is available within the database manager is a huge advantage of Ledger-SMB over Quickbooks and the like. The rapid development of reports allows for one to easily develop reports of any sort within Ledger-SMB. -

18.5.1 Examples

For one customer, we developed a report of parts sold and received during arbitrary time frames. The report +

For one customer, we developed a report of parts sold and received during arbitrary time frames. The report allows one to go back and look up the invoices involved. -

19 Integration Possibilities

An open database system and programming API allows for many types of integration. There are some +

An open database system and programming API allows for many types of integration. There are some challenges, but in the end, one can integrate a large number of tools. -

19.1 Reporting Tools

Any reporting tool which can access the PostgreSQL database can be used with Ledger-SMB for custom +

Any reporting tool which can access the PostgreSQL database can be used with Ledger-SMB for custom reporting. These can include programs like Microsoft Access and Excel (using the ODBC drivers), PgAccess (A PostgreSQL front-end written in TCL/Tk with a similar feel to Access), Rekall, Crystal Reports, OpenOffice and more. -

19.1.1 Examples

We have created spreadsheets of the summaries of activity by day and used the ODBC driver to import these +

We have created spreadsheets of the summaries of activity by day and used the ODBC driver to import these into Excel. Excel can also read HTML tables, so one can use PostgreSQL to create an HTML table of the result and save it with a .xls extension so that Windows opens it with Excel. These could then be served via the same web server that serves Ledger-SMB. -

19.2 Line of Business Tools on PostgreSQL

Various line of business tools have been written using PostgreSQL in large part due to the fact that it is far +

Various line of business tools have been written using PostgreSQL in large part due to the fact that it is far more mature than MySQL in areas relating to data integrity enforcement, transactional processing, and the like. These tools can be integrated with Ledger-SMB in various ways. One could integrate this program with the HERMES CRM framework, for example. -

19.2.1 Known Issues

Ledger-SMB uses a single ’id’ sequence across many tables. At the same time it is expected that these tables +

Ledger-SMB uses a single ’id’ sequence across many tables. At the same time it is expected that these tables do not have identical id values in their records as they are used as a sort of pseudo-foreign key by the acc_trans table which stores the financial transaction information. -

If the integration solution does not keep this in mind, it is possible to create a situation where the account +

If the integration solution does not keep this in mind, it is possible to create a situation where the account transactions are ambiguously associated with a number of different types of financial transactions. This would lead to a large number of problems. -

19.2.2 Strategies

In general, it is advisable to run all such programs that benefit from integration in the same database but +

In general, it is advisable to run all such programs that benefit from integration in the same database but under different schemas. This allows PostgreSQL to become the main method of synchronizing the data in real time. However, sometimes this can require dumping the database, recreating the tables etc. in a different schema and importing the data back into Ledger-SMB. -

One possibility for this sort of integration is to use database triggers to replicate the data between the +

One possibility for this sort of integration is to use database triggers to replicate the data between the applications in real-time. This can avoid the main issue of duplicate id’s. One issue that can occur however relates to updates. If one updates a customer record in HERMES, for example, how do we know which record to update in Ledger-SMB? There are solutions to this problem but they do require some forethought. -

A second possibility is to use views to allow one application to present the data from the other as its own. +

A second possibility is to use views to allow one application to present the data from the other as its own. This can be cleaner regarding update issues, but it can also pose issues regarding duplicate id fields. -

19.2.3 Examples

Others have integrated L’ane POS and Ledger-SMB in order to make it work better with touch screen +

Others have integrated L’ane POS and Ledger-SMB in order to make it work better with touch screen devices. Still others have successfully integrated Ledger-SMB and Interchange. In both cases, I believe that triggers were used to perform the actual integration. -

19.3 Line of Business Tools on other RDBMS’s

Often there are requests to integrate Ledger-SMB with applications like SugarCRM, OSCommerce, and other +

Often there are requests to integrate Ledger-SMB with applications like SugarCRM, OSCommerce, and other applications running on MySQL or other database managers. This is a far more complex field and it requires a great deal more effort than integrating applications within the same database. -

19.3.1 Strategies

Real-time integration is not always possible. MySQL does not support the SQL extension SQL/MED +

Real-time integration is not always possible. MySQL does not support the SQL extension SQL/MED (Management of External Data) that supports non-MySQL data sources so it is not possible to replicate the data in real-time. Therefore one generally resorts to integrating the system using time-based updates. Replication may be somewhat error-prone unless the database manager supports triggers (first added to MySQL in 5.0) or other mechanisms to ensure that all changed records can be detected and replicated. In general, it is usually advisable to add two fields to the record– one that shows the insert time and one that shows the last update. -

Additionally, I would suggest adding additional information to the Ledger-SMB tables so that you can +

Additionally, I would suggest adding additional information to the Ledger-SMB tables so that you can track the source record from the other application in the case of an update. -

In general, one must write replication scripts that dump the information from one and add it to the other. +

In general, one must write replication scripts that dump the information from one and add it to the other. This must go both ways. -

19.3.2 Integration Products and Open Source Projects

While many people write Perl scripts to accomplish the replication, an open source project exists called +

While many people write Perl scripts to accomplish the replication, an open source project exists called DBI-Link. This package requires PL/Perl to be installed in PostgreSQL, and it allows PostgreSQL to present any data accessible via Perl’s DBI framework as PostgreSQL tables. DBI-Link can be used to allow PostgreSQL to pull the data from MySQL or other database managers. -

DBI-Link can simplify the replication process by reducing the operation to a set of SQL queries. -

DBI-Link can simplify the replication process by reducing the operation to a set of SQL queries. +

20 Customization Guide

This section is meant to provide a programmer with an understanding of the technologies enough +

This section is meant to provide a programmer with an understanding of the technologies enough information to get up to speed quickly and minimize the time spent familiarizing themselves with the software. Topics in this section are listed in order of complexity. As it appeals to a narrower audience than previous discussions of this topic, it is listed separately. -

20.1 General Information

The main framework scripts (the ar.pl, ap.pl, etc. scripts found in the root of the installation directory) handle +

The main framework scripts (the ar.pl, ap.pl, etc. scripts found in the root of the installation directory) handle such basic features as instantiating the form object, ensuring that the user is logged in, and the like. They then pass the execution off to the user interface script (usually in the bin/mozilla directory). -

Ledger-SMB in many ways may look sort of object oriented in its design, but in reality, it is far more +

Ledger-SMB in many ways may look sort of object oriented in its design, but in reality, it is far more data-driven than object oriented. The Form object is used largely as a global symbol table and also as a collection of fundamental routines for things like database access. It also breaks down the query string into sets of variables which are stored in its attribute hash table. -

In essence one can and often will store all sorts of data structures in the primary Form object. These can +

In essence one can and often will store all sorts of data structures in the primary Form object. These can include almost anything. It is not uncommon to see lists of hashes stored as attributes to a Form object. -

20.2 Customizing Templates

Templates are used to generate printed checks, invoices, receipts, and more in Ledger-SMB. Often the format +

Templates are used to generate printed checks, invoices, receipts, and more in Ledger-SMB. Often the format of these items does not fit a specific set of requirements and needs to be changed. This document will not include LATEX or HTML instruction, but will include a general introduction to editing templates. Also, this is not intended to function as a complete reference. -

Template instructions are contained in tags <?lsmb and ?>. The actual parsing is done by the +

Template instructions are contained in tags <?lsmb and ?>. The actual parsing is done by the parse_template function in LSMB/Form.pm. -

20.2.1 Page Breaks in LATEX

The first tag one will see with LAT

The first tag one will see with LATEX templates is <?lsmb pagebreak num1 num2 num3 ?>

@@ -3710,9 +3709,9 @@ class="E">EX templates is <?lsmb pagebreak nu

num2 represents lines on first page

num3 represents lines on second page.

The pagebreak block is terminated by <?lsmb end pagebreak ?>. Any text within the pagebreak block is ignored +

The pagebreak block is terminated by <?lsmb end pagebreak ?>. Any text within the pagebreak block is ignored by the template. -

20.2.2 Conditionals

@@ -3728,14 +3727,14 @@ by the template.

Lines conditionals are otherwise ignored by the parser.

Conditionals cannot be nested, but IF’s can be nested inside loops.

20.2.3 Loops

<?lsmb foreach varname ?>is used to iterate through a list of vars set by the user interface system (usually +

<?lsmb foreach varname ?>is used to iterate through a list of vars set by the user interface system (usually one of the files under bin/mozilla (or otherwise). The block is repeated for each varname in a list. Block ends with <?lsmb end varname ?> -

20.2.4 File Inclusion

@@ -3753,35 +3752,35 @@ class="E">EX templates, the input

Filenames cannot use slashes (/) or .. due to directory transversal considerations.

Files can force other files to be included, but the same file cannot be included more than once.

20.2.5 Cross-referencing and multiple passes of LATEX

In LAT

In LATEX cross-references require two passes with latex to resolve. This is because the type is set page by page and the program really doesn’t know on which page a given reference will fall. This becomes an even larger issue where floats are concerned as they can move between pages for formatting reasons. -

In rare cases, cross-references may point at incorrect pages even with two passes (if the inclusion of the +

In rare cases, cross-references may point at incorrect pages even with two passes (if the inclusion of the cross-reference data moves the object to another page). In this case you will need to use three passes of LATEX in order to have accurate references. -

Ledger-SMB as of the time of this writing (2.6.8) only makes one pass at the LAT

Ledger-SMB as of the time of this writing (2.6.8) only makes one pass at the LATEX file. To force it to make more than one pass, open Form.pm with your favorite text editor. Look for the line: -

system("latex –interaction=nonstopmode $self->

system("latex –interaction=nonstopmode $self->{ tmpfile} > $ self->{ tmpfile} .err"); -

Duplicate this line for two passes, or add two copies if you need three passes. -

Duplicate this line for two passes, or add two copies if you need three passes. +

20.2.6 Variable Substitution

The following format is used for variable substitution: +

The following format is used for variable substitution:

<?lsmb varname options ?>Options are one or more (whitespace separated) of: @@ -3794,52 +3793,52 @@ class="cmsy-10">} .err");

20.3 Customizing Forms

Data entry forms and other user interface pieces are in the bin directory. In Ledger-SMB 1.0.0 and later, +

Data entry forms and other user interface pieces are in the bin directory. In Ledger-SMB 1.0.0 and later, symlinks are not generally used. -

Each module is identified with a two letter combination: ar, ap, cp, etc. These combinations are generally +

Each module is identified with a two letter combination: ar, ap, cp, etc. These combinations are generally explained in the comment headers on each file. -

Execution in these files begins with the function designated by the form->

Execution in these files begins with the function designated by the form->{action} variable. This variable is usually derived from configuration parameters in the menu.ini or the name of the button that was clicked on to submit the previous page. Due to localization requirements, the following process is used to determine the appropriate action taken: -

The $locale->getsub routine is called. This routine checks the locale package to determine if the value +

The $locale->getsub routine is called. This routine checks the locale package to determine if the value needs to be translated back into an appropriate LSMB function. If not, the variable is lower-cased, and all spaces are converted into underscores. -

In general there is no substitute for reading the code to understand how this can be customized and how +

In general there is no substitute for reading the code to understand how this can be customized and how one might go about doing this. -

20.4 Customizing Modules

The Perl Modules (.pm files) in the LedgerSMB directory contain the main business logic of the application +

The Perl Modules (.pm files) in the LedgerSMB directory contain the main business logic of the application including all database access. Most of the modules are relatively easy to follow, but the code quality leaves something to be desired. The API calls themselves are likely to be replaced in the future, so work on documenting API calls is now focused solely on those calls that are considered to be stable. At the moment, the best place to request information on the API’s is on the Developmers’ Email List (ledger-smb-devel@lists.sourceforge.net). -

Many of these modules have a fair bit of dormant code in them which was written for forthcoming +

Many of these modules have a fair bit of dormant code in them which was written for forthcoming features, such as payroll and bills of materials. -

One can add a new module through the normal means and connect it to other existing modules. -

One can add a new module through the normal means and connect it to other existing modules. +

20.4.1 Database Access

The $form object provides two methods for accessing the database. The $form->dbconnect(%myconfig) method +

The $form object provides two methods for accessing the database. The $form->dbconnect(%myconfig) method commits each individual statement as its own transaction. The $form->dbconnect_noauto(%myconfig) method requires a manual commit. Both these functions are thin wrappers around the standard Perl DBI operations. -

20.5 CLI Examples

Louis Moore contributed some SQL-Ledger CLI examples that still work for LedgerSMB. You can find his page at +

Louis Moore contributed some SQL-Ledger CLI examples that still work for LedgerSMB. You can find his page at http://www.sql-ledger.org/cgi-bin/nav.pl?page=contrib/moore.html&title=Louis%20B.%20Moore. @@ -3849,40 +3848,40 @@ href="http://www.sql-ledger.org/cgi-bin/nav.pl?page=contrib/moore.html&title=Lou id="x1-214000III">Appendix

A Where to Go for More Information

There are a couple of relevant sources of information on Ledger-SMB in particular. -

The most important resources are the LedgerSMB web site (

There are a couple of relevant sources of information on Ledger-SMB in particular. +

The most important resources are the LedgerSMB web site (http://www.ledgersmb.org) and the email lists found at our Sourceforge site. -

In addition, it is generally recommended that the main bookkeeper of a company using Ledger-SMB +

In addition, it is generally recommended that the main bookkeeper of a company using Ledger-SMB work through at least one accounting textbook. Which textbook is not as important as the fact that a textbook is used. -

B Quick Tips

B.1 Understanding Shipping Addresses and Carriers

Each customer can have a default shipping address. This address is displayed prominantly in the add new +

Each customer can have a default shipping address. This address is displayed prominantly in the add new customer screen. To change the shipping address for a single order, one can use the ship to button at the bottom of the quote, order, or invoice screen. -

The carrier can be noted in the Ship Via field. However, this is a freeform field and is largely used as +

The carrier can be noted in the Ship Via field. However, this is a freeform field and is largely used as commentary (or instructions for the shipping crew). -

B.2 Handling bad debts

In the event that a customer’s check bounces or a collection requirement is made, one can flag the customer’s +

In the event that a customer’s check bounces or a collection requirement is made, one can flag the customer’s account by setting the credit limit to a negative number. -

If a debt needs to be written off, one can either use the allowance method (by writing it against the contra +

If a debt needs to be written off, one can either use the allowance method (by writing it against the contra asset account of "Allowance for Bad Debts" or using the direct writeoff method where it is posted as an expense. -

C Step by Steps for Vertical Markets

C.1 Common Installation Errors

@@ -3896,20 +3895,20 @@ expense.

When the chart of accounts (COA) is altered such that it is no longer set up with appropriate items, you can make it impossible to define goods and services properly. In general, until you are familiar with the software, it is best to rename and add accounts rather than deleting them.

C.2 Retail With Light Manufacturing

For purposes of this example we will use a business that assembles computers and sells them on a retail +

For purposes of this example we will use a business that assembles computers and sells them on a retail store. -

Install Ledger-SMB.
Set preferences, and customize chart of accounts. -
+
1. Before customizing the COA it is suggested that you consult an accountant.
@@ -3988,19 +3987,19 @@ class="cmmi-10">>payment. Fill out approrpiate fields and click
One can use the requirements report to help determine what parts need to be ordered though one cannot generate PO’s directly from this report.

Note, the needs of Ledger-SMB are mostly useful for light manufacturing operations (assembling +

Note, the needs of Ledger-SMB are mostly useful for light manufacturing operations (assembling computers, for example). More manufacturing capabilities are expected to be released in the next version. -

A custom assembly is a bit difficult to make. One must add the assembly prior to invoice (this is not true +

A custom assembly is a bit difficult to make. One must add the assembly prior to invoice (this is not true of goods and services). If the assembly is based on a different assembly but may cost more (due to non-standard parts) you can load the old assembly using Goods and Services->Reports->Assemblies and then make necessary changes (including to the SKU/Partnumber) and save it as new. -

Then one can add it to the invoice. -

Then one can add it to the invoice. +

D Glossary

BIC

is Cost of Goods Sold. When an item is sold, then the expens class="pplb8t-">Credit

: A logical transactional unit in double entry accounting. It is the opposite of a debit. Credits affect different account types as follows: -

Equity

: Credits are used to apply adjustments at the end of accoun class="pplb8t-">Debit

: A logical transactional unit in double entry accounting systems. It is the opposite of a credit. Debits affect different account types as follows: -

Equity