December 2020 - users - lists.freelock.com

Can't connect to port 5762 (starman) to ledgersmb
by fherman＠inferential.com 01 Apr '24

01 Apr '24

I am a new user. This installation is on a local machine running linuxmint. I installed the latest ledgersmb image for docker via a pull. I have been able to get the PostgreSQL and the ledgersmb containers running. The container name for ledgersmb is myledger. The ps command shows both PostgreSQL and starman running. When I try to browse to http://localhost:5762/setup.pl, I get connection refused. I also tried to telnet to the port but got refused error. When I look for listening ports, port 5762 doesn't show. Apparently I am missing something in my installation. TIA

2 2

LedgerSMB 1.7.25 released
by Erik Huelsmann 13 Apr '22

13 Apr '22

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

2 1

'Making Tax Digital' and HMRC in the UK
by Lyn St George 24 Mar '22

24 Mar '22

Hallo, I see WebService::HMRC on cpan with a note that it was originally developed for LedgerSMB, but I can find no reference to it in the list archives. Is there an existing implementation of this? Cheers Lyn

3 4

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