- users - lists.freelock.com

LedgerSMB 1.5.16 released
by Erik Huelsmann 28 Jan '18

28 Jan '18

The LedgerSMB development team is happy to announce yet another new version of its open source ERP and accounting application. The trial period of the 1.5-slim Docker image has been extended by one more release (due to practical reasons). This release contains the following fixes and improvements: Changelog for 1.5.16 * Properly compute the last cleared balance on reconciliation (Yves L, #3405) * Fix regression reports not showing (PDF, etc) download links (Erik H, #3408) * Fix typo in SQL Ledger upgrade code (Erik H, #3409) * Add French Chart of Accounts (Yves L) * Lift requirement to enter sensitive private data when creating users (Erik H) * Fix absolute [New] link on order, AR and AP pages (Erik H) * Support non-root hosting by using relative '/' to 'login.pl' redirect (Erik H) Erik H is Erik Huelsmann Yves L is Yves Lavoie For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.5.16/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.5.16 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.5.16 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.5.16 These are the sha256 checksums of the uploaded files: 3b878c8430267b3d1c7ab1f4eee3f16c36b110047a7a67f6574351a62fee032a ledgersmb-1.5.16.tar.gz 485f405566556892700ca09cad4dd3fcea2e07b9a9bb65a1cec737e6b6bb744a ledgersmb-1.5.16.tar.gz.asc

1 0

Useful sql selects - at least for me :-)
by bill Ott 26 Jan '18

26 Jan '18

As tax time approaches, I thought I'd share two sql select scripts that I have found useful. The first one gets all of the email addresses that were current during the year (for sending out W-9 forms, for example) It works as written through January of the next year. If you use it in February, you'll need to modify the "now()-'31d'". it runs on LSMB 1.5 *select distinct b.contact from ar a, eca_to_contact b where (date_trunc('year',a.transdate)) = (date_trunc('year',now()-'31d'::interval)) and a.entity_credit_account = b.credit_id and b.contact_class_id>14 order by b.contact;* The second get all of the email addresses that were current in the prior month (for sending out "happy New Years" to your tenants) *select distinct b.contact from ar a, eca_to_contact b where (date_trunc('month',a.transdate)) = (date_trunc('month',now()-'31d'::interval)) and a.entity_credit_account = b.credit_id and b.contact_class_id>14 order by b.contact;** * Hope you find them useful. If you make improvements, please share. -- Regards, Bill Ott Home: 919-363-0031 Cell: 919-434-7589 Email: Mailto:billott@theotts.org Website: http://www.theotts.org Profile: http://www.linkedin.com/in/wbott

1 0

Deleting Transaction
by Angelene Jamias 18 Jan '18

18 Jan '18

Hi Ledger SMB Team, How to make 0% of all the transaction in the system like vendors, customer, and other transaction ? because were going to make an system migration in Ledger SMB Your reply is highly appreciated. Angelene Jamias IT Programmer

4 4

Unable to use admin.pl
by Louis 12 Jan '18

12 Jan '18

I'm finally ready to move to the 1.5 series. To beging the migration, I started by going to http://localhost/ledgersmb/admin.pl, logged in with my DB credentials and got: Action Not Defined: __default at /usr/local/ledgersmb/lsmb-request.pl line 115, line 1. dbversion: 1.4.42, company: my_company It has been a while, since I used admin, have I forgotten something important, like, does it use a different password than my db credentials? In other words, help! Louis

4 4

Release of ledgersmb-1.5 v1.5.15-1
by Robert J. Clay 10 Jan '18

10 Jan '18

