January 2019 - users - lists.freelock.com

Are there any subscribers using LedgerSMB versions older than 1.4?
by Erik Huelsmann 06 Apr '19

06 Apr '19

Hi all, Migrations have become considerably more controlled since the 1.5 release, which introduces a smooth migration from 1.4. As such migration paths do not exist for 1.1, 1.2 and 1.3, I'm eager to learn if there are any users out there of these old versions, and, if you're not migratiing, what's keeping you from doing so. If you can't publicly respond to this inquiry, please mail me privately so I can treat your information confidentially. Thanks for your responses, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

3 5

Migration to 1.5
by Ryle Zabate 24 Jan '19

24 Jan '19

Greetings!Hello Team, we are still using the 1.3 version of LedgerSMB.Can we directly migrate to the 1.5 by extracting it on top of the 1.3 without any problem/issue? Your response is highly appreciated. Warm Regards. Ryle.Msinc/ITDept

2 3

Release of ledgersmb-1.6 package v1.6.10-1
by Robert J. Clay 20 Jan '19

20 Jan '19

An initial version of the debian ledgersmb-1.6 package version for LedgerSMB v1.6.10 has been created and uploaded to our PPA[1], for Ubuntu 'disco' (v19.04) and 'cosmic' (v18.10) as well as for 'bionic' (v18.04 LTS). (The debian source packages are available as well.) The packages at our PPA: ledgersmb-1.6 ledgersmb-1.6-apache ledgersmb-1.6-lighttpd ledgersmb-1.6-nginx ledgersmb-1.6-varnish Only the main 'ledgersmb-1.6' package is required; the others are related to which web proxy you might want to use and you only need one of them. (They depend on their respective web proxy applications and attempt to do at least some setup for them.) Note that I haven't created a ledgersmb-1.6 package yet at our apt package repository[2] for Debian 'Buster' (which is expected to be Debian v10) as that Debian version has not yet been released. It is, however, expected later this year so if people would like that I start making it available as well, please let me know. -- 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://launchpad.net/~ledgersmb/+archive/ubuntu/main/+packages [2] https://apt.ledgersmb.org/

1 0

LedgerSMB 1.7.0-alpha1 released
by Erik Huelsmann 20 Jan '19

20 Jan '19

Hi, After the merge of the (improved) Multi Currency Support branch (MC branch), we have released a preview version of LedgerSMB 1.7.0. It's not feature complete yet, but is intended as a general sense of direction for the 1.7.0 release and a way to solicit feedback. Note that you should run this version *only* on a *copy* of your database; this version is NOT intended for production use. The full changelog for 1.7.0 so far is included below. The most important feature by far is the improved multi currency support, which required quite extensive changes to the software. As such, this is the feature we're looking for feedback on most. If you need help getting set up to test 1.7.0-alpha1, please let me know! Changelog for 1.7 Series Forthcoming New functionalities * Deletion of template transactions (Nick P) * Transaction date now part of purchase history report (Chris T) * UI allows addition and removal of custom `account_link` flags (Nick P) Improved foreign currency support * Multiple rates per day per currency (Erik H) - Reversing a transaction from a closed-period on a day with different rate - Bank transfers with different banks on the same day with bank's fx rate - Migration from systems which support per-transaction or per-line fx rates * Multiple currencies in a single general ledger transaction (Erik H) - Posting an opening balance with all currencies in 1 transaction - Transferring between foreign currencies on e.g. Paypal in 1 transaction * Fixed copying of invoice copies fx rate without option to change (Erik H) * UI showing foreign and default currency amounts in transactions (Erik H) Quality Assurance * Expanded checks and resolutions for schema changes (Erik H) * Testing infrastructure and tests for schema change checks (Erik H) * Ensure correct dependency declaration (RequireExplicitInclusion critic policy) * POD documentation structure improvements, with automated checks (Erik H) * Expanded BDD tests, including payments, batches and approval (Nick P) Dependency updates * Dojo Toolkit (JavaScript UI tools) updated to 1.14.2 (Erik H) Code cleanup * Removed deprecated 'custom table' and 'custom field' tables (Erik H) * Reduce dependencies on deprecated LedgerSMB::App_State (Nick P) * Simplified deprecated LedgerSMB::PGOld (Nick P) * Remove unused LedgerSMB::DBObject and LedgerSMB::PGOld methods (Nick P) * Remove unused configuration settings in ledgersmb.conf (Erik H) * Further (compared to 1.6) reduction of warnings * Implemented tests for LedgerSMB::File(::*) modules (Nick P) * Template engine simplification by separation of UI and printed docs (Erik H) * Consistent copyright notices - with tests - on all Perl files in lib/ (Nick P) * Request handling cleanup by mapping 'flat' POST data into hierarchy (Erik H) Nick P is Nick Prater Erik H is Erik Huelsmann Chris T is Chris Travers -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

