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