-
-
Notifications
You must be signed in to change notification settings - Fork 150
/
Changelog
4560 lines (3639 loc) · 195 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.12 Series
Unreleased
Changelog for 1.12.0
Added functionalities
* AR/AP transaction history similar to invoices (#7773)
* More consistency checks in setup.pl (#7649)
* Ability to include documentation in Chart of Account definition files (#7651)
* Highlighting of unapproved payments on invoices and transactions (#7777)
* Enhancements for migrations from 1.3 through 1.7 (#7794)
* Enhancements for migrations from 1.3 through 1.5 (#7795)
* Enhancements for migrations from 1.3 (#7793)
* Experimental Orders API (#8084)
* Persistence of calculated taxes on orders and quotes (#8038)
Changed functionalities
* Default cookie names no longer include LedgerSMB version number (#7639)
Removed functionalities
* 'Class' removed from Company and Person entry and search (#8086, #8087)
Bugs fixed
* Invoices from batch printed even though not paid (#7761)
* Countries in setup.pl from Locale::CLDR; use reference data instead (#7648)
* Correctness of HTML pages, now includes 'html' closing tag (#7784)
* JavaScript dependencies versus dev-dependencies (#8028)
* AR/AP items in vouchers can be saved only once (#6895)
* Accounts marked for reconciliation can't be deleted (#7805)
* Transactions and invoices with attachments can't be saved (#6018)
* Aging statement shows functional instead of foreign currency amounts (#2162)
Cleanup & architecture improvements
* Reference data factored out of database schema (#7648)
* Removed global state LedgerSMB::App_State::User (#7876)
* Moved Order/Quote state into separate process (#7908)
* Move PostgreSQL SERIAL to GENERATED BY DEFAULT (#8047)
Updated dependencies
* Email::Sender (minimum increased to 2.601)
Changelog for 1.11 Series
Released 2023-10-03
Changelog for 1.11.11
* Fix 'not set up for hierarchy reporting' on Entity Account screen (#8065)
* Fix date format presentation misalignment with placeholder (#7983)
* Fix order of comparison periods in PNL and B/S (#7800)
* Fix handling of discounts in invoice API (#8030)
* Restore Hebrew 'nplurals' setting back to 4
* Enable scroll bars on setup(upgrade) data fix screens (#8071)
Changelog for 1.11.10
* Fix upgrades from older Pg versions with the 'cash_impact' view (#7987)
* Fix missing locale parameter creating GL Search report (#7997)
* Fix setup.pl CSRF regressions (#8007, #8000)
* Fix date filters on Cash > Receipt/Payment (#8015)
Changelog for 1.11.9
* Add missing batch and entity sequences to the Defaults screen (#7965)
* Stop warning during startup without configuration file (#7928)
* CVE-2024-23831: CSRF attack on 'setup.pl'
Changelog for 1.11.8
* Fix changing Taxform checkmark after posting AR/AP transactions (#7894)
* Restore customer/vendor name on PNL drilldown after GL column change (#7895)
* Fix formatting of amounts on AR/AP search results (#7896)
* Fix import of CoA csv with non-empty 'links' field (#7912)
* Explicitly set foreground color on dark backgrounds in blue theme (#7875)
* Fix screens, e.g. contacts, impacted by rename of 'action' parameter (#7918)
Changelog for 1.11.7
* Fix creating an invoice from an order (#7855)
* Retain partsgroup selection on Update in parts screen (#7848)
* Fix missing columns on trial balance 'Ending' report type (#7870)
Changelog for 1.11.6
* Fix 'Current earnings' not showing in the balance sheet report (#7785)
* Fix saving headings of headings (#7802)
* Fix saving unused accounts configured for reconciliation (#7805)
* Fix 'delete' link shown in CoA screen on accounts used with parts (#7812)
* Fix deletion of parts (#7811)
Changelog for 1.11.5
* 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)
* Add missing AR/AP workflow context creation in 1.10->1.11 migration (#7765)
* Show workflow based AR/AP transaction history, same as on invoices (#7774)
* Fix approval of payment/receipt batches (#7771)
Changelog for 1.11.4
* Show database and user name in setup.pl consistency result screen (#7714)
* Fix AR/AP transaction Reverse button (#7719, #7717)
* Fix invoices created from API to be in SAVED state (#7733)
* Fix 'New Window' menu item throwing an error (#7735)
* Fix Parts > Group > Add throwing 'Group missing!' (#7737)
Changelog for 1.11.3
* Fix typo to make 'Copy to New' button work on GL screen (#7675)
* Minimum PGObject::Type::BigFloat version resolving Math::BigFloat issue (#7704)
* Show posted AR/AP transaction after Post instead of 'Draft posted' (#7701)
* Consistency 'New button in GL/AR/AP screens in SAVED + POSTED states (#7702)
Changelog for 1.11.2
* Fix trial balance drill down showing partial results (#7657)
* Specify Locale::CLDR minimum version to fix numbers shown as 'HASH()' (#7671)
Changelog for 1.11.1
* API documentation lists incorrect version in cookie name (#7640)
* Further Math::BigFloat fixes (combined with Locale::CLDR) (#7646)
* Order/Quote can't be deleted due to unconfirmed prior deletion (#7654)
* Fix syntax error in consistency check and add two new ones (#7650)
Changelog for 1.11.0
Added functionalities
* Reclassification of negative assets to liabilities and vice versa (#7389)
* AR/AP invoice history shows more actions, user and timestamp (#5873)
* Bank statement parser for reconciliation through configuration (#7050)
* System > Users menu item listing users in the company (#7032)
* More webservice APIs (#7056, ...)
* Total paid and Remaining balance summaries added to invoices (#7130)
* Configurable directories (UI, workflows & sql) (#7236, #7250, #7251)
* Tracking of user name in AR/AP/GL history (#5023)
* Printing of GL and cash transfer transactions (#7310)
* Barcode support added on invoices (regressed since 1.5) (#1584)
* Loading template-sets with 'ledgersmb-admin template load-all' (#7367)
* Database restore to user-specified schema with ledgersmb-admin (#7259)
* GL transaction notes editable after posting (#7517)
* Cross-referencing reversed and reversing transactions (#6715)
* Shipto* variables added for expansion in invoice e-mails (#7543)
* SQL Ledger and Ledger123 migrations for SL versions prior to 2.8.4
Changed functionalities
* Fresh new application logo and login page layout (#7317, #7319)
* More database statistics reported after upgrade completion (#7017)
* System > Sequences lists next value for consistency with Defaults (#7054)
* Posted transactions show as read-only to differentiate from saved ones
* Improve migration of not-the-latest LedgerSMB 1.3 databases
Removed functionalities
* Reconciliation file parser customization (#7050)
* Inaccessible (partially duplicated) Colombian reports (#7138)
* Customization through import of 'scripts/custom/*.pl' (#7138)
Bugs fixed
* Performance fixes for stored procedures being slow on huge databases (#7072)
* Multiple fixes on AR/AP template transactions
* Command 'setup' of ledgersmb-admin erroneously marked unimplemented (#7367)
* Broken SQL-Ledger 2.8 and Ledger123 migration
Code cleanup & architecture improvements
* Continued removal of code based on the DBObject coding paradigm
* Removed unused 'entity_id' and 'till' fields from AR and AP tables (#7390)
* Removed broken autoselection of last-used customer/vendor (#7527)
* JavaScript unit tests built on Jest
* Factoring AR/AP/GL process into separate state
* 'ledgersmb-common.css' moved from UI/css/ to UI/css/global/ (#7316)
* Database data consistency checks in setup.pl (#7265)
* Architecture Decision Record (ADR) repository added
* Detach JavaScript front-end build from repository root
* Resolve naming conflict on 'action' between URL and form parameters
* Continued migration of table-based pages to CSS Grid (#7344)
* Output HTML generator (for UI) configurable with dependency injection
* Vue UI state managed by state machines
Dependency updates
* Countless JavaScript dependency updates
Changelog for 1.10 Series
Released 2022-10-08
Changelog for 1.10.33
* Enable scroll bars on setup(upgrade) data fix screens (#8071)
* Fix 'not set up for hierarchy reporting' on Entity Account screen (#8056)
* Fix order of period comparisons in PNL and B/S (#7800)
* Fix recurring transactions after setup.pl CSRF mitigation (#8042)
* Revert Hebrew 'nplurals' back to 4
Changelog for 1.10.32
* Fix upgrades from older Pg versions with the 'cash_impact' view (#7987)
* Fix missing locale parameter creating GL Search report (#7997)
* Fix setup.pl CSRF regressions (#8007, #8000)
* Fix date filters on Cash > Receipt/Payment (#8015)
Changelog for 1.10.31
* Fix GL transaction entry regressed from 1.10.29 (#7984)
Changelog for 1.10.30
* Add missing batch and entity sequences to the Defaults screen (#7965)
* Stop warning during startup without configuration file (#7928)
* CVE-2024-23831: CSRF attack on 'setup.pl'
Changelog for 1.10.29
* Fix formatting of amounts in AR/AP search results (#7896)
* Explicitly set foreground color on dark backgrounds in blue theme (#7875)
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)
* Stricter database schema to ensure reconciliation correctness (#2485)
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 (End of Life)
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 (End Of Life)
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)