- users - lists.freelock.com

LedgerSMB 1.7.26 released
by Erik Huelsmann 31 Jan '21

31 Jan '21

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.7.26 * Disable the broken-on-orders Schedule button on orders (#5295) * Fix several LedgerSMB 1.3 migration issues * Fix dates on weekly-entry timecards (#5336) * Fix descending sort order on reports can't be reversed (#5298) * Fix individual batch approval lists all batches, not unapproved ones (#4971) * Fix for #4854 (HTML misalignment, v1.7.19) adds more misalignment (#5298) For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.7.26/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.7.26 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.7.26 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.7.26 These are the sha256 checksums of the uploaded files: 92ce5be39bf1d96ff28a704d843c079192461070019e99bc31fae68ffe75d647 ledgersmb-1.7.26.tar.gz 5082dee5eaf0f38b966060c01684fabf1c82e0c0900056ddd684c26f8597eab4 ledgersmb-1.7.26.tar.gz.asc

1 0

An old user back again with a Q for a friend
by phil＠pricom.com.au 01 Jan '21

01 Jan '21

People, I used LSMB briefly many years ago before my IT work evolved into having one full-time client - and then I retired. Now I have a friend who might be interested in LSMB. I know data can be exported as CSV but have people written their own custom export facilities for producing custom formats for their accountants to easily import / digest? - my preference would be to write a Ruby script to do something like this. We are in Australia BTW so any comments re LSMB and Australian tax forms etc and multi-currency stuff is also appreciated! Regards, Phil.

3 2

Best Digital Marketing Company in Australia
by thebpogroup344＠gmail.com 29 Dec '20

29 Dec '20

The BPO Group is the Digital marketing Agency for more than 10 years now. We are digital Marketing Corporation with expertise in Search Engine Optimization (SEO), Social Media Management (SMO) and Content Writing. We also providing consultancy to several businesses. We are on a mission to make online SEO, advertising, social media marketing, paid promotion, email marketing, creative content marketing, SEO, web analytics, and more. View: https://thebpogroup.com

2 1

LedgerSMB 1.8.9 released
by Erik Huelsmann 26 Dec '20

26 Dec '20

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.8.9 * Fix SQL error thrown when partially invoicing an order * Fix incorrect totals in single payment screen on FX payments (#5223) * Limit 'Class' drop-down on Accounts tab to supported types only (#5216) * Fix regression deleting draft invoices/transactions with payments (#5207) * Fix empty columns when posting a payment batch (#5192) * Hide 'Payment Type' selector when drop-down empty (#5191) For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.8.9/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.8.9 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.8.9 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.8.9 These are the sha256 checksums of the uploaded files: 7c482be66159c71dfa6e4257db318590df9cf40c780c966be60829f59b635d39 ledgersmb-1.8.9.tar.gz 9691288df0091655944af8d2475c3c06e00772afdf2baddf47061eab61642f92 ledgersmb-1.8.9.tar.gz.asc

1 0

LedgerSMB community overview 2020
by Erik Huelsmann 22 Dec '20

22 Dec '20

Hi, As the year-end approaches, it's time to provide an overview of what our community has achieved over the past year. At the end of last year, I wished everybody a healthy and prosperous 2020. The year has turned out to be a big challenge and I hope this overview reaches you in a health as good as (or better than) last year's. Where many open source communities seem to have been negatively affected by the circumstances this year, core project seems to have held up very well and actually done better than last year. == Community interest == Although the number of hits on the website has declined steadily over the years, we're seeing the bounce rate decline (steadily) as well, in combination with an increase in the average time spent on the site and the average number of actions on the site. It seems our site increases in relevance to the visitors which we *are* getting. In prior years I wrote how a decrease in website traffic might not be an indication of loss of interest as more and more users are converting to mobile web-experiences. Traffic on the mailing lists was also very low this year. From the fact that during the year, we've also seen the number of Stars and Forks on GitHub slowly but steadily increase (Stars went up from 158 in February to 207 today), we can conclude that there is still interest in the project, however, the broader community didn't have much time to engage with the project this year -- as other volunteer-driven projects are experiencing this year. == Releases == With the release of 1.8.0 on 4 September 4 2020, we realized our goal to release 1.8 in the second half of the year, around a year after 1.7. We were even able to reduce the release cycle *below 1 year*! This way, our target of releasing around the middle of the year, in order for the software to mature well before year-end (when most companies close their books). Despite the short release cycle, we were able to include a sizeable list of new functionalities, changes and (code) cleanups through 786 files changed, 149056 added lines and 153741 removed lines of code (and comments) between 1.7.0 and 1.8.0. This year we released almost double the number of releases as we did in 2019 and 2018: where we delivered around 20 releases in both prior years, this year we delivered: 1.6 (11): 1.6.18 - 1.6.28 1.7 (19): 1.7.7 - 1.7.25 1.8 (14): 1.8.0-rc1 1.8.0 - 1.8.8 (including pre-releases: 1.8.0-alpha1 1.8.0-beta1 - 1.8.0-beta3) 44 releases! == Packaging and installation == With the 1.8 release, we were able to move the Docker images to Debian Buster! Moving the Docker image to Buster in 2019 with the 1.7 release was unsuccessful due to dropped support for ssmtp in Debian and lack for replacement functionality and lack of support for some of the ssmtp functionality in LedgerSMB itself. In 1.8, we added extensive support for the configuration of outgoing e-mail to LedgerSMB, allowing for this transition. The Debian ledgersmb package for 1.6 transitioned to Buster last year and we were very happy about that, but at the same time we found breakage in the package. We hoped to fix that soon after discovery. That turned out quite differently: as it happens, we had to come to the conclusion that we lost contact with Robert James Clay (aka Jame) with last known contact around October 2019. He used to maintain the Debian packages for us, including many of our dependencies which hadn't been packaged for Debian before. Unfortunately, LedgerSMB 1.6 has now been dropped from Debian Testing due to problems with dependencies and no newer versions have been packaged. We hope that Jame is doing fine and in the mean time would welcome anybody who wants to take over (Debian) packaging. == Development progress == This year we had a *lot* of development activity as demonstrated by the size of the 1.8.0 release and the number of patch releases for our active maintenance branches. The number of active developers - judging by accepted commits - went up from 4 last year to 7 people contributing commits this year, generating some 800 pull requests on GitHub: Project commits on all branches (excluding merges): 1247 Erik Huelsmann* 179 Yves Lavoie* 108 Nick Prater* 37 Aung Zaw Win* 3 Håvard Sørli 1 Bobberty 1 Andreas Karlsson * includes contributions on maintenance branches By comparison, these are the figures for 2019: 640 Erik Huelsmann 26 Yves Lavoie 21 Nick Prater 1 David Godfrey Please note that these numbers don't include the time spent by those taking the effort to report their problems with the software and taking the time to respond to developer questions as well as helping to test solutions when developers think they solved the problem. Similarly, there was a lot of activity with respect to issues: Number of open issues at 2020-01-01: 339 of which remain open today: 180 Issues closed since 2020-01-01: 278 of which created before 2020-01-01: 159 Issues created since 2020-01-01: 161 of which still open: 42 Number of open issues today: 222 This amount of development activity triggers many CI/CD jobs. Last year, we had just moved our coverage testing loads from TravisCI to CircleCI due to the fact that our coverage testing loads were taking too long to complete within the TravisCI limits. This year, unfortunately, we're moving our regular CI/CD loads from TravisCI to GitHub Actions: TravisCI has seriously restricted (effectively dropped) support for Open Source work loads. Even though we now have effectively moved off TravisCI, I'd like to take the opportunity to publicly thank them for all the builds that they were able to donate to this project over the course of years: our project ran almost 10.200 builds and my own account ran roughly 5.700 additional builds in preparation for merges! TravisCI, thank you! With everything going on, we were able to improve our test coverage to 44% (from 41 last year), but unfortunately, that's not nearly as much as in the year before (34 -> 41). In the Changelog for 1.9 ( https://github.com/ledgersmb/LedgerSMB/blob/master/Changelog#L3), you'll be able to read where we spent our time, for all effort that didn't end up in 1.8 and wasn't listed above. Areas that we're currently spending time on, include: * Selection of a new translation engine which supports more than 2 plural forms * Gradual polishing of 1.8 through regular fixes of issues left to be polished after 1.8.0 release * A Perl and PostgreSQL API to form a foundation to build a Web API and command line application on * Improvements in our JavaScript handling to support a switch to Vue The 222 issues that are open today summarize into these statistics: * 15 bite-sized: a good place to start when looking to make contributions * 33 needs-design: waiting in our design queue to be handled * 125 enhancement: requesting new features added to the application * 12 waiting-for-user: can't proceed on these without further reporter input (Note that an issue may fall into more than one category or none at all.) == New functionality and improvements == In 1.9, JavaScript code will be built with Webpack: *the *standard for JavaScript delivery. This allows us to add static code analysis as well as lots of code transforms customary in the JavaScript world. Basically it makes our JavaScript delivery more "as any JS project would do it". Yves sank immense amounts of time into trying to realize this change, wrestled and came out a winner! Thanks Yves. Another change that isn't highly visible, but should be noticeable is that we worked on improving the page response times. We were able to eliminate a lot of overhead (in miliseconds) from our page generation. Another topic that we spent a lot of time on is the consistency and validity of the example Charts of Accounts delivered with LedgerSMB: by changing the storage format from SQL code to XML structured data and formulating consistency rules for the XML data set, we were able to establish consistency and resolve consistency issues. Through this effort new users trying other Charts of Accounts than the US or CA charts that the developers usually use, should have a much better first user impression. == Looking forward to 2021 == In 2021, we'll likely release 1.9 around the middle of the year; again in a release cycle a bit shorter than a year. Fortunately at 10 June 2021, 1.6 will reach end-of-life which means that over the first half of the year, supported maintenance branches will be 1.8-1.7-1.6 while over the second half of the year it will be 1.9-1.8-1.7. Experience this year has shown that while maintaining 3 branches is challenging (especially with the rate of change we're currently going through), it is doable. However, running more than 3 maintenance branches in parallel won't be manageable. This is one of the reasons why we decided that the 1.8 and later branches receive 2 years instead of 3 years community maintenance support. Another reason being that upgrades have become a lot less painful over the past years (or so our users have told us). For 2021, I hope that the project can resolve a series of long-standing open issues as well as finally completing (and expanding on) the foundation for APIs at every level of the application: database, Perl, Web and (command line) application. Next to that, I hope that we can significantly increase our test coverage just like last year (and unlike this one) as well as cleaning (removing) old/deprecated code. All of that obviously in the expectation that it will result in an attractive 1.9 release! And last but not least, I'm hoping for 1 or 2 new contributors (not necessarily developers; translators, testers, documenters or UI artists are all greatly appreciated!). If you want to contribute, but don't know where to start, please contact me. Thanks to everybody who contributed to any of the above in any way, especially to * those who offered me or one of the other developers private access to their data to help get their problems resolved. This way, we were able to resolve a series of COGS related corner cases which I would not have been able to reproduce -- saving me huge amounts of time. * Computerisms.ca for hosting our DNS * Freelock.com for hosting our website and mailing lists * Efficito.com for hosting our mailing list archive, apt repository, release and download server * GitHub.com, TravisCI, CircleCI and coveralls.io for hosting our development workflow My special personal thanks go to my GitHub Sponsors for supporting me for time, efforts and (financial) resources dedicated to the project! Leaves me only to wish everybody in our community - and their loved ones - happy holidays and a safe and highly improved (over 2020) 2021! -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

LedgerSMB 1.8.8 released
by Erik Huelsmann 15 Dec '20

15 Dec '20

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.8.8 * Faster GL account tree consistency check * Maintain consistency between ar/ap/gl and transactions tables on delete * Fix CSV import of inventory adjustment * Fix failure to delete unapproved reconciliation reports For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.8.8/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.8.8 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.8.8 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.8.8 These are the sha256 checksums of the uploaded files: 14653c499fafca33b26ac85998e6dbe8e41e204638593dd0c3ea3fcc5ea15129 ledgersmb-1.8.8.tar.gz 600de1e1dee17bfe3cdafea278e29e0cdfeab9df7823558d55cdfdcbe3c64301 ledgersmb-1.8.8.tar.gz.asc

1 0

LedgerSMB 1.6.28 released
by Erik Huelsmann 15 Dec '20

15 Dec '20

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.6.28 * Faster GL account tree consistency check * Maintain consistency between ar/ap/gl and transactions tables on delete * Fix CSV import of inventory adjustment to use same logic as manual input For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.28/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.28 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.28 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.28 These are the sha256 checksums of the uploaded files: 6b1e8a28a90ee453751ec5f921f1e769c73e04c7314f04683358c4bfdb75a6ba ledgersmb-1.6.28.tar.gz e49597be8bbff9eac2e8fcc1c06a93e6766e14261ecf7980672ba4cebe2e78ce ledgersmb-1.6.28.tar.gz.asc

1 0

New install on Debian 10 (buster)
by fmiser 15 Dec '20

15 Dec '20

I'm having troubles with configuration, setup, running. I have been using SQL-Ledger for many years but now I must update... I can access the ledgersmb login using links browser pointed to localhost. But I'm failing to figure out how to allows LAN access. I have a fresh install of Debian on a machine. I used the package manager to install ledgerSMB 1.6.9. To keep it light, no X. This system is for a very small organization. One login typical, never more than 5, access from inside the LAN only. Any clues on how to setup Apache or Starman or ?? to make this setup work? -- fm

3 7

Error finding template
by Pete Houston 23 Nov '20

23 Nov '20

Hello, I am testing an upgrade to LSMB 1.7.13 (from 1.2.26!) and have hit this error when trying to display an invoice from a tex template: Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - ERROR - lsmb_legacy::catch {...} /var/www/ledgersmb/bin/../old/bin/old-handler.pl (175) -- 'Template error: file error - invoice: not found at /var/www/ledgersmb/lib/LedgerSMB/Template.pm line 564.\n' Unfortunately, this does not say where it is looking for the template. An invoice.tex file exists in /var/www/ledgersmb/templates/$USER/ where $USER is the LSMB user I have logged in as but this isn't being found. Please can you tell me where the templates should be installed in order for LSMB to pick them up? Thanks very much, Pete Here is the full slew of warnings, diagnostics etc. in the lead up to the above error message: -------------------------------------------------------------------------------- Unquoted string "customer" may clash with future reserved word at /var/www/ledgersmb/bin/../old/bin/is.pl line 1152 (#1) (W reserved) You used a bareword that might someday be claimed as a reserved word. It's best to put such a word in quotes, or capitalize it somehow, or insert an underbar into it. You might also declare it as a subroutine. Unquoted string "customer" may clash with future reserved word at /var/www/ledgersmb/bin/../old/bin/is.pl line 1374 (#1) Use of uninitialized value in substitution (s///) at /var/www/ledgersmb/old/lib/LedgerSMB/Form.pm line 2226 (#2) (W uninitialized) An undefined value was used as if it were already defined. It was interpreted as a "" or a 0, but maybe it was a mistake. To suppress this warning assign a defined value to your variables. To help you figure out what was undefined, perl will try to tell you the name of the variable (if any) that was undefined. In some cases it cannot do this, so it also tells you what operation you used the undefined value in. Note, however, that perl optimizes your program and the operation displayed in the warning may not necessarily appear literally in your program. For example, "that $foo" is usually optimized into "that " . $foo, and the warning will refer to the concatenation (.) operator, even though there is no . in your program. Use of uninitialized value within %xkeyref in hash element at /var/www/ledgersmb/old/lib/LedgerSMB/Form.pm line 2310 (#2) Use of uninitialized value in array dereference at /var/www/ledgersmb/bin/../old/bin/is.pl line 162 (#2) Use of uninitialized value $dec in numeric gt (>) at /var/www/ledgersmb/old/lib/LedgerSMB/IS.pm line 1429 (#2) Use of uninitialized value in string eq at /var/www/ledgersmb/bin/../old/bin/is.pl line 191 (#2) Use of uninitialized value in array dereference at /var/www/ledgersmb/bin/../old/bin/is.pl line 196 (#2) Use of uninitialized value in foreach loop entry at /var/www/ledgersmb/bin/../old/bin/is.pl line 196 (#2) Argument "" isn't numeric in numeric le (<=) at /var/www/ledgersmb/bin/../old/bin/is.pl line 236 (#3) (W numeric) The indicated string was fed as an argument to an operator that expected a numeric value instead. If you're fortunate the message will identify which operator was so unfortunate. Note that for the Inf and NaN (infinity and not-a-number) the definition of "numeric" is somewhat unusual: the strings themselves (like "Inf") are considered numeric, and anything following them is considered non-numeric. Use of uninitialized value $lsmb_legacy::myconfig{"acs"} in pattern match (m//) at /var/www/ledgersmb/bin/../old/bin/is.pl line 239 (#2) Use of uninitialized value $dec in numeric gt (>) at /var/www/ledgersmb/bin/../old/bin/is.pl line 287 (#2) Use of uninitialized value in string eq at /var/www/ledgersmb/bin/../old/bin/io.pl line 715 (#2) Use of uninitialized value in string eq at /var/www/ledgersmb/bin/../old/bin/io.pl line 744 (#2) Use of uninitialized value in string eq at /var/www/ledgersmb/bin/../old/bin/io.pl line 756 (#2) Use of uninitialized value in addition (+) at /var/www/ledgersmb/bin/../old/bin/io.pl line 916 (#2) Use of uninitialized value in split at /var/www/ledgersmb/bin/../old/bin/io.pl line 1317 (#2) Use of uninitialized value $IS::inventory_accno_id in string at /var/www/ledgersmb/old/lib/LedgerSMB/IS.pm line 217 (#2) Use of uninitialized value $dec in numeric gt (>) at /var/www/ledgersmb/old/lib/LedgerSMB/IS.pm line 338 (#2) Use of uninitialized value $_[0] in pattern match (m//) at /usr/share/perl5/I18N/LangTags.pm line 398 (#2) Use of uninitialized value in substitution (s///) at /var/www/ledgersmb/bin/../old/bin/io.pl line 1386 (#2) Use of uninitialized value in substitution (s///) at /var/www/ledgersmb/bin/../old/bin/io.pl line 1394 (#2) Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - INFO - LedgerSMB::Template::DBProvider::_template_modified -- last modified date requested for ./invoice Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - INFO - LedgerSMB::Template::DBProvider::_retrieve_template_data -- Retrieving template for (invoice, , tex) Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - INFO - LedgerSMB::Template::DBProvider::_retrieve_template_data -- Retrieving template for (invoice, -undef-, tex) Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - WARN - LedgerSMB::Template::DBProvider::_retrieve_template_data /var/www/ledgersmb/lib/LedgerSMB/Template/DBProvider.pm (99) -- No match found retrieving the template 'invoice' Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - WARN - LedgerSMB::Template::DBProvider::_template_modified /var/www/ledgersmb/lib/LedgerSMB/Template/DBProvider.pm (129) -- No last modified date for invoice Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - INFO - LedgerSMB::Template::DBProvider::_template_modified -- last modified date requested for ./invoice Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - INFO - LedgerSMB::Template::DBProvider::_retrieve_template_data -- Retrieving template for (invoice, , tex) Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - INFO - LedgerSMB::Template::DBProvider::_retrieve_template_data -- Retrieving template for (invoice, -undef-, tex) Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - WARN - LedgerSMB::Template::DBProvider::_retrieve_template_data /var/www/ledgersmb/lib/LedgerSMB/Template/DBProvider.pm (99) -- No match found retrieving the template 'invoice' Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - WARN - LedgerSMB::Template::DBProvider::_template_modified /var/www/ledgersmb/lib/LedgerSMB/Template/DBProvider.pm (129) -- No last modified date for invoice Use of uninitialized value in concatenation (.) or string at /var/www/ledgersmb/bin/../old/bin/old-handler.pl line 192 (#2) Req:62A47F6E281411EBA7D544DC3F926520 2020/11/16 14:02:39 - ERROR - lsmb_legacy::catch {...} /var/www/ledgersmb/bin/../old/bin/old-handler.pl (175) -- 'Template error: file error - invoice: not found at /var/www/ledgersmb/lib/LedgerSMB/Template.pm line 564.\n' -------------------------------------------------------------------------------- -- Openstrike - improving business through open source https://www.openstrike.co.uk/ or call 01722 770036

2 10

LedgerSMB 1.8.7 released
by Erik Huelsmann 20 Nov '20

20 Nov '20

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.8.7 * Fix internal server error when creating AR/AP voucher (#5188) * Fix AP Aging inadvertedly having been dropped from the menu (#5193) * Fix 'Approved'/'Unapproved' filter in GL search (#5181) For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.8.7/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.8.7 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.8.7 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.8.7 These are the sha256 checksums of the uploaded files: db67f501dee90a0f85d0b5e0b430b006955dc87b0a943b4ed9dd563d7522f22e ledgersmb-1.8.7.tar.gz 5aa2b669faab809cef0348b88c4ee1e9f4bda4c794b3e42b5a22821663cfc718 ledgersmb-1.8.7.tar.gz.asc

3 4