LedgerSMB 1.3.25 released

The LedgerSMB team is pleased to announce the release of LedgerSMB 1.3.25. With this release we mostly have focused on cosmetic changes for the software, thus reducing the sorts of user interface issues that are likely to cause minor headaches for users of the software.

There are, however, three significant issues that have been corrected in this release which make an upgrade recommended for everyone:

1: In previous versions, term of payment on sales orders and purchase orders were not properly respected.

LedgerSMB 1.3.24 released, FCGI and PSGI support

The LedgerSMB development team is proud to release 1.3.24. This release contains a fairly large number of polishing bug-fixes, but also important Plack-related fixes for folks wanting to use LedgerSMB in FCGI and PSGI environments. These fixes ensure that LedgerSMB can be run caching some of the dependencies and thus will be far more responsive than when run as a simple CGI application.

Run SQL scripts


psql [database name]then
 \i /usr/share/ledgersmb/sql/upgrade/1.3-1.2.sqlor
psql [dbname] < /usr/share/ledgersmb/sql/upgrade/1.3-1.2.sql

Select the database version

SELECT * FROM defaults WHERE setting_key = 'version';

Select the default settings

The Defaults settings ( System/Defaults)
select * from defaults order by setting_key;

Select all parts in orders

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;

Grant permission to manage users (on a terminal)

GRANT lsmb_"your company"__users_manage TO "your username";

List available user roles (access types)

SELECT * FROM lsmb_roles;

Show all users in a company

select * from USERS;

Change expire time on users

Change expire time on users, so they can log in and change password when changing through the web interface is no longer an option:

ALTER USER 'myusername' WITH VALID UNTIL '2011-11-09';

Pages

Subscribe to LedgerSMB RSS