Hello team.
I have a question.It is possible if we can create a multiple branch for a specific company database setup?
Your response is highly appreciated.
Cheers!
:)
Ryle.Msinc/ITDept
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
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
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
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
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
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