forked from ledgersmb/LedgerSMB
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChangelog
4047 lines (3308 loc) · 176 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.11 Series
Unreleased
Changelog for 1.11.0
Added functionalities
*
Changed functionalities
*
Removed functionalities
*
Bugs fixed
*
Code cleanup
*
Dependency updates
*
Changelog for 1.10 Series
Released 2022-10-08
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.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)
Changelog for 1.7.26
* 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.7.25
* Faster GL account tree consistency check
* Maintain consistency between ar/ap/gl and transactions tables on delete
* Fix CSV import of inventory adjustment
Changelog for 1.7.24
* Fix 'Approved'/'Unapproved' filter in GL Search not working (#5181)
Changelog for 1.7.23
* 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 subtotals not working in GL report (#5098)
* Fix AR/AP transaction applying exchangerate without locale conversion (#4879)
* 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 'Manager' drop down not populated in employee page (#5125)
* Fix Account contact screen buttons populating customer on invoice/... (#932)
Changelog for 1.7.22
* 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)
Changelog for 1.7.21
* Fix AR/AP account dropdown not retained on 'Update' (#4927)
* Fix AR/AP search Employee filter not limiting the result (#4606)
* Fix Departments dropdown not populated on Receipts/Payments (#4636)
* Fix missing sales employee on existing AR/AP transactions (#1015)
* Fix error when posting recurring GL transactions (#4946)
* Fix incorrectly populated dropdowns on Asset screen (#5017)
* Fix conflict between HTML5 and our 'date' INPUT widgets (#5017)
* Fix asset classes with missing accounts not being in search result (#5021)
Changelog for 1.7.20
* Fix Arabic being default language on Account creation (#4439)
* Add Locale::Codes as explicit dependencies after removal from CORE
* Fix invoices opened from payments screen missing CSS (#4890)
* Add date-filter to Draft search filter screen
* Fix amounts filter in Draft search not working (#4929)
* Fix missing accounts in AR/AP transactions using 'Min Empty Lines (#4930)
* Add 'select all' column toggle button to Draft search
* Fix sequences returning 'invnumber' instead of sequence number (#4949)
* Make AR/AP transaction sequence drop-down follow application style
Changelog for 1.7.19
* Fix purchase order HTML template mis-alignment (#4854)
* Fix tax form reports throwing an error when opened (#4881)
* Fix 'missing method "error"' on bulk payments 'Print and Post' (#4780)
* Fix bulk payments cheque/source numbering (#4780)
* Fix error when deleting a template transaction (#4848)
Changelog for 1.7.18
* Fix payment posting due to number formatting errors (#4781)
* Fix payment posting due to date formatting errors (#4794)
* Fix posting reversal of sales invoice after assembly reversal (#4791)
* Fix overpayment reversal failing to post (#4803, #4816)
Changelog for 1.7.17
* Fix reversals of purchases failing to post due to COGS error (#4771)
* Fix assemblies failing to save after 'Update' (#4755)
Changelog for 1.7.16
* Fix migration including NULL and zero exchange rate defaults (#4673)
* Fix AR Outstanding report showing negative taxes (#4688)
* Remove dev-mode server-killing /stop URL (#4705)
* Fix GL journal creation silently inserting 2 'gl' records (#4719)
* Fix sorting hierarchical balance sheet and income statement sections (#4740)
* Update Dojo dependency to 1.15.4
* Add SameSite policy on session cookie to prevent being ignored (#4748)
Changelog for 1.7.15
* Fix tax on invoice differs from search results (#4651)
* Fix COGS for purchased-in-arrears parts (#4658)
* Update Dojo to 1.15.3
Changelog for 1.7.14
* Fix AR/AP account being reset to default on transaction Update-s (#4599)
* Fix CSV, ODS or TXT reports being downloaded without extensions (#4613)
* Fix 'To pay' amount resetting on second updates in single payments (#4633)
* Fix 'Paid' amount incorrect when 'Apply discount' unchecked (#4514)
* Fix income statement failing to filter on invoice reporting units (#4615)
* Fix payment discount not being posted (#4616)
* Fix tax base and amount doubled on printed invoice (#4645)
Changelog for 1.7.13
* Fix listing asset classes throwing an error (#4569)
* Solve failure to create initial user by requiring input (#4525)
* Fix links at the bottom of the CoA screen (#4568)
* Fix CoA export (ODS, XLS or XLSX) throwing malformed XML error (#4580)
* Fix downloaded reports missing extension (e.g. '.pdf') (#4584)
* Improve performance of deleting batches (#4449)
* Fix error thrown when opening reporting unit 'edit' screen (#4592)
* Fix transdate being NULL in journal lines from bulk payments (#4587)
Changelog for 1.7.12
* Reconciliation reports list now shows usernames rather than user ids (#4388)
* Single payment interface throws error without open invoices (#4529)
* Fix CSV data imports discading the first row (#4567)
* Improve Chart of Accounts import no longer discards heading (#4567)
Changelog for 1.7.11
* Fix inventory adjustments failing to update balances (#4467)
* Fix inability to delete individual vouchers from a batch (#4448)
Changelog for 1.7.10
* Fix error displaying NULL exchange rates (#4438)
* Fix incorrect receipt totals due to number formatting (#4441)
* Prevent re-approval of approved inventory adjustment (#4458)
* Fix NULL transaction dates in inventory adjustment (#4463)
* Fix alignment of numbers in Inventory Activity report (#4454)
* Fix variance calculation on reconciliation report (#4486)
* Fix CSV import through explicit version on HTTP::Headers::Fast dependency
Changelog for 1.7.9
* Fix authentication issue due to inconsistent cookie handling (#4380)
* Fix delete access for SIC codes (standard industry code) (#4391)
* Fix SL 3.0 migration of assemblies (#4386)
Changelog for 1.7.8
* Upgrade Dojo dependency to 1.15.1
* Load the template from the database when printing receipts
* Prevent dead-locks in response to request from timed out session
* Add monetary formatting to payments/receipts screen and report
Changelog for 1.7.7
* Fix currency column not being available in the parts screen
Changelog for 1.7.6
* Disallow rate entry for the default currency (#4236)
* Fix formatting on-hand (OH) column on orders to follow user settings (#3334)
* Fix UI translation other than the menu, regressed from 1.6 (#4293)
* Fix missing 'Entered At' date in contact notes (#2822)
* Fix removal of lines from orders and vendor invoices on entry (#3703)
Changelog for 1.7.5
* Fix failure to save tax forms (#4252)
* Fix failure to undo database edits when surrounding code fails (#4253)
* Allow uploads of files with MIME types unavailable in the database (#1949)
* Fix failure to render (AR/AP) aging report (#4259, #4260)
* Separate authentication domains for setup.pl and login.pl (#4247)
Changelog for 1.7.4
* Fix COGS failure when posting AP invoice reversal (#4218)
* Include first transaction on account in reconciliation (#4221)
* Fix error on reconciliation when no prior balance available (#4224)
* Fix SQL write access error when posting fixed assets disposal (#4230)
* Correctly calculate the tax basis amount even for 0% taxes ($4240)
Changelog for 1.7.3
* Fix regression in fixed assets module due to Multi Currency support (#4195)
* Fix 'constraint not deferrable' error in fixed assets disposal (#4195)
* Stop posting manual tax lines with zero amount and zero base amount (#4196)
* Fix incorrect currency setup error on 'Update' in part screen (#4198)
* Fix occasional COGS error on invoice posting (#4200)
* Fix occasional COGS error on invoice reversal posting (#4213)
* Fix regression with missing download links on reports (#4206)
Changelog for 1.7.2
* Fix invoice screens crashing on manual tax with 0% tax rate (#4176)
* Fix manual tax lines posted on current instead of transaction date (#4180)
* Fix default currency invoice sometimes failing to save (#4184)
* Fix SQL error in reversal of services in AP invoice (#4190)
Changelog for 1.7.1
* Generate unique names for backups
* Fix tax checkmarks in contact screen sometimes being selected after save
* Fix tax accounts inclusion in posted AR/AP transactions
* Fix SQL error when running trial balance report
* Fix assets and expenses with incorrect signs in GIFI balance and PnL
Changelog for 1.7.0
New functionalities
* Deletion of template transactions (Nick P)
* Transaction date now part of purchase history report (Chris T)
* UI allows addition and removal of custom `account_link` flags (Nick P)
Improved foreign currency support
* Multiple rates per day per currency (Erik H)
- Reversing a transaction from a closed-period on a day with different rate
- Bank transfers with different banks on the same day with bank's fx rate
- Migration from systems which support per-transaction or per-line fx rates
* Multiple currencies in a single general ledger transaction (Erik H)
- Posting an opening balance with all currencies in 1 transaction
- Transferring between foreign currencies on e.g. Paypal in 1 transaction
* Fixed copying of invoice copies fx rate without option to change (Erik H)
* UI showing foreign and default currency amounts in transactions (Erik H)
Quality Assurance
* Expanded checks and resolutions for schema changes (Erik H)
* Testing infrastructure and tests for schema change checks (Erik H)
* Ensure correct dependency declaration (RequireExplicitInclusion critic policy)
* POD documentation structure improvements, with automated checks (Erik H)
* Expanded BDD tests, including payments, batches and approval (Nick P, Erik H)
Code cleanup
* Removed deprecated 'custom table' and 'custom field' tables (Erik H)
* Reduce dependencies on deprecated LedgerSMB::App_State (Nick P)
* Simplified deprecated LedgerSMB::PGOld (Nick P)
* Remove unused LedgerSMB::DBObject and LedgerSMB::PGOld methods (Nick P)
* Remove unused configuration settings in ledgersmb.conf (Erik H)