14 Nov
2021
14 Nov
'21
10:54 a.m.
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.9.3
* Sort the buttons on the e-mail entry screen
* Fix issues with the PDF output for PNL and Balance sheet reports
* Fix indenting on the hierarchical PNL and balance sheet HTML reports
* Add link to download HTML PNL and balance sheet reports
* Add rudimentary CSS to HTML PNL and balance sheet reports
* Fix off-by-one column on the PNL and balance sheet total lines
* Remove application links on downloaded HTML PNL and balance sheet reports
* Use a temp table to prevent bulk payments trampling on each other
* Fix sorting on fixed asset searches (#6151)
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.9.3/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.9.3
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.9.3
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.9.3
These are the sha256 checksums of the uploaded files:
265aaa291f2a021e5c77e9fb674740669a19d552856f841b73f62cc040bf0a4a ledgersmb-1.9.3.tar.gz
f97ecc7fa4277648a018ff508d656c403b2445cf4669a0e52908e23f83c74861
ledgersmb-1.9.3.tar.gz.asc
16 Nov
16 Nov
9:30 a.m.
Hi
Trying to upgrade my 1.7.24 version to 1.9.3, I get this error.
Error!
*Error applying upgrade script
./sql/changes/1.6/track-deleted-transactions.sql: ERROR: update or
delete on table "transactions" violates foreign key constraint
"invoice_trans_id_fkey" on table "invoice"
DETAIL: Key (id)=(27) is still referenced from table "invoice". at
lib/LedgerSMB/Database/Change.pm line 309.
*
dbversion: 1.9.3, company:
---
The problem is that rows in the invoice table still reference
transaction rows, while the upgrade script tries to delete them.
We have experienced several data related issues during the past couple
of years, so I'm thinking that it would be an idea to start all over
with only the contact, product, and account information. Do we have a
way to port only the essential data to the new version?
/kaare
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.9.3
* Sort the buttons on the e-mail entry screen
* Fix issues with the PDF output for PNL and Balance sheet reports
* Fix indenting on the hierarchical PNL and balance sheet HTML reports
* Add link to download HTML PNL and balance sheet reports
* Add rudimentary CSS to HTML PNL and balance sheet reports
* Fix off-by-one column on the PNL and balance sheet total lines
* Remove application links on downloaded HTML PNL and balance sheet reports
* Use a temp table to prevent bulk payments trampling on each other
* Fix sorting on fixed asset searches (#6151)
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.9.3/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.9.3
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.9.3
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.9.3
These are the sha256 checksums of the uploaded files:
265aaa291f2a021e5c77e9fb674740669a19d552856f841b73f62cc040bf0a4a ledgersmb-1.9.3.tar.gz
f97ecc7fa4277648a018ff508d656c403b2445cf4669a0e52908e23f83c74861
ledgersmb-1.9.3.tar.gz.asc
_______________________________________________
devel mailing list --devel(a)lists.ledgersmb.org
To unsubscribe send an email todevel-leave(a)lists.ledgersmb.org
17 Nov
17 Nov
7:45 a.m.
New subject: Copy masterdata to new company (Re: LedgerSMB 1.9.3 released)
Hi Kaare,
On Tue, Nov 16, 2021 at 10:30 AM Kaare Rasmussen <kaare(a)jasonic.dk> wrote:
Trying to upgrade my 1.7.24 version to 1.9.3, I get
this error.
Error!
*Error applying upgrade script
./sql/changes/1.6/track-deleted-transactions.sql: ERROR: update or delete
on table "transactions" violates foreign key constraint
"invoice_trans_id_fkey" on table "invoice" DETAIL: Key (id)=(27) is
still
referenced from table "invoice". at lib/LedgerSMB/Database/Change.pm line
309. *
dbversion: 1.9.3, company:
---
The problem is that rows in the invoice table still reference transaction
rows, while the upgrade script tries to delete them.
What this means is that there are no records in acc_trans which are
associated with the transaction referenced from the invoice row. If "qty -
allocated = 0" then these records can be removed without side effects. If
the condition does not hold, the question is whether qty is positive or
negative. If it's positive, the record belongs to a sales transaction and
the fact that "qty - allocated = 0" does not hold, means that at some point
insufficient stock was available to allocate COGS. (Removing the row will
prevent that COGS amount from being posted.) If it's negative, it means
that there's stock left which hasn't been allocated to a sale yet for COGS.
(Removing the row will leave an amount in inventory without explanation
from purchase records.)
We have experienced several data related issues during
the past couple of
years, so I'm thinking that it would be an idea to start all over with only
the contact, product, and account information. Do we have a way to port
only the essential data to the new version?
A good and fair question. The answer is that we don't have that at the
moment as a ready-made solution from the project. If you are going to build
something like it, I'll gladly help you with the information you need in
order to build it. Also, I think it's great to be able to include such a
tool (even if it's not fully done and rough around the edges) in our set of
utilities.
Regards,
Erik.
/kaare
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.9.3
* Sort the buttons on the e-mail entry screen
* Fix issues with the PDF output for PNL and Balance sheet reports
* Fix indenting on the hierarchical PNL and balance sheet HTML reports
* Add link to download HTML PNL and balance sheet reports
* Add rudimentary CSS to HTML PNL and balance sheet reports
* Fix off-by-one column on the PNL and balance sheet total lines
* Remove application links on downloaded HTML PNL and balance sheet reports
* Use a temp table to prevent bulk payments trampling on each other
* Fix sorting on fixed asset searches (#6151)
For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.9.3/README.md
The release can be downloaded from our download site at
https://download.ledgersmb.org/f/Releases/1.9.3
The release can be downloaded from GitHub at
https://github.com/ledgersmb/LedgerSMB/releases/tag/1.9.3
Or pulled from Docker Hub using the command
$ docker pull ledgersmb/ledgersmb:1.9.3
These are the sha256 checksums of the uploaded files:
265aaa291f2a021e5c77e9fb674740669a19d552856f841b73f62cc040bf0a4a ledgersmb-1.9.3.tar.gz
f97ecc7fa4277648a018ff508d656c403b2445cf4669a0e52908e23f83c74861
ledgersmb-1.9.3.tar.gz.asc
_______________________________________________
devel mailing list -- devel(a)lists.ledgersmb.org
To unsubscribe send an email to devel-leave(a)lists.ledgersmb.org
_______________________________________________
devel mailing list -- devel(a)lists.ledgersmb.org
To unsubscribe send an email to devel-leave(a)lists.ledgersmb.org
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
746
days inactive
749
days old
2 comments
3 participants
participants (3)
-
Erik Huelsmann -
Erik Huelsmann -
Kaare Rasmussen