forked from timschofield/webERP-svn
/
Change.log
4745 lines (4509 loc) · 482 KB
/
Change.log
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
webERP Change Log
10/2/18 PaulT: Remove $db parameter from all GetStockGLCode() functions.
10/2/18 PaulT: Remove variables left behind from 7944 commit.
9/2/18 PaulT: MRPReschedules.php, MRPShortages.php: Use DB_table_exists() from commit 7943 to replace table check query.
9/2/18 PaulT: Remove the last of the remaining URL 'SID' references.
9/2/18 Paul Becker (PaulT commit): StockLocMovements.php, StockMovements.php: Add serial number column to output. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8088)
9/2/18 Paul Becker (PaulT commit): InternalStockRequestFulfill.php: Add controlled stock handling within this script. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8086)
9/2/18 Tim/PaulT: MRPPlannedPurchaseOrders.php, MRPPlannedWorkOrders.php: Fix conversion factor matter noted by Tim, use DB_table_exists() from commit 7943 to replace table check query, and minor rework to 'missing cell' handling from commit 7939.
9/2/18 PaulT: Replace old method of table row alternating color handing with improved CSS. Also, this change removes some empty/unused properties from a few css file and removes old URL 'SID' references in files already modified for this commit. Due to SVN issues with TestPlanResults.php, this one file will be committed later.
9/2/18 Tim (PaulT commit): ConnectDB_xxxx.inc files: Add function DB_table_exists() function to all DB support files, by Tim suggestion. Note that this function will be used in other files in a future commit.
7/2/18 Paul Becker (PaulT commit): Z_SalesIntegrityCheck.php: Fix that the does not take into account discountpercent so it shows an issue where non exists. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8084)
7/2/18 Tim (PaulT commit) UserSettings.php: Fix the 'Maximum Number of Records to Display' from populating with the session default at page load instead of the user's setting. Applied Tim's improved handling. (Reported in forums by Paul Becker: http://www.weberp.org/forum/showthread.php?tid=8081)
6/2/18 geo_displaymap_customers.php, geo_displaymap_suppliers.php: Fix a few PHP short-tags, and move some javascript from PHP output to fix 'missing tag' validation complaints.
6/2/18 MRPPlannedPurchasekOrders.php, MRPPlannedWorkOrders.php: PaulT: Add missing table cell to work orders to match recent change to planned purchase orders and replace 'where clause joins' with table join in both files. Paul B/PaulT: Apply consistent code formatting between both files. (Some consistency matters reported in forums: http://www.weberp.org/forum/showthread.php?tid=8061)
5/2/18 PaulT: SalesGraph.php: Rework previous 7908 implementation that caused graphing to break. (Reported broken in forums by Paul Becker: http://www.weberp.org/forum/showthread.php?tid=8071)
4/2/18 PaulT: InternalStockRequestInquiry.php: Restore ONE space to previous 7936 commit.
4/2/18 PaulT: Remove unused $db and $conn parameters from DB_Last_Insert_ID() and (where present) from DB_show_tables(), and DB_show_fields(). Also, remove any unused 'global $db' references across the code base.
4/2/18 Paul Becker (PaulT commit): MRPPlannedPurchaseOrders.php: Add capability to review planned purchase orders and add a new link to convert to a new PO. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8061)
4/2/18 Paul Becker (PaulT commit): PrintCustOrder.php, PrintCustOrder_generic.php, PDFOrderPageHeader_generic.inc: Add units, volume, and weight info, date/signature lines, sales order details narrative, plus other minor PDF formatting. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8048)
4/2/18 PaulT: Remove unused $db parameter from DB_fetch_array() and DB_Query() functions. Also, rename several DB_Query names to match function definition name: DB_query.
2/2/18 PaulT: Dashboard.php: Replace due date handling with existing function.
2/2/18 PaulT: PrintCustTrans.php, PDFTransPageHeader.inc, PrintCustTransPortrait.php, PDFTransPageHeaderPortrait.inc: Add missing stock lot/serial info to landscape output to be consistent with portrait output (reported by HDeriauFF), add Due Date info to invoices (reported by Paul Becker), and (PaulT) add security checks to portrait file, layout improvements, change PDF initialization handling, and more. (A summary of all changes in this commit can be viewed here: http://www.weberp.org/forum/showthread.php?tid=8065&pid=14115#pid14115)
31/1/18 PaulT: Add a 'warning' case to getMsg(), as there is mixed use of 'warn' and 'warning' usage with prnMsg() calls. The 'warning' (before this change) defaults to an 'info' style message.
27/1/18 PaulT: Remove unused $db parameter from DB_query(), DB_error_no(), DB_error_msg() and other DB-related function calls.
27/1/18 Paul Becker (PaulT commit): Remove stray ; appearing after if, else, and foreach blocks. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8064)
27/1/18 PaulT: MiscFunctions.php, Z_ChangeStockCode.php, Z_ChangeGLAccountCode.php: Remove unused $db parameter from function ChangeFieldInTable().
26/1/18 Andrew Galuski/Tim (PaulT merge/commit): New picking list feature for regular and controlled/serialized stock. This feature improves (and replaces) the current pick list handling. (Reported in forums by HDeriauFF: http://www.weberp.org/forum/showthread.php?tid=7988)
26/1/18 Exson: Add single quotation escape and charset in htmlspecialchars() in session.inc
26/1/18 Exson: Use htmlspecialchars() to encode html special characters to html entity and set the cookie available only httponly in session.inc
25/1/18 Briantmg (PaulT commit): ReorderLevel.php: Exclude completed orders from on order counts. (Reported in forums by briantmg: http://www.weberp.org/forum/showthread.php?tid=8060)
24/1/18 Paul Becker/PaulT (PaulT commit): SelectOrderItems.php: Paul B. Fix stock table columns NOT sorting on this page / PaulT. Use existing CSS to replace two style attributes. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8057&pid=13987#pid13987)
24/1/18 Andy Couling (PaulT commit): SupplierInvoice.php, CounterSales.php: Replace two other hard-coded styles with existing CSS class. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8057)
24/1/18 Paul Becker/PaulT (PaulT commit): SelectOrderItems.php: Paul B. Remove stray value output / PaulT. Replace hard-coded style with existing CSS class. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8057)
15/1/18 Paul Becker (PaulT commit): CustomerPurchases.php: Adds Units and Discount columns and other minor changes so that it more closely matches output from OrderDetails.php. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8040)
12/1/18 Paul Becker (PaulT commit): CustomerPurchases.php: Fix script to show actual Price and actual Amount of Sale based upon discount. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8040)
9/1/18 PaulT: Payments.php: Remove my debug/test echo line from the previous commit.
9/1/18 Paul Becker (PaulT commit): Payments.php: Show bank balance at payments. Know that balance display/output is protected by a similar security check manner as protected information at the dashboard. (Reported in forums: http://weberp.org/forum/showthread.php?tid=8017)
9/1/18 Paul Becker (PaulT commit): Z_MakeNewCompany.php, default.sql, demo.sql: Remove doubled underscore in EDI_Sent reference. (Reported in forums: http://weberp.org/forum/showthread.php?tid=7920)
8/1/18 Paul Becker (PaulT commit): PDFTransPageHeader.inc, PDFTransPageHeaderPortrait.inc: Add additional address fields and/or adds an extra space between some address fields. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7942)
8/1/18 Tim (PaulT commit): PO_Items.php: Fix/improve Supplier checkbox handling, and fix a PHP7 compatibility issue. (Reported in forums by Confucius: http://www.weberp.org/forum/showthread.php?tid=7958)
8/1/18 Paul Becker/Tim (PaulT commit): SalesGraph.php: Replace period numbers in graph title with month and year. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7946)
7/1/18 Paul Becker (PaulT commit): WriteReport.inc: Fix broken page number handling. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7955)
7/1/18 PaulT: Change.log: Update remaining past commit entries (during the past few weeks) to give credit to the right person(s) involved with the change, and when applicable, add the related forum URL for historical reference.
7/1/18 Phil: Update phpxmlrpc to latest from https://github.com/gggeek/phpxmlrpc
6/1/18 PaulT: Change.log: Update some past commit entries to give credit to the right person(s) involved with the change, and when applicable, add the related forum URL for historical reference.
6/1/18 Paul Becker and Tim (PaulT commit): SelectSalesOrder.php: Fix handling to correct table heading value. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8000)
6/1/18 Phil: Attempt to avoid XSS attacks by logged in users by parsing out "script>" from all $_POST and $_GET variables - subsequentely changed to strip_tags from all $_POST and $_GETs per Tim's recommendation
3/1/18: Paul Becker (PaulT commit): SelectSalesOrder.php: Fix search to retain quote option and set StockLocation to the UserStockLocation to auto-load current Sales Orders. (Reported in formus: http://www.weberp.org/forum/showthread.php?tid=8000)
2/1/18: Paul Becker and Tim (PaulT commit): SelectSalesOrder.php: Move handling for URL Quotations parameter to top of file to avoid potential page error(s). (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8000) Handling move reduces code within some conditional checks. This change also includes minor whitespace improvements and removes an unused global reference.
2/1/18: PaulT: css/default/default.css: Add text alignment in a couple of styles to match the same use in other CSS to avoid formatting issues when the default theme is used. Also, set several property names to lowercase.
20/12/17 PaulT: FormMaker.php, ReportMaker.php, WriteForm.inc: A few more PHP 7.1 array compatibility changes.
20/12/17 PaulT: RCFunctions.inc, FormMaker.php: PHP 7.1 array compatibility change.
19/12/17 PaulT: PDFOrderStatus.php: Remove redundant ConnectDB.inc include reference. (already included by session.php at the top of the file)
19/12/17 PaulT: Change.log: Correct my Day/Month entry references over the last few days.
19/12/17 PaulT: Contracts.php: Move work center handling causing a partial form to appear after the footer when no work centers exist.
19/12/17 Paul Becker (PaulT commit): Contract_Readin.php: Add customerref field to query to appear in the form when a contract is modified. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7998)
18/12/17 rjonesbsink (PaulT commit): ReportCreator.php: PHP 7.1 array compatibility change. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7969)
18/12/17 Paul Becker (PaulT commit): BOMIndented.php, BOMIndentedReverse.php: Adjust PDF position values, and add UoM, remove stray 0-9 string output. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7994)
18/12/17 Paul Becker (PaulT commit): PDFBOMListingPageHeader.inc, BOMListing.php: Adjust PDF position values, and add UoM. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7993)
15/12/17 Paul Becker (PaulT commit): MRPPlannedPurchaseOrders.php, MRPPlannedWorkOrders.php: Fix PDF highlighting, PDF position value adjustments, and other minor tweaks. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7991)
14/12/17 Tim (PaulT commit): CustomerReceipt.php: Wrap delete link parameter values with urlencode(). (Tim forum suggestion: http://www.weberp.org/forum/showthread.php?tid=7980)
13/12/17 Paul Becker (PaulT commit): PDFCOA.php: Add column prodspeckey to queries which is used as a description alternative. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7989)
13/12/17 Paul Becker (PaulT commit): PDFCOA.php, PDFProdSpec: Minor value adjust to correct inconsistent footer wrap. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7987)
13/12/17 PaulT: HistoricalTestResults.php, SelectQASamples.php, TestPlanResults.php: Fix date inputs to work with the date picker. (Reported in forums by briantmg: http://www.weberp.org/forum/showthread.php?tid=7984)
13/12/17 Paul Becker (PaulT commit): PDFQALabel.php: Overlapping in the PDF when printing non-controlled items. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7976)
13/12/17 Paul Becker (PaulT commit): CustomerReceipt.php: Add identifier to URL for delete link. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7980)
13/12/17 Paul Becker (PaulT commit): QATests.php: Correct wrong attribute name in two option tags. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7983)
11/12/17 rjonesbsink (PaulT commit): PHP 7 constructor compatibility change to phplot.php. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7977)
11/12/17 Paul Becker (PaulT commit): SelectSalesOrder.php: Consistent delivery address and correct a unit conversion issue. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7967)
11/12/17 rjonesbsink (PaulT commit): PHP 7 constructor compatibility change to htmlMimeMail.php and mimePart.php. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=7971)
6/12/17 RChacon: Order by transaction date and add link to debtors in Dashboard.php script.
3/12/17 Phil commited Tim's BankAccountBalances.php script
2/12/17 Exson: Fixed the outstanding quantity is not right in PO_SelectOSPurchOrder.php.
2/12/17 Phil committed Tim Schofield's fix for javascript date picker for US date formats
2/12/17 Phil/Paul Becker: Purchases report - also deleted id non-exsitent in css committed changes suggested by VortecCPI http://www.weberp.org/forum/showthread.php?tid=7943
23/11/2017 Andy Couling: Added Petty Cash receipt file upload to directory functionality.
7/11/17 Exson: Remove cost updating for WAC method in BOMs.php.
25/10/17 Exson: Fixed the salesman authority problem in PrintCustTrans.php.
23/10/17 Exson: Prevent sales man from viewing other sales' sales orders in PrintCustTrans.php.
23/10/17 Exson: Prevent customer from modifying or viewing other customer's order in SelectOrderItems.php and PrintCustTrans.php.
21/10/18 Exson: Change header to meta data to avoid header do not work in some server environment in SelectCompletedOrder.php and SelectGLAccount.php
17/10/17 Andy Couling: Removed reference to css class 'toplink' in CustomerInquiry.php and CustomerAccount.php.
17/10/17 Phil: Fix InventoryPlanning.php and includes/PDFInventoryPlanPageHeader.inc to display categories selected and fix month headings displayed
15/10/17 Andy Couling: New Expenses/Update Expense table header in PcClaimExpensesFromTab.php
15/10/17 Andy Couling: Fixed the edit/delete cash assignment functionality in PcAssignCashToTab.php
15/10/17 Andy Couling: Table header labels corrected in PcClaimExpensesFromTab.php and PcAuthorizeExpenses.php.
15/10/17 Andy Couling: Fixed expense deletion dialogue box in PcClaimExpensesFromTab.php.
15/10/17 Andy Couling: Missing $Id comments added to Petty Cash scripts.
10/10/12 Exson: Fixed the bug that Narrative information will loss when add or remove controlled items lot no in StockAdjustments.php.
10/10/17 RChacon: If it is set the $_SESSION['ShowPageHelp'] parameter AND it is FALSE, hides the page help text (simplifies code using css).
10/10/17 RChacon: Set decimals variable for exchange rate in Currencies.php.
10/10/17 RChacon: Improve currency showing and set decimals variable for exchange rate in Payments.php.
10/10/17 Exson: Fix the indian_number_format bug in MiscFunctions.php.
9/10/17 Exson: Fixed the non-balance bug in CustomerReceipt.php. And fixed the non rollback problem when there is a non-balance existed. Fixed error noises.
3/10/17 Exson: Add html view to SuppPriceList.php.
20/9/17 RChacon: Standardise and add icons for usability.
20/9/17 RChacon: Increases accuracy in coordinates.
20/9/17 Exson: Fixed the wrong price retrieved bug in PO_Header.php.
20/9/17 Exson: Fixed the vendor price bug to ensure only the effective price showed by suppliers in SelectProduct.php.
20/9/17 Exson: Fixed the bug to make GRN reverse workable.
19/9/17 Exson: customer information missing in CustomerReceipt.php. Reported by Steven Fu.
18/9/2017 Tim (committed by Andy): Geocode bug fixes. http://www.weberp.org/forum/showthread.php?tid=4380
17/9/17 VortecCPI: SelectProduct.php made image dispay code match that used in WorkOrderEntry.php
11/9/17 Andy Couling: Fixed the onclick delete confirmation box call in ContractBOM.php, was 'MakeConfirm'.
11/9/17 Andy Couling: Code consistency in PO_Items.php. http://www.weberp.org/forum/showthread.php?tid=4355
8/9/17 PaulT: Z_ChangeLocationCode.php: Add missing locationusers table update, reported by Paul Becker in forums.
8/9/17 Phil: Fix portrait invoice email now has narrative of correct invocie number!
8/9/17 Andrew Couling: Petty cash improvements to tax taken from Tim's work
6/9/17 RChacon: Fix currency translation in PO_AuthorisationLevels.php.
6/9/17 Exson: Fixed the bug that invoice cannot be issued by same transaction multiple times in SuppTrans.php.
30/8/17 Exson: Fixed the bug that can not display correctly while the same debtors has more than one transaction and make GL account which is not AR account or bank account transaction showing on too.
30/8/17 Exson: Fixed the default shipper does not work in CustomerBranches.php reported by Steven.
10/8/17 PaulT: CounterSales.php and StockAdjustments.php: Apply fixes posted by Tim in weberp forums.
27/7/17 Exson: Fixed the search failure problem due to stock id code in SelectWorkOrder.php.
18/7/17 Exson: Add QR code for item issue and fg collection for WO in PDFWOPrint.php
17/07/17 RChacon: Fix call to image tick.svg.
15/7/17 Phil: Utility script to remove all purchase back orders
10/07/17 Exson: Fixed the wrong price bug and GP not updated correctly in SelectOrderItems.php. Report by Robert from MHHK forum.
08/07/17 PaulT: reportwriter/admin/forms area, fix tag name in four files: <image> to <img>
04/07/17 PaulT: DefineImportBankTransClass.php - Remove extra (
30/06/17 Exson: Fixed the argument count error in SupplierInvoice.php.
2017-06-26 4.14.1 release
25/06/22 RChacon: Merge css/WEBootstrap/css/custom.css into css/WEBootstrap/default.css to preserve bootstrap as original.
24/06/22 RChacon: Add style sections for device rendering width ranges for no responsive themes.
23/06/22 RChacon: Fix class for TransactionsDiv, InquiriesDiv and MaintenanceDiv. Fix bootstrap copy.
22/06/22 Exson: Fixed the Over Receive Portion bug in WorkOrderReceive.php.
21/06/17 RChacon: Add meta viewport for initial-scale=1 for working css in small devices.
2017-06-20 4.14 release
19/06/17 Exson: Add menu.css to make the main menu workable in header.php.
19/06/17 Exson: Fixed the variable not existed error (Reported by Tim). Add a feature to add favorite script under main menu which idea originated from Tim's Kwamoja project.
19/06/17 Exson: Add a empty submit blocked feature to SupplierInvoice.php to avoid a empty invoice.
19/06/17 Exson: Make these classes defined php 7 compliant and keep php4 backwards compatibility.
18/06/17 RChacon: Rename from css/custom/ to from css/WEBootstrap/.
18/06/17 RChacon: Standardise icon size to 36x36 px in css/custom/ (WEBootstrap).
18/06/17 RChacon: Delete unused images in css/xenos/.
18/06/17 Tim (committed by RChacon): Improve jump to enter a GL receipt if 'Type'=='GL' in CustomerReceipt.php.
18/06/17 RChacon: Add missing images and delete unused images in css/custom/.
18/06/17 Exson: Fixed a typo in GLPostings.inc.
18/06/17 Giankocr created a custom theme for webERP, Exson port part of it to webERP.
17/06/17 RChacon: In CustomerReceipt.php, it jumps to enter a GL receipt if 'Type'=='GL'.
08/06/17 Exson: Fixed quotation and orders are mixed in searching result of SelectSalesOrder.php.
1/6/17 VortecCPI fixed empty list error in GLAccounts.php, GLCashFlowsIndirect.php, GLCashFlowsSetup.php
18/5/17 Phil: remove changes in Andrew's PO_Items.php script that increased dp for purchase price to 5 - for some low value currencies this would be inappropriate, better to use the currency decimal places + 2 as per Ricard's idea
16/5/17 Andrew Couling: SQL correction in PO_Items.php. Line 1094.
7/5/17 Andy Couling/Janb: Fixes to MRP scripts SQL to get table names per forum post http://www.weberp.org/forum/showthread.php?tid=2448
13/4/17 RChacon: Rename includes/footer.inc, includes/header.inc and includes/session.inc to includes/footer.php, includes/header.php and includes/session.php.
09/4/17 RChacon: In UserSettings.php, add options to turn off/on page help and field help. In WWW_Users.php, improve code and documentation.
30/3/17 RChacon: In ManualContents.php, fix checkbox showing and do some improvements.
29/3/17 RChacon: In webERP manual, allow to use default pages if locale pages do not exist.
26/3/17 Abel World: Make degine $ReportList as an array to comply with PHP 7.
19/3/17 RChacon: Rename AccountSectionsDef.inc to AccountSectionsDef.php.
11/3/17 Tim - committed by Phil: allow sales order item lines to be imported from a csv consisting of lines of item code, quantity
07/03/17 TurboPT: (by Tim in forums) BankAccounts.php: Add quotes to variable in query.
27/02/17 TurboPT: SpecialOrder.php add identifier to delete link; DefineSpecialOrderClass.php remove the "&" with parameter to function remove_from_order().
26/02/17 TurboPT: CopyBOM.php fixed insert SQL had duplicate digitals field
14/1/17 Phil: CustomerReceipt now calculates payment discount based on percentages entered in payment methods
12/1/17 RChacon: Removes the "&" before the variable $ResultIndex in ConnectDB_XXX.inc.
12/1/17 Phil: Added a discount percentage field to the payment methods - to allow calculation of discount when receipts entered... still yet to code this bit
6/1/17 RChacon: Add Turn off/on the page help and the field help.
5/1/17 RChacon: In GLCashFlowsIndirect.php, fix named key in Associative array with config value. Thanks Tim.
5/1/17 RChacon: For strict Standards, removes the "&" before the variable in DB_fetch_row() and in DB_fetch_array() in ConnectDB_XXX.inc. Thanks Tim.
21/12/16 RChacon: In PurchasesReport.php, fix date comparison and title. Thanks Tim.
20/12/16 RChacon: Standardise to "Print" button.
20/12/16 RChacon: Add a report of purchases from suppliers for the range of selected dates.
11/12/16 PaulT: Dashboard.php: Correct table closure. When there are no outstanding orders, causes footer artifact.
08/12/16 Exson: Fixed the variable error in stock take pdf header in includes/PDFStockCheckPageHeader.inc. And fixed undefined noise in Payments.php. Reported by shane.
08/12/16 Exson: Fixed noise of undefined variable and string required for function_exists in Dashboard.php. Reported by Shane.
06/12/16 PaulT: SelectProduct.php: Add footer before the script exits when stock categories are not defined.
02/12/16 PaulT: WriteReport.inc: Fix condition needed to support PHP7, reported by Tim.
02/12/16 RChacon: fix and improve code for existent parameters in GLCashFlowsSetup.php.
02/12/16 Exson: Add location code and reference to Work Orders search result in SelectWorkOrder.php.
02/12/16 Exson: Fixed the no users data displayed bug and copy BOM fields error bug in WWW_Users.php and CopyBOM.php. Thanks for shane's report.
30/11/16 Exson: Fixed the bug that write off option not work without freight cost input in Credit_Invoice.php.
27/11/16 4.13.1 release
26/11/2016 Exson: Add a constraint to Pc assignment transfer in PcAssignCashTabToTab.php
26/11/16 Exson: Fixed the bugs in InternalStockRequestInquiry.php. Thanks for Tim's report.
23/11/16 RChacon: On AccountGroups.php, add navigation aids (return button).
08/11/16 RChacon: On WWW_Users.php, fix hardcoded label (difficult to translate for languages with a different structure to English), do sortable the users list, replace printf() with plain list echo, and add format class.
08/11/16 RChacon: Add scripts to show a statement of cash flows for the period using the indirect method.
08/11/16 RChacon: On SelectSupplier.php, fix table html code.
06/11/16 RChacon: On SupplierPriceList.php, fix to show price in user's locale format, add supplier's id and name to title, replace printf() with plain list echo, and regroup and document code.
03/11/16 RChacon: On Dashboard.php, fix creditors payment to point to allocation instead to payment, replace printf() with plain list echo, regroup code, and complete column styles.
01/11/16 RChacon: On SupplierInquiry.php, replace the printf() statements with echo statements to fix bug caused by a supplier invoice with a comment that includes a % character (reported by R2-G, solution by Tim).
30/10/16 RChacon: In SecurityTokens.php: Fix Description's input maxlength, fix table head in data table, move form-tables after data table, add cancel button in edit form table, add return button, add style to print data table, add title in form tables, regroup code, change from if/elseif to switch/case to improve code readability, and add code documentation.
30/10/16 RChacon: On SupplierPriceList.php, add ViewTopic and BookMark, and complete html table. Add info to manual.
17/10/16 Phil: Fix SQL in ReverseGRN.php as reported by Ricard/Tim.
16/10/16 RChacon: Fix function convertDate(dS,dF).
05/10/16 Eatong: Format the ManualAPITutorial.html for easier reading.
05/10/16 Eatong: Add CSS rule for <pre> for easier reading.
05/10/16 Eatong: Align field length of salesanalysis.salesperson to salesman.salesmancode.
05/10/16 RChacon: Add cross.svg, next.svg, previous.svg, and tick.svg images in Scalable Vector Graphics (SVG) format for general use (any size).
04/10/16 RChacon: In class.pdf.php, fix the function addJpegFromFile() use of the functionality Image() of TCPDF class.
04/10/16 RChacon: In class.pdf.php, functions Rectangle() and RoundRectangle() use the functionalities Rect() and RoundedRectXY() of TCPDF class.
04/10/16 RChacon: Add return.svg image for Return button in Scalable Vector Graphics (SVG) format.
27/09/16 RChacon: Add webERP logo in Scalable Vector Graphics format.
25/09/16 Exson: Make customer reference GET method workable in SelectCompletedOrder.php. Fixed decimalplaces missing bug in SelectOrderItems.php. Add due date, order date and customer reference option in SelectSalesOrder.php.
25/09/16 Exson: Make the details show immediately when the search result is one in SelectCompletedOrder.php.And add return links in OrderDetails.php.
24/10/16 Simon Kelly: Fixed placing POs for sales orders using array form variable
24/09/16 waynemcdougall: Fixed missing date in Sales Price history
24/09/16 Exson: Make Justify feature workable in addTextWrap in class.pdf.php.
24/09/16 Exson: Fixed the AddTextWrap missing characters errors when there is space and make it more reliable.
21/09/16 RChacon: In SuppWhereAlloc.php, accepts the payment multiple creditors. In CustWhereAlloc.php, accepts the receipt of multiple debtors.
18/09/16 RChacon: Add style to describe how button image should be displayed. Clean up Xenos css.
18/09/16 Exson: Add multiple items issue for non-controlled items feature to Work Orders in WorkOrderIssue.php.
14/09/16 Exson: Add narrative, transaction date data to PDFOrdersInvoiced.php.
14/09/16 Exson: Add order line narrative and invoices link to sales order inquiry in OrderDetails.php.
12/09/16 Exson: Add a filter to avoid tons of zero valued gl transaction records generated in SQL_CommonFunctions.inc.
04/09/16 Exson: Add WO items delete constraint in WorkOrderEntry.php. Thanks for Phil's reminder.
04/09/16 Exson: Add delete Work orders Items feature in WorkOrderEntry.php.
04/09/16 Exson: Fixed the undefined noise in WorkOrderStatus.php.
04/09/16 Exson: Fixed the bug that work order location will be wrong when user select location which is not user's default location.
04/09/16 Dave Parrish fixed accumulated No of orders bug in SalesByTypePeriodInquiry.php.
31/08/16 Exson: Addd new feature assign cash from one tab to another.
24/08/16 Exson: Fixed the latin1 charset mixed bug in supplierdiscounts table;
24/9/16 Exson: Fixed the bug that days of payment terms in the following month over 31 days can not be handled correctly in DateFunctions.inc.
20/08/16 RChacon: In ConfirmDispatch_Invoice.php, fix table html code.
18/08/16 RChacon: In PDFStatementPageHeader.inc, replace addJpegFromFile() and RoundRectangle() functions from class.pdf.php with Image() and RoundedRect() functions from tcpdf.php.
18/08/16 Exson: Add a Cancel button on SupplierAllocations.php to make user can return to previous page easily.
18/08/16 Exson: Add date format validation in PcClaimExpensesFromTab.php.
17/8/16 RChacon committed for Tim: In CustWhereAlloc.php and SuppWhereAlloc.php, use the ConvertSQLDate() function for the dates.
14/8/16 RChacon:In SuppWhereAlloc.php, show transaction date in report. Improvements in HTML code and code documentation.
13/8/16 RChacon:In CustWhereAlloc.php, show transaction date in report. Standardise trandate in debtortrans. Improvements in HTML code and code documentation.
11/8/16 Phil: committed falkoners fix for the upgrade script - was not adding the new field in customercontact required for the customer statements email address
11/8/16 Simon Kelly: Fix SQL for location users in SelectSalesOrder.php
05/08/16 RChacon: In GLAccountInquiry.php, add noprint class to clean up printer output and improve code documentation.
05/08/16 RChacon: Fix html code in SuppInvGRNs.php.
02/08/16 Exson: Make account inquiry shown directly when GL Code selected or inquiry result is 1 in SelectGLAccount.php.
27/07/16 Exson: Add cost update date for material cost in WorkOrderCosting.php and WorkOrderIssue.php.
27/07/16 Exson: Fixed the typo in Credit_Invoice.php introduced in previous update.
27/07/16 Exson: Fixed the divided by zero error when discount is 100% in SelectOrderItems.php.
27/07/16 Exson: Add error proof to avoid a blank credit note issued without any items credited or freight charge input in Credit_Invoice.php.
25/07/16 Exson: Add InternalStockRequestInquiry.php script.
22/07/16 Exson: Make items search limited to the sales orders and if search result is 1 show the result immediately in SelectSalesOrder.php
22/07/16 Exson: Add empty check for internal request to avoid empty request creating in InternalStockRequest.php.
09/07/16 Exson: Fixed the utf8 character print incorrect of pdf file in class.pdf.php.
08/07/16 Exson: Fixed the transaction atomicity bug by change table lock to row lock in SQL_CommonFunctions.inc.
08/07/16 Exson: Fixed the bug that when bank account or currency changes the functional rate or exrate unchanged with suggested rate in Payments.php.
07/07/16: Exson: Fixed the bug of wrong original amount of payments to another bank accounts in GLAccountInquiry.php and wrong transaction link in DailyBankTransactions.php and add payment transaction no in bank transaction ref to make it traceable.
29/06/16 Exson: add identifier to avoid SESSION overwritten in CustomerReceipt.php.
29/06/16 Exson: Fixed the wrong balance of amount in bank account currency in DailyBankTransactions.php.
20/06/16 Exson: Fixed bom clone failure due to fields missing in CopyBom.php. Reported by shane.
20/06/16 Exson: Fixed the bug that # is not allowed as part of stockid in SelectProduct.php.
16/06/16 Exson: Make monthly payment term can be more than 30 days.
12/06/16 TurboPT: Fix syntax error in StockClone.php
08/06/16 Exson: add data label for SalesGraph.php.
22/5/16 Release 4.13
30/5/16 Phil: Default new salesperson to current
30/5/16 Andew Galuski: remove hidden GP_Percent form field when customer login to prevent un-authorised viewing of this data when looking at the page source
28/5/16 Gilberto Dos Santos Alves: Updated Portuguese Brazilian translation
28/5/16 Phil: PrintCustStatement.php now has an option to email the statement and uses the customer contacts email addresses defined as wanting a statement and sends individual statements to each of the customer contacts for their customer statement and lists the customers and the recipients they have been sent to. The existing emailcustomerstatement script had too much potential to send statement for other customers to another customer by mistake - so I've removed it!
23/5/16 Phil: PrintCustStatement.php now shows all the date.
23/5/16 Phil: Credit_Invoice.php now adds correct tax authorities - correcting bug that resulted in foreign key errors when adding taxauthorities as per fix to SelectCreditItems.php on 13/1/16
20/5/16 Phil: POS upload file now includes assembly items
20/5/16 RChacon: Insert missing script as an utility.
20/5/16 RChacon: In Login.php, add a return link.
20/5/16 Paul Harness: CustomerAllocations.php consistent sort order adding by date and transno sorting for transactions on the same date
15/05/16 RChacon: In SelectCustomer.php, use a default map host if $map_host is empty.
15/05/16 RChacon: In AccountGroups.php, hide no printing elements.
15/05/16 Exson: Add sequence digitals to make BOM sequences can be adjusted flexible and avoid any uncertainty of the number stored in SQL. Thanks Tim's suggestion.
14/05/16 RChacon: In SelectCustomer.php, fix use of Google Maps JavaScript API V3, unpaired html tags and other bugs.
13/05/16 RChacon: In AddCustomerContacts.php, add classes to print and table heads. Improve code.
12/05/16 RChacon: Fix blank line caused by reverse character RTL. Clean up code.
11/05/16 RChacon: Include translation to hebrew, thanks to Hagay Mandel.
09/05/16 Exson: Tidy Code Up to remove redundant code according to Tim's guide.
05/06/16 Exson: Modify Z_RePostGLFromPeriod.php to make this feature still reliable with prev
05/06/16: Exson: Remove the $db which is not needed now. Reported by Tim. ious version of GLPostings.inc. Rework the new GLPostings.inc.
05/06/16 Exson: Fixed typo of IndentText, thanks for Tim's report. Change sequence from int to double to make item is easily inserted into BOMs and Add pictures to BOMs and make BOM printable.
01/05/2016 RChacon: In Z_poAddLanguage.php, fix directory name and default language file name.
29/4/16 RChacon: In includes/DateFunctions.inc, add year in long date and time in locale format.
26/4/16 Phil committed for Tim: apparently only change required for PHP7 see http://www.weberp.org/forum/showthread.php?tid=2733&pid=7132#pid7132
25/4/16 RChacon: In Payments.php, allow to input a customised gltrans.narrative, supptrans.suppreference and supptrans.transtext.
25/4/16 Jan Bakke: google maps api improvement to SubmitCustomerSelection changed script src to https du to mixed content error Updated to Google Maps API v.3 Integrated code lines from ceocode.php to update Customers (custbranch table) without lat (0) but width brpostaddr1 Show Branch Contact beneath Customer Contacts when branch is selected Table-width cleanup - diff submitted in March sorry Phil's bad :-(
25/4/16 Jan Bakke: Improvements to allow .png and .gif images
15/04/16 PaulT: add missing } causing error.
12/04/16 Exson: add cost security token to make price security and cost security separated to cope with different situation.
10/04/16 RChacon: In WorkCentres.php, add ViewTopic and BookMark and completes html table. In doc/Manual/ManualManufacturing.html, add help for WorkCentres.php.
10/04/16 RChacon: In SupplierInvoice.php, add ' - ' to standardise gltran.narrative to "SupplierID - ". In SuppTransGLAnalysis.php, add ViewTopic and Bookmark, completes html tables, add text class, and add currency_code to input table. In css/*/default.css, regroup horizontal align classes for readability. In doc/Manual/ManualAccountsPayable.html, add anchor id="SuppTransGLAnalysis".
07/04/16 RChacon: In includes/class.pdf.php, add script documentation and completes switch($Align) to translate from Pdf-Creator to TCPDF.
07/04/16 Exson: Add remark column to CopyBOM.php.
01/04/2016 Exson: Make Petty cash assigner and authorizer multiple selectable in PcExpenses.php,PcTabs.php, PcAssignCashToTab.php and PcAuthorizeExpenses.
24/03/16 RChacon: In CustomerReceipt.php, allow more precision on the functional_exchange_rate. In Payments.php, add pattern and required attributes to the functional_exchange_rate input.
24/03/16 Exson: Make the MRP report more place for material description in MRPReport.php.
18/03/2016 Exson: Correct the currency code for transaction between bank account in GLAccountInquiry.php.
18/03/2016 Exson: Fixed the bug that transaction between bank shows wrong original currency and amount in GLAccountInquiry.php.
10/03/2016 Tim: Fixed the credit note tax authority not set up bug in SelectCreditItems.php. Reported by Bob.
03/09/16 Exson: Fixed the bug of wrong location selected when add items to Work Orders in WorkOrderEntry.php.
9/3/16 Andrew Galuski: Fix FormDesigner requires casting XML elements as strings
03/09/16 Exson: Add PO details option to show balance of each outstanding PO in PO_SelectOSPurchOrder.php.
03/09/16 Exson: Fixed the typo which make sql query failed in GLPostings.inc. reported by Richard.
24/02/16: Richard, Exson Fix the GLPosting initiating error in GLPostings.inc.
20/02/16 Janb,Tim fixed typo in upgrade4.12.3-4.13.sql
19/02/16 Daveparrish fixed page number error of AgedDebtors.php.
02/02/16 Exson��Fixed the bug of chartdetails bfwd amount wrong in GLPostings.inc.
1/2/15 Exson: Make GL Posting really transaction in GLPostings.inc.
30/01/16 Exson: Fix the bug to print invoice instead of credit note when a credit note requested in CustomerInquiry.php reported by daveparrish.
14/01/16 Exson: Add Supplier transaction allocation inquiry in SuppWhereAlloc.php and add a link to in SupplierInquiry.php.
14/01/16 Exson: Add credit note allocation option for CustWhereAlloc.php and add a link to it in CustomerInquiry.php and make the allocation printable by print.css.
13/01/16 Exson: Add remark to BOM items and make the BOM printable via the new print.css created by Rafael.
13/1/16 Phil: Fixed bug in creating customer credit notes manually - blank taxes were being added that caused the SQL to commit the transaction to fail with foreign key constraint to tax authorities
13/01/16 Exson: Fixed the variables non-refresh bugs in GLAccountInquiry.php. Reported by Richard.
11/01/16 Exson: Fixed the bug of bank account original amount data error. Reported by Tim, Richard and make this data only available for bank account.
01/07/16 Exson: Fixed the lot control items negative not allowed problem and fix the data storage caused precision error which make material issuing is impossible under some situation in WorkOrderIssue.php.
29/12/15 RChacon: In GLAccountUsers.php: Fix script name; add $ViewTopic and $BookMark; improve $SelectedGLAccount validation; improve page_title_text; improve select GL account; regroup modify access permission code (improve logic); add classes to table elements; translate database "0" and "1" to human "No" and "Yes"; simplify and tide code; modify prnMsg from multiple part sentence to one part sentence (better to translate when language use a different grammar structure from English); add "Print This", "Select A Different GL account" and "Return" buttons. Add info to ManualGeneralLedger.html.
28/12/15 Exson: Fixed the bug that discount not modified for items whose discount is null in discount matrix in SelectOrderItems.php.
27/12/15 RChacon: In UserGLAccounts.php: Fix script name; add $ViewTopic and $BookMark; improve $SelectedUser validation; improve page_title_text; improve select user; regroup modify access permission code (improve logic); add classes to table elements; translate database "0" and "1" to human "No" and "Yes"; simplify and tide code; modify prnMsg from multiple part sentence to one part sentence (better to translate when language use a different grammar structure from English); add "Print This", "Select A Different User" and "Return" buttons. Add info to ManualGeneralLedger.html.
26/12/2015 Exson: Add items not received information on outstanding po inquiry screen in PO_SelectOSPurchOrder.php.
24/12/15 Exson: Add supplier no as a option for supplier transaction inquiry in SupplierTransInquiry.php.
24/12/15 Exson: Add width of printed text to make day to appear in PDFOstdgGRNsPageHeader.inc.
2015/12/24 Exson: Add Completed option for PO printed to allowed the order details can be completed in PO_Header.php.
20/12/15 Phil: GoodsReceived.php now shows the supplier's item code as well
20/12/15 Phil: SelectProduct.php now allows items to be searched based on the supplier's item code
14/12/15 Exson: Remove retrieving allocated data in Z_AutoCustomerAllocations.php.
11/12/15 Exson: Fixed the default Transaction Disable bug to enable for CustomerBranches.php.
10/12/15 Exson: Add invoice no while reprint GRN in ReprintGRN.php.
10/12/15 Exson: Add multiple work orders total cost inquiry script.
09/12/05 Exson: Fixed the telephone regular expression bug in SelectCustomer.php. Reported by Terry.
01/12/15 Exson: Remove the wrong foreign key in suppinvstogrn. Reported by rafael.
26/11/15 Exson: Fixed the rounding error caused extra lines on WO pdf file and 2 number display without locale format in PDFWOPrint.php.
21/11/15 Gilberto Dos Santos Alves: Updated Portuguese Brazilian translation
18/11/15 AlexFigueiro: Remove the duplicate foreign key in stockrequest and stockrequestitem;
15/11/15 RChacon: Tidy css/*/default.css, reagrouping style for clases centre, number, page_title_text and text.
15/11/15 Hazem wehbi Add new arabic locale for Syria.
14/11/15 RChacon: In css/default/default.css, add sections to use with a cascading style sheet for a small device width, reagroup style for centre, number and text in tables.
11/11/15 Ricard: New feature GL accounts - users authority.
09/11/15 RChacon: In CustomerReceipt.php, minor changes (completes table columns, adds classes, etc.).
05/11/15 Exson: Tidy code up following Tim's suggestion.
3/11/15 RChacon: In GLAccountInquiry.php, add ViewTopic and BookMark, fix some colspan, and add thead and column classes.
3/11/15 Exson: Tidy code up in StockClone.php.
3/11/15 Exson: Fixed typo in PriceMatrix.php.
30/10/15 Exson: Allow user input supplier's delivery note during goods receiving and make the inquiry script for it. So users can search corresponding GRN, PO and invoice with it.
29/10/15 Exson: Add gl narrative and account balance information to DailyBankTransactions.php.
28/10/15 Exson: Add bank default currency, original amount and check no data to GL account inquiry in GLAccountInquiry.php.
06/10/15 UK-Steven: Contribute email customer statements feature scripts.
06/10/15 Exson: Fixed the wrong unable to identify the selected customer warning at SelectOrderItems.php.
23/09/2015 Tim: ADD invoice to grns mapping data in SupplierInvoice.php.
21/09/15 RChacon: In StockLocStatus.php, add current date and time, and format to use print.css.
21/09/15 Exson: Fix the wrong material cost updated in SupplierCredit.php. Reported by Akits.
19/9/15 Dongbak Cha:Korean translation via Google translate
14/9/15 RChacon: Rebuild languages files *.pot, *.po and *.mo to includes new texts.
14/9/15 RChacon: In AnalysisHorizontalIncome.php, delete duplicated tag. Replaces text "Absolute/Relative variation" with "Absolute/Relative difference" to avoid confusions.
13/9/15 RChacon: In AccountSections.php, add modifications for direct printing.
4/9/15 Wes Wolfenbarger: Fix to Z_ImportStocks.php added quotes to descriptions - also fixes error message when the csv does not match the template
27/08/15 Exson: Fixed the allocation status of involved invoice and credit notes in Credit_Invoice.php.
19/08/15 RChacon: In AnalysisHorizontalIncome.php, delete variable $period because it is not used anywhere (thanks Tim). Extract header.inc from if.
13/08/15 RChacon: In doc/ManualGeneralLedger.html, add help for the horizontal analysis.
13/08/15 RChacon: Add new script AnalysisHorizontalIncome.php to generate an horizontal analysis of the statement of comprehensive income. In AnalysisHorizontalPosition.php, adjust signs and add report footnote.
05/08/15 RChacon: In AnalysisHorizontalPosition.php, modify DB_fetch_array() function because it requires only one parameter (thanks Tim). Other improvements.
04/08/15 RChacon: Add new script AnalysisHorizontalPosition.php to generate an horizontal analysis of the statement of financial position.
02/08/15 RChacon: In CustomerReceipt.php, move currency tags near currency ratesand other minor changes.
27/07/15 RChacon: In Payments.php, move currency tags near currency rates.
20/06/15 RChacon: In header.inc, add meta tag to keep relationship between CSS pixels and device pixels.
19/06/15 : Kif (from webERP Chinese Community QQ group) fixed the menu cannot show completely on mobile phone in xenos/default.css.
04/06/15 TurboPT: Currencies.php: Add closing select, td and tr tags to complete last table row.
27/05/15 Thumb: Fix error_reporting() bug change && to & in install/index.php.
25/5/15 Tom Barry: SupplierInquiry.php moved SQL to get the users authorisation to put supplier invoices on hold outside the loop to avoid unecessary round trips to the SQL server
21/5/15 RChacon: Adjust CustomerAccount.php for direct printing.
19/5/15 RChacon: Add documentation and help for users in Locations.php and ManualInventory.html.
17/5/15 Version 4.12.3
17/5/15 Phil: Made currencies delete check first for bank accounts set up using the currency - as reported by Ricard
10/05/15 RChacon: New features: (1) GL account code for an inventory location, so that you can have general ledger transactions of inventory transfers to or from this location; useful for pledged inventory and goods on consignment. (2) Allow Invoicing parameter to allow or deny the availability of a location to be delivered; useful when a location stores compromised good that can not be sold.
09/05/15 Exson: Fixed no input filtering bug which cause input failure and location quantity become mess in WorkOrderReceive.php. But the transaction failure maybe still there.
08/05/15 RChacon: In DeliveryDetails.php, add $ViewTopic and $BookMark to ManualSalesOrders.html.
07/05/15 RChacon: In CustomerInquiry.php, hide submit button and 'More Info' columns when printing. Add thead tag to enable the table header to be printed at the top of each page.
07/05/15 RChacon: In SupplierInquiry.php, hide submit button and 'More Info' columns when printing. Add thead tag to enable the table header to be printed at the top of each page.
04/05/15 Exson: Make PO number searching also in compliance with location authority rules and make default search result as all if users have full location authority.
04/05/15 Exson: Make all option available for users who have authority for all locations and all option available for all stock categories in PO_SelectOSPurchOrder.php.
02/05/15 TeHonu: Added bankaccountusers table in Z_ChangeGLAccountCode.php
30/04/15 TurboPT: Add Delivery Date in GoodsReceived.php output. Forum feature request by giusba71.
30/04/15 Exson: Fixed the notice noise in SupplierCredit.php and SupplierInvoice.php.
30/04/15 Exson: Fixed the properties initial bug and tidy code up by fix typo.
26/04/15 Exson: Add adjustment reason to the mail text and fixed the notice noise in StockAdjustments.php.
26/04/15 Exson: Comment out the mrpparameters table update in sql file upgrade4.11.3-4.11.4.sql which made a misleading during upgrade and absolutely non-necessary.
26/4/15 Exson: Fixed the account code cannot be key in directly bug in GLJournal.php. Reported by Akits.
26/4/15 Exson: Fixed the raw material sellable bug introduced by myself in SelectOrderItems.php.
19/4/15 RChacon: Remove the class noprint from the image in page_title_text.
19/4/15 RChacon: Add ".page_title_text img" as a display none class. This makes unnecessary to add the class noprint to the image in page_title_text.
19/4/15 Phil: SelectSupplier - total supplier spend was incorrect only looked at supplier transactions excluding invoices? Now takes invoice net of debit notes reported by Andrew Galuski
07/4/15 Exson: Fixed the Wiki link broken bug in SystemParameters.php.
04/4/15 Exson: Fixed the bug that Credit and Debit submit amount was duplicated processed by local_number_format function.
01/4/15 Exson: Remove comma from item description and suppliername to make csv file correctly in POReport.php.
01/4/15 Exson: Fixed comma bug due to locale issue of POReport.php csv file. And add ordered/received quantity field in the report.
01/4/15 Exson: Fixed the bug that when delete one gl item from the payment details, the bank account related setting will disappeared in Payments.php. Reported by Steven.
01/4/15 Thumb: Add a Z_ImportCustbranch.php script to import customer branches.
30/3/15 Vitaly: Get all taxes for the tax group, even if calculationorder is left at default value 0.
29/3/15 Phil: Allow dummy/service items to be propogated to CounterLogic POS installs through the api
27/3/15 Exson: Remove redundant code from PrintCustTrans.php.
27/3/15 Exson: Make credit not for freight only is printable in PrintCustTrans.php.
26/3/15 Exson: Fixed disabletrans status bug in CustomerBranches.php and fix index undefined noise.
25/3/15 Exson: Add planned accumulation in MRP report.
14/3/15 Exson: Fixed undefined index noise in Credit_Invoice.php.
13/3/15 Exson: fixed the undefined index noise in WorkOrderReceive.php.
13/3/15 Exson: Fixed the undefined index noise in SelectWorkOrder.php.
13/3/15 Exson: Make Labor type allowed by category select in WorkOrderIssue.php.
12/3/15 Exson: Make Order No sortable in SelectSalesOrder.php.
12/3/15 Exson: Fixed undefined parameters noise in PO_SelectPurchOrder.php.
11/3/15 Exson: Fixed wrong handling for dummy parts receiving from PO in GoodsReceived.php.
09/3/15 Vitaly: Page refresh when credit type changes in Credit_Invoce.php
09/3/15 RChacon: In DailyBankTransactions.php: Improves page_title_text. Orders by banktrans.transdate ascending and banktrans.banktransid ascending. Adds division to identify the report block. Groups table-header cells inside thead tags. Groups table-data cells inside tbody tags. Adds th.text class to left align. Adds "Print This" and "Return" buttons with icon.
09/3/15 Exson: Fixed undefined index noise of $_POST['SupplierContact'] in PO_Header.php.
08/3/15 Vitaly: Fit HTML view of invoices to one screen
08/3/15 Exson: Fixed undefined index noise in PO_Items.php.
07/3/15 RChacon: Deletes class="invoice" (it does not exist in css). Creates division id="Report" to identify the report block. Moves full width style to print.css (thanks Tim Schofield).
07/3/15 Exson: Fixed undefined index noise in ShipmentCosting.php.
07/3/15 Exson: Fixed property ShiptCounter non defined bug in DefineSuppTransClass.php.
07/3/15 Exson: Fixed the undefine index OpenOrClose noise in Shipt_Select.php.
07/3/15 Exson: Fixed undefine index InputError noise in SupplierInvoice.php.
07/3/15 Exson: Fixed typo in AuditTrail.php.
07/3/15 Exson: Remove properties $_SESSION['Shipment']->GLLink which never been defined in Shipments.php.
07/3/15: Exson: Change login date of users without login record to 'No login record' instead of today. It's very confusion.
07/3/15 Exson: Fixed order value error that should be value undelivered instead of uncompleted line value and some notice noise in SelectSalesOrder.php.
04/3/15 Vitaly: Display Phantom assembly type correctly in SelectProduct.php
04/3/15 Vitaly: Added missing comma to SQL statement in Credit_Invoice.php
3/3/15 RChacon: Adds cross.png to all css images for use in Reset or Cancel buttons as needed.
2/3/15 RChacon: Completes table-row colums, regroups price, cost and gross profit in one table-row, uses company decimal places for gross profit in SelectProduct.php.
25/2/15 TurboPT: Fix Z_ImportSupplier bug reported in forum by: Bill Schlaerth.
22/2/15 TurboPT: Fix supplier delivery address bug reported in form by: Giusba
22/2/15 RChacon: Adjust page_title and add "Print This" and "Return" buttons with icon to Statement of Comprehensive Income and Trial Balance scripts. Add code documentation and removes redundant $ViewTopic and $BookMark in GLTrialBalance.php.
22/2/15 RChacon: Add missing preview.png and new previous.png icons. Add "Print This" and "Return" buttons with icon in GLBalanceSheet.php.
22/2/15 Simon Rhodes: added global $db; statements to functions in ConnectDB_mysql.inc that had been missed for the transaction functions
21/2/15 RChacon: Add headings, page-title and centre-align styles to print.css. Improve page title to use with print.css and add code documentation in GLBalanceSheet.php.
20/2/15 RChacon: Fix heading 2 html-tags inside paragraph html-tags. Add code documentation.
19/2/15 RChacon: Fix AddTextWrap split behaviour (thanks Andrew Galuski). Add code documentation.
19/2/15 Tim: Align numbers to the right in print.css
17/2/15 Vitaly: Added print.css to allow printing pages off the screen
15/2/2015: Exson: Fixed date format error for request date and start date in WorkOrderEntry.php.
12/2/15 RChacon: Fix on PrintCustTransPortrait.php: Do not need to escape special characters in a string for use in an SQL statement.
11/2/15 Vitaly: BOMIndented.php fix bug that duplicated components - error with SQL to restrict to only those users with permission to view a locations
10/2/15 Phil: New script StockCategorySalesInquiry.php - shows category sales by item for a selected custom date range
10/2/15 Phil: Reinstate Andrew Galuski's lost functionality that shows only the items that are defined for a customer (in the custitems table) when searching for items for a sales order/quote.
9/2/15 RChacon: Standardise to currency.png. Delete currency.gif.
8/2/15 RChacon: Changes from email.gif to email.png. Delete email.gif.
8/2/15 Phil: InventoryPlanning.php now has an option to export the last 24 months usage to CSV
8/2/15 RChacon: Add credit.png, email.png, folders.png and currency.png. Delete bank.gif.
7/2/15 Phil: New script CustomerAccount.php - on screen statement similar to CustomerInquiry.php
6/2/15 Version 4.12.2
6/2/15 Vitaly:Added SQL to add the script LocationUsers.php and the necessary table locationusers
6/2/15 Version 4.12.1
5/2/15 Phil: Rewrite of Z_ImportChartOfAccounts.php old script used the api and hard coded based on the database in api_php.php
3/02/15 Exson: Fixed date compatible problem for strict sql mode in CopyBOM.php.
3/2/15 Phil: Added more of Andrew Galuski's QA pdf manual to the webERP html manual.
3/2/15 Andrew Galuski: Fix bug in Credit_Invoice.php that prevented the credit note where the origianal invoice was over delivered compared to the underlying order.
2/2/15 Exson: Remove unecessary suppliercontact sql statement which makes installation failed.
31/01/15 RChacon: Add and modify help text. Spanish translation improvements. Standardise "Account:" to "Account".
30/1/15 Jiro: Updated Traditional Chinese translation under zh_TW.utf8
27/01/15 RChacon: Spanish translation improvements. Note: The "Delete" key (keyboard) is translated to "Suprimir"; for usability, we standardise "borrar", "eliminar", etc. to "suprimir".
27/01/15 Version 4.12 release
25/01/15 RChacon: Add $ViewTopic and $BookMark, comments and page_title_text to ImportBankTrans.php. Add info to Manual.
24/01/15 RChacon: Add info to Manual about Indian Numbering System. Add comments to code. Improvements to Cascading Style Sheet (CSS) for Manual.
23/01/15 RChacon: Generalise indian number format for country=India (languages: English, Hindi, Marathi, etc.).
20/01/15 RChacon: Add translation for transaction type, script ID, manual references, class="number" to columns.
20/1/15 Exson: Remove die() function from Suppliers.php which will make adding or updating suppliers' data failed when google map is activated. Reported by Terry.
17/01/15 RChacon: Fix Czech language code, add info for Croatian language, add the script name and revision number and sort by language code.
16/01/15 RChacon: Standardise RevisionTranslations.php's titles to Stocks.php's titles.
16/01/15 RChacon: Inserts HTML line breaks before all newlines in the default language's long description.
12/1/15 Exson: Remove redundant code from Prices.php.
12/1/15 Exson: Fixed bug in Z_AutoCustomerAllocations.php to make it workable.
9/1/15 Bob Thomas: Removed reference to AliasNbPages() now no longer part of TCPDF
7/1/15 Phil: Added missing SQL for suppliercontacts and supplierdiscounts and adding the script SalesTopCustomersInquiry to the scripts table
5/01/15 RChacon: Allow turn on/off the dashboard display after login for an specific user. Add comments to code.
4/01/15 RChacon: In RevisionTranslations.php, add $Id, $ViewTopic, $BookMark and page_title_text. Add info to manual. Add comments to code.
4/01/15 RChacon: In SystemParameters.php, remove root path to config.php and add comments.
1/01/15 RChacon: Move default theme from session.inc to config.php. Add the ability to change the default theme in SystemParameters.php.
1/01/15 Exson: Make StockCategories.php strict sql mode compatible.
28/12/14 RChacon: Standardise labels and texts in Prices_Customer.php SpecialOrder.php and WWW_Access.php. Add $ViewTopic and $BookMark to WWW_Access.php
28/12/14 RChacon: Add comments, variables to link to the manual and titles in Z_CurrencyDebtorsBalances.php and Z_CurrencySuppliersBalances.php.
28/12/14 RChacon: Add comments, variables to link to the manual and titles in Z_Change*.php.
28/12/14 RChacon: Update comment for the SVN repository automatically updates the revision number, standardise title.
27/12/14 RChacon: Add info to manual and context $BookMark for Sales People Maintenance.
27/12/14 RChacon: Allow translation of typename in CustomerTransInquiry.php.
27/12/14 RChacon: Allow translation of typename in GLAccountInquiry.php.
27/12/14 RChacon: In AutomaticTranslationDescriptions.php, add comment for the SVN repository automatically updates the revision number, add $ViewTopic and $BookMark, and else if no translation. Add info to manual.
27/12/14 RChacon: Set boolean field needrevision to tiny integer with a maximum display width of 1, signed and not null. Add comments to sql file.
20/12/14 Exson: Make COGSGLPostings.php, SalesGLPostings.php SQL strict mode compatible.
20/12/14 Exson: Remove item from weberpchina.sql
18/12/14 RChacon: Modifications of stockdescriptiontranslations table for longdescription translation and translated versions control.
18/12/14 Phil: Fix to only add a description translation record where there is a non-empty translation string
18/12/14 Ricard: Google translate script to add descriptions in a selected language
16/12/14 Agaluski: Add new Quality Module to WebERP.
16/12/14 RChacon: Expand and uniform the accuracy of the exchange rate.
5/12/14 Exson: Fixed the branch field bug in CustomerReceipt.php. Reported by wertthey.
29/11/14 RChacon: Add Pan Size explanation (thanks to Exson Qu Tim Schofield and Pak Ricard) and other item maintenance explanations.
24/11/14 RChacon: In PrintCustStatements.php, make translatable the currency name and the transaction type.
24/11/14 RChacon: Spanish translation improvements. Merging "View GL Entries" and "View the GL Entries".
22/11/14 Exson: Fix the qualitytext does not have default value for strict sql mode in Credit_Invoice.php.
22/11/14 Phil: Z_DeleteOldPrices.php now removes all old prices where there is a later start for a price with no end date
22/11/14 Phil: Added new script CustomerBalancesMovement.php to show customer activity debits and credits and the movement of their balances over a specified date range
22/11/14 Phil: Added new script Z_UpdateItemCosts.php that allows a csv import of items and costs and updates the standard cost based on imported data
20/11/14 Exson: Add GRN numbers to select grns screen in SuppInvGRNs.php.
20/11/14 Exson: Fixed the pop up error when input account no in Payments.php by align the js function with applying it. The fixes are mismatched before. Hope it's the last time.
17/11/14 Thumb: Move EnsureGLBalance() to the right place in ConfirmDispatch_Invoice.php to ensure that the whole transaction are checked instead of only one type of it checked.
17/11/14 Exson: Fixed InvoiceQuantityDefault parameters failed to save in SystemParameters.php. Reported by Richard.
15/11/14: Exson: Remove qtyrecd in work orders requirements calculation from group by in MRP.php.
15/11/14 Exson: Fixed the NULL bug for no issued materials for WO and make multiple times material issues correctly in MRP.php.
14/11/14 Exson: Fixed the foreign key constrained failure bug in Z_DeleteCreditNote.php.
14/11/14 Exson: Fixed the bug in MRP.php that wo requirement not counting demand for work orders without issuing items. Thanks for Tim's reminder.
14/11/2014 Tim: The systypes should be 28 instead of 38 for work order issued in MRP.php.
13/11/Exson: Fixed bugs that issued materials not be calculated in demand for work orders and over received are ignored in level netting and negative inventory are not considered in REORDER level management in MRP.php which leads to wrong MRP results.
9/11/14: Tim: fix to javascript function to sort numbers including formatted numbers with commas.
8/11/14: Alessandro Saporetti: Fixed the bug that the wrong invoiced quantity result in Z_DeleteInvoice.php.
7/11/14 Exson: Remove date range from sql when users input the PO number in PO_SelectOSPurchOrder.php.
06/11/14 Exson: Add code change for table custitem and pricematrix in Z_ChangeStockCode.php.
3/11/14 Exson: Make Dashboard.php workable in php which version is lower than 5.3. Report by Craig Craven.
28/10/14 Exson: Add Chinese Yuan to default.sql to prevent wrong Chinese Yuan input which leads lots of problem. Advised by Thumb.
28/10/14 Exson: Fixed the variable undefined bug in simplify Chinese manual in Manual/ManualContents.php. Reported by webERP Chinese community QQ group chengdu-belief.
27/10/14 Phil: Removed the $db parameter from all DB_Txn_Begin($db) DB_Txn_Commit($db) DB_Txn_Rollback($db)calls - $db is now global
27/10/14 Phil: Removed the $db parameter from all DB_Maintenance($db) calls - $db is now global
27/10/14 Phil: Removed the $db parameter from all DB_error_msg($db) calls - $db is now global
27/10/14 Phil: Removed the $db parameter from all DB_error_no($db) calls - $db is now global
27/10/14 Phil: Removed all $db in DB_query() calls as now a global
25/10/14 Exson: Add sorting feature for tables to meet different needs.
24/10/14 Exson: Fixed the extra blank in pattern in TaxGroups.php which leads to input failure.
24/10/14 Exson: Correct Chinese currency code in weberpchina.sql
22/10/14 Exson: Add Order by in SalesTypes.php.
22/10/14 Exson: Remove debug info in GetPrice.inc. Reported by Jiro Akits.
17/10/14 RChacon: Remove translation of tax category 'Freight' inside database.
17/10/14 Exson: Add po line and due date result in OrderDetails.php.
15/10/14 Exson: Fixed no receipt data displayed retrieved bugs for sales login in CustomerInquiry.php.
14/10/14 Jiro Akits: Update Chinese traditional translation.
13/10/14 Version 4.11.5 release
13/10/14: Exson: Fixed the bugs in pattern properties with extra blank which leads to the patterns checking failed for all fields. Report from webERP Chinese community QQ group DongDong.
12/10/14 Version 4.11.4 release
09/10/14 RChacon: Add transaccion type name translation, transaccion type number and link to GL transaction inquiry in DailyBankTransactions.php.
06/10/14 Exson: Fixed the prices or line total variance in invoice for foreign currencies.
4/10/14 Andrew Galuski: defaulted factory location from WO record
30/09/14 Exson: Fixed the purchase order details status to be right when the PO is recovered from Cancelled status.
29/09/14 Exson: Change charset from latin1 to utf8 for supplierdiscounts.
27/09/14 RChacon: Add ascending class to have sortable columns, complete table-heads and add documentation.
21/9/14 Phil: Tidy up Dashboard to remove redundant code etc
20/9/14 Phil: Move the DB Maintenance/GetConfig/Exchange rates update/audit trail purge inside UserLogin.php to ensure they do no add unecessary overhead to every page
20/9/14 Bob Thomas: StockStatus incorrectly displaying quantity on order extended by conversion units
19/09/14 RChacon: Add ascending class to PaymentMethods.php to have sortable columns.
17/9/14 Phil: Moved the audit log purge to occur if DB_Maintenance is set to run
16/9/14 Phil: Added BNZ GIFTS format for bank account transaction imports
15/09/14 Exson: fixed the date format errors in WorkOrderEntry.php.
13/9/14 Phil: Added new MT940 - SCB - Siam Comercial Bank Thailand style - a bit different to ING's style. Modifications to BankAccounts.php to allow the transaction file format for imports. ImportBankTrans.php must now select the bank account to determine the file import format to use. It now uses an include for the file parsing so other formats can easily be accomodated with a new include.
11/09/14 RChacon: Adds gettext() to line 402 of CustomerAllocations.php. Reported by Harald.
11/09/14 Exson: Code tidy up to make it meet coding guidance in CustomerInquiry.php.
11/09/14: Exson: Fixed the prnMsg bug in CustomerReceipt.php and add an inquiry link in it and make a status selectable in Customer inquiry and removed those rowstring definition which caused printf parameters missing.
31/8/14 RChacon: In general: Replaces code to determine background colour with TableRows(). Adds comments to ManualNewScripts.html. Fixes manual.css format. In GLTransInquiry.php: Adds $ViewTopic and $BookMark and sorts columns, and minor improvements. Minor translation improvements.
31/8/14 RChacon: Standardizes page_title_text to main-menu-option, standardizes bottom tax-menu, adds $ViewTopic and $BookMark, completes table header columns, formats data columns in Tax* scripts.
30/8/14 RChacon: In TaxAuthorities.php, adds $ViewTopic and $BookMark, completes table headings, formats number columns to fix sort order, and minor improvements.
30/8/14 Phil: WorkOrderEntry.php didn't handle no item returned from search correctly - fixed.
29/8/14 RChacon: In TaxAuthorityRates.php and TaxCategories.php: adds $ViewTopic and $BookMark; Uses gettext() to translate 'Exempt', 'Freight' and 'Handling'.
29/8/14 Exson: Fixed the StockLocStatus Serial Number link column shift problem.
28/8/14 RChacon: In Tax.php: Fixes SQL select order-by from transaction-date to record-number (primary key). Minor improvements.
28/8/14 Exson: Fixed the csv file aligned abnormal when there are commas in fields strings.
28/8/14 RChacon: In Tax.php: Adds code comments, clean-up unneeded variables, simplies and reorder SQL select, reduces if() calls, replaces addTextWarp-left-align with addText, replaces line-drawing a box with Rectangle(), fixes start-date for 'Y/m/d' format, adds start-date for 'Y-m-d' format, adds a summary section for the report, adds ViewTopic and BookMark, adds more NoOfPeriods.
26/8/14 RChacon: In PDFPriceList.php: Adds code comments, adds PageHeader() print for currabrev and categoryid, replaces addTextWarp-left-align with addText, replaces line-drawing a box with Rectangle(), adds 'Prices excluding tax' warning.
15/8/14 RChacon: Fixes double line feed in PDFQuotationPortrait.php reported by Arwan Galaya. Uniforms code between PDFQuotation.php and PDFQuotationPortrait.php.
14/8/14 RChacon: In CustomerInquiry.php and SupplierInquiry.php makes translatable the systypes.typename.
14/8/14 RChacon: In SupplierInquiry.php: Reorganizes columns Date, Type, Number, Reference and Comments, and regroups table-datacel format-strings as in CustomerInquiry.php code.
13/8/14 kelo: SupplierBalsAtPeriodEnd.php fix calculation to take into account fx differences on after date transactions
13/8/14 RChacon: includes/DatabaseTranslations.php used to store the fields of tables that are used from the database so that they can be translated in particular systypes for the types of transactions invoice credit note payment receipt etc. Can be extended for scripts and other tables where the data from the table is static and used to display
13/8/14 RChacon: In CustomerInquiry.php: Adds class ascending and reorganizes columns Date, Type, Number and Reference; Regroups table-datacel format-strings, completes the datacel quantity by table-row; makes translatable the systypes.typename.
12/8/14 RChacon: In SupplierInquiry.php: makes the field systypes.typename be translatable.
12/8/14 RChacon: In Z_poRebuildDefault.php: extends title, improves comments, sets file to pot, updates $FilesToInclude, renames old pot file to bak extension. Minor improvements.
08/8/14 Andrew Galuski: Add SQL and maintenance screens for Location based security. added new report aged controlled stock. additional scripts to follow as time allows
2/1/14 Tim: Change columns around on SelectWorkOrder.php
31/7/14 RChacon: Corrects the bottom line of the rectangle. Adds comments (info for developers).
29/7/14 RChacon: In PDFPriceList.php: Adds comments (info for developers), ViewTopic and BookMark, and currency name in locale language; deletes unused lines; reformats for legibility; adjusts column sizes to field sizes; improves printing of stockmaster.longdescription; improves code to reduce execution time (calculation out of loops); links right column positions to right margin; corrects IF for CustomerSpecials (deletes translation). In ManualSalesTypes.html: Adds help info about Print a price list by inventory category.
27/7/14 Exson: Fixed the PO header lost initiator bugs when locations changed. Report by Akits from www.minghao.hk/bbs/.
25/7/14 Phil: Allow dummy - labour stock type items to be added to purchase orders.
17/7/14 RChacon: Adds ViewTopic and BookMark, adds bullet for class ascending columns, repositions columns Type and Trans, add class number to Trans, completes printf.
16/7/14 Andrew Galuski: Add standard cost to stock movement record for stock adjustments
03/07/14 Exson: Make status comments available in PO_OrderDetails.php to ensure that some important data such as grn reversing can be viewed. And add a return previous page link.
27/06/14 RChacon: Add code-comments, $ViewTopic, $BookMark, page_title_text and code to update NewStockID if OldStockID and SelectedStockItem are the same in Z_ChangeStockCode.php. Add id to the "Change An Inventory Item Code" topic anchor in ManualSpecialUtilities.html.
27/6/14 Exson: Make tel length in PO_Header.php is as same as field definition in sql.
26/6/14 Exson: Fixed the bug that Select Customers search result inconsistence with Customer receipt search result in SelectCustomer.php.
24/6/14 RChacon: Add $ViewTopic, $BookMark to Prices.php and minor improvements.
23/6/14 Tim: Fixed the GL account validation pop up error in MiscFunctions.js.
23/6/14 Exson: Fixed the bug that the sales order line's quantity will be update to zero but it show no change in appearance in SelectOrderItems.php.
22/6/14 Tim: Replace now() with CURRENT_TIMESTAMP in MRP.php to get time stamp to meet ANSI standard.
22/6/14 Exson: Fixed the mrp parameters runtime to datetime instead of date format since MRP running records need more precision.
22/6/14 Benjamin (bpiltz2302) from web-ERP-users mail list report and provide the solution for MRP LevelNetting unusual exit bug. The details can be found here: http://weberp-accounting.1478800.n4.nabble.com/MRP-Error-LevelNetting-td4657425.html
21/6/14 Exson: Add location check in StockAdjustments.php to prevent from users selecting controlled items based on one location but changed the location before submit it to server which make serial not exist check absolutely failed.
17/6/14 Exson: Add Z_ImportDebtors.php into Utilities menu and scripts table.
15/6/14 Akits from minghao.hk/bbs/ fixed the bugs that www_Users.php allowed modules does not matched the one displayed in index.php.
11/6/2014 Exson: Fixed the exported csv files with wrong aligned fields due to comma as part of fields content.
09/6/2014 Exson: Fixed the Delivery Date lossing bugs when change Warehouse. Reported by akits from minghao.hk(weberp) bbs.
2/6/14 Phil: Added bom effectivity dates into work order creation cost calculations - as spotted by Andrew Galuski
1/6/14 Phil: Fixed bug in POItems.php that resulted in an SQL error when the number of items from the search was zero after previous searches had returned records
27/05/14 RChacon: Add page title text and icon to import scripts. Page title text = menu option.
27/05/14 RChacon: Regroups the import scripts in the utility menu.
27/05/14 Exson: Add Sales man login control for PDFOrderStatus.php
26/05/14 Thumb: Fixed discount modifier missing bug in SelectOrderItems.php.
26/05/14 rchacon: Fixes other problems related to updating translations of the items description..
22/05/14 newuser990(from webERP forum): fixed bugs in MRP.php that quantity which stated in PO with lines not completed but PO status marked Completed are calculated as supplies. Exson add PO order lines checked to avoid same problem.
22/5/14 Tim: Currencies.php now allows FunctionalCurrency to be modified
22/5/14 Phil: Prevent use of enter key - experimental - in number fields - prevents users from losing data in big forms where they are entering large amounts of data e.g. purchase ordering - maybe we should consider for integer fields too?
22/5/14 Ricard/Phil: Tidy up SQL in StockClone.php
19/5/14 Exson: Tidy up code of SelectOrderItems.php.
18/5/14 Thumb: Fixed the bug in ConfirmDispatch_Invoice.php for Balance quantity canceled policy by line no instead of by stockid since webERP allow same stock appeared in one order multiple times.
18/5/14 Exson: Tidy up SelectSalesOrder.php SQL code and add Thumb's salesman login control and fixed bugs caused by no group by statements for customer and items selected.
17/05/14 Phil: sales invoice and credit scripts all check for 0 exchange rate before updating sales anlaysis now
17/05/14 Phil: Fixed Z_ChangeStockCode.php which was orphaning stockdescriptiontranslations without changing them to the new code
14/05/14 Exson: Fixed typo in MRPReport.php which make some supplies not to be shown on the report and use itemdue instead of deliverydate in MRP to ensure that requirements are calculated correctly for items due on different date.
3/5/14 Khwunchai J.: New Xenos theme
3/5/14 Phil: StockCostUpdate.php now allows updates to manufactured items.
29/4/14 Exson: Make price matrix workable including GetPrice.inc, MainMenuLinksArray.php,SelectOrderItems_IntoCart.inc,PriceMatrix.php, SelectProduct.php,StockDispatch.php.
20/04/14 Exson: Fixed undefined variable bugs in PDFWOPageHeader.inc and PDFWOPrint.php and remove some redundant codes in PDFWOPrint.php
17/04/14 Exson: Update zh_CN.utf8 translation.
09/04/14 Tim: Fixed the table sort failure bugs in SelectSalesOrder.php reported by Andrew Agaluski.
07/04/14 Exson: Add InOutModifier to input Quantity when there whole batches are removed. Otherwise, it will create a wrong quantity left in Add_SerialItems.php.
07/04/14 Exson: Fixed the bug in Prices_Customer.php. MySQL strict mode not allowed a date is a white space.
06/04/14 Exson: Fixed the quote date and order confirmed date has not been retrieved for orders to modify in SelectOrderItems.php.
6/4/14 Andrew Galuski: Extensions for printing WO documentation new labels and links to print
05/04/14 rchacon: Fixes the bug that emptied ItemDescriptionLanguages.
05/04/14 Exson: Add decimal places check for controlled items quantity input in Add_SerialItems.php and InputSerialItems.php.The wrong decimal places will make this sections quite buggy and problem prone.
05/04/14 Exson: Add a decimal places check in StockAdjustments.php to prevent from wrong decimal places input.
04/04/14 Exson: Fixed the bug that controlled items can be dispatched more than order balance in ConfirmDispatch_Invoice.php.
2/4/14 Andrew Galuski: Get Credit available when modifiying an existing order
28/03/14 Exson: Fixed the Expiry Date not handled right during stocks adjustments by manual key in or bar code scan in Add_SerialItems.php, DefineSerialItems.php,InputSerialItems.php and InputSerialItemsKeyed.php.
26/3/14 Serakfalcon: fixed findLogoFile function in includes/session.inc
24/3/14 Phil: Removed DefaultTheme configuration parameter - unecessary as noted by Serafalcon
23/03/14 Exson: Fixed the no defined variable bugs in WorkOrderIssue.php. Reported by Tim.
23/03/14 Exson: Fixed the bug that the search results shows only limited to DisplayRecordsMax which does not make sense due to pagination in WorkOrderIssue.php.
23/03/14 Exson: Fixed that currency name not available in Prices.php.
22/03/14 Exson: Fixed the stock searching function failure when items setup in system less than DisplayedRecordsMax in WorkOrderEntry.php.
21/03/14 Exson: Fixed that bugs in WorkOrderIssue.php that the issued non BOM materials not shown. And fixed bugs in WorkOrderStatus.php failed to retrieve item description.
20/3/14 Exson: Fixed the bugs in StockCounts that Location set does not work and link typo.
19/3/14 Tim: Fixed the bug Items Other than those in BOM are not listed in Status of Work Order even if issued. Exson made a little revision to keep SQL query only once for those additional issued materials. Reported by newuesr990 from weberp forum.
18/03/14 Exson: Fixed the bugs in GoodsReceived.php which will leads to duplicated goods receiving.
17/3/14 rchacon: Allow translations of tax category Freight
15/3/14 Phil: Z_ChangeStockCategory.php was not updating sales analysis records correctly - fixed
15/3/14 Andrew Galuski: Auto Supplier number functionality
14/3/14 Jiro Akits: Updated zh_TW.utf8 translation
14/3/14 Phil: removed htmchars in DB_escape_string() functions as suggested by Tim
05/03/14 icedlava: Ensure there are no unescaped characters in existing data when updating purchorders after reversing GRN. This fixes a symptom of a more widespread bug and therefore temporary until more general fix is applied.
05/03/14 icedlava: Remove input fields (Country and Language) and display this data instead on customer view page
03/03/14 Exson: Remove redundant code in CustomerAllocations.php
03/3/14 icedlava: WhereUsedInquiry.php will no longer accept StockID with dash (-) as input allowed has changed. Still need to check for consistency for StockId input elsewhere in code.
2/3/14 Paul T: Div swap in footer to simplify CSS for Gel and Silverwolf themes. Some other themes will see a basic position swap of the date and version info where these vertically appeared together at the far left end.
1/3/14 Paul T: Correct variable spelling error. [reported in forums by serakfalcon]
24/2/14 Exson: Make negative integer allowable in MiscFunctions.js and make negative integer inputable for PastDueDays in SystemParameters.php.
22/2/14 Exson: Fixed the wrong error messages displayed while input date data manually in MiscFunctions.js.
19/2/14 icedlava: GLTrialBalance_csv.php -Remove set AllowAnyone variable and prevent TB display - temp solution.
18/2/14 Exson: Remove redundant code in StockLocStatus.php and InventoryPlanning.php.
17/2/14 Exson: Tidy up variable overwrite to if else structure in WorkOrderReceive.php scripts according Tim's comments.
17/2/14 icedlava: CopyBOM.php - SQL fix for insert to bom and locstock tables - ensure column counts match values even when zero.
16/2/14 icedlava: StockCounts.php - Enter by Category only counts and enters 10 items maximum - fix to allow any number that are input.
15/2/14 Exson: Make perishable control available in WorkOrderReceive.php.
15/2/14 Phil: Stock check comparison report now shows the bin location after the item code
15/2/14 Phil: Customer statement now shows bank account number for payments based on the defined default bank account
15/2/14 Andrew Galuski: Reverse HTML5 input type="date" as this will not use the webERP javascript date picker used everywhere else - better be consistent as html5 date picker functionality varies between browsers - AddCustomerNotes.php and AddCustomerTypeNotes.php
15/2/14 Vitaly: Fix PO_SelectOSPurchOrder.php date selection functionality
15/2/14 Phil: Fixed POSDataCreation script to send all current prices in the POS currency including debtorno info so the POS can now deal with customer specific prices correctly.
15/2/14 Andrew Galuski: WorkOrderStatus.php now shows requirements for multiple parent item works orders.
12/2/14 Andrew Galuski: WOSerialNos.php - added filter number format on quantity
12/2/14 Exson: Fixed the Earliest date calculation when is over Friday cutoff Time in DateFunctions.inc.
8/2/14 Release 4.11.3
8/2/14 Phil: prevented GL posting to control accounts from Payments.php and CustomerReceipts.php where the configuration option to stop postings to these accounts is set.
8/2/14 Phil: Used Tim's code as the basis to allow deletion of internal stock request items.
6/2/14 Eduardo Marzolla: geocode integration geocode with google API v3. You need to get a API Key from google. The parameters to geocode must be: geocode key: your API key geocode lat: your lat geocode long: your long geocode height: 100 geocode width: 100 host geocode: maps.googleapis.com
6/2/14 icedlava: Payments.php - correct javascript to prevent error popup on every manual GL code entry, correct spacing.
6/2/14 icedlava: BankMatching.php - correct column heading order.
4/2/14 Tim: SalesTopCustomersInquiry.php - shows top customers over specified date range showing invoices/returns and net sales
3/2/14 Exson: Fixed installer now allows characters in the database name
3/2/14 Phil: Fix bug in Payments.php that was duplicating payments for mutliple GL analysis entries. Now just a single bank trans is created for the payment which can be analysed to any number of GL accounts
31/1/14 Andrew Galuski: Profit and Loss format fixed for detailed - don't show zero balances accounts
31/1/14 Muthu: Added sequence field to BOMs.php
30/1/14 gilberto dos santos alves: Updated pt_BR and also applied to pt_PT translation since pt_PT translation was quite old
28/01/14 Exson: Update the hold reason table default data dissallowinvoice to make customers' credit on watch is workable.
24/1/14 Andrew Galuski: Display serial items on GRN printouts
23/1/14 Phil: Fixed incompatible error traps on hyphens between new customers and new branches. Now both allow hyphens. Also prevented deletion of the last customer branch. Customer branches are now deleted when a customer is attempted to be deleted provided there are no dependent records.
19/01/14 Exson: Add sales man login control and modify the PDF to download to harmony with other files and solve backward failure problem in PrintCustStatements.php.
18/01/14 Paul T: Change property name value to uppercase to match use in the script. [causing input loss]
16/01/14 Exson: Fixed sql strict mode failure problem in StockTransfers.php by adding a '' to qualitytext fields.
23/1/14 Tim: PO_SelectOSPurchOrder.php now allows selection of purchase orders based on order dates
14/1/14 Tim: system would go to get currency rates even though they were set to manual - bug fixed.
14/1/14 Phil: Fixed bug that was not recording the standard cost against goods received - this would put all accounting out for both standard and weighted average journals.
13/1/14 Phil: Fixed SuppInvGRNs.php price variance was not calculated correctly because cost not brought accross correctly as reported by Don Grimes
11/1/14 CQZ: Fixed that no bank accounts recorded in gl in CounterReturns.php
6/1/14 Phil: Apply Tim's bug report regarding conversion of database name to lower case in ConnectDB.inc Although uppercase characters should not be included in database names, removing this trap allows backward compatibility with users who did install with upper case database name
4/1/14 Phil: Add option to create CSV from inventory valuation rather than create PDF
2/1/14 Exson: Fixed php-mbstring extension detection failure in install/index.php during installation.
27/12/13 Thumb: Fixed the stock location will loss problem when move to StockAdjustmentsControlled.php interface in StockAdjustments.php.
23/12/13 Exson: Fixed the controlled items cannot be removed due to the negative operator is modified and balance of a serial no is wrong due negative operator is missing during credit controlled items by KEYED method. Other input method has not be inspected.
22/12/13 Exson: Add a fool-proof to Credit_Invoice.php to prevent an invoice was credit again and again.
22/12/13 Exson: Modify the stock select element to a combox box which autocomplete the limited stock ID options to 300 in PriceMatrix.php. Otherwise, users have to input an stock ID themselves. To avoid a too long stock list as pointed by Tim.
21/12/13 Exson: Add price matrix features. Modified MainMenuLinksArray.php, GetPrice.inc and add pricematrix table and PriceMatrix.php
20/12/13 Thumb: Salesman can only review his own customer's data
14/12/12: Phil: As per Gilberto dos santos alves - Extended smtp user name to varchar(50) as sometimes a full email address is required - tidied the script a bit too.
11/12/13: Thumb: fixed bug that calculated the wrong StandardCost of assembly parts in Credit_Invoice.php and SelectCreditItems.php. Bug confirmed by Phil.
11/12/13 Thumb: fixed bug that using limit without offsetting in PO_Items.php,WorkOrderEntry.php and make users' DisplayRecordsMax effective in SelectOrderItems.php.And fixed typo in SelectCreditItems.php.
9/12/13 Exson Fixed the typo of sql in DiscountCategories.php. Report by tangjun
7/12/13 Phil: Allow entry of stock counts by stock category
7/12/13 Phil: Fixed htmlMimeEmail.inc following Tim's submission - removed & value by reference errors
4/12/13 Exson: Alter table stockmoves reference to varchar(100) to make it can meet mysql strict mode requirements when data is more than original 40.
2/12/13 Exson: Fixed the typo in WWW_Users.php. Reported by Thumb.
1/12/13 Exson: Fixed country Chinese sql for installation failure.
1/12/13 CQZ: Correct Chinese translation error dispatch cut_off time.
1/12/13 Release 4.11.2
30/11/13 Ricard: Added user permissions by bank account so only certain users can see and create payments/receipts on bank accounts selected.
30/11/13 rchacon: Includes supplier-code, currency-code, and currency-name-from-CurrenciesArray.php in SelectSupplier.php.
2013/11/30 Thumb: Add salesman constraint to show salesperson's own sales orders invoice, customer etc in DailySalesInquiry.php,PDFDeliveryDifferences.php,PDFOrdersInvoiced.php,PDFOrderStatus.php,PDFPickingList.php,SalesByTypePeriodInquiry.php,SalesInquiry.php,SelectCompletedOrder.php.
28/11/13 Phil: Apply Tim's idea for stripping slashes from incorrectly displayed items PO_Items.php and DeliveryDetails.php
28/11/13 Thumb: Add salesman constraints to ConfirmDispatch_Invoice.php to ensure that sales can only print his own sales orders' invoice.
28/11/13 Thumb: Add constraints to salesman that he can only print his own sales orders in PrintCustOrder_generic.php
28/11/13 Thumb: Add constraints to salesman that he can only print his own sales orders in PrintCustOrder.php
28/11/13 Thumb: Add salesman login constraint to only their own customers available in SelectOrderItems.php and fixed SQL error of customers login.
27/11/13 Thumb: Add create new scripts to import Customers and Debtors.
26/11/13 Phil: Supplier invoice entry now allows modification of invoice quantities and prices for multiple goods received lines in line rather than having to go into each line to modify individually.
20/11/13 rchacon: Translate the name of each language to the name in their respective language.
20/11/13 Phil: Payments.php FunctionalExchangeRate was not defaulted appropriately when entering a supplier payment in FX from a bank account of the same currency selected and the transaction was posted immediately without update first. Fixed
19/11/13 Thumb/CQZ: Add webERP Chinese country sql including Chinese COA, currency, role,tax, transaction type etc which should be localized.
19/11/13 Thumb: Add '-' to telephone no pattern in CustomerBranches.php and WWW_Users.php.
19/11/13 Thumb: Correct translation of customer text and customer code in CustomerReceipt.php of locale file.
19/11/13 Thumb: Text 'settled transaction' position adjusted to proper position in PrintCustStatements.php.
18/11/13 Exson: Make inventory it as default to show inventory serial no in ConfirmDispatchControlled_Invoice.php.
18/11/13 Exson Make company name client side requirements consistent with server side in CompanyPreferences.php.
16/11/13 rchacon: Improves translation and format in PaymentMethods.php.
16/11/13 Phil: MacPhotoBiker reported shipment charges html5 type=number removed to use the class=number javascript'
12/11/13 rchacon: Allow translation of the subkey name in FormDesigner.php.
07/11/13 rchacon: Allow translation of the key name in FormDesigner.php.
7/11/13 Exson: Add check box to allow user to decide weather raw material is sellable or not.
7/11/13 Exson Revise the bin definition to NOT NULL DEFAULT '' as suggest by Tim to make it more ISO compatible.
06/11/13 rchacon: Allow multiline printing of salesorderdetails.narrative in quotations.
5/11/13 Phil: Fixed the warning error in GLAccountInquiry.php add change variable type to array to make min() and max() reasonable. Reported by Jo
04/11/13 icedlava: change insert new clone stock event to transaction as in Stocks.php for new item.
03/11/13 rchacon: Allow translate the name of the currency on CompanyPreferences.php.
3/11/13 Exson fixed the bug that discount id for category cannot be set and add an error message when there is no stockid set for the respective category.
03/11/13 Exson: Fi3/11/13 Exson: fixed bug by removing pattern and add no-illegal-chars to stockid in StockReorderLevel.php.xed bug in MiscFunctions.js allow '0' input as number.
01/11/13 rchacon: Allow translate the name of the currency on Currencies.php.
31/10/13 rchacon: Allow translate the name of the currency on CustomerReceipt.php and Payments.php.
30/10/13 rchacon: Allow insert different data on banktrans.ref and gltrans.narrative for the bank account on CustomerReceipt.php. Match the page_title_text with the MainMenuLinksArray option for Bank Account Payments Entry and Bank Account Receipts Entry. Regroup the General Ledger Transactions menu.
30/10/13 Exson: Add required attribute for Z_MakeNewCompany.php to avoid file void error and make it more user friendly.
30/10/13: Exson modify the locstock table change the bin to NULL to avoid stick sql standard constraint failed for those items without bin.
30/10/13 Exson: Modify the the insert new stocks event to transaction.
24/10/13 MailingGroupMaintenance.php, minor tag and other formatting corrections.
20/10/13 icedlava: Add StockClone.php script to create a new item with the same properties, image, cost, purchasing and pricing data as the selected item, and allow modification of image and general item details before cloning.
18/10/13 Paul T: ManualSecuritySchema.html, add missing tr tags, reduced doubled-closing td tags to one, and changed & to & for HTML.
18/10/13 Paul T: ManualInventory.html, add bracket to complete closing h3 tag.
15/10/13 Paul T: GoodsReceived.php, change variable name from OrderNumber to OrderNo.
11/10/13 Tim: Links for manual internal transfers and supplier payment link to allocations
9/10/13 Exson: commit the fixed "Unable to Locate Purchase Order Number" error when the PO is created by SO interface. Fixed provided by Tim and reported by Merci from webERP forum.
6/10/13 Phil: New script to show a grid of items by preferred supplier for placing purchase orders to the users's default inventory location - orders will be authorised if the user has authority and the auto-authorise config option is enabled.
3/10/13 icedlava: PO_Items.php with non-stock items still require GL Code in case of modified order at invoice time else SQL error is generated due to invalid GL Code.
2/10/13 David Lynn: Added new field url to suppliers modified SelectSupplier.php and Suppliers.php
28/9/13 wh_hsn: help with regular expression to trap quotes and backslashes for data-type="no-illegal-chars"
28/9/13 Phil: Followed Exson's example to set pattern to prevent dodgy characters in other scripts that were using a pattern that only allowed [a-zA-Z0-9] thus making it impossible to enter non latin characters.
11/9/13 icedlava: SelectCompletedOrder.php Fix SQL typo.
7/9/13 Exson: using javascript to set the pattern attribute based on a new attribute data-type and first script Stocks.php
7/9/13 icedlava: Fix PrintStatements.php to allow selection of alphanumeric customer codes in length to match database definition.
7/9/13 icedlava: StockStatus.php Allow dash in stock code again.
6/9/13 Version 4.11.1
6/9/13 Phil: Typo in ConfirmDispatch_Invoice preventing invoicing - changed patterns to remove {1,20} statements which make the pattern fail to validate. SelectProduct removed pattern from keyword search on description to allow entry of any characte as reported by Brian May
5/9/13 icedlava: Stocks.php Set error message for upload image failure when no upload tmp directory set in php.
5/9/13 icedlava: Stocks.php Clear item image for new item creation.
5/9/13 icedlava: Suppliers.php regex pattern for email, also not all suppliers have email.
4/9/13 Exson: Fixed the undefined StockID error and make it html5 compatible and table sorting in StockReorderLevel.php
2/9/13 icedlava: SelectOrderItems.php fix frequently ordered items to accept entry as was not working.
2/9/13 icedlava: inc tax corrected to ex tax on ConfirmDespatch.php and DeliveryDetails.php
1/9/13 Version 4.11.0
29/8/13 Exson: Fixed the pattern typo error in StockCategories.php.
28/8/13 Exson: Fixed html tag mark error and make it html5 compatible and table sortable in StockStatus.php
28/8/13 Exson: Fixed MiscFunctions.js bug which make onclick event failed for tag whose class is date, number or integer. Solution from Tim. And update the sql file in coa directory.
27/8/13 Exson: Remove the option of weberp-demo.sql to avoid installation error. Reported by icedlava.
27/8/13 icedlava: Allow display of BOM component entry screen after deletion of component in BOM.php
27/8/13 icedlava: Fix rounding error in supplier unit price when less than 1
26/8/13 Exson Add A default company name to make the installation as dummy as possible.
26/8/13 icedlava: Fix COGS and Sales GL interface to include AN area and specific Sales Type and Stock Category.
21/8/13 Thumb: Fixed the object no definition error in StockTransfers.php.
21/8/13 Exson: Fixed the notice error of undefined index Status and and space for some string.
21/8/13 Exson: Fixed the sortable not workable bug in Prices.php.
21/8/13 Exson: Change sortable block from table to tbody. Reported by Tim.
20/8/13 Exson: make StockUsage.php html5 compatible and table sortable.
20/8/13 Exson: html5 compatible and table sortable for SuppContractChgs.php,SuppCreditGRNs.php,SuppFixedAssetChgs.php,SuppInvGRNs.php, SupplierAllocations.php
20/8/13 Exson: Make SupplierInquiry.php table sortable
20/8/13 Exson: SupplierContacts.php html5 compatible and table sortable.
20/8/13 Exson: Make SupplierCredit.php html5 compatible.
20/8/13 Exson: Use manually instead of manual to make distinguish translation possible and make it html5 compatible in SupplierInvoice.php.
19/9/13 Exson: Fixed the typo that should be class integer instead of type integer. Reported by Tim.
19/8/13 Exson: Fixed the account code pattern to make it compatible with the definition in GLAccounts.php
19/8/13 Exson: Fixed the type error to class is integer. Reported by Tim.
19/8/13 Exson: Fixed blank validation error in Suppliers.php and make it html5 compatible.
19/8/13 Exson: Add warning messages for no suppliers returned in SupplierTenderCreate.php and make it html5 compatible and table sortable.
19/8/13 Exson: Make SupplierTenders.php html5 compatible and sortable.
19/8/13 Exson: Fixed the validation error which allow blank supplier type and make it html5 compatible and sortable.
19/8/13 Exson: Make SuppLoginSetup.php html5 compatible.
16/8/13 Exson: Remove redundant Ref no and make SuppPaymentRun.php html5 compatible.
16/08/13 Exson: Make the SuppShiptChgs.php html5 compatible.
16/08/13 Exson: Fixed the account code max length in SuppTransGLAnalysis.php and make it html5 compatible.
15/8/13 Exson: Modify 'manual' to 'manually' in SystemParameters.php to remove the translation frustration and make it html5 compatible.
15/8/13 Exson: Make TaxAuthorities.php html5 compatible and table columns sortable.
15/8/13 Exson: Make TaxAuthorityRates.php html5 compatible.
15/8/13 Exson: Make the tax category 'Freight' undeleted in TaxCategories.php and make it html5 compatible and table sortable.
15/8/13 Exson: Make TaxGroups.php html5 compatible.
15/8/13 Exson: Make TaxProvinces.php html5 compatible.
15/8/13 Exson: Fixed the no-number warning in TopItems.php and make it html5 compatible.
14/8/2012 Exson: make UnitsOfMeasure.php html5 compatible.
14/08/13 Exson: html5 compatible for UserSettings.php
14/8/13 Exson: Make table in WorkCentres.php sortable.
14/8/13 Exson: make WhereUsedInquiry.php Html5 compatible.
14/8/13 Exson: Make WorkCentres.php html5 compatible.
14/8/13 Exson: HTML5 compatible for WorkOrderEntry.php.
14/8/13 Exson: fixed the in_array() warning in WorkOrderIssue.php and make it html5 compatible.
14/8/13 Exson: html5 compatible for WorkOrderReceive.php
14/8/13 Exson: Html5 compatible
14/8/13 Exson: Fixed INSERT sql errors and href link error and make it html5 compatible in WOSerialNos.php.
0/8/13 icedlava: Update Manual - Using the webERP Installer - rework of some text due to new installer, and updated screen shots
03/8/13 icedlava: Obfuscate database name in login, do not show company in login if directory/company not wanted.
29/7/13 Serge Gélinas: Profit and loss now has option to show all accounts and by default just shows those with a balance
29/7/13 icedlava: Hard code the page title in Installer html, previously missing - no language strings available at this time - used English
28/7/13 icedlava: Installer - strip inline styles, add html5/css to pretty up, fix small typo/bugs and spelling/grammar. No logic changes.
28/7/13 icedlava: Allow ampersands in company name eg Matthew & Sons Ltd
26/7/13 icedlava: Move Supplier Contact Detail review link to top of page away from Delete button
26/7/13 icedlava: Fix Form Designer xml for GL Journal
26/7/13 icedlava: Fix PO PDF Preview when $result returns Bool in some environments.
25/7/13 Serge Gélinas: Balance sheet now has option to show all accounts and by default just shows those with a balance
24/7/13 Exson: Fixed that empty password should be allowed. Reported by Tim.
24/7/13 Exson: Add the html5 mark for some input fields in WWW_Users.php.
22/7/13 Exson: Fixed the document.form not defined error in GLJournal.php.
22/7/13 Thumb: Fixed the onchange overwritten problem for number class in MiscFunctions.js. Reported by Tim for GLJournal.php lost Credit and Debit mutually exclusive feature.
21/07/13 Exson: allowed the input of numeric format like .5 in MiscFunctions.js rLocalNumber() function. Reported by Tim.
7/21/13 Exson: Fixed the keyChar control to avoid backspace mistake.
7/21/13 Exson: Fixed the number class function in MiscFunctions.js prevent character 0 from input for integer. Reported by Icedlava
20/7/13 Phil: Added Tim's javascript as modified a bit to use different styles to allow sorting of tables - images for styles to all themes and added th.ascending th.descending to theme/default.css scripts
19/7/13 Phil: Swag of scripts updated for html5 <input type="tel" "email" pattern required="required" autofocus="autofocus" as per http://www.weberp.org/wiki/TransitionToHtml5 also added many title="" tooltips
19/7/13 Exson: add required to the input field of WWW_Access.php
19/7/13 Exson make the WWW_Access.php html5 compatible
18/7/13 Exson: Move the hidden input after the html document type definition. Reported by Tim.
18/7/13 Exson: fixed the LanguageSetup.php extra language mark introduced by handle locale number. Reported by Tim.
18/7/13 Exson: Fixed the missing negative mark problem reported by Tim.
18/7/13 Exson add a locale style check to pass the style to MisFunctions.js to do locale number format validation in LanguageSetup.php.
18/7/13 Exson: modify the MisFunctions.js to improve the locale number validation feature.
17/7/13 icedlava: stripslashes on Description for consistency with LongDescription but why- only until we fix source of this problem in the code
17/7/13 icedlava: add checkbox option in UI to clear item image
17/7/13 Exson: Add space bar as a accepted charcode for number input in MiscFunctions.js
16/7/13 icedlava: Add date check on purchase price effective date.
16/7/13 icedlava: AllowCompanySelectionBox comparison fix to allow boolean value to evaluate correctly
14/7/13 Exson: Add new directory for new installer and add those default installation sql file.
14/7/13 Exson: Rewrite the installer by removing the save.php file and revise the index.php file.
24/6/13 Phil: webSHOP ShopParameters.php script and new configuration variables to allow integrated shop
21/6/13 Phil: ContractCosting.php fix references to contract issues object which should just have been an array.
18/6/13 Phil: Reworked the display of stock category properties on the SelectProduct.php inquiry
18/6/13 Tim: Z_ImportGLTransactions.php new script for importing GL payments, receipts or journals from a CSV file
17/6/13 Paul Harness: Fix sql query of goods received when a serial number is already present. GoodsReceived.php
12/6/13 tomglare: SelectSupplier - improve handling if single supplier selected
25/5/13 Phil: CountriesArray.php now uses the index as the ISO 2 character code for the country.
25/5/13 Phil: Currencies.php now takes advantage of Rafael's new CurrenciesArray - to ensure correct ISO 3 letter abbreviation is selected - also allows for translation of currency names
25/5/13 Rafael Chacón: New include/CurrenciesArray.php listing all ISO currencies and their code
22/5/13 Rafael Chacón: include/PO_PDFOrderPageHeader.inc now allows different length labels for date and intiator without running into the field data - needed for translations of different lengths
18/5/13 Exson: Stop session.inc execution when there is no config.php found.
17/5/13 Phil: ConfirmDispatch_Invoice.php -include qty already invoiced in order when cancelling any balance on subsequent deliveries.
12/5/13 Tim: Add patch for the email groups are set situation in PDFChequeListing.php, MailSalesReport.php, MailSalesReport_csv.php, OffersReceived.php.
12/5/13 Tim: Add patch for GetMailList to show error when there is no email settings available.
12/5/13 Exson: Make smtp mail available for StockLocTransferReceive.php.
12/5/13 Exson: Make the smtp mail available for StockAdjustments.php.
12/5/13 Exson: Fixed the bug of not use strpos correctly in PO_PDFPurchOrder.php.
12/5/13 Exson Make smtp mail available for InternalStockRequestFulfill.php.
12/5/13 Exson: Fixed the stockrequestitems duplicated primary key bug by modify the primary definition.
12/5/13 Exson Make the smtp mail available in InternalStockRequest.php.
12/5/13 Exson Make the SMTP mail available for UserLogin.php.
12/5/13 Exson: Make SMTP mail available for EmailConfirmation.php. The scripts seem not ready.
12/5/13 Exson: Add smtp mail to DeliveryDetails.php.
12/5/13 Exson Make the SMTP mail available for CounterSales.php to mail new WO.
12/5/13 Exson: Make the sales report can be mailed via SMTP in files MailSalesReport.php and MailSalesReport_csv.php
11/5/13 Exson: Make EDI modules can send mail via SMTP in files EDIProcessOrders.php, EDISendInvoices.php, EDISendInvoices_Reece.php
11/5/13 Exson: Make the inventory valuation report can be mailed.
11/5/13 Exson: Add Mail Validation Report to inventory module in MainMenuLinksArray.php.
11/5/13 Exson: Revise the CURDATE() to CURRENT_DATE to make it a more general SQL compatible in OffersReceived.php. Recommend by Tim.
12/5/13 Rafael Chacón: Spanish translation update
11/5/13 Exson: Add OffersRecievedResultRecipients group to mailgroups in ugrade4.10-4.11.sql/mysql/upgrade4.10-4.11.sql
11/5/13 Exson: Add OffersReceivedRecipients Group, added feature to use mail instead of smtp mail only, fixed the problem that item with single quotation mark cannot be stored and the same date comparison problem.
11/5/13 Exson: Add MailSalesReport_csv to scripts and add SalesAnalysisReportRecipients for mailing list in sql/mysql/upgrade4.10-4.11.sql
11/5/13 Exson: Make the report can be sent via smtp mail in MailSalesReport_csv.php.
11/5/13 Exson: Add Cc and Reply-To feature for mail sent by smtp in DefineTenderClass.php.
11/5/13 Exson: Make the offer can be mailed via smtp in DefineOfferClass.php.
11/5/13 Exson: Make the tender can be sent by SMTP mail in DefineTenderClass.php.
10/5/13 Exson Fixed the Z_CreateCompanyTemplateFile.php to make it workable in windows OS and make it workable via smtp mail.
10/5/13 Exson: Fixed the report_runner.php to make it can be sent via smtp.
10/5/13 Exson: Modify RecurringSalesOrdersProcess.php to make it can send the order by smtp.
10/5/13 Exson Fixed the mail function for PDFChequeListing.php
10/5/13 Exson: Add GetMailList function in MiscFunctions.php.
10/5/13 Exson: Fixed the unclosed a href tag in MailingGroupMaintenance.php.
10/5/13 Exson: Add new feature to main mail list group for mail sending purpose.
9/5/13 Exson: Fixed the date hard coded problem in PcAssignCashToTab.php which lead to malfunction for some date format. Report by thumb.
3/5/13 Ricard: new script to change GL account codes Z_ChangeGLAccountCode.php and SQL to upgrade to varchar account codes
2/5/13 Exson: Fixed strpos error and make the smtp server name more generic when user not use a email address in function of SendmailBySmtp in MiscFunctions.php.
2/5/13 Phil: Credit_Invoice.php was not setting the selected location to credit into as reported by Ricard
2/5/13 Exson: Revise the account code to 20 reported by Tim in GLAccounts.php.
2/5/13 Exson: Make correction for removing those functions not related with webERP committed last time in MiscFunctions.php. Thanks for Tim's review.
2/5/13 Exson: Make smtp available for PDFDeliveryDifferences.php.
2/5/13 Exson: Make smtp mail available for PDFDIFOT.php and fixed the bug that the result should be data within acceptable days instead of out of the range.
02/05/13 Exson: Make the smtp mail available for PrintCustTransPortrait.php
02/05/13 Exson: Add SendmailBySmtp function to MiscFunctions.php and make smtp mail workable for PrintCustTrans.php.
1/5/13 Ricard: GLAccounts.php change error trap that only allows numeric GL accounts as now the chart of accounts can contain text accounts
1/5/13 Phil: Fix purchase order lead time calculation as reported by MacPhotoBiker on forum
1/5/13 Phil: Add link to print purchase order after placement as suggested by MacPhotoBiker on forum
30/4/13 Exson Update the translation file for Chinese simplify locale
30/4/13 Exson: Fixed the bug in SystemParameters.php which missing a</select> tag and cannot display the config in $_SESSION correctly. Reported by Tim.
30/4/13 Exson: Create a new sql file 4.10-4.11.sql with the smtp setting statement.
29/4/13 Exson: Modify the PO_PDFPurchOrder.php to make it suitable for smtp setting.
29/04/13 Exson Fixed the smtp does not work for langaguage is change in utf8 code in file of smtp.php and HTMLMimeMail.php.
29/04/13 Exson Fixed the db_free_result() error messages due to the query returned a boolean value in SMTPServer.php
27/4/13 Samudaya: Fixed a bug in PO_Items.php when a line of a purchase order is deleted (other than the last line) and then subsequently a new line is added - the last line of the order is over-written.
27/4/13 Samudaya: PO_Items.php When purchasing a non-stock item (asset), AssetID goes to wrong column in purchorderdetails table (Column name - suppliers_partno). Fixed the bug and now save the AssetID in the correct assetid column.
27/4/13 Samudaya: Fixed the Page Navigation (Go, Previous, Next) problem. This problem occurs there are many assets and display as several pages.
26/04/13 Exson: Fix the image broken problem for Manual/ManualGettingStarted.html Chinese version
19/7/13 Phil: StockLocStatus.php was not showing purchase orders with status of printed
25/4/13 Tim: Selecting customer in Contracts form was not working - fixed
25/4/13 Bob Thomas: WorkOrderIssue.php was not showing the serialised items with a quantity that could be issued was showing them all in error
25/4/13 Phil: BOMs.php fixed error that allowed auto issue to be flagged on serialised items
25/4/13 Phil: Rework includes/GLPostings.inc to avoid incorrect b/fwd balances on posting back to a period which did not previously exist.
19/4/13 Phil: Reported by Bob Thomas - BOMExtendedQty.php was missing purchase orders with status='Authorised' or Printed
18/4/13 Tim: Credit_Invoice.php missing $identifier in link causing details of credit note to be lost
16/4/13 Ricard: Audit trail was not being purged if DB Maintenance was turned off and it should be pruned daily.
16/04/13 Thumb: Fixed the bug of Y-m-d date format error in MiscFunctions.js (this date type is missing) which will display wrong date in Work Order.
6/4/13 Rafael: PDFPriceList.php split long description to maximum of 132 characters long
1/4/13 Kalmer Piiskop: Correct includes/LanguagesArray.php to use correct decimal point and thousands separator
27/3/13 Fahad Hatib: Updates to editing tenders and button to close a tender
22/3/13 Kalmer Piiskop: Updated Estonian translation
21/3/13 Arwan: CustomerReceipt.php Added GL tag name for GL analysis of receipts
23/3/13 Phil: Karel Van Der Esch discovered issues in PO_Items.php and Prices.php in relation to thousands and decimal separators now resolved.
23/3/13 Phil: Added salesperson to debtortrans and now credit notes can have salesman allocated - previously the salesperson was only used for sales analysis reporting - but for those that need sales person against all transactions and want to drill into the detail it is necessary to have the salesperson recorded on each debtortrans - changed CounterSales.php CounterReturns.php ConfirmDispatch_Invoice.php SelectCreditItems.php Credit_Invoice.php defaulted for api functions
21/3/13 Phil: CounterSales.php cancel order during item search failed - now fixed
21/3/13 Phil: MT940 Bank transactions importing - allows importation of bank statements from the bank (for those banks that offer MT940 format statment exports) - other bank transaction export formats are easily accomodated
21/3/13 Phil: Fixed Asset Maintenance tasks, user schedule of tasks due and email reminders to the maintainer and their supervisor when the task is overdue
21/3/13 Fahad Hatib: Committed by Phil - remove the need to be logged in to see the manual
6/3/13 Tim Schofield: Only display those offers that have not gone past their expiry dates
25/2/13 Re-released 4.10.1 without the duplicate records in reportlinks table
24/2/13 Tim Schofield: SalesGraph.php Fix syntax error, missing ; at end of line
24/2/13 Tim Schofield: CustWhereAlloc.php Fix syntax error, bad indenting, and an extra } entered because of it
23/2/13 Version 4.10.1 Released
23/2/13 Phil: Tidy up PDFSellThroughSupportClaim.php report
18/2/13 Fahad Hatib: Committed by Phil - added BookMarks and ViewTopic links in the General Ledger scripts and modifications to the general ledger manual to add these bookmarks.
18/2/13 Tim Schofield: Z_ImportPriceList.php to import a price list from a csv file
15/2/13 Gilberto Dos Santos Alves: Updated Brazilian Portuguese (pt_BR.utf8) translation
15/2/13 Rafael Chacón: Corrected CRC flag
13/2/13 Phil: Fix bugs in labelling of fields in view customer details in Customers.php
12/2/13 Paul Harness: Fix of serialized transfer quantities/includes, StockTransferControlled.php
11/2/13 Fahad Hatib: Committed by Phil - added Manual links for AR, Fixed Assets and AP manual sections
10/3/13 Phil: Added bin to locstock so the standard bin location for stock can be specified, can update from LocReorderlevel.php script of StockStatus.php - this prints on packing slips so dispatch people can see where the stock should be to pick it. Could also add to picking report and GRN receipt report.
2/2/13 Phil: Refix wiki links
2/2/13 Phil: Fix PDFTransPageHeader.inc landscape invoice printing
2/2/13 Tim: Fixed up syntax error in InternalStockCategoriesByRole.php
1/2/13 Fahad Hatib: New Manual page for Supplier Tendering brought in from KwaMoja
2/1/13 Phil: Fix PDFTransPageHeader.inc landscape invoice printing
31/1/13 Tim: includes/MiscFunctions.php fix wiki links
29/1/13 Tim: Fix sql injection security hole in session.inc.
27/1/13 Version 4.10.0 Released
27/1/13 Phil: Sell Through Support scripts - allows setting up rebate for a customer/supplier/item combinations for a date range with a discount to apply. A claim report allows a listing of invoices/credits where these items have been sold accumulating the claim from the supplier. Claim report needs work.
27/1/13 Phil: Supplier discounts/promotions can now be configured against supplier purchasing data with an effective date range. Purchase orders automatically accumulate and apply the discounts on placing orders.
27/1/13 Tim/Fahad Hatib: Various minor improvements from their fork Kwamoja
27/1/13 Tim: Phil brought in changes to date functions to allow for Y-m-d date formats and finished
27/1/13 Tim: Provide facility for editing account group name in AccountGroups.php
27/1/13 Tim: Automatically adjust config.php for variable name changes
27/1/13 Fahad Hatib: Manual updates for internal inventory transfer system
10/1/13 Martha Njeri: Use scandir to get an array of files/directories for neater code
6/1/13 Phil: Prevent selection of assembly items to create purchase orders for... these are just selling devices like kits
4/1/13 Bob Thomas: Fix wiki link for media wiki had extra /
2/1/13 Thomas Lie: corrections to various strings where English was suspect!!
29/12/12 Phil: on log out destroy session and show the login form - avoiding nasty errors
29/12/12 Phil: Proper casing of $Title $RootPath $Theme $DBType $DBUser $DBPassword $AllowDemoMode variables - may make upgrade tricky!!
24/12/12 Ricard: OutstandingGRNs.php now has show on screen option
15/12/12 Phil: Customer login selection of branch option removed unecessary fields from customer order placement
15/12/12 Bob Thomas: modified default.css for the default theme to use pt based default font and other font sizes based on this
12/12/12 Phil/RockStar: SelectOrderitems.php would not recognise Customer only logins correctly as there are two tokens in a Customer login role. and was testing to see if just one token!
11/12/12 Phil: Made CustomerLogin and SupplierLogin more intuitive - still rely on hard coded Security Tokens though.
11/12/12 Phil: Reworked GLTransInquiry.php produced incorrect journals
10/12/12 Phil: Remove hard coding of security tokens in favour of new OrderEntryDiscountPricing dummy script
8/12/12 Phil: Check user has authority to receive goods before allowing auto receiving
7/12/12 Phil: SupplierInvoice.php add link to pay invoice after invoice input
5/12/12 Phil: Allow auto receiving of purchase orders and populating of purchase invoice when purchase order is authorised.