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.
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
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/
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.
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
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.
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
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.
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
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.