January 2018 - users - lists.freelock.com

MULTIPLE BRANCH
by Ryle Zabate 30 Jan '18

30 Jan '18

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

1 0

testings
by Ryle Zabate 30 Jan '18

30 Jan '18

Ryle.Msinc/ITDept

1 0

LedgerSMB 1.5.16 released
by Erik Huelsmann 28 Jan '18

28 Jan '18

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

1 0

Useful sql selects - at least for me :-)
by bill Ott 26 Jan '18

26 Jan '18

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

1 0

Deleting Transaction
by Angelene Jamias 18 Jan '18

18 Jan '18

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

4 4

Unable to use admin.pl
by Louis 12 Jan '18

12 Jan '18

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

4 4

Release of ledgersmb-1.5 v1.5.15-1
by Robert J. Clay 10 Jan '18

10 Jan '18

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

1 0

LedgerSMB 1.5.15 released
by Erik Huelsmann 07 Jan '18

07 Jan '18

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

1 0