Select all parts in orders

Submitted by ehu on Fri, 11/09/2012 - 13:25

All parts in order, from '2012-04-21' and '2012-04-22':

select p.partnumber, count(*), sum(qty) from orderitems o join parts p on p.id = o.parts_id where trans_id in (select id from oe where not closed and transdate between '2012-04-21' and '2012-04-22') group by p.partnumber;

How do the templates work? [PDF, PS, Latex]

Submitted by hasorli on Sat, 08/18/2012 - 11:20
How the LaTeX templates work and what is usually needed to get them up and working.

[work in progess...]
The PDF and PS invoices are generated using a program called LaTeX which handles the layout and typesetting. The actual LaTeX files are creating using Template Toolkit with extensions for LaTeX. These extensions are in the Template::Latex package available from CPAN. The software then generates a LaTeX file which is then processed to create a PDF or PS.

Is LedgersSMB free software?

Submitted by Anonymous (not verified) on Tue, 11/01/2011 - 02:47

Yes, its open source. The tools we use (Perl, PostsgreSQL, Apache ++) are also open source.

Open source means that the source code of the software is available for free to everyone and you can modify the code and distribute it yourself. https://en.wikipedia.org/wiki/Open_source

Look for a place to contribute. This means not only programming, but also documentation, theme design, art work, or architectural design.

Can VAT be automatically be split off into the required VAT accounts?

Submitted by Anonymous (not verified) on Tue, 11/01/2011 - 02:05

Short answer: Yes

LedgerSMB can tie product sales to a tax class so that VAT can automatically be split off into the required VAT accounts on a sale, and when cancelling an invoice, automatically perform the reverse bookings.

Each product can be 'attached' to an account and the associated % will be applied automatically.

How do I get admin.pl to work? (./Build test errors)

Submitted by Anonymous (not verified) on Mon, 11/02/2009 - 06:46

This content is outdated and kept here for reference only!

(admin.pl is replaced with setup.pl in LedgerSMB v. 1.3.x and upwards)

I am trying to install ledgerSMB on SuSE 11.1 and have followed the INSTALL and README documents to do so, and have also installed all dependencies.

When I get to the following instruction I get some errors.

$ ./Build test

The errors are seen in the last few lines of output following the instruction. I list them below. Note that prior to these last few lines are many lines starting with "BEGIN failed--compilation aborted ..."

Does ledgersmb support SSL connection ?

Submitted by Chris Travers on Thu, 04/03/2008 - 20:01

Q: How could I set it up ledgersmb to support SSL connection?

SSL support on Apache is handled by configuring Apache. For having LedgerSMB connect to PostgreSQL using SSL, you can set the PGSSLMODE environment variable to 'require' in the ledgersmb.conf. Note that by default, LedgerSMB will try to connect to PostgreSQL via SSL and fall back to unsecured connections if this is not available.

We highly recommend using SSL for any access to LedgerSMB over the network.

How do I account for Depreciation in LedgerSMB?

Submitted by Chris Travers on Wed, 04/25/2007 - 05:24

This content is outdated and kept here for reference only!

NOTE: LedgerSMB has a Fixed assets module as of 1.3. The FAQ below is out-dated.

LedgerSMB does not have a built-in assett tracking / depreciation feature. Depreciation can be managed manually using General Ledger Transactions. You should probably confirm this with your accountant, but the basic procedure (kindly suggested by Tony Fraser) is, assuming a computer asset over 5 years: