24e3f6db587857268565b56f222906267db442ce
[fa-stable.git] / CHANGELOG.txt
1 /**
2 * @version $Id$
3 * @package FrontAccounting
4 * @copyright (C) 2005 - 2008 FrontAccounting
5 * @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
6 * FrontAccounting is Free Software
7 */
8
9 1. Changelog
10 ------------
11 This is a changelog for FrontAccounting All releases.
12
13 Legend:
14
15 # -> Bug Fix
16 + -> Addition
17 ! -> Change
18 - -> Removed
19 ! -> Note
20 $ -> Affected files
21
22 ---------------------------------------Release Candidate 1-------------------------------
23 09-Jun-2008 Janusz Dobrowolski
24 # Some additional fixes related to last big committment
25 $ /gl/gl_journal.php
26   /gl/gl_deposit.php
27   /gl/gl_payment.php
28   /includes/ajax.inc
29   /includes/ui/ui_lists.inc
30   /includes/ui/ui_view.inc
31   /js/inserts.js
32   /js/utils.js
33   /sales/includes/ui/sales_order_ui.inc
34   /themes/default/default.css
35   /themes/aqua/default.css
36   /themes/cool/default.css
37
38 08-Jun-2008 Joe Hunt
39 ! Preparing for release candidate 1
40 $ config.php
41
42 08-Jun-2008 Joe Hunt
43 ! Set 'max_execution_time' to 60 seconds by ini_set.
44 $ /install/save.php
45
46 07-Jun-2008 Joe Hunt
47 # Fixed a layout bug in footer.inc
48 $ /includes/page/footer.inc
49
50 07-Jun-2008 Joe Hunt
51 ! Changed install.html and update.html
52 $ install.html
53   update.html
54 + New files, change_current_user_password.php and alter2.sql
55 $ /admin/change_current_user_password.php
56   /sql/alter2.sql
57 ! Changed some files for layout
58 $ /lang/en_US/stylesheet.css
59   /themes/aqua/default.css
60   /themes/aqua/renderer.php
61   /themes/cool/default.css
62   /themes/cool/renderer.php
63   /themes/default/default.css
64   /themes/default/renderer.php
65 ! Changed install sql scripts
66 $ /sql/en_US-demo.sql
67   /sql/en_US-new.sql
68   
69 07-Jun-2008 Janusz Dobrowolski
70 + Added ajax functionality and ui hints to sales form entry pages.
71 $ /sales/sales_order_entry.php
72   /sales/includes/ui/sales_order_ui.inc
73 + Added option for hints display, changed input/lists functions API
74 $ /admin/display_prefs.php
75   /admin/db/users_db.inc
76   /includes/current_user.inc
77   /includes/prefs/userprefs.inc
78   /includes/ui/ui_input.inc
79   /themes/default/renderer.php
80   /sql/alter.sql
81 + List functions rewrite. Added ajax functionality, universal combo_input().
82 $ /includes/ui/ui_lists.inc
83 + Ajaxified exchange_rate_display()
84 $ /includes/ui/ui_view.inc
85 + Added methods for setting focus and page reload to $Ajax class
86 $ /includes/ajax.inc
87   /includes/main.inc
88 + Added comma separated css element selectors
89 $ /js/behaviour.js
90 ! Searchable select js changes related to new ui_lists.inc changes
91 $ /js/inserts.js
92   /js/utils.js
93 + Additional style definitions for various ajax controls
94 $ /themes/default/default.css
95 ! Fixes related to changed input/lists API and ajax extensions
96 $ /admin/company_preferences.php
97   /admin/fiscalyears.php
98   /admin/forms_setup.php
99   /admin/gl_setup.php
100   /dimensions/dimension_entry.php
101   /dimensions/inquiry/search_dimensions.php
102   /gl/bank_transfer.php
103   /gl/includes/ui/gl_deposit_ui.inc
104   /gl/includes/ui/gl_journal_ui.inc
105   /gl/includes/ui/gl_payment_ui.inc
106   /gl/inquiry/bank_inquiry.php
107   /gl/inquiry/gl_account_inquiry.php
108   /gl/inquiry/gl_trial_balance.php
109   /gl/manage/gl_account_types.php
110   /gl/manage/gl_accounts.php
111   /includes/ui/ui_controls.inc
112   /inventory/includes/item_adjustments_ui.inc
113   /inventory/includes/stock_transfers_ui.inc
114   /inventory/inquiry/stock_movements.php
115   /manufacturing/search_work_orders.php
116   /manufacturing/work_order_add_finished.php
117   /manufacturing/work_order_entry.php
118   /manufacturing/includes/work_order_issue_ui.inc
119   /manufacturing/manage/bom_edit.php
120   /purchasing/supplier_payment.php
121   /purchasing/includes/ui/grn_ui.inc
122   /purchasing/includes/ui/invoice_ui.inc
123   /purchasing/includes/ui/po_ui.inc
124   /purchasing/inquiry/po_search.php
125   /purchasing/inquiry/po_search_completed.php
126   /purchasing/inquiry/supplier_allocation_inquiry.php
127   /purchasing/inquiry/supplier_inquiry.php
128   /sales/customer_credit_invoice.php
129   /sales/customer_delivery.php
130   /sales/customer_invoice.php
131   /sales/includes/ui/sales_credit_ui.inc
132   /sales/inquiry/customer_allocation_inquiry.php
133   /sales/inquiry/customer_inquiry.php
134   /sales/inquiry/sales_deliveries_view.php
135   /sales/inquiry/sales_orders_view.php
136   /taxes/tax_groups.php
137
138 06-Jun-2008 Joe Hunt
139 # Final fixes in html layout
140 $ /admin/create_coy.php
141   /gl/gl_deposit.php
142   /gl/gl_payment.php
143   /gl/manage/exchange_rates.php
144   /inventory/prices.php
145   /inventory/purchasing_date.php
146   /inventory/reorder_level.php
147   /inventory/inquiry/stock_status.php
148   /manufacturing/inquiry/where_used_inquiry.php
149   /manufacturing/manage/bom_edit.php
150   
151 05-Jun-2008 Joe Hunt
152 ! Made an improment to the date picker. Shows the week number as well. Many delivery systems are week number based.
153 $ /includes/ui/ui_view.inc
154 # Fixed a html layout bug
155 $ /includes/page/header.inc
156
157 31-May-2008 Joe Hunt
158 # A lot of annoying layout bugs taken. Mostly from views and inquiries. A couple of files are critical, ui_view and ui_lists!
159 $ /gl/view/gl_deposit_view.php
160   /gl/view/gl_payment_view.php
161   /includes/ui/ui_controls.inc
162   /includes/ui/ui_lists.inc
163   /includes/ui/ui_view.inc
164   /manufacturing/work_order_add_finished.php
165   /manufacturing/includes/manufacturing_ui.inc
166   /manufacturing/view/work_order_view.php
167   /manufacturing/view/wo_issue_view.php
168   /sales/inquiry/customer_allocation_inquiry.php
169   /sales/inquiry/customer_inquiry.php
170
171 30-May-2008 Joe Hunt
172 # Fixed bug in 2 files regarding stock movements. Moved from Invoice to Delivery.
173 $ /inventory/inquiry/stock_movements.php
174   /reporting/rep302.php
175
176 28-May-2008 Joe Hunt
177 # More bugs related to debtor_trans changes (positive amounts)
178 $ /gl/includes/db/gl_db_banking.inc
179   /sales/allocations/customer_allocate.php
180   /sales/includes/db/custalloc_db.inc
181   /sales/inquiry/customer_allocation_inquiry.php
182
183 27-May-2008 Joe Hunt
184 # Changed more files with new html/css.
185 $ /includes/page/header.inc
186   /purchasing/inquiry/supplier_allocation_inquiry.php
187   /sales/credit_note_entry.php
188   
189 26-May-2008 Joe Hunt
190 # Fixed many minor bugs, new ones as well as debtor_trans related.
191 ! Changed to use DOCTYPE html 4.01 transitionel. Some files/css needed change.
192 $ /admin/backups.php
193   /admin/create_coy.php
194   /admin/inst_lang.php
195   /admin/inst_module.php
196   /gl/manage/exchange_rates.php
197   /includes/session.inc
198   /includes/page/header.inc
199   /includes/ui/ui_controls.inc
200   /includes/ui/ui_input.inc
201   /includes/ui/ui_lists.inc
202   /includes/ui/ui_view.inc
203   /purchasing/allocations/supplier_allocate.php
204   /sales/allocations/customer_allocate.php
205   /sales/includes/db/sales_credit_db.inc
206   /sales/inquiry/customer_allocation_inquiry.php
207   /themes/aqua/default.css
208   /themes/cool/default.css
209   /themes/default/default.css
210   
211 23-May-2008 Joe Hunt
212 # Minor bug in dimensions.php (Outstanding Dimensions)
213 $ /applications/dimensions.php
214   /dimensions/inquiry/search_dimensions.php
215   
216 23-May-2008 Janusz Dobrowolski
217 ! Include file order / error handling order fixed once again.
218 $ /includes/main.inc
219   /includes/session.inc
220   
221 23-May-2008 Joe Hunt
222 ! Moved menu-system from header.inc/footer.inc to renderer.php for relevant theme. Fixed frontaccounting.php to get the
223   correct renderer.php.
224 $ frontaccounting.php
225   /includes/page/header.inc
226   /includes/page/footer.inc
227   /themes/default/renderer.php
228   /themes/cool/renderer.php
229   /themes/aqua/renderer.php
230
231 22-May-2008 Janusz Dobrowolski
232 ! Error handler switching moved to session.inc for early error catching
233 $ /includes/main.inc
234   /includes/session.inc
235 ! Cosmetic cleanup
236   /js/utils.js
237   
238 18-May-2008 Janusz Dobrowolski
239 # Added explicit ob_end_flush() on shutdown needed for php5
240 $ /includes/main.inc
241 # Fixed for www servers on nonstandard listening ports.
242 $ /js/JsHttpRequest.js
243
244 18-May-2008 Joe Hunt
245 # Bug when inserting new records in debtor_trans.
246 $ /sales/includes/db/cust_trans_db.inc
247
248 16-May-2008 Janusz Dobrowolski
249 + Rewritten errors/messages handling, unified for ajax/user/php errors
250 $ /includes/errors.inc
251   /includes/main.inc
252   /includes/ui/ui_msgs.inc
253 + Framework extended for ajax functionality, javascript code organization improvements.
254 $ /config.php
255   /includes/JsHttpRequest.php (new file)
256   /includes/ajax.inc (new file)
257   /includes/current_user.inc
258   /includes/session.inc
259   /includes/lang/language.php
260   /includes/page/footer.inc
261   /includes/page/header.inc
262   /includes/ui/ui_controls.inc
263   /includes/ui/ui_input.inc
264   /includes/ui/ui_view.inc
265   /js/JsHttpRequest.js (new file)
266   /js/allocate.js (new file)
267   /js/utils.js (new file)
268   /js/behaviour.js
269   /js/inserts.js
270   /themes/aqua/images (new dir)
271   /themes/aqua/images/button_ok.png (new file)
272   /themes/aqua/images/locate.png (new file)
273   /themes/cool/images (new dir)
274   /themes/coll/images/button_ok.png (new file)
275   /themes/coll/images/locate.png (new file)
276   /themes/default/images/button_ok.png (new file)
277   /themes/default/images/progressbar.gif (new file)
278   /themes/default/images/progressbar1.gif (new file)
279   /themes/default/images/progressbar2.gif (new file)
280   /themes/default/default.css
281   /themes/aqua/default.css
282   /themes/cool/default.css
283 ! Payment allocation js functions moved to allocate.js
284 $ /purchasing/allocations/supplier_allocate.php 
285   /sales/allocations/customer_allocate.php
286 ! Some initializations moved from sales_order_ui.inc
287 $ /sales/includes/cart_class.inc
288 + Added javascript compression routine
289 $ /includes/main.inc
290
291 14-May-2008 Joe Hunt
292 # Minor bugs in the former fixing.
293 $ /includes/ui/ui_lists.inc
294
295 14-May-2008 Joe Hunt
296 # When no_item_list or no_customer_list or no_supplier_list was checked in company setup the listboxes were filled with all
297   the records when there were no search values.
298 $ /includes/ui/ui_lists.inc
299
300 09-May-2008 Joe Hunt
301 ! Due to differences in Javascript the script update_db.php had to be changed.
302 ! New fields, base_sales in 0_company and factor in 0_sales_types affects the default chart of accounts.
303 $ /update_db.php
304   /sql/en_US-new.sql
305   /sql/en_US-demo.sql
306   
307 09-May-2008 Janusz Dobrowolski
308 # Automatic calculation of not set item prices from home currency and base sales type settings.
309 $ /admin/company_preferences.php
310   /admin/db/company_db.inc
311   /includes/ui/ui_lists.inc
312   /sales/includes/cart_class.inc
313   /sales/includes/sales_db.inc
314   /sales/includes/db/sales_order_db.inc
315   /sales/includes/db/sales_types_db.inc
316   /sales/includes/ui/sales_credit_ui.inc
317   /sales/includes/ui/sales_order_ui.inc
318   /sales/manage/sales_types.php
319   /sql/alter.sql
320 # Fixed dev bug blocking change of price on order entry.
321 $ /sales/includes/ui/sales_order_ui.inc
322 # Small display fix
323 $ /sales/manage/sales_people.php
324
325 30-Apr-2008 Joe Hunt
326 # Fixed price update also in purchase order
327 $ /purchasing/includes/ui/po_ui.inc
328
329 30-Apr-2008 Janusz Dobrowolski
330 # Fixed price update when changing item in sales order.
331 $ /includes/ui/ui_lists.inc
332   /js/inserts.js
333   /sales/includes/ui/sales_order_ui.inc
334
335 24-Apr-2008 Janusz Dobrowolski
336 + Added new per company directory for customized versions of report definition files repXXX.php, checked before using system default file.
337 $ /company/0/reporting (added new directory)
338   /company/0/reporting/index.php
339   /admin/create_coy.php
340   /reporting/includes/reports_classes.inc
341 # Warnings turned off in case of charset not supported by htmlspecialchars().
342 $ /includes/db/connect_db.inc
343 # Added content type encoding header
344 $ /includes/page/header.inc
345
346 24-Apr-2008 Joe Hunt
347 # Wrong include file path in /includes/ui/items_cart.inc changed /inventory/includes/prefs/sysprefs.inc to
348   /includes/prefs/sysprefs.inc
349 $ /includes/ui/items_cart.inc  
350 # Wrong include file in /reporting/includes/pdf_report.inc. Changed header2a.inc to header2.inc
351 $ /reporting/includes/pdf_report.inc
352
353 23-Apr-2008 Joe Hunt
354 ! Removed the content of function header2 in pdf_report.inc to a separate file, header2.inc.
355   It will make it easier to design your own document layouts.
356 $ /reporting/includes/pdf_report.inc
357   /reporting/includes/header2.inc (new file)
358   
359 20-Apr-2008 Janusz Dobrowolski
360 # Checking uniqueness of company settings, fixed creating database with prefix 0 when none was selected.
361 $ /admin/create_coy.php
362 ! Added missing include_once directives.
363 $ /includes/ui/items_cart.inc
364   /includes/ui/ui_lists.inc
365   /includes/ui/ui_view.inc
366 + Added ini default_charset unnecessary for planned ajax calls.
367 $ /includes/lang/language.inc
368
369 19-Apr.2008 Joe Hunt
370 # Bug (right to left text was done if price decimals were 3). A test sentense from a while
371   ago wasn't removed.
372 $ /reporting/includes/pdf_report.inc
373
374 18-Apr-2008 Janusz Dobrowolski
375 # Additional checks on provisions and break point entry.
376 $ /sales/manage/sales_people.php
377 ! Modules purchasing, sales and taxes sealed against XSS attacks
378 $ /install/save.php
379   /admin/db/maintenance_db.inc
380   /purchasing/includes/db/grn_db.inc
381   /purchasing/includes/db/invoice_items_db.inc
382   /purchasing/includes/db/po_db.inc
383   /purchasing/includes/db/supp_trans_db.inc
384   /purchasing/manage/suppliers.php
385   /sales/includes/db/credit_status_db.inc
386   /sales/includes/db/cust_trans_db.inc
387   /sales/includes/db/cust_trans_details_db.inc
388   /sales/includes/db/sales_order_db.inc
389   /sales/includes/db/sales_types_db.inc
390   /sales/manage/customer_branches.php
391   /sales/manage/customers.php
392   /sales/manage/sales_areas.php
393   /sales/manage/sales_people.php
394   /taxes/db/item_tax_types_db.inc
395   /taxes/db/tax_groups_db.inc
396   /taxes/db/tax_types_db.inc
397
398 18-Apr-2008 Joe Hunt
399 ! Module gl sealed against XSS Attacks
400 $ /gl/includes/db/gl_db_accounts.inc
401   /gl/includes/db/gl_db_account_types.inc
402   /gl/includes/db/gl_db_bank_accounts.inc
403   /gl/includes/db/gl_db_bank_trans.inc
404   /gl/includes/db/gl_db_bank_trans_types.inc
405   /gl/includes/db/gl_db_currencies.inc
406   /gl/includes/db/gl_db_trans.inc
407   
408 18-Apr-2008 Janusz Dobrowolski
409 ! Modules admin and dimensions sealed against XSS attacks
410 $ /admin/payment_terms.php
411   /admin/shipping_companies.php
412   /admin/db/company_db.inc
413   /admin/db/maintenance_db.inc
414   /admin/db/users_db.inc
415   /admin/db/voiding_db.inc
416   /dimensions/includes/dimensions_db.inc
417
418 18-Apr-2008 Joe Hunt
419 ! Modules includes, inventory and manufacturing sealed against XSS attacks
420 $ /includes/db/comments_db.inc
421   /includes/db/inventory_db.inc
422   /includes/db/references_db.inc
423   /inventory/includes/db/items_category_db.inc
424   /inventory/includes/db/items_db.inc
425   /inventory/includes/db/items_locations_db.inc
426   /inventory/includes/db/items_units_db.inc
427   /inventory/includes/db/movement_types_db.inc
428   /manufacturing/includes/db/work_centres_db.inc
429   /manufacturing/includes/db/work_orders_db.inc
430   /manufacturing/includes/db/work_orders_quick_db.inc
431   /manufacturing/includes/db/work_order_issues_db.inc
432   /manufacturing/includes/db/work_order_produce_items_db.inc
433   
434 18-Apr-2008 Janusz Dobrowolski
435 ! Changed db_escape function to avoid XSS attacks via js db injection
436 $ /includes/db/connect_db.inc
437 # Database inserts/updates secured against js injection
438 $ /admin/db/maintenance_db.inc
439   /gl/includes/db/gl_db_accounts.inc
440   /purchasing/includes/db/po_db.inc
441   /sales/sales_order_entry.php
442   /sales/includes/db/sales_order_db.inc
443
444 16-Apr-2008 Joe Hunt
445 # Bug in /includes/ui/ui_lists.inc:914. Sql clause was cut.
446 $ /includes/ui/ui_lists.inc
447
448 09-Apr-2008 Janusz Dobrowolski
449 # Fixed number formatting bug in standard cost update.
450 $ /inventory/cost_update.php
451
452 -------------------- 2,0 Beta - released ----------------------------
453
454 06-Apr-2008 Joe Hunt
455 ! Changed install.html and update.html to fit the new unstable release 2.0
456 ! Changed demo sql script to fit the 2.0 unstable.
457 $ install.html
458   update.html
459   /sql/en_US-demo.sql
460   
461 06-Apr-2008 Janusz Dobrowolski
462 # Sales invoice edition denied for documents created in FA 1.xx because of nonportable differences in gl posting/db schema.
463   /sales/customer_invoice.php
464 # Fixed typo causing error while adding new tax type.
465   /taxes/tax_types.php
466   
467 05-Apr-2008 Joe Hunt
468 # Fixed a bug when creating subfolder for new companies. Should be company id and not the table pref counter.
469 $ /admin/create_coy.php
470
471 05-Apr-2008 Joe Hunt
472 # Removed annoying warnings in several reports. 
473 $ config.php 
474   /reporting/rep102.php
475   /reporting/rep104.php
476   /reporting/rep201.php
477   /reporting/rep203.php
478   /reporting/rep705.php
479   /reporting/rep706.php
480   /reporting/rep707.php
481   /reporting/rep709.php
482   /reporting/reports_main.php
483   /reporting/includes/pdf_report.inc
484   
485 04-Apr-2008 Janusz Dobrowolski
486 # Javascript bugfix in selecting orders for template.
487 $ /sales/inquiry/sales_orders_view.php
488
489 04-Apr-2008 Joe Hunt
490 ! Updated chart of accounts for release 2.0 unstable. Set the status to 2.0 Beta in config.php. Minor changes in update.html
491 + Preparing for download of release 2.0b on SourceForge.
492 $ config.php
493   update.html
494   /sql/en_US-new.sql
495   /sql/en_US-demo.sql
496   
497 02-Apr-2008 Janusz Dobrowolski
498 # Removed selector expansion on space key for multi-line selectors
499 $ /js/inserts.js
500 ! Hiding search button in combo selectors for javascript enabled browsers
501 $ /includes/ui/ui_lists.inc
502   /js/inserts.js
503 + Focus set to invalid form field after submit check fail
504 $ /admin/company_preferences.php
505   /admin/fiscalyears.php
506   /admin/gl_setup.php
507   /admin/payment_terms.php
508   /admin/shipping_companies.php
509   /admin/users.php
510   /admin/void_transaction.php
511   /dimensions/dimension_entry.php
512   /gl/bank_transfer.php
513   /gl/gl_deposit.php
514   /gl/gl_journal.php
515   /gl/gl_payment.php
516   /gl/manage/bank_accounts.php
517   /gl/manage/bank_trans_types.php
518   /gl/manage/currencies.php
519   /gl/manage/exchange_rates.php
520   /gl/manage/gl_account_classes.php
521   /gl/manage/gl_account_types.php
522   /gl/manage/gl_accounts.php
523   /inventory/adjustments.php
524   /inventory/cost_update.php
525   /inventory/prices.php
526   /inventory/purchasing_data.php
527   /inventory/transfers.php
528   /inventory/manage/item_categories.php
529   /inventory/manage/item_units.php
530   /inventory/manage/items.php
531   /inventory/manage/locations.php
532   /inventory/manage/movement_types.php
533   /manufacturing/work_order_add_finished.php
534   /manufacturing/work_order_entry.php
535   /manufacturing/work_order_issue.php
536   /manufacturing/work_order_release.php
537   /manufacturing/manage/bom_edit.php
538   /manufacturing/manage/work_centres.php
539   /purchasing/po_entry_items.php
540   /purchasing/po_receive_items.php
541   /purchasing/supplier_credit.php
542   /purchasing/supplier_credit_grns.php
543   /purchasing/supplier_invoice.php
544   /purchasing/supplier_invoice_grns.php
545   /purchasing/supplier_payment.php
546   /purchasing/supplier_trans_gl.php
547   /purchasing/allocations/supplier_allocate.php
548   /purchasing/manage/suppliers.php
549   /sales/credit_note_entry.php
550   /sales/customer_credit_invoice.php
551   /sales/customer_delivery.php
552   /sales/customer_invoice.php
553   /sales/customer_payments.php
554   /sales/sales_order_entry.php
555   /sales/allocations/customer_allocate.php
556   /taxes/item_tax_types.php
557   /taxes/tax_groups.php
558   /taxes/tax_types.php
559 # Set default focus in update_db.php
560 $ /admin/backups.php
561
562 29-Mar-2008 Janusz Dobrowolski
563 # Changed gl_all_accounts_list() API
564 $ /includes/ui/ui_lists.inc
565 + Enhanced list accessability in kbd usage via space key
566 $ js/inserts.js
567
568 28-Mar-2008 Janusz Dobrowolski
569 # Fixed headers for various display mode
570 $ /sales/inquiry/sales_orders_view.php
571
572 28-Mar-2008 Joe Hunt
573 + Added print document options in inquiries.
574 $ /sales/inquiry/customer_inquiry.php
575   /sales/inquiry/sales_orders_view.php
576   /sales/inquiry/sales_deliveries_view.php
577   /purchasing/inquiry/po_search.php
578   /purchasing/inquiry/po_search_completed.php
579   
580 28-Mar-2008 Joe Hunt
581 # Fixed a minor bug in customers_db.inc (should include type == 2 - Bank Deposits)
582 $ /sales/includes/db/customers_db.inc
583 # Fixed a PHP vers. 5.xx bug. No need for & operator in function calls, only in declaration. Gives a warning.
584 $ /sales/includes/db/sales_credit_db.inc
585 # Fixed a wrong variabel declaration doc_Document_no to doc_Invoice_no
586 $ /reporting/includes/doctext.inc
587   /reporting/includes/doctext2.inc
588 # Fixed so Customer Balances and Aged Customer Analysis reports presents correct sign.  
589 $ /reporting/rep101.php
590   /reporting/rep102.php
591
592 28-Mar-2008 Janusz Dobrowolski
593 # Layout/focus fixes for no_[customer/supplier/item]_list option on
594 $  /includes/ui/ui_lists.inc
595    /purchasing/includes/ui/po_ui.inc
596    /sales/credit_note_entry.php
597    /sales/sales_order_entry.php
598    /sales/includes/ui/sales_credit_ui.inc
599    /sales/includes/ui/sales_order_ui.inc
600
601 27-Mar-2008 Janusz Dobrowolski
602 + Automatic first field focus on page start, focus order preserved between form updates
603 $  /gl/inquiry/gl_account_inquiry.php
604    /includes/page/footer.inc
605    /includes/ui/ui_controls.inc
606    /includes/ui/ui_input.inc
607    /includes/ui/ui_lists.inc
608    /includes/ui/ui_view.inc
609    /js/inserts.js
610    /sales/sales_order_entry.php
611    /sales/credit_note_entry.php
612    /sales/includes/ui/sales_credit_ui.inc
613    /sales/includes/ui/sales_order_ui.inc
614 + Data picker omitted in keyboard tabbing sequence (FF,IE, not old mozilla)
615 $  /includes/ui/ui_input.inc
616 ! Javascript recalcAccount() superseded by class='combo' behaviour binding
617 $  /gl/gl_deposit.php
618    /gl/gl_journal.php
619    /gl/gl_payment.php
620    /gl/includes/ui/gl_deposit_ui.inc
621    /gl/includes/ui/gl_journal_ui.inc
622    /gl/includes/ui/gl_payment_ui.inc
623    /includes/ui/ui_view.inc
624    /purchasing/po_entry_items.php
625    /purchasing/includes/ui/po_ui.inc
626    /sales/sales_order_entry.php
627    /sales/includes/ui/sales_credit_ui.inc
628    /sales/includes/ui/sales_order_ui.inc
629    /js/inserts.js
630 ! get_js_set_focus moved from ui_view (this is only standalone form).
631    /update_db.php
632 # Fixed debit/credit entry check 
633 $  /gl/gl_journal.php
634 # Restored GET/POST security check on path_to_root
635 $  /config.php
636
637 26-Mar-2008 Janusz Dobrowolski
638 # Bug fixes in purchase module related to tax structure changes.
639 $  /purchasing/includes/supp_trans_class.inc
640    /purchasing/includes/db/invoice_db.inc
641    /purchasing/includes/db/invoice_items_db.inc
642    /purchasing/includes/ui/invoice_ui.inc
643    /reporting/rep105.php
644
645 25-Mar-2008 Janusz Dobrowolski
646 ! Per company pdf, backup and graphics directories in 'company' dir.
647 $  /company (new dir)
648    /company/0 (new dir)
649    /company/0/images/ (new dir)
650    /company/0/images/102.jpg    (moved from inventory/manage/image)
651    /company/0/images/103.jpg    (moved from inventory/manage/image)
652    /company/0/images/104.jpg    (moved from inventory/manage/image)
653    /company/0/images/logo_frontaccounting.jpg   (moved from themes/default/images)
654    /company/0/images/logo_frontaccounting.png   (moved from themes/default/images)
655    /admin/backups.php
656    /admin/create_coy.php
657    /admin/db/maintenance_db.inc
658    /install/index.php
659    /reporting/rep102.php
660    /reporting/rep104.php
661    /reporting/rep202.php
662    /reporting/rep303.php
663    /reporting/rep706.php
664    /reporting/rep707.php
665    /reporting/includes/pdf_report.inc
666    /inventory/manage/items.php
667
668 + jscript component caching (enables browser caching and future compression)
669 $  /includes/session.inc
670    /includes/main.inc
671    /includes/page/header.inc
672    /includes/ui/ui_view.inc
673    /admin/display_prefs.php
674    /config.php
675
676 - Removed obsolete file
677 $  /sales/includes/ui/print_invoice.inc
678
679 21-Mar-2008 Janusz Dobrowolski
680 ! Total Allocation/Left to Allocate update without page submit.
681 $  /includes/ui/ui_view.inc
682    /purchasing/allocations/supplier_allocate.php
683    /sales/allocations/customer_allocate.php
684 # Fixed unvisable under IE editbutton
685 $  /themes/aqua/default.css
686    /themes/cool/default.css
687    /themes/default/default.css
688
689 20-Mar-2008 Janusz Dobrowolski
690 # Excluding delivery notes from Customer Balances, removed warnings. 
691 $  /reporting/rep101.php 
692 # Divide by zero fix on order_price==0 in new supplier invoice
693 $  /purchasing/supplier_invoice_grns.php
694 # Database bug fix in new customer entry
695 $  /sales/manage/customers.php
696 # Small bug fix (warnings) in is_date() function.
697 $  /includes/date_functions.inc
698
699 18-Mar-2008 Janusz Dobrowolski
700 # Line items editor uses POST method - no disappearing shippment info.
701 $  /sales/credit_note_entry.php
702    /sales/sales_order_entry.php
703    /sales/includes/ui/sales_credit_ui.inc
704    /sales/includes/ui/sales_order_ui.inc
705 + Added edit_button_cell() function
706 $  /includes/ui/ui_controls.inc
707 + Helper function for finding indexed submit $_POST vars.
708 $  /includes/ui/ui_input.inc
709 + New class .editbutton for buttons. Default view is link alike.
710 $  /themes/aqua/default.css
711    /themes/cool/default.css
712    /themes/default/default.css
713
714 17-Mar-2008 Janusz Dobrowolski
715 # Added rounding when needed to avoid document non cosistent documents.
716 $  /includes/banking.inc
717    /purchasing/supplier_credit_grns.php
718    /purchasing/supplier_invoice_grns.php
719    /purchasing/includes/supp_trans_class.inc
720    /purchasing/includes/ui/invoice_ui.inc
721    /purchasing/includes/ui/po_ui.inc
722    /reporting/rep107.php
723    /reporting/rep109.php
724    /reporting/rep110.php
725    /reporting/rep209.php
726    /sales/includes/cart_class.inc
727    /sales/includes/ui/sales_credit_ui.inc
728    /sales/includes/ui/sales_order_ui.inc
729    /sales/view/view_credit.php
730    /sales/view/view_dispatch.php
731    /sales/view/view_invoice.php
732    /sales/view/view_sales_order.php
733    /taxes/tax_calc.inc
734 # Sign bug for customer transactions
735 $  /reporting/rep709.php
736 # Include file conflict fix
737 $ /purchasing/includes/ui/invoice_ui.inc
738   /gl/manage/bank_accounts.php
739   /manufacturing/inquiry/where_used_inquiry.php
740   /purchasing/manage/suppliers.php
741   
742 16-Mar-2008 Janusz Dobrowolski
743 + Added javascript add-on for unobtrusive apply javascript handlers to html elements.
744 $  /js/behaviour.js
745    /js/inserts.js
746 + Added javascript source collecting functions
747 $  /includes/main.inc
748 ! Moved check_page_security(); for safe start in case of broken wa_current_user var.
749 + Added global js code collecting arrays  $js_lib, $js_static
750 $  /includes/session.inc
751 ! Changed get_js_user num to add_js_user_num; extended for percent/qty/price formatting
752 $  /includes/ui/ui_view.inc
753 + Added including javascript source colections from $js_lib, $js_static; conditional display for ajax calls
754 $  /includes/page/footer.inc
755    /includes/page/header.inc
756 ! Added including of data_checks.inc
757 $  /includes/ui.inc
758 + User side percent/exrate/qty/price input formatting via onblur handler.
759 $  /admin/gl_setup.php
760    /gl/gl_budget.php
761    /gl/manage/exchange_rates.php
762    /includes/ui/ui_input.inc
763    /inventory/purchasing_data.php
764    /inventory/reorder_level.php
765    /inventory/includes/item_adjustments_ui.inc
766    /inventory/includes/stock_transfers_ui.inc
767    /manufacturing/work_order_entry.php
768    /manufacturing/manage/bom_edit.php
769    /purchasing/po_entry_items.php
770    /purchasing/po_receive_items.php
771    /purchasing/supplier_credit.php
772    /purchasing/supplier_credit_grns.php
773    /purchasing/supplier_invoice_grns.php
774    /purchasing/supplier_trans_gl.php
775    /purchasing/allocations/supplier_allocate.php
776    /purchasing/includes/ui/po_ui.inc
777    /sales/customer_delivery.php
778    /sales/customer_invoice.php
779    /sales/allocations/customer_allocate.php
780    /sales/includes/ui/sales_credit_ui.inc
781    /sales/includes/ui/sales_order_ui.inc
782    /taxes/tax_groups.php
783    /taxes/tax_types.php
784
785 14-Mar-2008 Janusz Dobrowolski
786  + All forms fixed to accept user native numeric format.
787  $ /admin/gl_setup.php
788    /gl/bank_transfer.php
789    /gl/gl_budget.php
790    /gl/gl_deposit.php
791    /gl/gl_journal.php
792    /gl/gl_payment.php
793    /gl/includes/db/gl_db_banking.inc
794    /gl/includes/ui/gl_deposit_ui.inc
795    /gl/includes/ui/gl_journal_ui.inc
796    /gl/includes/ui/gl_payment_ui.inc
797    /gl/manage/exchange_rates.php
798    /inventory/adjustments.php
799    /inventory/cost_update.php
800    /inventory/prices.php
801    /inventory/purchasing_data.php
802    /inventory/reorder_level.php
803    /inventory/transfers.php
804    /inventory/includes/item_adjustments_ui.inc
805    /inventory/includes/stock_transfers_ui.inc
806    /inventory/manage/item_units.php
807    /manufacturing/work_order_entry.php
808    /manufacturing/inquiry/where_used_inquiry.php
809    /manufacturing/manage/bom_edit.php
810    /purchasing/po_entry_items.php
811    /purchasing/po_receive_items.php
812    /purchasing/supplier_credit_grns.php
813    /purchasing/supplier_invoice_grns.php
814    /purchasing/supplier_payment.php
815    /purchasing/supplier_trans_gl.php
816    /purchasing/allocations/supplier_allocate.php
817    /purchasing/includes/ui/po_ui.inc
818    /purchasing/inquiry/po_search.php
819    /sales/credit_note_entry.php
820    /sales/customer_credit_invoice.php
821    /sales/customer_delivery.php
822    /sales/customer_invoice.php
823    /sales/customer_payments.php
824    /sales/sales_order_entry.php
825    /sales/allocations/customer_allocate.php
826    /sales/includes/ui/sales_credit_ui.inc
827    /sales/includes/ui/sales_order_ui.inc
828    /sales/manage/customers.php
829    /sales/manage/sales_people.php
830    /sales/view/view_credit.php
831    /sales/view/view_dispatch.php
832    /sales/view/view_invoice.php
833    /sales/view/view_receipt.php
834    /sales/view/view_sales_order.php
835    /taxes/item_tax_types.php
836    /taxes/tax_groups.php
837    /taxes/tax_types.php
838  + User format functions for percent/price/exrate amounts display.
839  $ /includes/current_user.inc
840  + Input checking functions for numeric input fields in user native format
841  $ /includes/data_checks.inc
842  + Numeric input fields in user native format
843  $ /includes/ui/ui_input.inc
844  + Javascript function for conversion to/from user native numeric format.
845  $ /includes/ui/ui_view.inc
846  + New class amount for numeric input
847  $ /themes/aqua/default.css
848    /themes/cool/default.css
849    /themes/default/default.css
850  # Removed warning on adding component
851    /manufacturing/manage/bom_edit.php
852  # Quantity display correction
853    /manufacturing/inquiry/where_used_inquiry.php
854  # Fixed add_customer_trans() call
855    /gl/includes/db/gl_db_banking.inc
856
857 12-Mar-2008 Joe Hung
858  + Added update of Units of Measure and converting of deptor_trans records from release 1.XX
859  - Removed default insertion of Units of Measure. Not neccessary.
860  $ /sql/alter.sql
861    /admin/db/maintenance_db.inc (added support for update)
862
863 11-Mar-2008 Janusz Dobrowolski
864  + Table of measure moved into new table item_units
865  ! Removed $themes[] from config.php, theme list based on directory structure
866  $ /config.php
867    /includes/ui/ui_lists.inc
868    /applications/inventory.php
869    /inventory/includes/inventory_db.inc
870    /inventory/includes/db/items_units_db.inc
871    /inventory/manage/item_units.php
872    /inventory/manage/items.php
873    /sql/alter.sql
874
875 11-Mar-2008 Joe Hunt
876  # Small fix for alignment of date and due date label fields in customer_invoice.php and customer_delivery.php
877  $ /sales/customer_invoice.php
878    /sales/customer_delivery.php
879  
880 10-Mar-2008 Joe Hunt
881  # Small fix for Template Invoice in sales_order_entry.php on line 363 (duedate for Invoice).
882  $ /sales/sales_order_entry.php
883  
884 10-Mar-2008 Janusz Dobrowolski
885  + Added price list selector to sales entry (debtor_master gives only default one)
886  + Added optional submit_on_change parameter to sales ui lists
887  $ /includes/ui/ui_lists.inc
888    /sales/sales_order_entry.php
889    /sales/includes/ui/sales_credit_ui.inc
890    /sales/includes/ui/sales_order_ui.inc
891  # Additional PHP5 fixes, do_clone superseded by local ? : constructs
892  $ /sales/includes/cart_class.inc
893    /includes/ui/ui_view.inc
894    /sales/includes/sales_db.inc
895  # Fixed bogus sales_type lists in edition mode
896  $ /sales/customer_delivery.php
897    /sales/customer_invoice.php
898  # Smaller fixes, cart_class.sales_type name change
899  $ /sales/includes/ui/sales_credit_db.inc
900    /sales/credit_note_entry.php
901    /sales/customer_credit_invoice.php
902    /sales/includes/cart_class.inc
903    /sales/includes/db/sales_credit_db.inc
904    /sales/includes/db/sales_delivery_db.inc
905    /sales/includes/db/sales_invoice_db.inc
906    /sales/includes/db/sales_order_db.inc
907    /sales/includes/ui/sales_credit_ui.inc
908  # One another pmWiki name conflict removed
909  $ /admin/display_prefs.php
910  
911 09-Mar-2008 Joe Hunt
912  - Removed redundant form_types functions and the file /reporting/includes/form_types.inc. Removed table form_items
913  $ /dimensions/includes/dimensions_db.inc
914    /gl/includes/db/gl_db_banking.inc
915    /includes/main.inc
916    /inventory/includes/db/items_adjust_db.inc
917    /manufacturing/includes/db/work_order_issues_db.inc
918    /manufacturing/includes/db/work_order_produce_items_db.inc
919    /manufacturing/includes/db/work_orders_db.inc
920    /manufacturing/includes/db/work_orders_quick_db.inc
921    /purchasing/includes/db/grn_db.inc
922    /purchasing/includes/db/po_db.inc
923    /purchasing/includes/db/supp_payment_db.inc
924    /reporting/includes/form_types.inc (File removed)
925    /sales/includes/db/sales_delivery_db.inc
926    /sales/includes/db/sales_invoice_db.inc
927    /sales/includes/db/sales_order_db.inc
928    /sql/alter.sql
929  # Bug in calculating exchange rates in Reports Supplier Balances and Customer Balances
930  $ /reporting/rep101.php
931    /reporting/rep201.php
932  # clone replacement do_clone() for both PHP 4 and PHP 5.
933  $ /includes/ui/ui_view.inc (at the very bottom)
934    /sales/includes/cart_class.inc
935    
936 07-Mar-2008 Janusz Dobrowolski
937  ! Changed name tax type uniqueness constraint to (name, rate)
938  $ /includes/ui/ui_lists.inc
939    /taxes/items_tax_types.php
940  ! Tax included option moved from tax_group to sales_types table
941  $ includes/ui/ui_view.inc
942    /purchasing/includes/ui/invoice_ui.inc
943    /taxes/tax_calc.inc
944    /taxes/tax_groups.php
945    /taxes/db/tax_groups_db.inc
946    /sql/alter.sql
947  # Final rewriting of sales module, a lot of bugfixes.
948  + Template delivery/invoicing
949  + Concurrent document editing control on sql level
950  + Most of sales documents are now editable
951  + Some links to print documents after entry
952  ! Changed javascript helper function for customer allocations
953  $ /applications/customers.php
954    /includes/ui/ui_input.inc
955    /reporting/rep107.php
956    /reporting/rep109.php
957    /reporting/rep110.php
958    /sales/credit_note_entry.php
959    /sales/customer_credit_invoice.php
960    /sales/customer_delivery.php
961    /sales/customer_invoice.php
962    /sales/customer_payments.php
963    /sales/sales_order_entry.php
964    /sales/allocations/customer_allocate.php
965    /sales/allocations/customer_allocation_main.php
966    /sales/includes/cart_class.inc
967    /sales/includes/sales_db.inc
968    /sales/includes/sales_ui.inc
969    /sales/includes/db/cust_trans_db.inc
970    /sales/includes/db/cust_trans_details_db.inc
971    /sales/includes/db/custalloc_db.inc
972    /sales/includes/db/customers_db.inc
973    /sales/includes/db/payment_db.inc
974    /sales/includes/db/sales_credit_db.inc
975    /sales/includes/db/sales_delivery_db.inc
976    /sales/includes/db/sales_invoice_db.inc
977    /sales/includes/db/sales_order_db.inc
978    /sales/includes/db/sales_types_db.inc
979    /sales/includes/ui/print_invoice.inc
980    /sales/includes/ui/sales_credit_ui.inc
981    /sales/includes/ui/sales_order_ui.inc
982    /sales/inquiry/customer_allocation_inquiry.php
983    /sales/inquiry/customer_inquiry.php
984    /sales/inquiry/sales_deliveries_view.php
985    /sales/inquiry/sales_orders_view.php
986    /sales/manage/credit_status.php
987    /sales/manage/sales_types.php
988    /sales/view/view_credit.php
989    /sales/view/view_dispatch.php
990    /sales/view/view_invoice.php
991    /sales/view/view_receipt.php
992    /sales/view/view_sales_order.php
993 # Removed function name conflict with wiki help system
994    /includes/lang/language.php
995    
996 06-Mar-2008 Janusz Dobrowolski
997  + Wiki help links integration
998  $ /config.php
999    /includes/page/header.inc
1000    /includes/lang/language.php
1001  + Optional debuging with xdebug module
1002  $ /index.php
1003    /includes/db/connect_db.inc
1004  ! Concurrent edition fix
1005  $  /includes/systypes.inc
1006  # Table header fix
1007  $  /manufacturing/manage/bom_edit.php
1008  # Menu layout fixes
1009  $ /themes/aqua/renderer.php
1010    /themes/cool/renderer.php
1011    /themes/default/renderer.php
1012  # Removed warning about nonexistent $_GET variable
1013  $ /dimensions/inquiry/search_dimensions.php
1014  # MySQL 3.xx CAST bug fix
1015  $ /includes/db/manufacturing_db.inc
1016    /manufacturing/includes/db/work_order_requirements_db.inc
1017    /manufacturing/inquiry/where_used_inquiry.php
1018
1019 04-Mar-2008 Joe Hunt
1020  ! Changed so that average item material price is automatic updated whenever a PO Delivery is received.
1021    Changed so that a Bill of Materiel, Parent's material price, is automatic updated from underlying items.
1022  $ /inventory/cost_update.php
1023    /purchasing/includes/db/grn_db.inc and
1024    /manufacturing/manage/bom_edit.php. 
1025    /manufacturing/includes/db/work_orders_db.inc
1026    /manufacturing/includes/db/work_orders_quick_db.inc
1027    /manufacturing/work_order_entry.php
1028   
1029 21-Feb-2008 Joe Hunt
1030  + Added Print for documents in /admin/view_print_transaction.php (according to our new routines).
1031  $ /admin/view_print_transaction.php
1032    /applications/setup.php
1033   
1034 17-Feb-2008 Joe Hunt
1035  ! Minor change in menu and function in view_print_transaction.php
1036  $ /admin/view_print_transaction.php
1037    /application/setup.php
1038  + Preparing for print of single documents
1039  $ /reporting/includes/reporting.inc
1040  ! Removing 'out' field in table tax_types
1041  $ /sql/alter.sql
1042    /taxes/tax_types.php
1043    /taxes/db/tax_types_db.inc
1044  + Added 2 functions in ui_input.inc, button and button_cell
1045    /includes/ui/ui_input.inc
1046
1047 11-Feb-2008 Joe Hunt
1048  + Added file, update_db.php, for updating company databases from an SQL script.
1049  $ update_db.php (New file)
1050    update.html
1051   
1052 06-Fef-2008 Joe Hunt
1053  + Added Report, Salesman Listing, rep106.php. 
1054  $ /reporting/reports_main.php
1055    /reporting/rep106.php
1056   
1057 06-Feb-2008 Janusz Dobrowolski
1058  + Separation of customer invoice issue and goods delivery.
1059  + Batch invoicing for more than one delivery
1060  # Corrected inadequate shipping tax calculations.
1061  ! Default debugging status changed to off.
1062  $ /taxes/tax_calc.inc
1063    /taxes/db/tax_groups_db.inc
1064    /admin/db/voiding_db.inc
1065    /applications/customers.php
1066    /includes/systypes.inc
1067    /includes/types.inc
1068    /includes/ui/ui_controls.inc
1069    /includes/ui/ui_lists.inc
1070    /includes/ui/ui_view.inc
1071    /inventory/inquiry/stock_status.php
1072    /reporting/rep105.php
1073    /reporting/rep107.php
1074    /reporting/rep109.php
1075    /reporting/rep110.php 
1076    /reporting/rep209.php
1077    /reporting/reports_main.php
1078    /reporting/includes/doctext.inc
1079    /reporting/includes/doctext2.inc
1080    /reporting/includes/form_types.inc
1081    /reporting/includes/pdf_report.inc
1082    /reporting/includes/reports_classes.inc
1083    /sales/customer_credit_invoice.php
1084    /sales/customer_invoice.php
1085    /sales/sales_order_entry.php
1086    /sales/customer_delivery.php 
1087    /sales/includes/db/sales_delivery_db.inc 
1088    /sales/includes/ui/print_invoice.inc 
1089    /sales/includes/cart_class.inc
1090    /sales/includes/sales_db.inc
1091    /sales/includes/db/cust_trans_db.inc
1092    /sales/includes/db/cust_trans_details_db.inc
1093    /sales/includes/db/sales_credit_db.inc
1094    /sales/includes/db/sales_invoice_db.inc
1095    /sales/includes/db/sales_order_db.inc
1096    /sales/includes/ui/sales_order_ui.inc
1097    /sales/inquiry/customer_allocation_inquiry.php
1098    /sales/inquiry/customer_inquiry.php
1099    /sales/inquiry/sales_orders_view.php
1100    /sales/inquiry/sales_deliveries_view.php 
1101    /sales/view/view_dispatch.php
1102    /sales/view/view_invoice.php
1103    /sales/view/view_sales_order.php
1104    /sql/alter.sql
1105    config.php
1106   
1107 01-Feb-2008 Joe Hunt
1108  ! Changed so sales orders can have more than one row with the same stock_id. In alter.sql.
1109  $ /sales/includes/cart_class.inc
1110    /sales/includes/db/sales_credit_db.inc
1111    /sales/includes/db/sales_invoice_db.inc
1112    /sales/includes/db/sales_order_db.inc
1113    /sales/includes/db/cust_trans_details_db.inc
1114    /sales/includes/ui/sales_order_ui.inc
1115    /sales/includes/ui/sales_credit_ui.inc
1116    /sales/credit_note_entry.php
1117    /sales/customer_credit_invoice.php
1118    /sales/sales_order_entry.php
1119    /sales/customer_invoice.php
1120
1121 31-Jan-2008 Joe Hunt
1122  ! New Release 2.0 Pre Alpha
1123  $ config.php
1124  # Fixed a release 2 related bug in create_coy.php
1125  $ /admin/create_coy.php
1126  + An alter.sql file to use for updating databases. Until the update_db.php is ready, you can use the install/update companies
1127    and select the companies one by one and upload the alter.sql file to all companies. You can still run the release 2
1128    with these databases changes without any new files. They are coming as soon as possible.
1129  $ /sql/alter.sql (New file)  
1130  # Fixed a release 2 related bug. A field in supp_trans_items were declared as integer(11). Changed to VARCHAR(11) in alter.sql
1131    and 2 related files
1132  $ /purchasing/supplier_trans_gl.php
1133    /purchasing/includes/db/invoice_items_db.inc
1134  ! Moved variables $no_item_list, $no_customer_list and $no_supplier_list in config.php to company table
1135  $ /includes/ui/ui_lists.inc
1136    /purchasing/includes/ui/po_ui.inc
1137    /sales/includes/ui/sales_order_ui.inc
1138    /admin/company_preferences.php
1139    /admin/db/company_db.inc
1140    config.php
1141  + Created 3 new fields in salesman table for provision, break point and provision2. Included in alter.sql. 
1142    Update sales_people.php.Preparing for a new Salesman report with provision etc. Selected with time range. Should be very good.
1143  $ /sales/manage/sales_people.php
1144    /includes/ui/ui_input.inc
1145  
1146 -------------------- 2,0 Pre Alpha - above ----------------------------
1147 31-Jan-2008 Janusz Dobrowolski
1148  # Minor bugfix in db_import()
1149  $ /admin/db/maintenance_db.inc
1150  
1151 30-Jan-2008 Janusz Dobrowolski
1152  # Minor display fix in tax_types.php
1153  $ /taxes/tax_types.php
1154  ! Format cleanup on some files.
1155  $ /gl/includes/gl_db.inc
1156    /gl/includes/gl_ui.inc
1157    /applications/application.php
1158    frontaccounting.php
1159    index.php
1160    
1161 -------------------- 1.16 Stable Released ----------------------
1162 28-Jan-2008 Joe Hunt
1163  + Added a possibility to replace the normal listboxes for items, customer and/or suppliers with a search box.
1164    The listboxes can only hold about 1000 items. New variables in config.php, $no_item_list, $no_customer_list 
1165    and $no_supplier_list. Default is the normal behavior for all listboxes.
1166  $ /includes/ui/ui_lists.inc
1167    /sales/includes/ui/sales_orders_ui.inc
1168    /purchases/includes/ui/po_ui.inc
1169    /themes/default/images/locate.png (New file)
1170    config.php
1171
1172  + Added ALTER TABLE possibility in db_import. For future releases.
1173  $ /admin/db/maintenence_db.inc  
1174
1175  # Removed warnings 'Call-time pass-by-reference' in /includes/db/connect_db.inc and /includes/ui/ui_lists.inc
1176  # Fixed File not found when loading local stylesheet.css (for other languages) in /includes/page/header.inc
1177  $ /includes/db/connect_db.inc
1178    /includes/ui/ui_lists.inc
1179    /includes/page/header.inc
1180    /access/login.php
1181    
1182 16-Jan-2008 Joe Hunt
1183  # When login screen is displayed after session timeout page content is broken. It
1184    is because of NOT using absolute paths in href attribute theme elements.
1185  $ /access/login.php
1186  
1187 30-Dec-2007 Joe Hunt
1188  # Minor adjustments in function db_export on line 325
1189  $ /admin/db/maintenance_db.inc
1190  
1191 29-Dec-2007 Joe Hunt
1192  + Added a variable, $print_invoice_no, in config.php for printing the invoice number instead of invoice reference.
1193  $ config.php
1194  
1195  # Fixed a bug when exporting database. Exported NULL field values from NO to empty field (from mysql version 5.0.32).
1196    Also fixed a unneccessary str_replace when importing sql scripts.
1197  ! Changed the PDF presentation to deleting the Javascript cache before presentation.
1198  $ /admin/db/maintenance_db.inc
1199    /reporting/includes/pdf_report.inc
1200    
1201 13-Dec-2007 Joe Hunt
1202  # Still bugs in trial balances and account inquiry on screen when selecting non balance accounts. Fixed.
1203  $ /gl/inquiry/gl_trial_balance.php
1204    /gl/inquiry/gl_account_inquiry.php
1205
1206 13-Dec-2007 Joe Hunt
1207  # Fixed a bug when voiding a transaction (Journal Entry). An eventually underlying bank transfer was not voided.
1208  $ /admin/db/voiding_db.inc
1209  
1210 06-Dec-2007 Joe Hunt
1211  # Fixed a bug when adding lines during Payments to suppliers, the supplier was set back to the first.
1212  $ /gl/gl_payment.php
1213    /gl/includes/ui/gl_payment_ui.inc
1214    
1215  ! Changed $loc_notification to be set to 0 instead of 1.
1216  $ config.php
1217  
1218 -------------------- 1.15 Stable Released ----------------------
1219 05-Dec-2007 Joe Hunt
1220  + Added email notification to stock location when available stock is below reorder level
1221  $ config.php
1222    /sales/includes/db/sales_order_db.inc
1223    
1224  # Fixed bugs in Open balances when account is not a balance account
1225  $ /gl/inquiry/gl_trial_balance.php
1226    /gl/inquiry/gl_account_inquiry.php
1227    /reporting/rep704.php
1228    /reporting/rep708.php
1229    
1230 -------------------- 1.14 Stable Released ----------------------
1231 01-Oct-2007 Joe Hunt
1232  ! Major change in the installation of modules to also accept an SQL-file for upload.
1233  $ config.php
1234    /admin/inst_module.php
1235    /admin/db/maintenance_db.inc
1236    
1237 30-Sep-2007 Joe Hunt
1238  # The following files were still vulnerable. Fixed
1239  $ /access/login.php
1240    /includes/lang/language.php
1241
1242 -------------------- 1.13 Stable Released ----------------------
1243 14-Sep-2007 Joe Hunt
1244  + Added optional link for electronic payment on invoices (PayPal). 
1245  ! Better support for install/update languages.  
1246  ! Minor adjustments
1247  # Fixed a vulnerable item in config.php
1248  $ config.php
1249
1250 14-Sep-2007 Joe Hunt
1251  # We forgot to upload the PO file when installing new language. Used when GETTEXT is not installed on Server.
1252  # config.php has been vulnerable. Fixed.
1253  $ /admin/inst_lang.php
1254  $ config.php
1255  
1256 10-Sep-2007 Joe Hunt
1257  ! Changed Bank Address field from text to textarea (multirows)
1258  $ /gl/manage/bank_accounts.php
1259  
1260 06-Sep-2007 Joe Hunt
1261  + Added optional link for electronic payment on invoices (PayPal)
1262  $ /reporting/reports_main.php
1263    /reporting/rep107.php
1264    /reporting/includes/report_classes.inc
1265    /reporting/includes/pdf_report.inc
1266    /reporting/includes/doc_text.inc
1267    /reporting/includes/doc_text2.inc
1268    
1269 23-Aug-2007 Joe Hunt
1270  # Unnecessary parameter ($db) in check_for_recursive_bom
1271  $ /manufacturing/manage/bom_edit.php
1272  
1273 21-Aug-2007 Joe Hunt
1274  # Bug in /includes/lang/gettext.php (249) affecting changing language!
1275  $ /includes/lang/gettext.php
1276  
1277 08-Aug-2007 Joe Hunt
1278  # Minor adjustments
1279  $ config.php
1280    /access/login.php
1281    /admin/create_coy.php
1282    /reporting/includes/pdf_report.inc
1283    
1284 04-Aug-2007 Joe Hunt
1285  + Added a default fiscal year in the en_US-new.sql and start references.
1286  $ /sql/en_US-new.sql
1287  ! Changed some specific text strings in en_US.po (E.g. TAX instead of VAT)
1288  $ /lang/en_US/LC_MESSAGES/en_US.mo
1289  
1290 03-Aug-2007 Joe Hunt
1291  # A bug in Direct Invoicing (wrong Invoice Date) has been fixed.
1292  $ /sales/includes/db/sales_order_db.inc
1293  
1294 23-Jul-2007 Joe Hunt
1295  # Changed <? in front of 2 files to <?php.
1296  $ /purchasing/includes/purchasing_ui.inc
1297    /reporting/includes/class.mail.inc
1298    
1299 -------------------- 1.12 Stable Released ----------------------
1300 21-Jul-2007 Joe Hunt
1301  + Added option to handle Jalali and Islamic Calendars
1302  ! Minor adjustments
1303  $ config.php
1304    /gl/includes/db/gl_db_trans.inc
1305    /includes/date_functions.inc
1306    /includes/ui/ui_input.inc
1307    /includes/ui/ui_lists.inc
1308    /includes/ui/ui_view.inc
1309    /purchasing/po_receive_items.php
1310    /purchasing/includes/ui/invoice_ui.inc
1311    /purchasing/includes/ui/po_ui.inc
1312    /reporting/rep705.php
1313    /sales/includes/db/sales_order_db.inc
1314    /sales/includes/ui/sales_order_ui.inc
1315    
1316 20-Jul-2007 Joe Hunt
1317  ! Changed parameters on report Sales Order. Option to print as Quote.
1318  $ /reporting/reports_main.php
1319    /reporting/rep109.php
1320    /reporting/includes/pdf_report.inc
1321    /reporting/includes/doctext.inc
1322    /reporting/includes/doctext2.inc
1323  
1324 19-Jul-2007 Joe Hunt
1325  + Added Budget Entry in General Ledger. Includes Dimensions.
1326  $ config.php
1327    /applications/generalledger.php
1328    /gl/gl_budget.php (New File!)
1329    /gl/includes/db/gl_db_trans.inc
1330    /includes/date_functions.inc
1331    /reporting/report_classes.inc
1332    
1333 -------------------- 1.11 Stable Released ----------------------
1334 04-Jul-2007 Joe Hunt
1335  ! Option for using alpha numeric chart of accounts.
1336  $ config.php
1337    /gl/manage/gl_accounts.php
1338    /gl/includes/db/gl_db_accounts.inc
1339    /gl/includes/db/gl_db_bank_trans.inc
1340    /gl/includes/db/gl_db_trans.inc
1341    /gl/inquiry/gl_trial_balance.inc
1342    /admin/db/company_db.inc
1343    /inventory/includes/db/items_db.inc
1344    /sales/manage/customer_branches.inc
1345
1346 04-Jul-2007 Joe Hunt
1347  # Problems retrieving language texts for poEdit in long javascripts
1348  $ /includes/ui/ui_view.inc
1349  
1350 04-May-2007 Joe Hunt
1351  # Database error when updating more than one item row in Sales Orders.
1352  $ /sales/includes/db/sales_order_db.inc
1353  # Database error when inserting work order issues. Fixed.
1354  $ /manufacturing/includes/db/work_order_issues_db.inc
1355  
1356 03-May-2007 Joe Hunt
1357  # Multiple tables and JOIN's have syntax changes in MySQL 5.0.12. Need parentheses.
1358  $ /includes/db/manufacturing_db.inc
1359    /manufacturing/includes/db/work_order_requirements_db.inc
1360
1361 02-May-2007 Joe Hunt
1362  # Missing details on Purchase Order when emailing and printing
1363  $ /reporting/rep209.php
1364  
1365 -------------------- 1.1 Stable Released ----------------------
1366 02-May-2007 Joe Hunt
1367  + Enabled module addons and all the below bugfixes. No changes in database structure.
1368  - Removed /sql/basic.sql (included in the other sql files)
1369  - Removed /themes/default/images/left.gif and /themes/default/images/right.gif 
1370    (not needed anymore).
1371  + Addition of update.html  
1372  $ /admin/inst_module.php (New file!)
1373    /applications/customers.php
1374    /applications/dimensions.php
1375    /applications/generalledger.php
1376    /applications/inventory.php
1377    /applications/manufacturing.php
1378    /applications/setup.php
1379    /applications/suppliers.php
1380    /install/index.php
1381    /install/save.php
1382    /modules/inst_modules.php (New folder and new file!)
1383    /modules/index.php (New file!)
1384    /sql/en_US-demo.sql
1385    /sql/en_US-new.sql
1386    install.html
1387    update.html (New file!)
1388    
1389 01-May-2007 Joe Hunt
1390  # Missing measure of units when printing sales orders
1391  # Update of Sales People caused a database error
1392  $ /sales/manage/sales_people.php
1393    /reporting/rep109.php
1394  
1395 30-Apr-2007 Joe Hunt
1396  + The selected menu tab is now shown with same background as hover color.
1397  $ config.php (default tab line 77. Change if you want)
1398    /includes/page/header.inc
1399    
1400 28-Apr-2007 Joe Hunt
1401  # When saving work order entries a lot of debug boxes appeared. Fixed
1402  # When clicking on the link, Issue, on work order inquires an empty screen appeared. Fixed
1403  # When retrieving work centres id's there was a database error. Fixed by casting string to unsigned
1404  $ /includes/db/manufacturing_db.inc
1405    /manufacturing/work_order_entry.php
1406    /manufacturing/includes/work_order_issue_ui.inc
1407    /manufacturing/includes/db/work_order_requirements_db.inc
1408    /manufacturing/includes/db/work_orders_quick_db.inc
1409    /manufacturing/inquiry/where_used_inquiry.php
1410    
1411 25-Apr-2007 Joe Hunt
1412  # Missing Date Picker
1413  $ /sales/customer_invoice.php
1414  # No JS popup window
1415  $ /sales/view/view_invoice.php
1416  
1417 24-Apr-2007 Joe Hunt
1418  ! New and better Date Picker, better cool theme.
1419  $ /includes/ui/ui_input.inc
1420    /includes/ui/ui_view.inc
1421    /reporting/includes/reports_classes.inc
1422    /themes/cool/default.css
1423
1424 -------------------- 1.0.1 Stable Released ----------------------
1425 23-Apr-2007 Joe Hunt
1426  ! Release 1.0.1 established on SourceForge, fixing the bugs and including a Date Picker,
1427    the changes for selection lists customers/suppliers and the Audit Trail.
1428
1429 22-Apr-2007 Joe Hunt
1430  ! Changed the two selection lists for customers/suppliers in reports to a single one with
1431    No Filter
1432  ! Changed the sort order in these selection lists from id to name.
1433  + Added Audit Trail in GL trans. A switch in config.php, $use_audit_trail, must be set to 1.
1434  $ /reporting/reports_main.php
1435    /reporting/rep101.php
1436    /reporting/rep102.php
1437    /reporting/rep201.php
1438    /reporting/rep202.php
1439    /reporting/rep203.php
1440    /reporting/rep204.php
1441    /reporting/includes/reports_classes.inc
1442    /includes/ui/ui_lists.inc
1443    /gl/includes/db/gl_db_trans.inc
1444    config.php
1445    
1446 22-Apr-2007 Joe Hunt
1447  + Date Picker for all date fields.
1448  $ config.php
1449    /admin/fiscalyears.php
1450    /admin/void_transaction.php
1451    /includes/ui/ui_view.inc
1452    /includes/ui/ui_input.inc
1453    /dimensions/dimension_entry.php
1454    /dimensions/inquiry/search_dimensions.php
1455    /gl/gl_journal.php
1456    /gl/gl_deposit.php
1457    /gl/gl_payment.php
1458    /gl/bank_transfer.php
1459    /gl/inquiry/bank_inquiry.php
1460    /gl/inquiry/gl_account_inquiry.php
1461    /gl/inquiry/gl_trial_balance.php
1462    /gl/manage/exchange_rates.php
1463    /inventory/adjustments.php
1464    /inventory/transfers.php
1465    /inventory/inquiry/stock_movements.php
1466    /inventory/manage/items.php
1467    /manufacturing/work_order_add_finished.php
1468    /manufacturing/work_order_entry.php
1469    /manufacturing/work_order_issue.php
1470    /manufacturing/work_order_release.php
1471    /purchasing/supplier_payment.php
1472    /purchasing/po_entry_items.php
1473    /purchasing/po_receive_items.php
1474    /purchasing/supplier_credit.php
1475    /purchasing/supplier_credit_grns.php
1476    /purchasing/supplier_invoice.php
1477    /purchasing/supplier_invoice_grns.php
1478    /purchasing/supplier_trans_gl.php
1479    /purchasing/includes/ui/po_ui.inc
1480    /purchasing/inquity/po_search.php
1481    /purchasing/inquiry/po_search_completed.php
1482    /purchasing/inquiry/supplier_allocation_inquiry.php
1483    /purchasing/inquiry/supplier_inquiry.php
1484    /reporting/reports_main.php
1485    /reporting/includes/reports_classes.inc
1486    /sales/credit_note_entry.php
1487    /sales/customer_credit_invoice.php
1488    /sales/customer_payments.php
1489    /sales/sales_order_entry.php
1490    /sales/includes/ui/sales_order_ui.inc
1491    /sales/inquiry/customer_allocation_inquiry.php
1492    /sales/inquiry/customer_inquiry.php
1493    /sales/inquiry/sales_orders_view.php
1494    New image files:
1495    /themes/default/images/cal.gif
1496    /themes/default/images/next.gif
1497    /themes/default/images/prev.gif
1498
1499 19-Apr-2007 Joe Hunt
1500  # Bug no 1703895, Account numbers are varchars, need quotes, fixed
1501  # Bug no 1703891, Reserved MySQL words used as column names, fixed
1502  $ /taxes/db/tax_types_db.inc
1503
1504  # Bug no 1703888, Apostrophes and other unescaped characters, fixed
1505  $ /gl/manage/gl_accounts.php
1506    /gl/includes/db/gl_db_accounts.inc
1507    /includes/ui/ui_input.inc
1508
1509 18-Apr-2007 Joe Hunt
1510  # Bug no 1702594, Logon Loop, fixed
1511  $ config.php
1512
1513 -------------------- 1.0a Stable Released ----------------------
1514 10-Apr-2007 Joe Hunt
1515  ! Release 1.0a established on SourceForge, fixing the bugs.
1516
1517 11-Apr-2007 Joe Hunt
1518  # Bug No 1698214, Creating Items, fixed
1519  $ /includes/ui/ui_lists.inc
1520  # Bug no 1698216, Item Movements, fixed
1521  $ /inventory/manage/items.php
1522
1523 -------------------- 1.0 Stable Released ----------------------
1524 10-Apr-2007 Joe Hunt
1525  ! Release 1.0 established on SourceForge.
1526
1527 2. Copyright and disclaimer
1528 ---------------------------
1529 This application is opensource software released under the GPL.  Please
1530 see source code and the LICENSE file