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