An initial version of the Debian package of ledgersmb-1.5 for version 1.5.15-1 has been released and uploaded to our apt package repository for 'main'. It has also been uploaded to our PPA[2], for 'artful' (v17.10) as well as 'xenial (v16.04) and 'bionic (which will be v18.04); but due to an issue with the build farm at launchpad.net, they are not yet available and it is unclear when they will be. The packages at both our apt package repository and our PPA: ledgersmb-1.5 ledgersmb-1.5-apache ledgersmb-1.5-lighttpd ledgersmb-1.5-nginx ledgersmb-1.5-varnish -- Robert J. Clay rjclay(a)gmail.com, jame(a)rocasa.us GPG ID: 2448 3AE0 874D 8696 6DCD ECF4 198C AB6F 43B7 EA9A. [1] https://apt.ledgersmb.org/ [2] https://launchpad.net/~ledgersmb/+archive/ubuntu/main/+packages -- Robert J. Clay rjclay(a)gmail.com

1 0

LedgerSMB 1.5.15 released
by Erik Huelsmann 07 Jan '18

07 Jan '18

The LedgerSMB development team is happy to announce yet another new version of its open source ERP and accounting application. As of this release, we're publishing a docker image based on the debian *-slim images, which reduces the Docker Hub reported size from 220MB (regular 1.5 image) to 150MB (slim image). When we don't get any negative feedback regarding the slim image, the next release will be based on that. This release contains the following fixes and improvements: Changelog for 1.5.15 * Generate access logs on standard output by default (Erik H) * Fix cli scripts; block running as root in PSGI instead of Sysconfig (Erik H) * Remove our moving out of SourceForge notice from the welcome page (Erik H) * Fix zero-value depreciations from blocking later depreciations (Chris T) * Be explicit about which Perl::Critic policies to apply in tests (Nick P) * Check for file errors when blacklist test (Nick P) * Make checks work (out of the box) with our Docker dev images (Nick P) Chris T is Chris Travers Erik H is Erik Huelsmann Nick P is Nick Prater For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.5.15/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.5.15 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.5.15 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.5.15 Or pulled from Docker Hub, for the slim (150MB) image using $ docker pull ledgersmb/ledgersmb:1.5-slim These are the sha256 checksums of the uploaded files: 5555f5f894e9ecae11ce2ff93bd7ff557ce1d0952336781f6c34758992f557e3 ledgersmb-1.5.15.tar.gz 7693f4b178bc53010cc00190b03d33c84d9d0362aa24d678682c2ea1c40a0d34 ledgersmb-1.5.15.tar.gz.asc

1 0

Release of ledgersmb-1.5 v1.5.14-1
by Robert J. Clay 14 Dec '17

14 Dec '17

An initial version of the debian package for ledgersmb-1.5 for version 1.5.14-1 has been released and uploaded to our apt package repository for 'main' in stretch[1].. It has also been uploaded to our PPA[2], for 'artful' (v17.10) as well as 'xenial (v16.04). (The debian source packages are available as well.) Note also that an issue installing from the PPA for Xenial has been resolved, but still if anyone has any issues please let us know. The packages at both our apt package repository and our PPA: ledgersmb-1.5 ledgersmb-1.5-apache ledgersmb-1.5-lighttpd ledgersmb-1.5-nginx ledgersmb-1.5-varnish -- Robert J. Clay rjclay(a)gmail.com, jame(a)rocasa.us GPG ID: 2448 3AE0 874D 8696 6DCD ECF4 198C AB6F 43B7 EA9A. [1] https://apt.ledgersmb.org/ [2] https://launchpad.net/~ledgersmb/+archive/ubuntu/main/+packages

1 0

LedgerSMB 1.5.14 released
by Erik Huelsmann 08 Dec '17

08 Dec '17

