-
-
Notifications
You must be signed in to change notification settings - Fork 150
/
Copy pathChangelog
4291 lines (3477 loc) · 186 KB
/
Changelog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-*- fundamental -*-
Changelog for 1.10 Series
Released 2022-10-08
Changelog for 1.10.28
* Retain partsgroup selection on Update in parts screen (#7848)
* Fix missing columns on trial balance 'Ending' report type (#7870)
Changelog for 1.10.27
* Fix 'delete' link shown in CoA screen on accounts used with parts (#7812)
* Fix deletion of parts (#7811)
Changelog for 1.10.26
* Load paper size from database settings, if set (#7738)
* Fix CoA and Trial Balance PDF reports missing data in some columns (#7739)
* Fix check printing when paying a subset of the available invoices (#7761)
Changelog for 1.10.25
* Minimum PGObject::Type::BigFloat version to resolve Math::BigFloat issue (#7704)
Changelog for 1.10.24
* Specify Locale::CLDR minimum version to fix numbers shown as 'HASH()' (#7671)
Changelog for 1.10.23
* Further Math::BigFloat fixes (combined with Locale::CLDR) (#7647)
* Order/Quote can't be deleted due to unconfirmed prior deletion (#7655)
Changelog for 1.10.22
* Fix Math::BigFloat 1.999831 compatibility, included in Perl 5.36+ (#7635)
Changelog for 1.10.21
* Add option to include tax codes to taxform report (#7581)
Changelog for 1.10.20
* Increase maximum comparison periods from 9 to 13 (#7468)
* Fix check to complement missing GIFI on SQL-Ledger migration (#7500)
* Fix CSV imports with non-ascii, valid UTF-8, characters (#7511)
* Fix multi-currency migration from SQL-Ledger 3.0 (#7519)
* Fix transaction date of year-end reversals (#6852)
* Save 'Ship To' data on invoices (#7453)
* Fix 'Microfiche' column appearing empty on Goods search (#7558)
Changelog for 1.10.19
* Fix handling of updates with consecutive, exactly equal pages (#7464)
Changelog for 1.10.18
* Fix regression since 1.10.16 upgrading old companies while renaming setting
* Fix selection of default AR/AP accounts while importing databases (#7419)
* Fix error sending AR Aging statements, even though successful (#7428)
Changelog for 1.10.17
* Change workflow timestamps to per-second granularity (from minutes) (#7360)
* Fix workflow actions not being logged despite configuration (#7360)
* Fix deletion of parts groups (#7363)
* Align invoice/order entry between databases with and without parts (#7374)
Changelog for 1.10.16
* Hide CSS files from the theme drop-down which render the app unusable (#7326)
* Improve HTML compliance by moving INPUT tags around inside TABLE tags (#7323)
* Fix addition of second and further make/model rows in parts (#7346)
* Fix typo in setting name (#7337)
Changelog for 1.10.15
* Fix failure to save GL template transactions due to number formatting (#7302)
Changelog for 1.10.14
* Fix e-mail addresses on aging statement mails (#7235)
* Fix error popup after successfully sending aging statement mail (#7242)
* Fix 'cleared balance' on overlapping approved reconciliations (#7244)
Changelog for 1.10.13
* Aging reports per account; do not all entity invoices (#7177)
* Follow up to Print buttons fix -- Dojo doesn't support 'async') (#7131)
* Fix JOIN in 'all_managers' stored procedure (#7201)
* On CoA, Service, Goods and OOverhead import, hide transaction fields (#7212)
* Fix cloning companies being dependent on PG* environment vars (#7220)
Changelog for 1.10.12
* Random errors reported at the bottom of invoices without good reason (#7144)
* Asset disposal results in asset of disposed amount (#7143)
* Third address line on entity screen not saved for credit accounts (#7127)
* Print buttons call removed function (#7151)
* Empty inventory reports don't show in searches (#2661)
* Error thrown while mailing AR aging statements (#7158)
* CSV batch import fails due to incorrect function name (#7160)
* Align SQL setting-increment function with Perl implementation (#7186)
* Transaction Approval > Drafts doesn't set workflow state to POSTED (#7170)
* Order number filter on invoice search ignored (#7178)
* Fix notes from orders being on wrong invoice line (#7179)
Changelog for 1.10.11
* Stricter allowance for non-uniquely reconciled lines during migration (#7078)
* Rounding crash in reports with huge numbers (#7100)
* Unbalanced fixed asset disposal (through sale) transaction (#5180)
* Correctly show populated reconciliation after bank statement upload (#6183)
* CSV imports throwing a 'missing function' error (#7108)
* Restore logging into the default company entering the name (#7114)
* Addresses not aligning correctly with labels in some cases (#7117)
* <ENTER> not triggering login from input fields on login page (#7121)
Changelog for 1.10.10
* Don't show obsolete accounts in account drop-downs (#7061)
* Focus the first empty line on Update in AR, AP, Orders and Quotes (#1584)
* Correct alignment in HTML income statement and balance sheet (#7074)
* Improved layout of balance sheet and P&L reports for hierarchical CoA (#7086)
* Fixed database creation and upgrades failing for non-superuser admin (#7073)
Changelog for 1.10.9
* Various fixes to make tax forms work (#7037 and #7040)
* Fix error when retrieving template GL transactions (#7030)
* Fix borders on sort order drop-down in reconciliation screen (#7052)
* Fix report-sorting dropping results on each sort for some searches (#7057)
Changelog for 1.10.8
* Fix rendering performance of search results on Chrome-based browsers (#7018)
* Improve request performance by loading document formatters on server startup
* Improve invoice/order/quote performance by caching output formats
* Reduce the number of database queries retrieving 'decimal_places'
Changelog for 1.10.7
* Fix 'remaining life' for monthly depreciation in fixed assets (#6563)
* Fix new account configuration missing drop-down values and checkmarks (#7007)
* Fix various buttons in payment and customer screens (#7010)
* Fix alignment on Contact screen address, contact info and notes tabs (#7012)
Changelog for 1.10.6
* Fix serial numbers from orders being on wrong invoice line (#6979)
* Fix searching on quotation numbers in quote searching (#6988)
* Remove negative feedback in password change while typing passwords (#6991)
* Fix failing password resets resulting in a technical error (#6995)
* Fix changing passwords from user preferences page (#6978)
Changelog for 1.10.5
* Fix populating e-mail screen when mailing orders (#6956)
* Populate 'memo' instead of 'source' when applying payment discount (#6943)
Changelog for 1.10.4
* Fix AR/AP transactions posted, not saved, with separation of duties (#6932)
Changelog for 1.10.3
* Fix 'New' button on invoice and transaction screens (#6893)
* Fix UTF-8 character handling calling into old code (#6897)
* Fix database upgrades based on demo dataset (#6879)
* Remove stray double quote and curly character in purchase invoice (#6905)
* Fix regression preventing cross-yearend pnl reporting (#6386)
* Catch and report errors from updating pages (#6906)
* Fix invoice and order screens breaking on 'min empty lines' > 1 (#6911)
Changelog for 1.10.2
* Fix multiple uploads through the [Attach] link failing (#6855)
* Fix '<< Return' link on the e-mail screen being broken in some cases (#6858)
* Improve query performance by declaring stored functions STABLE (#6872)
* Fix manual tax entry unavailable on saved invoices (#6791)
* Fix added line being dropped from invoice while deleting another (#6788)
Changelog for 1.10.1
* Fix batch details screen failing to load (#6850)
* Update 1.10.0 Perl dependency changes in Changelog
* Fix taxes wrong taxes being applied to invoices (#6857)
* Fix HTML-encoding values on (PDF) printed documents (#6861)
Changelog for 1.10.0
Added functionalities
* Example hierarchical chart of accounts, US General
* Ability to delete user login accounts (#1135)
* SysV init script for managing 'starman' process (#6455)
* US/Washington tax module, doubling as an example for custom modules
* Customer address data passed to Tax modules
* Support for custom Tax modules adding a Source value on output lines
* Possibility to add Vue component based pages
* User-modified workflows through "custom_workflows" config path setting
* Increased configurability by using dependency injection instead of configuration
* Default printer selection supports 'Screen' as default output location
* Default page size for PDFs selectable through System > Defaults
* Support for Right-to-Left (RTL) languages
* Ability to download all document templates as a zip file (#1931)
* Added 'Currency', 'FX Debits' and 'FX Credits' columns to GL report (#3999)
* Attachments to reconciliations, e.g. bankstatement PDFs
Changed functionalities
* Overpayment section in payment screen hidden on missing configuration (#2512)
* Batch AR/AP upload changed to support foreign currency transactions
* Line description on AR/AP transactions renamed to 'linedescription' (#6482)
* Some existing pages (including login.pl) converted to Vue.js v3
* INI-format configuration file replaced by YAML dependency injection file
* Localization of setup.pl & login.pl based on browser preferences
* Some variables in document templates (e.g. 'company_name') renamed (#6672)
* Simplified and fixed 'display_report.tex' and 'dynatable.tex' templates (#6676)
Removed functionalities
* HTML 'accesskey' attribute, based on WebAIM.org guidance
* DojoToolkit's TableContainerWidget converting its use to CSS3 Grid
* Dependency on 'zip' program; replaced by dependency on Archive::Zip
* Broken 'auth' config key for user authentication provider configuration
* Unused config keys:
* force_username_case (section: main)
* check_max_invoices (section: main)
* dojo_theme (section: main)
* dojo_unbuilt (section: debug)
* Template set 'xedemo'; functionality merged into 'demo' templates
Bugs fixed
* Tax incorrect on existing invoice after customer tax status change (#2322)
* Better logging on authentication failure
* Full support for running from a schema other than 'public'
* Printing checks fails to include invoices on the check's voucher (#6253)
* Languages in language selection drop down now in user's language (#6289)
* Tax module initialization, in support of the US/Washington implementation
* B/S and PnL PDF templates cleaned up and alignment fixed
* Aging statements language selector restored (#6353)
* Multiple aging statements generation and e-mailing restored (#6353)
* Default printer selection in user preferences restored
* Template 'display_report.html' doesn't depend on 'ui-header' anymore (#6672)
Code cleanup
* Fewer warnings from old code
* Start changing client to use Vue3, vue-router and vue-i18n
* Remove unused defaults table settings 'revtrans', 'yearend' and 'closedto'
* Complete replacement of Log::Log4perl with Log::Any in library code
* Remove unused UI templates
* Simplify non-UI templates created from UI templates, removing UI remnants
* Encapsulate Dijit (Dojo) widgets in Web Components / Custom Elements
* Remove unused Dijit widget(s)
* Use more idiomatic Template Toolkit coding style for templates
* Remove duplicated (buggy) function from sql/moduls/Parts.sql
Dependency updates
* Perl 5.32 (updated from 5.24)
* Dojo and Dijit 1.17.2 (from 1.16)
* PostgreSQL 13 (updated from 10)
* PGObject 2.3.2 (updated from 2.2.0)
* PGObject::Simple 3.1.0 (updated from 3.0.2)
* PGObject::Simple::Role 2.1.1 (updated from 2.0.2)
* PGObject::Util::DBAdmin 1.6.1 (updated from 1.4.0)
* Workflow 1.59 (upadted from 1.56)
* YAML::PP (new)
* YAML (dropped)
* Version::Compare (dropped)
* JSONSchema::Validator (new)
* Locales (new)
* HTTP::AcceptLanguage (new)
* HTTP::Negotiate (new)
* Beam::Wire (new)
* Archive::Zip (new)
Changelog for 1.9 Series
Released 2021-09-24
Changelog for 1.9.30
* Fix check for missing GIFI on SQL-Ledger migration (#7501)
* Fix CSV import failure on non-ascii, but valid UTF-8, character (#7512)
* Fix transaction date on year-end reversal (#7540)
* Save 'Ship To' selection on invoices (#7546)
* Fix 'Microfiche' appearing empty on Goods search (#7559)
Changelog for 1.9.29
* Fix regression since 1.9.27 upgrading old companies while renaming setting
* Fix selection of default AR/AP accounts while importing databases (#7419)
Changelog for 1.9.28
* Fix deletion of parts groups (#7363)
* Align invoice/order entry between databases with and without parts (#7374)
Changelog for 1.9.27
* Hide CSS files from the theme drop-down which render the app unusable (#7326)
* Improve HTML compliance by moving INPUT tags around inside TABLE tags (#7323)
* Fix addition of second and further make/model rows in parts (#7346)
* Fix typo in setting name (#7337)
Changelog for 1.9.26
* Fix failure to save GL template transactions due to number formatting (#7302)
* Fix JOIN in 'all_managers' stored procedure (#7201)
Changelog for 1.9.25
* Random errors reported at the bottom of invoices without good reason (#7144)
* Asset disposal results in asset of disposed amount (#7143)
* Third address line on entity screen not saved for credit accounts (#7127)
* Empty inventory reports don't show in searches (#2661)
* Align SQL setting-increment function with Perl implementation (#7186)
* Order number filter on invoice search ignored (#7178)
* Fix notes from orders being on wrong invoice line (#7179)
Changelog for 1.9.24
* Don't show obsolete accounts in account selection drop-downs (#7062)
Changelog for 1.9.23
* Various fixes to make tax forms work (#7037 and #7040)
* Fix borders on sort order drop-down in reconciliation screen (#7052)
Changelog for 1.9.22
* Fix rendering performance of search results on Chrome-based browsers (#7018)
* Improve invoice/order/quote performance by caching output formats
* Reduce the number of database queries retrieving 'decimal_places'
Changelog for 1.9.21
* Fix 'remaining life' for monthly depreciation in fixed assets (#6563)
* Fix new account configuration missing drop-down values and checkmarks (#7007)
Changelog for 1.9.20
* Fix serial numbers from orders being on wrong invoice line (#6979)
* Fix searching on quotation numbers in quote searching (#6988)
* Remove negative feedback in password change while typing passwords (#6991)
Changelog for 1.9.19
* Fix UTF-8 character handling calling into old code (#6998)
* Fix regression preventing cross-yearen PNL reporting (#6386)
* Fix invoice and order screens breaking on 'min empty lines' > 1 (#6926)
Changelog for 1.9.18
* Fix '<< Return' link on the e-mail screen being broken in some cases (#6858)
* Improve query performance by declaring stored functions STABLE (#6872)
* Fix added line being dropped from invoice while deleting another (#6788)
Changelog for 1.9.17
* Fix HTML-encoding values on (PDF) printed documents (#6861)
* Fix removal of invoice line breaking entire UI interaction (#6807)
Changelog for 1.9.16
* Support for PostgreSQL 14 for databases upgraded from pre-1.9.15
Changelog for 1.9.15
* Fix invoices randomly being incorrectly voided (#2321)
* Fix response status code checks to correctly roll back on error (#6586)
* Fix incorrect template delimiters in 'templates/demo/*.html' (#6659)
* Fix Changelog for 1.9.14 - add two missing entries
Changelog for 1.9.14
* Fix reconciliation for multiple payments with the same Source (#6526)
* Fix reconciliation for payments with GL corrections (#6533)
* Fix GIFI account numbers not presented in the balance sheet report (#6520)
* Fix typo in the invoice TeX templates: acrue -> accrue (#6532)
Changelog for 1.9.13
* Fix line descriptions missing on AP transaction prints (#6482)
Requires templates update.
* Support PostgreSQL 14 (#6500)
* Fix saving of vendor invoices (#6507)
* Allow deletion of transactions with shipto address (#6509)
Changelog for 1.9.12
* Fix CSV export regression since 1.9.8 throwing an error (#6474)
* Remove runtime Javascript dependencies with security issues [CVE] (#6475)
* Fix tax form details reports throwing an error (#6458)
Changelog for 1.9.11
* Fix Goods > Search filters to honor selected part type (#6428)
* Update invoice creation date when posting recurring invoices (#6432)
* Fix double-counting of lines with business units in the trial balance (#6402)
Changelog for 1.9.10
* Second fix for sending e-mail due to the incompatibility in Workflow 1.59
Changelog for 1.9.9
* Fix sending e-mail due to an incompatibility in Workflow 1.59 (#6413)
Changelog for 1.9.8
* Fix regression in editing e-mail fields being discarded (#6168)
* Fix regression in CSV download report being mostly empty (#6389)
* Fix authentication failure returning incorrect HTTP error number (#6380)
Changelog for 1.9.7
* Fix clearing To/Cc/Bcc/... fields which were cleared in the UI (#6168)
* Fix invoice amounts for invoices generated from orders (#6125)
* Fix saving purchase orders as invoices (#6341)
* Require gain/loss account setup to post FX transaction payments #6360)
* [DATALOSS] Fix deletion of any batch removing payment information (#6368)
Changelog for 1.9.6
* Populate more fields in batch approval details report (#6271)
* Fix error when posting an invoice created from an order (#6280)
* Fix saving invoices and transactions as part of vouchers (#6327)
* Fix printing batch details from batch details approval screen (#6324)
Changelog for 1.9.5
* Fix correct AR/AP account being selected on Update and when editing (#6191)
* On date-entry, add the separator character immediatly when possible (#6121)
* Fix the end date on credit accounts being shown correctly (#6235)
* Fix calculation of credit limit remaining shown on transactions and invoices
* Fix credit limit remaining calculation for foreign currency transactions
* Extend AR/AP batch import to support multi currency imports (#6250)
* Fix login errors being hidden behind an "insecure response" error (#6251)
* Fix deletion of unapproved batches failing (#6252)
* Fix GL batch import menu item missing, even with appropriate permissions (#6248)
Changelog for 1.9.4
* Fix balance sheet printing template listing account descriptions (#6203)
* Fix reconciliations to include Source value from transactions (#6122)
* Fix error thrown from CSV export function (#6140)
* Fix reporting of login problems due to e.g. version mismatch (#5976)
* Fix 'import' of username on HR > Employee menu | User tab (#5287)
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)
Changelog for 1.9.2
* Fix sending mail with multiple Bcc addresses (#6087)
* Fix manual taxes on credit invoices (#5721)
* Add missing account configuration on Sales account (#6100)
* Fix Update clobbering invoice header data (e.g. fx rate) (#6114)
Changelog for 1.9.1
* Fix license declaration in package.json (gpl-v2.0-or-newer)
* Fix scrollbars in the main window overlapping with real content (#5874)
* Fix 'setup.pl' to work with Safari for creation of new data sets (#6016)
* Fix no payment lines shown after saving invoices and transactions (#6017)
* Fix e-mailed invoices not being sent to Bcc addresses
* Add support for workflow overrides
* Add a list of available e-mail variables for expansion
* Restore e-mail body variable expansion (#6042)
* Add example Chart of Accounts with hierarchy (US General based) (#6057)
* Fix SQL date errors using date formats other than yyyy-mm-dd (#6040)
* Fix default to/cc/bcc addresses not applied to e-mail (#6045)
* Correctly present password experation in preferences (#6067)
* Fix initialization of 'current earnings' setting from CoA XML
* Correctly select the default country on Contact address entry (#6058)
* Correctly set parent of CoA headers when loading from XML (#6068)
Changelog for 1.9.0
Added functionalities
* List of countries in preferences now translated
* Database used for authentication in setup.pl now configurable (auth_db)
* Database used to query system characteristics now configurable (admin_db)
* Add link to customer screen from invoice entry
* Add option to search by customer/vendor name on payments search
* Command line application for administrative tasks (bin/ledgersmb-admin)
* Emailed documents are added to the database as attachments
* Orders and invoices show change history
* Login pages show a warning when using an unsupported/obsolete browser
* On the payment/receipt screen, show invoice descriptions when available
Changed functionalities
* Improved error reporting on Print button with template evaluation failure
* Faster HTML response generation (optimized HTML preprocessing)
* `demo_with_images` document template set merged with standard `demo` set
* JavaScript now built using WebPack (no longer using Dojo's build only)
* Report filters and account settings hide GIFI when not configured
* Invoice 'Save Info' now saves changes to 'Salesperson'
* Add option to report opening or closing balance on balance sheet
* Chart of Accounts examples converted to XML (from SQL)
* Emailed invoices use data from the database instead of the screen
* No longer show "Print and Save (as new)" buttons when no printers configured
* Migrated to new test driver Yath (Test2::Harness), from `prove`
* Script `bin/drop-roles` replaced by `bin/ledgersmb-admin destroy` command
* Add `samesite` policy to the authentication cookie for modern browser support
Removed functionalities
* Configuration setting 'Only Timeout Locks' removed
Bugs fixed
* Clicking 'Update' no longer clobbers saved invoices and transactions
* Optimize listing of configured currencies (don't check in-use)
* Optimize balance sheet report (use balance snapshots from period closing)
* Fixed mailing of aging reports (regression since 1.3.42)
* Default CoA referential integrity and consistency
* Templates in setup.pl appearing in changing, random order
* Fix type problems due to BigFloat being downgraded to BigInt
* Parts search filter screen needs better layout
* Value selection on non-required select can be undone by selecting empty item
* Update menu to selected language after preferences save
* SIC value is free entry instead of selection from configured SIC list
* Back button steps back along the various form submissions intuitively now
* Inconsistent approval status between unapproved transactions and its lines
* Shipping screen 'Done' button no longer complains about the server response
* Orders and Quotes 'Save as new' saves using a new order/quote number
Code cleanup
* Remove use of LedgerSMB::Company_Config global state (excepf from PGNumber)
* Align HTML templates between `demo` and `xedemo` document template sets
* Clean up and align XeLaTeX vs LaTeX(pdflatex) document template sets
* Centralize database connection set-up
* Reformat UI HTML templates & HTML5 upgrade (from 4.01 Transitional)
* Simplify UI HTML template libraries elements.html & dynatable.html
* Stop using LedgerSMB::Sysconfig global variables (use functions instead)
* Initialize LedgerSMB::Sysconfig & ::Locale explicitly (no init-on-startup)
* SQL data types aligned (pnl vs balance, fixed assets)
* Code cleanup reducing the number of warnings in the server logs
* Dead code removal from old/ code
* Removal of licence-incompatible code in utils/lib/
* Performance tuning of UI template handling code
* Integrate JS code of main app page better by making it a Dojo widget
* User preferences are now stored using a row-based structure instead of columns
* Lots of changes to make CI testing work on GitHub Actions
* Enable `dependabot` to keep JavaScript dependencies up-to-date
Dependency updates (Perl)
* perl 5.24 (updated from 5.20)
* Hash::Merge (new)
* Locale::CLDR::* (new)
* Locale::Country (dropped)
* Locale::Language (dropped)
* Log::Any (new)
* Log::Any::Adapter::Log4perl (new)
* MooseX::ClassAttribute (new)
* PGObject 2.2.0 (updated from 2.0.2)
* PGObject::Util::DBAdmin 1.4.0 (updated from 1.0.1)
* Pod::Find (new)
* Syntax::Keyword::Try 0.15 (new)
* Try::Tiny (dropped)
* URI::Escape (new)
* Workflow (new)
* YAML (new)
Changelog for 1.8 Series
Released 2020-09-04
Changelog for 1.8.31
* Support for PostgreSQL 14 for databases upgraded from pre-1.9.15
Changelog for 1.8.30
* Fix invoices randomly being incorrectly voided (#2321)
* Fix response status code checks to correctly roll back on error (#6586)
Changelog for 1.8.29
* Fix the 1.8 Changelog which had been replaced with the 1.9 Changelog
Changelog for 1.8.28 (not released)
* Fix reconciliation for multiple payments with the same Source (#6526)
* Fix reconciliation for payments with GL corrections (#6533)
Changelog for 1.8.27
* Fix tax form details reports throwing an error (#6458)
* Support PostgreSQL 14 (#6500)
* Allow deletion of transactions with shipto address (#6509)
Changelog for 1.8.26
* Fix double-counting of lines with business units in the trial balance (#6402)
Changelog for 1.8.25
* Fix batch details printing throwing a PSGI error (#6325)
* Fix saving of AR/AP vouchers throwing errors (#6327)
* Fix account initialization in tax calculation module (#6335)
* Require gain/loss account setup to post FX transaction payments (#6360)
* [DATALOSS] Fix deletion of any batch removing payment information (#6368)
Changelog for 1.8.24
* Fix multiple issues with bank account reconciliation (#6122)
* Fix correct AR/AP account being selected on Update and when editing (#6191)
* Fix the end date on credit accounts being shown correctly (#6235)
* Fix calculation of credit limit remaining shown on transactions and invoices
* Fix credit limit remaining calculation for foreign currency transactions
* Fix login errors being hidden behind an "insecure response" error (#6251)
* Fix GL batch import menu item missing, even with appropriate permissions (#6248)
Changelog for 1.8.23
* Use a temp table to prevent bulk payments trampling on each other
* Fix sorting on fixed asset searches (#6151)
Changelog for 1.8.22
* Fix sending mail with multiple Bcc addresses (#6087)
* Fix manual taxes on credit invoices (#5721)
Changelog for 1.8.21
* Prevent draft approval by user without permission (#5984)
* Fix UI consistency (missing CSS class) in purchase invoice (#5988)
* Fix performance problem deleting huge draft transactions (#5993)
Changelog for 1.8.20
* Fix for chart of accounts headings import from CSV (#5987)
* Correctly set the payment account in invoices and transactions (#5801)
* Fix regression in CVE-2021-3693 failing to show errors as popups (#5921)
* Fix regression in CVE-2021-3693 with broken downloads of backups (#5931)
Changelog for 1.8.19
* Follow-up for the fix to CVE-2021-3693; fix bulk-posting payments
* Follow-up for the fix to CVE-2021-3693; fix incorrectly backported change
Changelog for 1.8.18
* Check whether HTML comes from a valid source; CVE-2021-3693
* Apply HTML escaping on error messages; CVE-2021-3694 (#5754)
* Fix several issues in `bin/prepare-company-database` (#5769)
* Prevent the application being wrapped in a frame; CVE-2021-3731
Changelog for 1.8.17
* Align filters between UI and the database on draft transaction search (#5692)
* Correctly present manual tax and invoice total on reversing invoice (#5721)
* Repeatedly saving a draft invoice pops up an SQL error (#5679)
Changelog for 1.8.16
* Fix incorrectly encoded UTF-8 characters on journal entry (#5583)
* Fix multiple updates in payment screen resetting user input (#5614)
* Improve error message when missing cash discount configuraition (#5632)
* Fix payment information for credit accounts which are Persons (#5632)
* Fix memos sometimes being associated with incorrect payment rows (#5646)
* Fix wrong fx value due to formatted exchangerate used in calculation (#5656)
* Fix decimal places setting not applied for AR/AP transactions (#5657)
* Fix duplicated income statement figures due to reversed year end (#5682)
Changelog for 1.8.15
* Improve reconciliation of data entered before migration to 1.8
* Fix AR/AP transaction+invoice 'New' button throwing an error (#5539)
* Fix transaction total in AR/AP transactions with applied payments (#5528)
* Stop doubling of the number of lines in an AR/AP transaction on Save (#5529)
* Fix vendors appearing in the AR customer drop-down and vice versa (#5534)
* Fix second and consecutive Save actions on invoices throwing an error (#5532)
* Only limit Customer/Vendor History by country with explicit filter (#4361)
Changelog for 1.8.14
* Follow-up (fix) to upgrades blocked by files attached to transactions
Changelog for 1.8.13
* Update welcome.html and README, removing FreeNode and updating Element
* Fix double-quoting values in GL transaction 'notes' and 'description' (#5415)
* Fix GL transaction after file attachment showing up empty (#5416)
* Retain AR/AP account across 'Update' on invoices and transactions (#5453)
* Don't drop creation date on AR/AP transactions and invoices from 1.3 (#5417)
* Fix reconciliations incorrectly updated when including new transactions (#5417)
Changelog for 1.8.12
* Improve upgrades in light of files attached to transactions
* Fix 1.3 upgrade breaking on default currency function type
* Fix duplicate key error in upgrade data validation
Changelog for 1.8.11
* Fix Number not updated by 'Save as New' on order and quote (#5358)
* Fix failure to save purchase shipping addresses and contacts (#5289)
* Fix searching and opening saved invoices with gapless AR enabled (#5369)
* Performance improvements through added database indexes
Changelog for 1.8.10
* Fix mail and print options under Schedule on invoices (#5297)
* Disable the broken-on-orders Schedule button on orders (#5295)
* Fix several LedgerSMB 1.3 migration issues
* Fix dates on weekly-entry timecards (#5336)
* Fix descending sort order on reports can't be reversed (#5298)
* Fix individual batch approval lists all batches, not unapproved ones (#4971)
* Fix for #4854 (HTML misalignment, v1.7.19) adds more misalignment (#5298)
Changelog for 1.8.9
* Fix SQL error thrown when partially invoicing an order
* Fix incorrect totals in single payment screen on FX payments (#5223)
* Limit 'Class' drop-down on Accounts tab to supported types only (#5216)
* Fix regression deleting draft invoices/transactions with payments (#5207)
* Fix empty columns when posting a payment batch (#5192)
* Hide 'Payment Type' selector when drop-down empty (#5191)
Changelog for 1.8.8
* Faster GL account tree consistency check
* Maintain consistency between ar/ap/gl and transactions tables on delete
* Fix CSV import of inventory adjustment
* Fix failure to delete unapproved reconciliation reports
Changelog for 1.8.7
* Fix internal server error when creating AR/AP voucher (#5188)
* Fix AP Aging inadvertedly having been dropped from the menu (#5193)
* Fix 'Approved'/'Unapproved' filter in GL search (#5181)
Changelog for 1.8.6
* Fix asset depreciation not being posted (#5174)
* Fix regression invoice conversion from order using order date (#5175)
Changelog for 1.8.5
* Fix failure to post recurring AR/AP transaction (#5152)
* Add horizontal scrolling for wide content (#5156)
* Fix Customer (ECA) Income statement not working (#2501)
* Change GL account selector to sort prefix-matches on top (#3908)
Changelog for 1.8.4
* Fix subtotals not showing on AR/AP outstanding report (#4732)
* Apply default sorting to AR/AP outstanding and transactions reports (#5080)
* Fix failure saving new reporting unit classes with modules checked (#4614)
* Fix failure sorting AR > Search results for filter with spaces (#4872)
* Fix aging detail overview throwing error when generating report (#4018, #3572)
* Fix various aging report problems (#5091)
* Duplicate PDF/HTML format selectors
* 'Date' column in PDF/PS output remaining empty
* 'Select all' functionality fixed (now handled in the browser)
* Fix various payment transaction issues (#5094)
* POST AND PRINT html output on payments screen returned as text (#5077)
* Payment report not containing payment lines
* Remove unavailable PDF and PS output options for POST AND PRINT
* Fix check printing showing random number in amount block (#5078)
* Fix subtotals not working in GL report (#5098)
* Add starting and ending balance to GL report filtered on account (#4985)
* Fix AR/AP transaction applying exchangerate without locale conversion (#4879)
* Fix parts searches failing to filter by serial number (#5107)
* Various sales person related fixes (#5115)
* Fix sales person failing to save on AR/AP Transactions
* Fix sales person selection retained on Update in sales invoice
* Fix loading sales person from database on document retrieval
* Fix upgrades from 1.7 failing on self-created exchange rate types (#5112)
* Fix 'Manager' drop down not populated in employee page (#5125)
* Fix parts lookup on invoice not filtered by entered text (#5138)
* Fix Account contact screen buttons populating customer on invoice/... (#932)
Changelog for 1.8.3
* Fix broken Bcc e-mail support (#5034)
* Fix duplicated sales persons list on order entry (#5035)
* Fix inability to open employee screen under specific circumstances (#5043)
* Fix creation of assets class without required accounts (#4624)
* Fix saving part's customer rate without 'Min QTY' (#4849)
* Fix 'Parent' dropdown empty in Report Unit entry screen (#4625)
* Explain password reset when importing user on company creation (#3249)
* Fix inability to delete business unit class (#4597)
* Fix missing buttons on unsaved invoice in closed period (#4840)
* Fix lengthy errors showing stack dumps (#5072)
* Split description and vendor/customer columns in GL and Drafts reports (#4836)
Changelog for 1.8.2
* Fix AR/AP search sales person not limiting selection (#4604)
* Fix departments dropdown not populated on Receipts/Payments entry (#4636)
* Fix sales person not shown on existing AR/AP transactions (#5004)
* Fix failure to post recurring GL transaction (#4946)
* Resolve conflict between HTML5 and our 'date' INPUT tags (#5016)
* Fix asset screen dropdowns not populating correctly (#5016)
* Fix asset classes not in search output when missing accounts (#5020)
* Fix address-type (Billing, etc) not correctly initialized on edit (#2564)
Changelog for 1.8.1
* Fix incorrect rounding on payments leading to under/overpayment (#4986)
* Fix AR/AP dropdown on transactions not retained after 'Update' (#4927)
* Fix sales order generation from timecards (#4984)
* Better defaults for 'HR > Add Employee' screen (#1672)
* Fix timecard Save feedback screen showing zero quantities (#4982)
Changelog for 1.8.0
Added functionalities
* Upload of logos and use in document templates (#1816)
* New configuration keys in '[mail]' section of ledgersmb.conf (#4378)
* Print templates for PNL, Balance sheet and generic reports now
* User-editable
* Customizable per company
* Stored in the database like all other templates (#811)
* Authentication and session storage through encrypted cookies (#4418)
* CSV upload of parts, services and overhead
* CSV upload of a batch of GL transactions
* Parts searches can be restricted by type (part, service, ...)
* SysV init script template for RedHat/CentOS (#2900)
* Beginnings of a web services API, served at /erp/api/v0 (#4452)
* Import of OFX bank statement files for reconciliation
* New 'migrate-company' command line tool for migrations from 1.2 and 1.3
Changed functionalities
* Payments now first-order data (no longer inferred)
* Removed cash/check/deposit dropdown POS remnant from single payment screen
* Faster loading of the menu
* Faster loading of selected accounts in the GL accounts drop-down
* Faster loading of the goods number and description drop-downs
* New UI for uploading and editing document (print) templates
* Colors of default scheme changed to follow the soft-tone of the Claro theme
* Manual tax lines with 0 (zero) tax and taxable amounts are no longer posted
* Employee 'Wages & Deductions' (experimental) page now hidden until enabled
* Search checkmarks 'Open/Closed' replaced by radio button 'Open/Closed/All'
* Default exchange rates cannot be NULL
* Don't display delete button for in-use currency or exchange rate types
* Harmonized CSS themes; now using CSS3 variables for overall consistency
* Removed support for 2-digit years in date input
* Failed migrations from LSMB1.2/1.3 or SL2.8/3.0 restore original schema
Bugs fixed
* Incorrect calculation of discounts where posting date isn't 'today' (#4505)
* Default dates sometimes off by a day (before or after the current day) (#2587)
* Customers and vendors in parts screen selectable through drop-downs
* Overpayments not shown in Cash > Reports > Receipts (#3577)
* Handling of currencies with short codes or unusual characters (#4435, #4436)
* Formatting of columns in the 'Inventory Activity' report
* Single-entry timecards work again after long-standing regression
* LedgerSMB 1.2 migration fixes and completeness
* Fix reporting units should allow one-per-category but allow multiple (#4654)
Code cleanup
* Refactored company migration logic into a separate module (out of setup.pl)
* Disentangled processing of UI and printed documents
* Replace unnecessary UNION selects on ar/ap/gl by select on transactions
* Remove unmaintained ability from Makefile to install dependencies
* Reduce use of LedgerSMB::App_State and LedgerSMB::App_State::Locale
* Remove legacy infrastructure to generate table-formatted report output
* Moved authentication for 'setup.pl', making it stand-alone
* Removed use of LSMB_ALWAYS_MONEY environment variable
* Replaced 'no strict "refs"' with use of Symbol module
* Removed tables 'fixes', 'menu_attribute' and 'payment_map'
* Removed template functions escape(), tt_url() & UNESCAPE()
* Javascript improvements based on automated code review from lgtm.com
* Remove remnants of custom field support
* Remove unused infrastructure to administer access role groups
* Stricter data model for storage of foreign currency exchange rates
* Stricter data constraints for storage of transactions
* Simplified request handling by
* Making old/bin/old-handler.pl a PSGI app (LedgerSMB::oldHandler)
* Stripping LedgerSMB::Form from anything handled by middleware
* Separating 'setup.pl authentication' into its own middleware
* Remove unused 'queue_payments' and 'poll_frequency' settings
* Remove unsupported, non-functioning scripts for asynchronous bulk payments
* Refactored reconciliation screen logic for easier maintenance
* Removal of dead code
* JavaScript consistency clean-up due to ESLint checks
* Changed UI templates from custom to standard TT delimiters ('[%' and '%]')
Dependency updates
* Perl 5.20 (upgraded from 5.18)
* Dojo Toolkit updated to 1.16.2
* TeX::Encode >= 2.007
* LaTeX::Driver >= 1.0.0
* Authen::SASL (new)
* Cookie::Baker (new)
* Email::Sender (new)
* Email::Stuffer (new)
* Session::Storage::Secure (new)
* String::Random (new)
* MIME::Lite (dropped)
* PGObject >= 2.0.2 (from 1.403.2)
* PGObject::Type::BigFloat >= 2.0.1 (from 1.0.0)
* PGObject::Type::DateTime >= 2.0.2 (from 1.0.4)
* PGObject::Type::ByteString >= 1.2.3 (from 1.1.1)
* XML::Simple (dropped)
Changelog for 1.7 Series
Released 2019-10-04
Changelog for 1.7.41
* Support for PostgreSQL 14 for databases upgraded from pre-1.9.15
Changelog for 1.7.40
* Fix invoices randomly being incorrectly voided (#2321)
* Reduce memory consumption rendering XLSX output (#6483)
Changelog for 1.7.39
* Fix tax form details reports throwing an error (#6458)
* Support PostgreSQL 14 (#6500)
* Allow deletion of transactions with shipto address (#6509)
Changelog for 1.7.38
* Fix batch details printing throwing a PSGI error (#6325)
* Fix saving of AR/AP vouchers throwing errors (#6327)
* Fix account initialization in tax calculation module (#6335)
Changelog for 1.7.37
* Fix login errors being hidden behind an "insecure response" error (#6251)
Changelog for 1.7.36
* Fix manual taxes on credit invoices (#5721)
Changelog for 1.7.35
* Fix for chart of accounts headings import from CSV (#5987)
* Correctly set the payment account in invoices and transactions (#5801)
* Fix regression in CVE-2021-3693 failing to show errors as popups (#5921)
* Fix regression in CVE-2021-3693 with broken downloads of backups (#5931)
Changelog for 1.7.34
* Follow-up to fix for CVE-2021-3693 to fix display of search results
* Follow-up for the fix to CVE-2021-3693; fix bulk-posting payments
Changelog for 1.7.33
* Check whether HTML comes from a valid source; CVE-2021-3693
* Apply HTML escaping on error messages; CVE-2021-3694 (#5766)
* Prevent the application being wrapped in a frame; CVE-2021-3731
* Align filters between UI and the database on draft transaction search (#5693)
* Correctly present manual tax and invoice total on reversing invoice (#5721)
* Repeatedly saving a draft invoice pops up an SQL error (#5679)
Changelog for 1.7.32
* Fix multiple updates in payment screen resetting user input (#5614)
* Improve error message when missing cash discount configuraition (#5632)
* Fix payment information for credit accounts which are Persons (#5632)
* Fix memos sometimes being associated with incorrect payment rows (#5646)
* Fix wrong fx value due to formatted exchangerate used in calculation (#5656)
* Fix decimal places setting not applied for AR/AP transactions (#5657)
* Fix duplicated income statement figures due to reversed year end (#5682)
Changelog for 1.7.31
* Stop doubling of the number of lines in an AR/AP transaction on Save (#5529)
* Fix vendors appearing in the AR customer drop-down and vice versa (#5534)
* Fix second and consecutive Save actions on invoices throwing an error (#5532)
* Only limit Customer/Vendor History by country with explicit filter (#4361)
Changelog for 1.7.30
* Follow-up (fix) to upgrades blocked by files attached to transactions
Changelog for 1.7.29
* Update welcome.html and README, removing FreeNode and updating Element
* Fix double-quoting values in GL transaction 'notes' and 'description' (#5415)
* Fix GL transaction after file attachment showing up empty (#5416)
* Retain AR/AP account across 'Update' on invoices and transactions (#5453)
* Don't drop creation date on AR/AP transactions and invoices from 1.3 (#5417)
Changelog for 1.7.28
* Improve upgrades in light of files attached to transactions
* Fix 1.3 upgrade breaking on default currency function type
* Fix duplicate key error in upgrade data validation
Changelog for 1.7.27
* Fix Number not updated by 'Save as New' on order and quote (#5382)
* Performance improvements through added database indexes
* Fix failure to save purchase shipping addresses and contacts (#5289)