LedgerSMB 1.6.10 released
by Erik Huelsmann 20 Jan '19

20 Jan '19

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.10 * Apply correct layout to schema upgrade pages in setup.pl (Erik H) * Fix iteration over row data provided in schema data fixes in setup.pl (Erik H) * Fix schema upgrade with multiple failing checks looping infinitely (Erik H) * Improve wording of correction instructions of schema check failure (Nick P) * Respect tempdir when rendering ODS template (don't use current dir) (Nick P) * Add user feedback when invoice needs recalculation before posting (Erik H) Erik H is Erik Huelsmann Nick P is Nick Prater For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.6.10/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.6.10 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.6.10 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.6.10 These are the sha256 checksums of the uploaded files: 4028fcd2fd63d90988f031de013b81c4a11fe55b8908114e4c05f142ce6389a0 ledgersmb-1.6.10.tar.gz 071c780fc5d8e5b95f7009a86de8496a705e45496d3d9428bc7db25693244e26 ledgersmb-1.6.10.tar.gz.asc

1 0

Exchange rate
by Erik Huelsmann 11 Jan '19

11 Jan '19

Hi Ryle, Your mails are appearing in the mailing list archive (..) but not in my inbox, so I'm copying the content of your mail here: > How can we set the exchange rates if the currency is different form our country default currency, In order to be able to set exchange rates, you need to indicate that you want to use multiple currencies. You can do that in the "System > Defaults"-menu. On the resulting page, there's a "Currency" input box. If you want to use more than one currency, e.g. USD (as the regular currency (also known as "functional currency")) and EUR as the foreign currency, you enter into the currency box (without the quotes): "USD:EUR" (the ":" is the important separator). When you have that, you can choose the currency when creating an order or invoice. When you choose "EUR" and click "Update", an input box will appear for the exchange rate. > Let's say the purchase order is to be sent to another country. Does the above help your case? Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

Fwd: Debian packages for LedgerSMB
by Robert J. Clay 11 Jan '19

11 Jan '19

Forgot to cc this to the mailing list... ---------- Forwarded message --------- From: Robert J. Clay <rjclay(a)gmail.com> Date: Tue, Jan 1, 2019 at 2:16 PM Subject: Re: [ledgersmb-users] Debian packages for LedgerSMB To: Nicolas Couchoud <nicolas.couchoud__ledgersmb(a)normalesup.org> Hi Nicolas! On Mon, Dec 31, 2018 at 10:07 AM Nicolas Couchoud <nicolas.couchoud__ledgersmb(a)normalesup.org> wrote: > > Hi, > > As far as I have understood, there are two sorts of Debian packages for > LedgerSMB : > * Debian regular repositories just contain packages called « ledgersmb » ; Yes, that's the official Debian package for the LedgerSMB application (which also migrates over to the developmental version of Ubuntu). The most recent is the one for the most recently released version of LedgerSMB, 1.6.9. (Released just a few days ago.) > * your repository apt.ledgersmb.org contains packages with names like > « ledgersmb-1.5 » and « ledgersmb-1.5-apache ». Yes, the ledgersmb-1.5 packages are for the 1.5.x versions of LedgerSMB, with the latest being v1.5.24 (just released a few days ago). The ones like ledgersmb-1.5-apache are for web proxies if one wants to use one. The 1.5.x versions will be supported by the project until December of this year (2019) when it will see its End Of Life for community support.. There are also the ledgersmb-1.6 packages, which are for the 1.6.x versions of the LedgerSMB application (the current stable). It also has the associated packages for a web proxy selection. > So, I feel a bit lost... Is there one preferred sort of package ? Are > some of these obsolete ? The ledgersmb-1.5 packages aren't "obsolete" but they are for the old-stable version of LedgerSMB (1.5.x), which as noted will see End of Life in December 2019. (Whereas the 1.6.x versions are good for LedgerSMB Community Support until December of 2021.) Their advantage is that due to the availability of dependencies, the ledgersmb-1.5 packages can be backported to older versions of Debian (or Ubuntu) than the ledgersmb-1.6 packages currently can be. The primary difference between the 'ledgersmb' package and the 'ledgersmb-1.x' packages is that due to Debian Policy (regarding embedded libraries), the ledgersmb packages uses the system installed packages for the Dojo libraries while the ledgersmb-1.x packages use the embedded versions of the Dojo libraries that are released with each version of the LedgerSMB application. -- Robert James Clay rjclay(a)gmail.com, jame(a)rocasa.us -- Robert J. Clay rjclay(a)gmail.com

1 0

Re: [ledgersmb-users] users Digest, Vol 20, Issue 1
by Ryle Zabate 11 Jan '19

11 Jan '19

Hi, thank you for your question. On our case, we are still using the 1.3.46 release since the only available pdf manual is only for 1.3 version.Can we now migrate to higher versions of LSMB without any issues and retaining the data of the 1.3 setup? Regards. Ryle.Msinc/ITDept From: "users-request(a)lists.ledgersmb.org" <users-request(a)lists.ledgersmb.org> To: users(a)lists.ledgersmb.org Sent: Wednesday, January 2, 2019 4:00 AM Subject: users Digest, Vol 20, Issue 1 Send users mailing list submissions to users(a)lists.ledgersmb.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.ledgersmb.org/mailman/listinfo/users or, via email, send a message with subject or body 'help' to users-request(a)lists.ledgersmb.org You can reach the person managing the list at users-owner(a)lists.ledgersmb.org When replying, please edit your Subject line so it is more specific than "Re: Contents of users digest..." Today's Topics: 1. Are there any subscribers using LedgerSMB versions older than 1.4? (Erik Huelsmann) ---------------------------------------------------------------------- Message: 1 Date: Tue, 1 Jan 2019 15:41:24 +0100 From: Erik Huelsmann <ehuels(a)gmail.com> To: users(a)lists.ledgersmb.org Subject: [ledgersmb-users] Are there any subscribers using LedgerSMB versions older than 1.4? Message-ID: <CACOoB6jUCbQsvB+oL3XSp=9jR=ZN0LpU0ady3Sz+uHGSGM37_Q(a)mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi all, Migrations have become considerably more controlled since the 1.5 release, which introduces a smooth migration from 1.4. As such migration paths do not exist for 1.1, 1.2 and 1.3, I'm eager to learn if there are any users out there of these old versions, and, if you're not migratiing, what's keeping you from doing so. If you can't publicly respond to this inquiry, please mail me privately so I can treat your information confidentially. Thanks for your responses, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

Exchange Rate
by Ryle Zabate 10 Jan '19

10 Jan '19

Hello Team, I need your expert advice for this subject.How can we set the exchange rates if the currency is different form our country default currency,Let's say the purchase order is to be sent to another country. Your help is greatly appreciated. Regards. Ryle.Msinc/ITDept

1 0

Re: [ledgersmb-users] Production Install, Networking and Setup
by Xboxboy Mageia 09 Jan '19

09 Jan '19

On Sat, Dec 29, 2018 at 11:28 AM Xboxboy Mageia <xboxboy.mageia(a)gmail.com> wrote: > Erik, thanks for responding. > > On Mon, Dec 24, 2018 at 9:43 PM Erik Huelsmann <ehuels(a)gmail.com> wrote: > >> Hi! >> >> Good! Feel free to drop in whenever you feel like it. The channel may not >> always be active, but I'm usually monitoring activity. You're most likely >> active during my nights (I'm in Europe), but I'll try to respond as early >> on the day as possible. >> > I forgot to mention, I'm on IRC these days as Aussie_matt (registered > name) or pilot_aus (unregistered). > >> >> >> Ok. So, I take it your desire is to run the setup in the Debian VM? Or >> are you looking at installing in a CentOS VM? >> >> Sorry, yes, I'll use a Debian OS guest VM, on a Centos host OS. > >> >> Sure. No problem. Is the server which hosts the VMs web-facing? (Hmm, >> reading on, I think your point with the fixed IP is probably that it is >> webfacing indeed.) >> > Not currently, I only have it running internally on our network: But I > wish to have LedgerSMB, and one other web app, to be accessible from > outside: I don't know the ins and outs of VPN's, but I suspect that makes > it tricky for the accountant to login. Web facing is more practical, but > more open to web threats? I could be wrong on that. > >> >> >>> I would like LedgerSMB to be web facing to allow me to >>> A: work from home at times >>> B: The accountant to log in and work when required (usually year end). >>> >> >> I have a setup like that myself too, so we can make that work :-) >> >> Awesome! > >> Which version of LedgerSMB did you install? Do I remember that you're >> installing 1.5? >> >> I believe you're correct it was 1.5, as the apt repo wasn't able to do > 1.6 for some reason at this point in time: Dependency related IIRC. > >> >>> All advice most appreciated. I may need my hand held significantly at >>> first, especially in regards to networking and security. >>> >> >> In order to run a secure setup, there's one very important thing you need >> to have: a TLS/SSL Certificate. That will help keep the password going over >> the wire, secure. >> Another thought that I have is: when you want to expose only LedgerSMB's >> web interface to the outside world, it's probably best to set up an >> extremely strict firewall/iptables setup which forwards/filters just the >> one single required port. Another idea would be to set up a (reverse) >> proxy: an HTTP server running on an already public VM which forwards the >> traffic to an internal server unaccessible to the internet. >> >> Ah yes. Ok, so on my home Nextcloud install (internal only) I was able to > create and use a self signed cert, but if we're going net facing, and the > accountant is going to access it, I'm guessing using Let's Encrypt or > similar is worth chasing up? > I'm all for locking firewalls down tight: I still don't fully understand > the reverse proxy concept: But I'm sure I can be guided :) > > >> Many ideas. Please follow-up or join #ledgersmb! >> >> I've come down sick over the break, so am yet to return to the shop to > look at doing anything: > > I guess my first step is to install a Debian OS vm, and get the APT repo > hooked in and installed: Take a snapshot, then we can proceed? > > Ok, so the debian install went simply. I used debian 9 (Stretch), without a GUI. 'ip addr' gives 192.168.1.101, which sounds right, as that's my lan, 192.168.1.X. I then followed the instructions on https://apt.ledgersmb.org/index.html, but I installed version 1.5, and did not add the 'test component', I don't know what that means, sorry. > Regards, >> >> -- >> Bye, >> >> Erik. >> >> Many thanks. > >> http://efficito.com -- Hosted accounting and ERP. >> Robust and Flexible. No vendor lock-in. >> > I was able to add the DB admin user where the prompt comes up: Now do I need to reset/config mysql's root user and password also? So from my desktop I tried to access via firefox 192.168.1.101:5762/setup.pl, but it's unable to connect. I have the VM network set to bridged, networking is my downfall, and the other thing I suspect is that I need to open the firewall for the webserver. All advice appreciated.

4 3