The LedgerSMB development team is happy to announce yet another new version of its open source ERP and accounting application. This release contains the following fixes and improvements: Changelog for 1.5.14 * Post (instead of save) transaction on depreciation approval (Erik H) * Fix role prefix set on copied databases from setup.pl (Erik H, #3219) * Fix argument names due to move to PGObject::Util::DBAdmin (Erik H) * Fix posting of vendor invoice fails with vendor-price in parts (Erik H, #3081) * Fix example Apache config file's SSLRequireSSL directive (Erik H, #3272) * Fix invoice shows fewer $decimalplaces than configured (Erik H, #3271) * Fix upgrade code using db transactions incorrectly (Erik H, #3289) * Improve 'in progress' feedback by fading submitted content (Erik H, #3283) * Add visual feedback to form input validation in setup.pl (Erik H) * Implement checks for correct loading of sql/modules/ files (Erik H) * Correct Roles.sql and PriceMatrix.sql loading errors (Erik H) * Fix 'uninitialized variable' warnings on database creation (Erik H, #3266) * Find part number on invoice/order by substring; was prefix (Erik H, #3266) * Find part description on invoice/order by substring; was 'full text' (Erik H) * Change part search on invoice/order to be case insensitive (Erik H, #3266) Erik H is Erik Huelsmann For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.5.14/README.md The release can be downloaded from our download site at http://download.ledgersmb.org///1.5.14 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.5.14 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.5.14 These are the sha256 checksums of the uploaded files: 90ee3e1847c53d3fbc12da99510a458c38ed5b25b4d87a6f2f598fc0c7b4ffaf ledgersmb-1.5.14.tar.gz 6f9f0f0302f92bcd83bf6a6c12e5d5eef593650d61ced8150c6016f5c6ed16f4 ledgersmb-1.5.14.tar.gz.asc

1 0

Release of ledgersmb-1.5 v1.5.13-2
by Robert J. Clay 16 Nov '17

16 Nov '17

An initial version of the ledgersmb-1.5 debian package for version 1.5.13-2 has been released and uploaded to our apt package repository for 'main' in stretch[1] as well as to our PPA[2], for 'artful' (v17.10) as well as 'xenial (v16.04). (The Debian source packages are available as well.) This new version includes the ledgersmb-1.5-apache, ledgersmb-1.5-lighttpd, & ledgersmb-1.5-varnish packages to go along with the existing ledgersmb-1.5-nginx package. Like the latter, they're dependant on the ledgersmb-1.5 package they were built with, for which they are an enhancement. Note that the installs do not attempt to get the proxy fully operational as they just get the proxy app installed if it isn't already along with installing (and/or providing an example of) a configuration file to use; which needs to be edited as neccessary, enabled, and the app restarted in order for it to be used. ledgersmb-1.5 : financial accounting and ERP program (Perl/SQL backend) ledgersmb-1.5-apache : web proxy via Apache ledgersmb-1.5-lighttpd : web proxy via lighttpd ledgersmb-1.5-nginx : web proxy via Nginx ledgersmb-1.5-varnish : web proxy via varnish -- Robert J. Clay rjclay(a)gmail.com, jame(a)rocasa.us GPG ID: 2448 3AE0 874D 8696 6DCD ECF4 198C AB6F 43B7 EA9A [1] https://apt.ledgersmb.org/ [2] https://launchpad.net/~ledgersmb/+archive/ubuntu/main/+packages

1 0

Release of ledgersmb-1.5 v1.5.13-1
by Robert J. Clay 01 Nov '17

01 Nov '17

An initial version of the ledgersmb-1.5 debian package for version 1.5.13-1 has been released and uploaded to our apt package repository for 'main' in Debian v9 (Stretch). It has also been uploaded to our PPA, for 'artful' (Ubuntu v17.10). (The Debian source packages are available as well.) At our apt package repository[1]: ledgersmb-1.5_1.5.13-1_all.deb ledgersmb-1.5-nginx_1.5.13-1_all.deb At our PPA[2]: ledgersmb-1.5_1.5.13-1~ubuntu17.11.1_all.deb ledgersmb-1.5-nginx_1.5.13-1~ubuntu17.11.1_all.deb -- Robert J. Clay rjclay(a)gmail.com, jame(a)rocasa.us GPG ID: 2448 3AE0 874D 8696 6DCD ECF4 198C AB6F 43B7 EA9A [1] https://apt.ledgersmb.org/ [2] https://launchpad.net/~ledgersmb/+archive/ubuntu/main/+package

1 0