- devel - lists.freelock.com

Which corrective action for "invoice COGS schema check"?
by Erik Huelsmann 30 Apr '18

30 Apr '18

Hi, After having merged the infrastructure to check data validity in an existing database before applying an upgrade script, I'm reviewing existing scripts to see if they may qualify to be enhanced with a check and user intervention. One script which qualifies is 1.5/invoice-tbl-cogs-constraint.sql which adds a constraint verifying that the COGS routines post data which makes sense. Existing data does not necessarily comply with the new constraint. I wonder though what corrective action to offer a user who is the proud owner of non-compliant data. I see a number of options: 1. Tell the user to contact the mailing list (and block his migration in the mean time) 2. Modify the data to be within the bounds to be enforced (and thereby loose the COGS audit trail? 3. Allow constraint creation to fail by modifying Loadorder and create a new script which creates a "not valid" constraint (which allows the existing data to remain in place, but verifies new data) 4. Create a check script which creates the "not valid" constraint and fakes script application by modifying dbchanges tables 5. Adjust the data back into bounds, allocating the overage to more recent invoices and creating a COGS adjustment journal which the admin must post Which should we go with? -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

2 2

Release of ledgersmb-1.5 v1.5.20-1
by Robert J. Clay 14 Apr '18

14 Apr '18

An initial version of the debian package ledgersmb-1.5 for version 1.5.20-1 has been released and uploaded to our apt repository for 'main' in stretch[1]. 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). (The Debian source packages are available as well.) 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 Only the main 'ledgersmb-1.5' package is required; the others are related to which web proxy you might want to use and you only need one of them. -- 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

1 0

LedgerSMB 1.5.20 released
by Erik Huelsmann 14 Apr '18

14 Apr '18

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.5.20 * Fix inability to save custom sequences (System > Sequence) (Erik H, #3511) * Fix error when downloading balance sheet as PDF (Erik H, #3515) * Fix empty backup file due to PGObject::Util::DBAdmin 0.120 (Erik H, #3531) * Norwegian (nb) translation update (Havard S) Erik H is Erik Huelsmann Havard S is Havard Sorli For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.5.20/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.5.20 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.5.20 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.5.20 These are the sha256 checksums of the uploaded files: bb815d97b23707c6f70b1a5cac56adb86fd0c841a5c4b403770760fee1a8392c ledgersmb-1.5.20.tar.gz 8931bac54f7b877486629fdf296968ad1b93bed11067116db8cbe531cecc4625 ledgersmb-1.5.20.tar.gz.asc

1 0

Refined label definitions
by Erik Huelsmann 14 Apr '18

14 Apr '18

Hi, After review of our issue labels and their use, I've changed the wording ( https://github.com/ledgersmb/LedgerSMB/wiki/Issue-labels) of the for the labels "blocking" and "started". Blocking now reads: Deemed "needs to be fixed before the assigned release"; issues in this category apply to unacceptable regressions or critical (non-accounting) bugs -- in general, issues preventing work from getting done The change here is the last sentence having been added "in general, issues preventing work from getting done" Started now reads: Work on this issue has started and the issue is actively being worked on The change here is the "and" clause having been added: "and the issue is actively being worked on". -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

HEADS UP: New development container due to changed dependencies for master
by Erik Huelsmann 13 Apr '18

13 Apr '18

Hi, Earlier today, I've changed tthe dependency on File::MimeInfo to MIME::Types due to the fact that the former depends on freedesktop.org while the latter has its own MIME database built in, thus reducing the number of external dependencies. To accomodate this changed dependency, I've triggered a build for the DEV-container, which should finish in ~30 minutes from now. Please update your development environments. Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 0

LedgerSMB 1.5.19 released
by Erik Huelsmann 02 Apr '18

02 Apr '18

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.5.19 * Fix payment screen localized amount formatting problem (Erik H, #3283) * Separate error and output 'psql' logs during database upgrade (Nick P) * Fix random order of PNL and B/S reports columns (Erik H, #2244) * Various fixes to setup.pl regarding backup file generation (Nick P) * Use File::Path to create directory instead of through shell call-out (Nick P) * On TAB-exit of accounts/parts selector, select first item (Erik H) * Estonian translation update (Margus L) * German translation update (Mikael A) * Hungarian translation update (Istvan P) Erik H is Erik Huelsmann Nick P is Nick Prater Istvan P is is Istvan Pongracz Margus L is Margus Lepmets Mikael A is Mikael Arhelger For installation instructions and system requirements, see https://github.com/ledgersmb/LedgerSMB/blob/1.5.19/README.md The release can be downloaded from our download site at https://download.ledgersmb.org/f/Releases/1.5.19 The release can be downloaded from GitHub at https://github.com/ledgersmb/LedgerSMB/releases/tag/1.5.19 Or pulled from Docker Hub using the command $ docker pull ledgersmb/ledgersmb:1.5.19 These are the sha256 checksums of the uploaded files: 7dba20470984328924ba3ef3dd3d92b60f41b6023ccbe72d107968da0cb1c677 ledgersmb-1.5.19.tar.gz 40f2f458a6605f05ee1eb238f0c084c481cd26273287568f35b927b75813665c ledgersmb-1.5.19.tar.gz.asc

1 0

HEADSUP (master/1.6): tools/starman.psgi moved to bin/ledgersmb-server.psgi
by Erik Huelsmann 02 Apr '18

02 Apr '18

Hi all, There's a PR pending which moves all content of tools/ (on master/1.6, not 1.5!) to other places: starman.psgi -> ../bin/ledgersmb-server.psgi makeblacklist.pl -> ../utils/devel/makeblacklist.pl starman-development.psgi -> ../utils/devel/ Most others were moved to bin/ and dbsetup.pl was removed (duplicate of prepare-company-database.pl). Regards, -- Bye, Erik. http://efficito.com -- Hosted accounting and ERP. Robust and Flexible. No vendor lock-in.

1 1

Release of ledgersmb-1.5 v1.5.18-1
by Robert J. Clay 11 Mar '18

11 Mar '18

An initial version of the debian package of ledgersmb-1.5 for version 1.5.18-1 has been released and uploaded to our apt repository.[1]. 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). 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

1 0

Book, Manual plus other documentation status
by Chris Bennett 11 Mar '18

11 Mar '18

I would like to know the situation right now with all of that stuff. I may be able to import something into a part of the ports tree if the documentation is at a good state with the current version and if that's OK to do from both the "powers that be" with LedgerSMB and OpenBSD. OpenBSD does like to have a documentation port for many different programs, for example postgresql-docs and many others. LedgerSMB-docs would be acceptable if it matches up with the current state of things. Just a thought, Chris Bennett

1 0

Dojo first for OpenBSD support LSMB Any Dojo comments?
by Chris Bennett 11 Mar '18

11 Mar '18

Right now I am recovering from the flu, so I'm still a little wiped out! I see that my first step ought to be Dojo. I've briefly glanced at the source. Anything I should be aware of for importing it? I was starting getting sick as I looked over everything real quickly and definitely with a lack of clarity from being sick. I'm going to look again in more depth at everything as best as I can. The dual licenses were certainly peculiar, but no problem since it was the BSD or the other one. I just thought I'd ask ahead of time if I would need any tips. I don't speak JavaScript, so couldn't hurt to ask. Plus, it's nice to let everyone know that I'm actually trying to get things going again with OpenBSD. Thanks, Chris Bennett

1 0