1.0

Select all parts in orders

Member for

4 years 5 months
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]

Member for

4 years 5 months
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.

How to clone database with no financial transactions?

Member for

1 month 3 weeks
Submitted by Anonymous (not verified) on Wed, 11/16/2011 - 18:07

Copy db :
In psql or your sql client:
CREATE DATABASE my_newdb WITH TEMPLATE my_old_db;

Note this will clone everything.
If you want to get rid of the transactions, you will need to delete everything in the acc_trans, ar, ap, and gl tables.

Also if goods and services are used, delete from invoice and inventory as well, and if wishing to clear out all orders, delete from
orderitems and oe.

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

Member for

1 month 3 weeks
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)

Member for

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

(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 ..."