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