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.

Riverbend Community Math Center - Dean Serenevy

Submitted by ehu on Fri, 06/29/2012 - 08:40

We are a US not-for-profit (http://riverbendmath.org/) using SQL-Ledger and LedgerSMB since 2006 (I'm not sure exactly when we made the switch). We are a small organization: ~15 part-time employees; ~$150,000 annual revenues; 2 users of the ledger. We are still using 1.2.x because my trial transition to 1.3.x did not work out as smoothly as I had hoped. Thus, I have put the transition on hold until I can give it a few days attention. As an organization we believe in and use open source software almost entirely. 

How do I migrate from SQL-Ledger?

Submitted by Anonymous (not verified) on Sun, 03/25/2012 - 01:59

A lot of people are wondering how to manage their migration to LedgerSMB from SQL-Ledger. While there is no one simple answer that will suit everyone's situation, there is some general advice.

First thing to know is - you are among friends. LedgerSMB is built on a community of people who want to see the software and it's users succeed. Information is freely shared, and as long as you are prepared to have a go at helping yourself, we are happy to jump right in and help you do that!

We now have a mailing list, whether you are actively working on migrating to LedgerSMB or even if you are staying with SQL-Ledger for now and want some friendly community support, join up the User List to get SQL-Ledger to LedgerSMB migration help

The best course of action depends on your situation:

How to clone database with no financial transactions?

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

Copy db :
In psql or your sql client:

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.

How to add a barcode for a part?

Submitted by Anonymous (not verified) on Wed, 11/09/2011 - 04:31

Sql ledger has the option to add a barcode to a part.

In 1.4, you will be able to add a barcode per make/model record.

How are barcodes added when using LedgerSMB?

Sort term solution:
It's not optimal for a UPC management but it solves the immediate problem:

Add a space separated list with the barcodes to the partnumber field

The partnumber is the "Number" filed on the same line as "Description" in the "Add Part" page.
And yes, "space separated list" works in the POS interface. (If you scan one of the codes in the space separated list )

Does LedgerSMB support my country's laws?

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

We don't know enough about the ideosyncracies with your laws to evaluate that. But quite frankly Free Software sometimes poses an issue with local regulation. If you go with LedgerSMB, I'd recommend working with us to detail any shortcomings and get those resolved.

You can help us to make a list over "X country" laws and LedgerSMB shortcomings according your countrys law.

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.