GRANT lsmb_"your company"__users_manage TO "your username";
SELECT * FROM lsmb_roles;
select * from 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';
LedgerSMB 1.3.23 has been released. This release includes a number of bugfixes, some of which affect the ability to deploy LedgerSMB in new environments. Most of these bugfixes are relatively minor but they do impact upgrades from 1.2.x for some users. Additionally most of the changes are ones which allow us to present a more polished product to the user.
This also corrects some i18n issues and a few other issues. The complete changelog is below.
The simple one:
Sales order: Customer wants to buy something.
Sales invoice: Customer owes for goods and services delivered.
Business-flow-wise, typically you take an order before everything is done necessary for the transaction to hit the books, and convert it to an invoice when everything that has been done for the income to be realized has happened. This typically means:
1) Goods or services are delivered
2) Any approval/error checking the business requires has happened
NP Broadcast Limited is a UK-registered Limited Company with a yearly turnover of approximately GBP 150,000, VAT registered with 2 LedgerSMB users. We are mainly a services company providing studio and outside broadcast engineering support to broadcasters.
[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.
Q: This particular merchant runs Windows. I don't think they have a pole display, though I can check. Ideally, it would be great to accommodate, with or without pole display. If it runs better on Linux, going forward I would propose Linux workstations for new merchants.
Ok. Let's first explain what the problems we have to solve are, then discuss the solutions that are bundled.
We have released LedgerSMB 1.3.22 in response to significant installation issues with new databases under 1.3.21. If you are planning on setting up additional companies, you should probably upgrade.
This release also corrects an issue with midsized databases where certain screens are slow. This was caused by the selection for all years being slow due to a missing index. If the AR/AP transaction screens are very slow, try upgrading here.
The complete changelog is below.