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